|
|
Database: priPac1 Primary Table: xenoRefFlat Row Count: 238,292   Data last updated: 2020-08-22
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | RPL32 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001001636 | varchar(255) | values | Name of gene |
chrom | chrUn | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 51782802 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 51783303 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 51782802 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 51783303 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 2 | int(10) unsigned | range | Number of exons |
exonStarts | 51782802,51783156, | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 51782979,51783303, | 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 |
---|
RPL32 | NM_001001636 | chrUn | + | 51782802 | 51783303 | 51782802 | 51783303 | 2 | 51782802,51783156, | 51782979,51783303, |
B-H2 | NM_078662 | chrUn | - | 132393233 | 132393398 | 132393233 | 132393398 | 1 | 132393233, | 132393398, |
plc-1 | NM_001136455 | chrUn | - | 153810223 | 153825050 | 153810223 | 153825050 | 37 | 153810223,153811246,153811554,153812134,153812255,153812982,153813093,153813542,153814182,153814307,153814479,153815187,15381585 ... | 153810316,153811321,153811602,153812191,153812351,153813051,153813261,153813566,153814260,153814403,153814566,153815238,15381592 ... |
CEBPZOS | NM_001322376 | chrUn | - | 103431112 | 103431322 | 103431322 | 103431322 | 1 | 103431112, | 103431322, |
CEBPZOS | NM_001322376 | chrUn | + | 11046204 | 11046486 | 11046486 | 11046486 | 1 | 11046204, | 11046486, |
CEBPZOS | NM_001322376 | chrUn | + | 5889425 | 5889790 | 5889790 | 5889790 | 2 | 5889425,5889667, | 5889560,5889790, |
WDR13 | NR_029427 | chrUn | - | 133746725 | 133746908 | 133746908 | 133746908 | 1 | 133746725, | 133746908, |
ABCF3 | NM_018358 | chrUn | - | 129349439 | 129366911 | 129349439 | 129366911 | 6 | 129349439,129349615,129349959,129351058,129351275,129366812, | 129349505,129349699,129349998,129351166,129351413,129366911, |
LARP6 | NM_018357 | chrUn | + | 11046214 | 11046485 | 11046485 | 11046485 | 1 | 11046214, | 11046485, |
LARP6 | NM_018357 | chrUn | + | 5889424 | 5889790 | 5889790 | 5889790 | 3 | 5889424,5889526,5889666, | 5889486,5889557,5889790, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|