|
|
Database: aquChr2 Primary Table: xenoRefFlat Row Count: 381,519   Data last updated: 2020-08-18
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | GOLGA7 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001006570 | varchar(255) | values | Name of gene |
chrom | KN265666v1 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 10217319 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 10224792 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 10221192 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 10224600 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 14 | int(10) unsigned | range | Number of exons |
exonStarts | 10217319,10217472,10217567,... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 10217398,10217544,10217609,... | 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 |
---|
GOLGA7 | NM_001006570 | KN265666v1 | - | 10217319 | 10224792 | 10221192 | 10224600 | 14 | 10217319,10217472,10217567,10217731,10217857,10217893,10218237,10218328,10218420,10221176,10222417,10222874,10224489,10224675, | 10217398,10217544,10217609,10217825,10217884,10218222,10218310,10218350,10218597,10221240,10222519,10223027,10224600,10224792, |
ENS-1 | NM_001080873 | KN265688v1 | - | 7640188 | 7646993 | 7646176 | 7646993 | 3 | 7640188,7646176,7646404, | 7640214,7646266,7646993, |
Scube1 | NM_001271472 | KN265799v1 | - | 675712 | 883003 | 675712 | 883003 | 22 | 675712,677029,678146,680782,682418,682452,683510,686820,688425,689702,699142,703815,726341,747371,767882,770848,778585,778971,83 ... | 675865,677104,678298,680978,682420,682614,683676,686970,688626,689825,699256,703931,726464,747488,767975,770962,778588,779090,83 ... |
Dis3 | NM_001275981 | KN265655v1 | + | 21664074 | 21675635 | 21664074 | 21675635 | 2 | 21664074,21675521, | 21664128,21675635, |
Dis3 | NM_001275981 | KN265693v1 | - | 7177993 | 7192624 | 7177993 | 7192624 | 13 | 7177993,7178538,7178619,7179805,7179874,7181672,7184366,7185083,7186058,7187374,7188476,7188615,7192534, | 7178059,7178598,7178697,7179862,7179976,7181822,7184414,7185176,7186136,7187515,7188479,7188744,7192624, |
woc | NM_001276081 | KN265698v1 | - | 1730445 | 1738050 | 1730445 | 1738050 | 6 | 1730445,1731989,1733097,1734682,1736077,1737987, | 1730529,1732049,1733241,1734718,1736182,1738050, |
Mir32 | NR_105205 | KN265740v1 | + | 4778443 | 4778524 | 4778524 | 4778524 | 1 | 4778443, | 4778524, |
ATG9A | NM_001190275 | KN265653v1 | + | 17340649 | 17348793 | 17340649 | 17348793 | 16 | 17340649,17341092,17341121,17342514,17342871,17343137,17344234,17345351,17345734,17346793,17346970,17347343,17347975,17348281,17 ... | 17340752,17341096,17341161,17342579,17343034,17343278,17344983,17345508,17345908,17346959,17347042,17347487,17348086,17348374,17 ... |
Col10a1 | NM_009925 | KN265686v1 | + | 9201390 | 9203253 | 9201390 | 9203253 | 2 | 9201390,9202857, | 9202770,9203253, |
Oxt | NM_011025 | KN265721v1 | - | 3257212 | 3257709 | 3257212 | 3257706 | 3 | 3257212,3257275,3257586, | 3257272,3257429,3257709, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|