|
|
Database: felCat3 Primary Table: refFlat Row Count: 743   Data last updated: 2020-08-21
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | F9 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001009377 | varchar(255) | values | Name of gene |
chrom | scaffold_204919 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 74661 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 108120 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 74661 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 108120 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 7 | int(10) unsigned | range | Number of exons |
exonStarts | 74661,80893,81258,85896,927... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 74749,81057,81283,86010,928... | longblob | | Exon end positions (or start positions for minus strand item) |
|
| |
|
|
Connected Tables and Joining Fields
|
|
Sample Rows
|
|
geneName | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds |
---|
F9 | NM_001009377 | scaffold_204919 | + | 74661 | 108120 | 74661 | 108120 | 7 | 74661,80893,81258,85896,92735,106798,107572, | 74749,81057,81283,86010,92864,106916,108120, |
ADRB1 | NM_001009375 | scaffold_133254 | + | 212266 | 212651 | 212266 | 212651 | 1 | 212266, | 212651, |
MCL1 | NM_001009374 | scaffold_127430 | - | 3560 | 4837 | 4719 | 4837 | 1 | 3560, | 4837, |
MCL1 | NM_001009374 | scaffold_48598 | - | 0 | 1169 | 0 | 1169 | 2 | 0,539, | 185,1169, |
PSIP1 | NM_001009372 | scaffold_199457 | - | 83 | 5719 | 83 | 5719 | 4 | 83,109,3646,5490, | 109,129,3765,5719, |
PSIP1 | NM_001009372 | scaffold_199461 | - | 57440 | 92050 | 57440 | 92050 | 6 | 57440,57449,58285,82136,91972,92005, | 57449,57465,58400,82276,92004,92050, |
CYP17A1 | NM_001009371 | scaffold_132920 | - | 417686 | 424387 | 417686 | 424387 | 7 | 417686,418482,419410,420888,421758,422198,424102, | 417969,418586,419586,420976,421988,422337,424387, |
PPIA | NM_001009370 | scaffold_23723 | + | 21 | 1522 | 21 | 1318 | 4 | 21,131,435,1185, | 52,220,608,1522, |
KLRAP1 | NM_001009834 | scaffold_83731 | + | 920 | 1090 | 920 | 1090 | 2 | 920,1082, | 1082,1090, |
KIT | NM_001009837 | scaffold_215273 | + | 168156 | 220767 | 168156 | 220767 | 13 | 168156,175913,176179,177293,212878,214534,215933,216137,216546,216740,218073,220057,220639, | 168429,176179,176194,177413,212993,214728,216040,216264,216651,216851,218224,220149,220767, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|