|
|
Database: rn5 Primary Table: refFlat Row Count: 19,066   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 | Vom2r3 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001099460 | varchar(255) | values | Name of gene |
chrom | chr1 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 388172 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 401149 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 388172 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 401149 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 6 | int(10) unsigned | range | Number of exons |
exonStarts | 388172,391017,391728,393384... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 388378,391300,392532,393609... | 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 |
---|
Vom2r3 | NM_001099460 | chr1 | + | 388172 | 401149 | 388172 | 401149 | 6 | 388172,391017,391728,393384,398976,400265, | 388378,391300,392532,393609,399100,401149, |
Map3k14 | NM_001108301 | chr10 | - | 91074395 | 91121436 | 91075687 | 91098372 | 16 | 91074395,91076171,91078343,91079105,91079373,91081202,91081725,91084471,91085137,91085462,91093292,91094803,91095503,91096999,91 ... | 91075852,91076272,91078488,91079212,91079706,91081353,91081889,91084576,91085269,91085592,91093430,91095424,91095714,91097069,91 ... |
Zfp458 | NM_001024299 | chr2 | + | 106640559 | 106649932 | 106645053 | 106649053 | 4 | 106640559,106644960,106645538,106647023, | 106640696,106645087,106645634,106649932, |
Rrlt | NM_001161691 | chr1 | - | 2810882 | 2825886 | 2810882 | 2825886 | 8 | 2810882,2811613,2812346,2812408,2813044,2813555,2813618,2825570, | 2810949,2811755,2812408,2812497,2813293,2813610,2813816,2825886, |
Lhx2 | NM_001106571 | chr3 | + | 27870026 | 27887928 | 27870085 | 27887305 | 5 | 27870026,27871623,27872754,27878190,27887017, | 27870205,27871826,27873158,27878396,27887928, |
Bex4 | NM_001037554 | chrX_AABR06110762_random | + | 118 | 711 | 125 | 482 | 1 | 118, | 711, |
Defb38 | NM_001037552 | chr16 | - | 74705205 | 74708438 | 74705205 | 74708438 | 2 | 74705205,74708377, | 74705336,74708438, |
Fkrp | NM_001025678 | chr1 | - | 79980700 | 79986302 | 79981958 | 79983443 | 2 | 79980700,79986252, | 79983484,79986302, |
Abhd17b | NM_001014028 | chr1 | + | 246554182 | 246587563 | 246580475 | 246587116 | 4 | 246554182,246580472,246585130,246586896, | 246554463,246580942,246585310,246587563, |
Plbd1 | NM_001013927 | chr4 | - | 234823109 | 234879736 | 234823215 | 234879562 | 11 | 234823109,234823657,234824649,234827977,234828211,234850140,234851091,234856670,234858301,234868938,234879444, | 234823386,234823764,234824835,234828118,234828412,234850285,234851232,234856809,234858385,234869158,234879736, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|