|
|
Database: canFam6 Primary Table: refFlat Row Count: 2,261   Data last updated: 2021-05-18
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | CYB5A | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001193298 | varchar(255) | values | Name of gene |
chrom | chr1 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 6078220 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 6113929 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 6078252 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 6113906 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 5 | int(10) unsigned | range | Number of exons |
exonStarts | 6078220,6106054,6108031,611... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 6078381,6106183,6108061,611... | 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 |
---|
CYB5A | NM_001193298 | chr1 | + | 6078220 | 6113929 | 6078252 | 6113906 | 5 | 6078220,6106054,6108031,6112084,6113824, | 6078381,6106183,6108061,6112119,6113929, |
BCL2 | NM_001002949 | chr1 | + | 14699876 | 14866689 | 14700531 | 14866486 | 4 | 14699876,14700249,14700747,14866351, | 14700023,14700747,14701107,14866689, |
PPIAP1 | NR_036669 | chr1 | - | 15634385 | 15635114 | 15635114 | 15635114 | 1 | 15634385, | 15635114, |
CDH20 | NM_001286988 | chr1 | - | 16150907 | 16202432 | 16152048 | 16202157 | 11 | 16150907,16156755,16161328,16166678,16169523,16175891,16185398,16189867,16192522,16193173,16201911, | 16152554,16157007,16161446,16166800,16169660,16176145,16185586,16190035,16192642,16193468,16202432, |
MC4R | NM_001080724 | chr1 | + | 17102320 | 17103318 | 17102320 | 17103318 | 2 | 17102320,17103096, | 17103096,17103318, |
PMAIP1 | NM_001195771 | chr1 | - | 17446016 | 17449325 | 17446017 | 17449323 | 2 | 17446016,17449265, | 17446124,17449325, |
SEC11C | NM_001003312 | chr1 | - | 17995617 | 18011161 | 17995650 | 18011091 | 6 | 17995617,17996316,17998421,18000665,18004574,18011004, | 17995704,17996374,17998541,18000815,18004684,18011161, |
MIR122 | NR_049246 | chr1 | - | 18577762 | 18577820 | 18577820 | 18577820 | 1 | 18577762, | 18577820, |
TCF4 | NM_001003268 | chr1 | + | 21044956 | 21401584 | 21049703 | 21401171 | 19 | 21044956,21049703,21166184,21169295,21225181,21276427,21277034,21349942,21353628,21359624,21367569,21368761,21371634,21374456,21 ... | 21045483,21049776,21166246,21169392,21225246,21276554,21277084,21350048,21353762,21359757,21367637,21368840,21371711,21374660,21 ... |
CUPIN1 | NM_001371796 | chr1 | - | 22052251 | 22065310 | 22053828 | 22065286 | 9 | 22052251,22054766,22056300,22057195,22059217,22060520,22063541,22064289,22065202, | 22053963,22054913,22056414,22057305,22059371,22060751,22063748,22064523,22065310, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|