|
|
Database: cerSim1 Primary Table: xenoRefFlat Row Count: 306,893   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 | KLHL7 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001012857 | varchar(255) | values | Name of gene |
chrom | JH767724 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 30698959 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 30767051 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 30698959 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 30767046 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 13 | int(10) unsigned | range | Number of exons |
exonStarts | 30698959,30700477,30702146,... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 30699243,30700574,30702349,... | 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 |
---|
KLHL7 | NM_001012857 | JH767724 | - | 30698959 | 30767051 | 30698959 | 30767046 | 13 | 30698959,30700477,30702146,30704450,30725682,30736909,30739429,30746844,30747238,30748203,30748225,30766902,30766926, | 30699243,30700574,30702349,30704691,30725825,30737084,30739608,30746966,30747330,30748205,30748326,30766904,30767051, |
ZNF674 | NM_001039891 | JH767800 | + | 872960 | 1155692 | 872960 | 1155692 | 10 | 872960,873171,874263,948713,948811,1134080,1154149,1154554,1155218,1155586, | 873074,873175,874359,948727,949106,1134239,1154220,1154800,1155254,1155692, |
Gdf15 | NM_001330687 | JH767731 | - | 43907717 | 43908170 | 43907717 | 43908170 | 2 | 43907717,43908074, | 43908059,43908170, |
GABRA2 | NM_001330690 | JH767724 | - | 53510187 | 53640531 | 53516915 | 53639872 | 50 | 53510187,53510294,53510345,53510451,53510590,53510677,53510788,53510903,53510927,53510953,53511191,53511652,53511806,53511910,53 ... | 53510238,53510326,53510438,53510499,53510668,53510728,53510875,53510915,53510940,53510999,53511267,53511718,53511900,53511936,53 ... |
Mucl3 | NM_001003965 | JH767735 | - | 34391310 | 34399535 | 34391311 | 34399515 | 6 | 34391310,34392408,34393303,34393408,34393555,34399433, | 34391458,34392441,34393366,34393495,34393629,34399535, |
stard4 | NM_001017679 | JH767726 | + | 31429528 | 31430748 | 31429528 | 31430748 | 2 | 31429528,31430628, | 31429648,31430748, |
ADORA2B | NM_001002944 | JH767766 | - | 2795706 | 2821807 | 2795706 | 2821807 | 4 | 2795706,2795772,2796259,2821472, | 2795769,2796256,2796376,2821807, |
nrd1b | NM_001044715 | JH767796 | - | 4278649 | 4341442 | 4278649 | 4341442 | 24 | 4278649,4280532,4281584,4282085,4282430,4284333,4286659,4288721,4291082,4293632,4295548,4296195,4298180,4303099,4303436,4303594, ... | 4278712,4280643,4281663,4282139,4282462,4284444,4286710,4288856,4291229,4293751,4295612,4296318,4298205,4303153,4303499,4303699, ... |
AI987944 | NM_183167 | JH767889 | - | 113382 | 699423 | 113382 | 699423 | 10 | 113382,113682,524553,525009,526134,595475,595587,698696,699190,699373, | 113403,113949,524646,525042,526364,595503,595633,698854,699289,699423, |
SkpA | NM_001297826 | JH767726 | + | 12279953 | 12291071 | 12279953 | 12291071 | 3 | 12279953,12289047,12290927, | 12280049,12289170,12291071, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|