|
|
Database: bosTau8 Primary Table: xenoRefFlat Row Count: 332,093   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 | ATP8B | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001260139 | varchar(255) | values | Name of gene |
chrom | chr10 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 60431163 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 60638949 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 60431163 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 60638949 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 15 | int(10) unsigned | range | Number of exons |
exonStarts | 60431163,60434138,60503891,... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 60431274,60434234,60503963,... | 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 |
---|
ATP8B | NM_001260139 | chr10 | + | 60431163 | 60638949 | 60431163 | 60638949 | 15 | 60431163,60434138,60503891,60519631,60527463,60528858,60537447,60559005,60579373,60592589,60592733,60593375,60619220,60630570,60 ... | 60431274,60434234,60503963,60519772,60527544,60528924,60537660,60559194,60579481,60592718,60592735,60593594,60619308,60630645,60 ... |
Spen | NM_019763 | chr16 | - | 52882374 | 52974805 | 52883383 | 52974449 | 42 | 52882374,52882525,52882728,52882889,52883010,52883146,52883332,52883989,52884486,52884841,52885815,52887456,52887518,52887598,52 ... | 52882497,52882685,52882842,52882937,52883049,52883201,52883515,52884148,52884681,52885324,52887453,52887473,52887577,52887739,52 ... |
COPS8 | NM_006710 | chr5 | + | 103081954 | 103083362 | 103081966 | 103082596 | 8 | 103081954,103082770,103082829,103083017,103083034,103083104,103083276,103083314, | 103082684,103082806,103082867,103083025,103083058,103083215,103083298,103083362, |
OR10G2 | NM_001193481 | chr10 | + | 25636814 | 25637754 | 25636814 | 25637754 | 1 | 25636814, | 25637754, |
SLC26A8 | NM_001193476 | chr23 | - | 9853161 | 9942439 | 9853587 | 9935005 | 24 | 9853161,9853261,9853304,9853587,9855246,9855533,9862142,9862312,9862355,9868180,9868676,9868827,9870238,9876209,9881750,9882807, ... | 9853245,9853282,9853504,9853665,9855424,9855578,9862250,9862348,9862502,9868267,9868746,9868928,9870336,9876285,9881864,9882897, ... |
LOC692860 | NM_001046705 | chr3 | + | 110268842 | 110269274 | 110268842 | 110269274 | 2 | 110268842,110269181, | 110268929,110269274, |
Tspan11 | NM_001024262 | chr5 | + | 107005355 | 107037320 | 107005367 | 107037320 | 8 | 107005355,107017602,107017903,107029372,107030609,107031857,107032399,107037260, | 107005454,107017788,107017906,107029447,107030714,107032016,107032486,107037320, |
ZNF799 | NM_001322497 | chr7 | - | 14012666 | 14287045 | 14012765 | 14279273 | 15 | 14012666,14012765,14013234,14013240,14061239,14096013,14096674,14120094,14120689,14196881,14197389,14277979,14278310,14279232,14 ... | 14012717,14012831,14013238,14013507,14061448,14096087,14096901,14120269,14120963,14196970,14197497,14278008,14278324,14279367,14 ... |
l(2)37Cc | NM_001169541 | chr19 | + | 37830093 | 37839260 | 37830093 | 37839260 | 7 | 37830093,37830263,37831648,37835093,37835371,37837619,37839053, | 37830186,37830266,37831802,37835236,37835488,37837715,37839260, |
Zfp597 | NM_153732 | chr25 | - | 37383648 | 37469626 | 37383648 | 37469626 | 3 | 37383648,37433163,37469515, | 37383690,37433298,37469626, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|