|
|
Database: felCat3 Primary Table: xenoRefFlat Row Count: 716,810   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 | description |
geneName | LMO3 | varchar(255) | Name of gene as it appears in genome browser. |
name | NM_001001395 | varchar(255) | Name of gene |
chrom | scaffold_206705 | varchar(255) | Reference sequence chromosome or scaffold |
strand | - | char(1) | + or - for strand |
txStart | 2011 | int(10) unsigned | Transcription start position (or end position for minus strand item) |
txEnd | 6765 | int(10) unsigned | Transcription end position (or start position for minus strand item) |
cdsStart | 2011 | int(10) unsigned | Coding region start (or end position for minus strand item) |
cdsEnd | 6765 | int(10) unsigned | Coding region end (or start position for minus strand item) |
exonCount | 4 | int(10) unsigned | Number of exons |
exonStarts | 2011,2048,3561,6559, | longblob | Exon start positions (or end positions for minus strand item) |
exonEnds | 2047,2082,3687,6765, | 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 |
---|
LMO3 | NM_001001395 | scaffold_206705 | - | 2011 | 6765 | 2011 | 6765 | 4 | 2011,2048,3561,6559, | 2047,2082,3687,6765, |
ARID4B | NR_135074 | scaffold_129862 | - | 640 | 739 | 739 | 739 | 1 | 640, | 739, |
RFTN2 | NM_001266607 | scaffold_162147 | - | 7393 | 7498 | 7393 | 7498 | 1 | 7393, | 7498, |
RFTN2 | NM_001266607 | scaffold_206809 | + | 83711 | 83825 | 83711 | 83825 | 1 | 83711, | 83825, |
HSPA5 | NM_001266596 | scaffold_146132 | + | 47798 | 49363 | 47798 | 49363 | 6 | 47798,47929,48121,48364,48565,48961, | 47923,48103,48349,48502,48943,49363, |
CELF4 | NM_001353703 | scaffold_86211 | + | 56 | 1048 | 1048 | 1048 | 6 | 56,131,257,331,659,767, | 101,140,315,620,756,1048, |
CELF4 | NM_001353706 | scaffold_86211 | + | 56 | 1048 | 1048 | 1048 | 6 | 56,131,257,331,659,767, | 101,140,315,620,756,1048, |
HDAC9 | NM_001204145 | scaffold_163386 | - | 87313 | 149439 | 87313 | 149439 | 3 | 87313,112823,149298, | 87367,112877,149439, |
HDAC9 | NM_001204145 | scaffold_191222 | + | 36865 | 37712 | 36865 | 37712 | 2 | 36865,37496, | 37078,37712, |
kst | NM_206265 | scaffold_155657 | + | 6029 | 7269 | 6029 | 7269 | 2 | 6029,7236, | 6086,7269, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|