|
|
Database: caePb2 Primary Table: xenoRefFlat Row Count: 276,832   Data last updated: 2020-08-18
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | AcCoAS | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001014599 | varchar(255) | values | Name of gene |
chrom | chrUn | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 9772822 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 9774722 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 9772822 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 9774722 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 6 | int(10) unsigned | range | Number of exons |
exonStarts | 9772822,9773101,9773567,977... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 9772978,9773143,9773789,977... | 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 |
---|
AcCoAS | NM_001014599 | chrUn | + | 9772822 | 9774722 | 9772822 | 9774722 | 6 | 9772822,9773101,9773567,9774004,9774086,9774584, | 9772978,9773143,9773789,9774049,9774563,9774722, |
tmprss4a | NM_001077738 | chrUn | + | 33305373 | 33306533 | 33305373 | 33306533 | 3 | 33305373,33306416,33306455, | 33305439,33306437,33306533, |
rin-1 | NM_001269694 | chrUn | + | 112901633 | 112902417 | 112901633 | 112902417 | 4 | 112901633,112901779,112901947,112902063, | 112901732,112901899,112902018,112902417, |
KDELR3 | NM_001244970 | chrUn | + | 20879573 | 20880787 | 20879573 | 20880787 | 4 | 20879573,20879754,20879941,20880691, | 20879684,20879829,20880088,20880787, |
CDK16 | NM_033018 | chrUn | - | 148886124 | 148887124 | 148886124 | 148887124 | 4 | 148886124,148886642,148886899,148887076, | 148886535,148886756,148887037,148887124, |
KCTD1 | NM_001244971 | chrUn | + | 125004385 | 125004550 | 125004385 | 125004550 | 3 | 125004385,125004449,125004526, | 125004416,125004493,125004550, |
KDELR3 | NM_001244970 | chrUn | + | 27524095 | 27524901 | 27524098 | 27524901 | 4 | 27524095,27524346,27524630,27524733, | 27524299,27524580,27524633,27524901, |
HTR4 | NM_001040172 | chrUn | - | 3873102 | 3873411 | 3873102 | 3873411 | 2 | 3873102,3873285, | 3873165,3873411, |
Eif4e2 | NM_001039169 | chrUn | - | 65885463 | 65885682 | 65885463 | 65885682 | 1 | 65885463, | 65885682, |
Eif4e2 | NM_001039170 | chrUn | - | 65885463 | 65885682 | 65885463 | 65885682 | 1 | 65885463, | 65885682, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|