|
|
Database: melGal1 Primary Table: xenoRefFlat Row Count: 357,605   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 | rs15 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001140743 | varchar(255) | values | Name of gene |
chrom | chr30 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 2684764 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 2685733 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 2684764 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 2685733 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 3 | int(10) unsigned | range | Number of exons |
exonStarts | 2684764,2685308,2685649, | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 2684878,2685542,2685733, | 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 |
---|
rs15 | NM_001140743 | chr30 | - | 2684764 | 2685733 | 2684764 | 2685733 | 3 | 2684764,2685308,2685649, | 2684878,2685542,2685733, |
LOC100194659 | NM_001139743 | chr17 | + | 4671627 | 4671855 | 4671627 | 4671855 | 1 | 4671627, | 4671855, |
LOC100194659 | NM_001139743 | chr17 | + | 4671855 | 4672083 | 4671855 | 4672083 | 1 | 4671855, | 4672083, |
LOC100194659 | NM_001139743 | chr21 | + | 6889603 | 6889831 | 6889603 | 6889831 | 1 | 6889603, | 6889831, |
TBC1D30 | NM_001132977 | chr1 | + | 35525906 | 35548168 | 35525906 | 35548165 | 12 | 35525906,35526393,35528797,35530440,35532463,35533437,35537639,35542677,35542951,35545697,35547386,35547967, | 35525969,35526459,35528923,35530626,35532634,35533604,35537745,35542791,35543071,35545899,35547712,35548168, |
let-2 | NM_078262 | chr9 | - | 13791257 | 13833822 | 13791257 | 13833822 | 19 | 13791257,13791700,13792423,13794391,13795391,13801387,13801499,13804993,13806463,13806501,13808331,13811367,13815209,13815267,13 ... | 13791356,13791820,13792555,13794448,13795466,13801408,13801542,13805043,13806477,13806607,13808388,13811387,13815246,13815315,13 ... |
LSP1 | NM_001013254 | chr5 | - | 14133484 | 14143463 | 14133484 | 14135720 | 6 | 14133484,14134270,14134973,14135481,14135682,14143421, | 14133547,14134300,14135057,14135563,14135720,14143463, |
CG31689 | NM_001273022 | chr26 | - | 4530276 | 4531603 | 4530276 | 4531603 | 4 | 4530276,4530663,4531303,4531504, | 4530372,4530686,4531372,4531603, |
stambpl1.L | NM_001092813 | chr8 | + | 21465234 | 21472634 | 21465234 | 21472634 | 10 | 21465234,21466869,21468338,21469287,21469578,21470264,21470453,21471250,21471371,21472537, | 21465453,21466940,21468432,21469446,21469641,21470372,21470591,21471360,21471374,21472634, |
mettl8 | NM_001140324 | chr7 | + | 18706857 | 18719624 | 18706857 | 18719624 | 7 | 18706857,18712395,18712730,18713318,18716163,18719368,18719562, | 18706966,18712490,18712769,18713354,18716274,18719477,18719624, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|