|
|
Database: hetGla2 Primary Table: xenoRefFlat Row Count: 536,763   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 | description |
geneName | zgc:153146 | varchar(255) | Name of gene as it appears in genome browser. |
name | NM_001045414 | varchar(255) | Name of gene |
chrom | JH602082 | varchar(255) | Reference sequence chromosome or scaffold |
strand | + | char(1) | + or - for strand |
txStart | 16285346 | int(10) unsigned | Transcription start position (or end position for minus strand item) |
txEnd | 16303019 | int(10) unsigned | Transcription end position (or start position for minus strand item) |
cdsStart | 16285346 | int(10) unsigned | Coding region start (or end position for minus strand item) |
cdsEnd | 16303019 | int(10) unsigned | Coding region end (or start position for minus strand item) |
exonCount | 2 | int(10) unsigned | Number of exons |
exonStarts | 16285346,16302959, | longblob | Exon start positions (or end positions for minus strand item) |
exonEnds | 16285394,16303019, | 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 |
---|
zgc:153146 | NM_001045414 | JH602082 | + | 16285346 | 16303019 | 16285346 | 16303019 | 2 | 16285346,16302959, | 16285394,16303019, |
LARS1 | NM_001102492 | JH602087 | - | 5609648 | 5668437 | 5609911 | 5668437 | 33 | 5609648,5609908,5615967,5616925,5618409,5621147,5623911,5624567,5627071,5628351,5629869,5634471,5635505,5637515,5637527,5638383, ... | 5609741,5610117,5616100,5617021,5618514,5621256,5624023,5624708,5627212,5628442,5630053,5634535,5635563,5637520,5637738,5638517, ... |
LOC100216697 | NM_001143103 | JH602054 | + | 23854332 | 23854485 | 23854332 | 23854485 | 1 | 23854332, | 23854485, |
LOC105384905 | NM_001309140 | JH602143 | + | 6521078 | 6581790 | 6521078 | 6581790 | 11 | 6521078,6528426,6529537,6533765,6537732,6539934,6553715,6555877,6570057,6575639,6581703, | 6521204,6528542,6529679,6533905,6537810,6540029,6553841,6555927,6570122,6575724,6581790, |
hmbox1.L | NM_001093483 | JH602071 | + | 23557117 | 23638365 | 23557132 | 23638287 | 9 | 23557117,23567167,23597887,23603141,23632914,23634655,23636121,23638149,23638320, | 23557596,23567253,23598000,23603293,23632997,23634751,23636210,23638290,23638365, |
ZNF705G | NM_001164457 | JH602261 | + | 7609 | 8902 | 7609 | 8500 | 4 | 7609,8129,8487,8857, | 7739,8317,8566,8902, |
ik | NM_001173724 | JH602056 | + | 33401313 | 33413518 | 33401313 | 33413518 | 14 | 33401313,33403017,33403095,33403594,33404799,33405137,33405693,33406027,33408016,33409378,33411322,33411599,33413135,33413409, | 33401361,33403092,33403109,33403654,33404967,33405255,33405762,33406058,33408183,33409489,33411376,33411656,33413224,33413518, |
HNF4A | NM_001287182 | JH602065 | - | 25361025 | 26216883 | 26216883 | 26216883 | 5 | 25361025,25460493,25770882,25962607,26216854, | 25361058,25460517,25770901,25962619,26216883, |
Vip | NM_001313969 | JH602098 | - | 5466971 | 5473340 | 5468883 | 5473337 | 8 | 5466971,5467158,5468883,5468888,5469746,5470234,5471327,5473238, | 5467142,5467243,5468888,5468921,5469880,5470335,5471452,5473340, |
Ltc4s | NM_001313968 | JH602046 | + | 42670789 | 42672454 | 42670789 | 42672454 | 4 | 42670789,42672048,42672230,42672371, | 42670847,42672148,42672301,42672454, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|