|
|
Database: turTru2 Primary Table: xenoRefFlat Row Count: 583,163   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 | description |
geneName | CPA3 | varchar(255) | Name of gene as it appears in genome browser. |
name | NM_001870 | varchar(255) | Name of gene |
chrom | JH498387 | varchar(255) | Reference sequence chromosome or scaffold |
strand | - | char(1) | + or - for strand |
txStart | 13139 | int(10) unsigned | Transcription start position (or end position for minus strand item) |
txEnd | 13625 | int(10) unsigned | Transcription end position (or start position for minus strand item) |
cdsStart | 13437 | int(10) unsigned | Coding region start (or end position for minus strand item) |
cdsEnd | 13625 | int(10) unsigned | Coding region end (or start position for minus strand item) |
exonCount | 2 | int(10) unsigned | Number of exons |
exonStarts | 13139,13398, | longblob | Exon start positions (or end positions for minus strand item) |
exonEnds | 13196,13625, | 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 |
---|
CPA3 | NM_001870 | JH498387 | - | 13139 | 13625 | 13437 | 13625 | 2 | 13139,13398, | 13196,13625, |
rassf2.L | NM_001096747 | JH492340 | + | 16024 | 16357 | 16024 | 16357 | 2 | 16024,16318, | 16267,16357, |
marveld2b | NM_001126406 | JH474239 | - | 148723 | 170228 | 148723 | 170228 | 5 | 148723,153186,158083,169745,170033, | 148825,153343,158160,169973,170228, |
SPCC4B3.18 | NM_001023064 | JH499423 | + | 27239 | 27392 | 27239 | 27392 | 1 | 27239, | 27392, |
Y67D8C.25 | NR_167558 | JH478790 | - | 85462 | 115320 | 115320 | 115320 | 6 | 85462,96946,98766,107208,107897,115138, | 85594,97069,98883,107291,108004,115320, |
SNAPC1 | NM_001101244 | ABRN02473053 | - | 419 | 521 | 419 | 521 | 1 | 419, | 521, |
Terf1 | NM_001012464 | JH472786 | - | 17855 | 18033 | 17869 | 18033 | 1 | 17855, | 18033, |
CR88 | NM_126439 | JH483169 | + | 96650 | 104894 | 96650 | 104894 | 4 | 96650,102600,104682,104846, | 96713,102690,104712,104894, |
SMIM10 | NM_001163442 | JH486635 | - | 64212 | 64397 | 64212 | 64397 | 1 | 64212, | 64397, |
dkk3b | NM_001089545 | JH481697 | - | 52046 | 106165 | 52046 | 106165 | 3 | 52046,53251,106093, | 52085,53386,106165, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|