|
|
Database: danRer7 Primary Table: xenoRefFlat Row Count: 271,761   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 | HNRNPDL | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001031142 | varchar(255) | values | Name of gene |
chrom | chr10 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 5005169 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 5013545 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 5007824 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 5013545 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 6 | int(10) unsigned | range | Number of exons |
exonStarts | 5005169,5007824,5007890,501... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 5005213,5007869,5007944,501... | 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 |
---|
HNRNPDL | NM_001031142 | chr10 | - | 5005169 | 5013545 | 5007824 | 5013545 | 6 | 5005169,5007824,5007890,5013190,5013353,5013395, | 5005213,5007869,5007944,5013310,5013356,5013545, |
SPRYD7 | NM_001113742 | chr1 | - | 47208188 | 47213834 | 47208194 | 47213834 | 4 | 47208188,47209384,47212610,47213716, | 47208292,47209487,47212777,47213834, |
PCDH15 | NM_001142763 | chr12 | - | 7250262 | 7502180 | 7250262 | 7502180 | 22 | 7250262,7259859,7263409,7268237,7270835,7283992,7284003,7290686,7324504,7325875,7325883,7354304,7374501,7394861,7397640,7408395, ... | 7250355,7260078,7263586,7268303,7271051,7283995,7284128,7290813,7324619,7325878,7326011,7354541,7374630,7394942,7397775,7408539, ... |
NCAM2 | NM_004540 | chr9 | - | 36142122 | 36290982 | 36142122 | 36290982 | 16 | 36142122,36147267,36186001,36186222,36187974,36192184,36199441,36202106,36204638,36237498,36251501,36268131,36268692,36280980,36 ... | 36142185,36147474,36186049,36186342,36187980,36192304,36199531,36202228,36204789,36237606,36251635,36268255,36268821,36280984,36 ... |
Bdnf | NM_001285416 | chr7 | - | 33259672 | 33261086 | 33260241 | 33261054 | 6 | 33259672,33259751,33259850,33260142,33260241,33260985, | 33259712,33259810,33259874,33260182,33260733,33261086, |
Calu | NM_001285412 | chr18 | - | 6102688 | 6115754 | 6102688 | 6110248 | 6 | 6102688,6104266,6107718,6110122,6112837,6115706, | 6102793,6104457,6107782,6110291,6113025,6115754, |
Calu | NM_001285412 | chr4 | + | 12635399 | 12639813 | 12636208 | 12639813 | 5 | 12635399,12636169,12636603,12637425,12639708, | 12635588,12636334,12636667,12637625,12639813, |
RCAN1 | NM_001285393 | chr20 | - | 39080855 | 39106072 | 39080855 | 39105913 | 4 | 39080855,39080912,39100899,39105892, | 39080912,39080989,39101038,39106072, |
RCAN1 | NM_001285392 | chr20 | - | 39080855 | 39106060 | 39080855 | 39105913 | 4 | 39080855,39080912,39100899,39105892, | 39080912,39080989,39101038,39106060, |
RCAN1 | NM_001285391 | chr20 | - | 39080855 | 39106060 | 39080855 | 39106060 | 4 | 39080855,39080912,39100899,39105892, | 39080912,39080989,39101038,39106060, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|