|
|
Database: felCat8 Primary Table: xenoRefFlat Row Count: 254,234   Data last updated: 2020-08-21
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | OTUD4 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001243311 | varchar(255) | values | Name of gene |
chrom | chrB1 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 82317873 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 82363396 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 82317907 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 82359646 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 45 | int(10) unsigned | range | Number of exons |
exonStarts | 82317873,82323847,82326376,... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 82317994,82323916,82326429,... | 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 |
---|
OTUD4 | NM_001243311 | chrB1 | + | 82317873 | 82363396 | 82317907 | 82359646 | 45 | 82317873,82323847,82326376,82333107,82333844,82335219,82336900,82340717,82341082,82341281,82344011,82345366,82345579,82349996,82 ... | 82317994,82323916,82326429,82333154,82333917,82335300,82337033,82340775,82341193,82341343,82344111,82345465,82345766,82350159,82 ... |
Selenos | NM_024439 | chrB3 | - | 19693851 | 19704771 | 19694443 | 19704756 | 8 | 19693851,19693963,19694182,19694339,19695991,19700905,19703854,19704682, | 19693933,19694149,19694194,19694529,19696160,19701012,19703991,19704771, |
PGLYRP4 | NM_001244284 | chrA1 | + | 35938 | 47668 | 35962 | 47160 | 12 | 35938,36864,37752,39357,40716,42414,45815,46978,47401,47447,47565,47636, | 35998,36957,37952,39474,40871,42613,45931,47288,47430,47471,47616,47668, |
LOC100065068 | NM_001317249 | chrB3 | - | 137460717 | 137465271 | 137460717 | 137465271 | 4 | 137460717,137461528,137462970,137464616, | 137460900,137461670,137463239,137465271, |
LOC100065068 | NM_001317249 | chrB3_AANG03311634v1_random | + | 1716 | 6271 | 1716 | 6271 | 4 | 1716,3748,5317,6087, | 2371,4017,5459,6271, |
Camsap3 | NM_001347111 | chrA2 | - | 6198273 | 6212808 | 6198468 | 6212628 | 26 | 6198273,6198467,6198869,6199065,6199433,6200011,6200469,6201772,6202174,6202255,6202505,6202688,6202915,6203076,6203309,6203628, ... | 6198333,6198775,6198982,6199178,6199531,6200047,6200523,6202096,6202216,6202468,6202688,6202885,6203062,6203213,6203376,6203706, ... |
Camsap2 | NM_001347109 | chrF1 | + | 40030813 | 40142176 | 40030945 | 40139775 | 29 | 40030813,40030892,40052926,40092865,40102188,40112036,40114865,40115316,40123104,40125359,40130049,40130512,40133969,40134461,40 ... | 40030837,40031084,40053186,40093023,40102276,40112069,40115007,40115456,40123198,40125454,40130120,40132715,40134106,40134682,40 ... |
Camsap2 | NM_001347110 | chrF1 | + | 40030813 | 40142176 | 40030945 | 40139775 | 28 | 40030813,40030892,40052926,40092865,40102188,40114865,40115316,40123104,40125359,40130049,40130512,40133969,40134461,40135836,40 ... | 40030837,40031084,40053186,40093023,40102276,40115007,40115456,40123198,40125454,40130120,40132715,40134106,40134682,40135911,40 ... |
Nipsnap3b | NM_001347099 | chrD4 | + | 66138832 | 66187793 | 66138832 | 66186851 | 5 | 66138832,66140771,66186595,66186769,66187754, | 66139046,66140930,66186677,66186860,66187793, |
LOC103654814 | NM_001347108 | chrC2 | + | 124284991 | 124308443 | 124284991 | 124308443 | 13 | 124284991,124289118,124290089,124293546,124294270,124294931,124296767,124298599,124300157,124300815,124306542,124306686,12430835 ... | 124285129,124289245,124290238,124293649,124294344,124295018,124296863,124298635,124300171,124300944,124306656,124306761,12430844 ... |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|