|
|
Database: susScr11 Primary Table: xenoRefFlat Row Count: 226,322   Data last updated: 2020-08-20
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | ube2f.S | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001091552 | varchar(255) | values | Name of gene |
chrom | chr16 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 26505607 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 26506047 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 26505607 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 26506047 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 3 | int(10) unsigned | range | Number of exons |
exonStarts | 26505607,26505745,26505933, | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 26505721,26505928,26506047, | 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 |
---|
ube2f.S | NM_001091552 | chr16 | - | 26505607 | 26506047 | 26505607 | 26506047 | 3 | 26505607,26505745,26505933, | 26505721,26505928,26506047, |
mapkapk2.L | NM_001091551 | chr9 | + | 67315127 | 67363465 | 67315127 | 67363465 | 11 | 67315127,67358770,67359093,67359432,67359989,67360081,67361232,67361696,67362402,67362590,67363357, | 67315255,67358916,67359158,67359512,67360081,67360115,67361309,67361820,67362485,67362671,67363465, |
Pou2f1 | NM_001100639 | chr4 | - | 83596284 | 83776410 | 83596528 | 83776408 | 19 | 83596284,83596398,83596522,83599053,83599879,83600017,83618726,83620689,83622528,83624751,83630068,83636367,83637861,83640296,83 ... | 83596341,83596413,83596839,83599142,83599944,83600225,83618832,83620869,83622674,83624893,83630242,83636462,83637988,83640485,83 ... |
LOC100534396 | NM_001279590 | chr1 | + | 120530803 | 120626715 | 120530803 | 120626715 | 7 | 120530803,120611459,120619523,120621856,120622553,120625346,120626610, | 120530933,120611617,120619607,120621947,120622663,120625589,120626715, |
ECU04_1440 | NM_001041179 | chr1 | - | 5670 | 10992 | 5670 | 10992 | 2 | 5670,10905, | 5760,10992, |
Xpo5 | NM_028198 | chr7 | - | 38531328 | 38569489 | 38532877 | 38569373 | 36 | 38531328,38531376,38531994,38532762,38533165,38533485,38533767,38534340,38534925,38535729,38536398,38536873,38536902,38537500,38 ... | 38531358,38531472,38532013,38533015,38533330,38533626,38533872,38534424,38534928,38535783,38536491,38536877,38536949,38537596,38 ... |
fz2 | NM_001275107 | chr10 | - | 58094913 | 58096673 | 58094913 | 58096673 | 5 | 58094913,58095093,58095198,58095765,58096322, | 58095015,58095183,58095587,58095981,58096673, |
RpL26 | NM_001275096 | chr16 | - | 51268742 | 51276261 | 51268742 | 51276261 | 2 | 51268742,51276093, | 51268886,51276261, |
ClC-c | NM_001274993 | chr14 | - | 20045846 | 20064206 | 20045846 | 20064206 | 8 | 20045846,20052222,20055341,20057793,20059039,20061889,20061947,20064083, | 20045978,20052459,20055428,20058145,20059116,20061892,20062154,20064206, |
Clk4 | NM_001310291 | chr2 | + | 79729509 | 79752692 | 79732659 | 79752371 | 18 | 79729509,79732659,79733055,79737373,79738709,79739198,79743567,79743754,79743776,79744143,79744479,79747728,79750960,79752041,79 ... | 79729617,79732820,79733061,79737596,79738800,79739265,79743682,79743757,79743942,79744238,79744603,79747817,79751040,79752132,79 ... |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|