|
|
Database: dipOrd1 Primary Table: xenoRefFlat Row Count: 666,567 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 | DLGAP2 | varchar(255) | Name of gene as it appears in genome browser. |
name | NM_001346810 | varchar(255) | Name of gene |
chrom | scaffold_22357 | varchar(255) | Reference sequence chromosome or scaffold |
strand | + | char(1) | + or - for strand |
txStart | 283 | int(10) unsigned | Transcription start position (or end position for minus strand item) |
txEnd | 1157 | int(10) unsigned | Transcription end position (or start position for minus strand item) |
cdsStart | 1157 | int(10) unsigned | Coding region start (or end position for minus strand item) |
cdsEnd | 1157 | int(10) unsigned | Coding region end (or start position for minus strand item) |
exonCount | 4 | int(10) unsigned | Number of exons |
exonStarts | 283,352,880,1041, | longblob | Exon start positions (or end positions for minus strand item) |
exonEnds | 331,380,928,1157, | 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 |
---|
DLGAP2 | NM_001346810 | scaffold_22357 | + | 283 | 1157 | 1157 | 1157 | 4 | 283,352,880,1041, | 331,380,928,1157, |
LOC108579106 | NM_001365301 | scaffold_15658 | + | 20236 | 25231 | 20236 | 25231 | 6 | 20236,21018,21894,23259,24069,25135, | 20362,21156,21972,23313,24195,25231, |
nkcc-1 | NM_001276883 | scaffold_95 | + | 18789 | 77988 | 18789 | 77988 | 7 | 18789,23455,32465,34917,65667,65935,77856, | 18909,23563,32564,35016,65707,65955,77988, |
POLR2M | NM_015532 | scaffold_9461 | - | 4849 | 6815 | 5851 | 6815 | 14 | 4849,4935,5320,5550,5727,5756,5847,5940,5971,6038,6293,6386,6498,6765, | 4926,4990,5499,5691,5746,5814,5931,5970,6016,6104,6326,6493,6761,6815, |
CTRB1 | NM_001105330 | scaffold_42461 | + | 5958 | 7542 | 5958 | 7539 | 5 | 5958,6170,6546,6795,7377, | 6070,6242,6691,6909,7542, |
Trhde | NM_001108991 | scaffold_16250 | + | 6151 | 6430 | 6151 | 6430 | 1 | 6151, | 6430, |
Mff | NM_001310697 | scaffold_367 | - | 178729 | 179687 | 178856 | 179510 | 9 | 178729,178772,178872,179063,179361,179384,179427,179461,179630, | 178750,178872,179052,179359,179382,179426,179459,179598,179687, |
Rgs3 | NM_001310706 | scaffold_2415 | + | 84708 | 103104 | 102161 | 103104 | 9 | 84708,102161,102313,102388,102436,102474,102608,102632,102781, | 84810,102283,102373,102413,102466,102493,102623,102719,103104, |
lrp8 | NM_001256393 | scaffold_3319 | + | 51911 | 63545 | 51911 | 63545 | 12 | 51911,53762,53924,54101,54275,54322,54725,54948,57427,58352,60916,63452, | 51968,53882,54008,54215,54280,54443,54837,55079,57545,58498,60958,63545, |
casq2 | NM_001002682 | scaffold_15223 | - | 27781 | 30266 | 27781 | 30266 | 3 | 27781,28779,30161, | 27886,28845,30266, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|