|
|
Database: hg16 Primary Table: xenoRefFlat Row Count: 248,219   Data last updated: 2020-08-22
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | Optc | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001107176 | varchar(255) | values | Name of gene |
chrom | chrUn_random | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 2693794 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 2700797 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 2693794 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 2700797 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 6 | int(10) unsigned | range | Number of exons |
exonStarts | 2693794,2693958,2696467,269... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 2693860,2694024,2696623,269... | 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 |
---|
Optc | NM_001107176 | chrUn_random | + | 2693794 | 2700797 | 2693794 | 2700797 | 6 | 2693794,2693958,2696467,2696875,2697436,2700707, | 2693860,2694024,2696623,2696879,2697637,2700797, |
armc9 | NM_001097173 | chr2 | + | 232282181 | 232399148 | 232282181 | 232399148 | 13 | 232282181,232283907,232302474,232302662,232307194,232326255,232329557,232343885,232344154,232345641,232349319,232358604,23239904 ... | 232282250,232284045,232302630,232302665,232307293,232326354,232329635,232344029,232344160,232345710,232349385,232358694,23239914 ... |
nr4a1 | NM_001078835 | chr12 | + | 50734376 | 50739504 | 50734379 | 50738995 | 12 | 50734376,50734477,50734511,50734682,50735168,50736080,50736544,50737101,50737402,50738735,50738848,50739458, | 50734406,50734489,50734595,50734907,50735255,50736210,50736603,50737310,50737578,50738815,50738995,50739504, |
GRHL1 | NM_001076450 | chr2 | + | 10113579 | 10164144 | 10113701 | 10162574 | 26 | 10113579,10116782,10120653,10121817,10122922,10124322,10125753,10126102,10127154,10147990,10152562,10153873,10155071,10157746,10 ... | 10113720,10116969,10120724,10121823,10123304,10124399,10125910,10126214,10127249,10148149,10152649,10154011,10155112,10157837,10 ... |
hoxa10ab | NM_001130855 | chr7 | - | 26953786 | 26955576 | 26953789 | 26955576 | 2 | 26953786,26955536, | 26954041,26955576, |
hoxa2aa | NM_001130854 | chr7 | - | 26882616 | 26884620 | 26882616 | 26884391 | 5 | 26882616,26882815,26883108,26884186,26884520, | 26882691,26882955,26883363,26884396,26884620, |
Olr1460 | NM_001000769 | chr19 | + | 61964094 | 61964397 | 61964094 | 61964397 | 1 | 61964094, | 61964397, |
Stxbp4 | NM_011505 | chr17 | + | 53542821 | 53716040 | 53542821 | 53711910 | 23 | 53542821,53551343,53551630,53551734,53559532,53583166,53586166,53595234,53599087,53624896,53630076,53630684,53633048,53693310,53 ... | 53542956,53551450,53551673,53551809,53559596,53583263,53586258,53595324,53599151,53625075,53630193,53630734,53633184,53693366,53 ... |
Idh3a | NM_133160 | chr15 | + | 76165717 | 76174463 | 76165717 | 76174463 | 8 | 76165717,76169740,76169993,76170394,76171667,76171728,76171874,76174310, | 76165795,76169926,76169996,76170528,76171692,76171768,76171939,76174463, |
Olr46 | NM_001001001 | chr11 | + | 4474451 | 4475382 | 4474451 | 4475382 | 1 | 4474451, | 4475382, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|