|
|
Database: latCha1 Primary Table: xenoRefFlat Row Count: 434,959   Data last updated: 2020-08-19
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | Mindy3 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001355537 | varchar(255) | values | Name of gene |
chrom | JH127403 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 401658 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 587371 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 401668 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 543943 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 13 | int(10) unsigned | range | Number of exons |
exonStarts | 401658,416104,420236,430296... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 401815,416176,420314,430356... | 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 |
---|
Mindy3 | NM_001355537 | JH127403 | - | 401658 | 587371 | 401668 | 543943 | 13 | 401658,416104,420236,430296,453411,453443,521036,524836,543331,543394,543581,543886,587289, | 401815,416176,420314,430356,453413,453507,521117,524907,543332,543469,543614,544006,587371, |
Tm1 | NM_001159872 | JH127746 | + | 61832 | 91162 | 61832 | 91162 | 3 | 61832,85276,91084, | 61886,85399,91162, |
KAT5 | NM_001192066 | JH126992 | - | 487845 | 550227 | 487845 | 550227 | 14 | 487845,490217,490227,496885,497690,498454,498490,499762,519048,544261,544366,546367,546663,550163, | 487971,490220,490308,496981,497829,498456,498580,500012,519078,544327,544393,546369,546735,550227, |
MAPK10 | NM_001318069 | JH127162 | + | 270480 | 466038 | 270486 | 464440 | 15 | 270480,317467,369249,379875,383607,402475,406957,427951,429614,440671,445255,464255,464547,464623,465969, | 270552,317637,369379,379934,383746,402641,407031,428132,429739,440735,445333,464440,464573,464653,466038, |
slc26a6 | NM_001091806 | AFYH01284070 | - | 316 | 460 | 316 | 460 | 1 | 316, | 460, |
PTPRK | NM_001291981 | JH130775 | + | 33294 | 33567 | 33294 | 33567 | 1 | 33294, | 33567, |
RIT2 | NM_002930 | JH128057 | + | 169040 | 181733 | 169040 | 181733 | 6 | 169040,172895,177641,178776,179273,181613, | 169090,172954,177715,178779,179465,181733, |
Grin2b | NM_012574 | JH128285 | - | 49689 | 297706 | 49692 | 297706 | 12 | 49689,56396,72400,103244,106599,113946,124123,124391,140402,297166,297529,297589, | 49764,56635,72587,103406,106829,114072,124279,124533,140510,297502,297556,297706, |
RCOR1 | NM_015156 | JH128893 | + | 310532 | 310740 | 310532 | 310740 | 2 | 310532,310681, | 310587,310740, |
kif4 | NM_200823 | JH126894 | - | 737787 | 739705 | 737787 | 739705 | 7 | 737787,738185,738434,738752,739062,739174,739453, | 738185,738327,738626,739028,739173,739444,739705, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|