|
|
Database: musFur1 Primary Table: xenoRefFlat Row Count: 313,724   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 | Akr1c2 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001013057 | varchar(255) | values | Name of gene |
chrom | GL896959 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 4152884 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 4160523 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 4152884 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 4160523 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 6 | int(10) unsigned | range | Number of exons |
exonStarts | 4152884,4154168,4154946,415... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 4153010,4154201,4155042,415... | 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 |
---|
Akr1c2 | NM_001013057 | GL896959 | - | 4152884 | 4160523 | 4152884 | 4160523 | 6 | 4152884,4154168,4154946,4158570,4159517,4160463, | 4153010,4154201,4155042,4158734,4159524,4160523, |
Gm14434 | NM_001101804 | GL897008 | - | 256358 | 862593 | 468690 | 862593 | 13 | 256358,354943,355273,397582,468537,614557,640234,694693,695188,748494,748697,748889,862405, | 256394,354976,355327,397636,468972,614637,640333,694936,695250,748529,748865,748992,862593, |
Ube4b | NM_001271198 | GL896903 | - | 32437327 | 32559663 | 32438026 | 32558941 | 26 | 32437327,32437525,32437580,32437673,32437783,32437808,32438026,32438414,32439123,32445064,32446839,32451000,32461117,32462294,32 ... | 32437493,32437551,32437607,32437697,32437796,32437832,32438088,32438561,32439298,32445256,32446974,32451150,32461352,32462392,32 ... |
LOC100282438 | NM_001155349 | GL897092 | + | 1897365 | 1897881 | 1897365 | 1897881 | 4 | 1897365,1897575,1897644,1897776, | 1897479,1897620,1897671,1897881, |
CPR3 | NM_001182437 | GL896901 | - | 24881018 | 24881140 | 24881018 | 24881140 | 2 | 24881018,24881098, | 24881075,24881140, |
CPR3 | NM_001182437 | GL896906 | + | 9906147 | 9906312 | 9906147 | 9906312 | 1 | 9906147, | 9906312, |
CPR3 | NM_001182437 | GL896909 | - | 16724033 | 16724144 | 16724033 | 16724144 | 1 | 16724033, | 16724144, |
CPR3 | NM_001182437 | GL896935 | + | 5950615 | 5951053 | 5950615 | 5951053 | 1 | 5950615, | 5951053, |
CPR3 | NM_001182437 | GL897009 | - | 2142247 | 2146542 | 2142247 | 2146542 | 4 | 2142247,2143566,2145922,2146523, | 2142358,2143629,2146011,2146542, |
Hbb-bs | NM_001111269 | GL897188 | + | 1348842 | 1350063 | 1348842 | 1350051 | 3 | 1348842,1348984,1349922, | 1348960,1349067,1350063, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|