|
|
Database: rheMac10 Primary Table: xenoRefFlat Row Count: 234,551   Data last updated: 2019-07-17
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | PGBD2 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001017434 | varchar(255) | values | Name of gene |
chrom | chr1 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 8426 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 26669 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 9001 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 10027 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 4 | int(10) unsigned | range | Number of exons |
exonStarts | 8426,8819,13490,26569, | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 8759,10086,13554,26669, | 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 |
---|
PGBD2 | NM_001017434 | chr1 | - | 8426 | 26669 | 9001 | 10027 | 4 | 8426,8819,13490,26569, | 8759,10086,13554,26669, |
PGBD2 | NM_170725 | chr1 | - | 8426 | 26677 | 9001 | 13507 | 4 | 8426,8819,13490,26569, | 8759,10763,13554,26677, |
Zfp692 | NM_001040686 | chr1 | + | 71624 | 80479 | 72386 | 80479 | 12 | 71624,72386,72829,73189,74136,74374,74924,75061,75240,76825,80038,80301, | 71657,72558,72861,73445,74187,74408,74945,75141,75319,76940,80138,80479, |
Zfp692 | NM_182996 | chr1 | + | 71624 | 80479 | 72386 | 80479 | 12 | 71624,72386,72829,73189,74136,74374,74924,75061,75240,76825,80038,80301, | 71657,72558,72861,73445,74187,74408,74945,75141,75319,76940,80138,80479, |
ZNF692 | NM_001024496 | chr1 | + | 72399 | 80618 | 72399 | 80602 | 12 | 72399,72829,73188,73425,74280,74376,74755,75063,75240,76825,80038,80301, | 72558,72861,73375,73455,74304,74407,74974,75141,75319,76940,80138,80618, |
ZNF692 | NM_001099356 | chr1 | + | 72415 | 80365 | 72415 | 80365 | 6 | 72415,75088,75237,76823,80038,80301, | 72560,75138,75317,76940,80138,80365, |
znf692 | NM_001123276 | chr1 | + | 72427 | 80464 | 72427 | 80464 | 5 | 72427,76819,80043,80301,80389, | 72553,76939,80138,80365,80464, |
Zfp692 | NM_001126272 | chr1 | + | 74130 | 80475 | 75061 | 80475 | 7 | 74130,74374,75061,75240,76825,80038,80301, | 74187,74460,75141,75319,76940,80138,80475, |
ZNF672 | NM_024836 | chr1 | - | 81268 | 91705 | 82137 | 83496 | 4 | 81268,85104,86131,91378, | 83719,85202,86285,91705, |
Zfp672 | NM_001256516 | chr1 | - | 82224 | 83466 | 82224 | 83466 | 3 | 82224,82938,83035, | 82905,83004,83466, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|