|
|
Database: canFam1 Primary Table: xenoRefFlat Row Count: 450,935   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 | lzts2a | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001145606 | varchar(255) | values | Name of gene |
chrom | chr24 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 21135750 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 21137508 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 21135750 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 21137508 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 6 | int(10) unsigned | range | Number of exons |
exonStarts | 21135750,21135927,21136329,... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 21135819,21135975,21136494,... | 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 |
---|
lzts2a | NM_001145606 | chr24 | + | 21135750 | 21137508 | 21135750 | 21137508 | 6 | 21135750,21135927,21136329,21136557,21136948,21137436, | 21135819,21135975,21136494,21136602,21137068,21137508, |
LOC100786504 | NM_001255243 | chr6 | + | 19648748 | 19651019 | 19648748 | 19651019 | 4 | 19648748,19649901,19650410,19650953, | 19648820,19649976,19650497,19651019, |
Kng1 | NM_001102411 | chr34 | + | 22368034 | 22395700 | 22368046 | 22395700 | 11 | 22368034,22376890,22392634,22394956,22395061,22395136,22395258,22395269,22395331,22395509,22395565, | 22368241,22377034,22392733,22395044,22395133,22395249,22395268,22395306,22395342,22395545,22395700, |
chmp4c.L | NM_001092411 | chr24 | + | 25922579 | 25974241 | 25922579 | 25974241 | 3 | 25922579,25970732,25974196, | 25922713,25970913,25974241, |
etf1.S | NM_001090894 | chrUn | - | 56192856 | 56194071 | 56192856 | 56194053 | 1 | 56192856, | 56194071, |
Vipas39 | NM_001101004 | chr8 | - | 53150859 | 53171241 | 53150899 | 53171233 | 18 | 53150859,53151641,53152159,53152831,53154199,53154808,53155886,53156461,53158655,53161461,53162970,53163576,53166077,53166844,53 ... | 53150920,53151746,53152249,53152918,53154289,53154856,53156015,53156537,53158729,53161489,53163073,53163610,53166134,53166909,53 ... |
znf143.S | NM_001090904 | chr21 | + | 35020551 | 35079304 | 35020551 | 35079304 | 15 | 35020551,35021495,35038114,35038451,35039354,35039964,35041320,35052421,35053275,35054078,35058308,35062705,35067271,35078181,35 ... | 35020614,35021502,35038216,35038524,35039433,35040047,35041520,35052505,35053351,35054204,35058488,35062932,35067322,35078264,35 ... |
RPS6KA5 | NM_001322237 | chr24 | - | 19772886 | 19800302 | 19800302 | 19800302 | 3 | 19772886,19791329,19800273, | 19772915,19791351,19800302, |
RPS6KA5 | NM_001322237 | chr12 | + | 38258097 | 38794579 | 38794579 | 38794579 | 4 | 38258097,38551712,38552625,38794561, | 38258139,38551727,38552641,38794579, |
CDA | NM_001193110 | chr2 | - | 78983856 | 79005723 | 78984244 | 79005709 | 6 | 78983856,78984237,78984287,78987552,78993444,79005563, | 78983973,78984273,78984361,78987610,78993564,79005723, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|