|
|
Database: xenTro10 Primary Table: xenoRefFlat Row Count: 170,176   Data last updated: 2021-03-24
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | pga | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001078583 | varchar(255) | values | Name of gene |
chrom | chr1 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 53888 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 78287 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 53888 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 78287 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 4 | int(10) unsigned | range | Number of exons |
exonStarts | 53888,55059,62337,78203, | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 53999,55095,62403,78287, | 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 |
---|
pga | NM_001078583 | chr1 | + | 53888 | 78287 | 53888 | 78287 | 4 | 53888,55059,62337,78203, | 53999,55095,62403,78287, |
PGA5 | NM_001082696 | chr1 | + | 53888 | 87633 | 53888 | 87633 | 5 | 53888,55059,62286,78215,87552, | 53999,55095,62391,78275,87633, |
PAG-8 | NM_001285722 | chr1 | + | 53888 | 87633 | 53888 | 87633 | 4 | 53888,62289,78203,87540, | 54002,62355,78275,87633, |
dok1.L | NM_001092439 | chr1 | - | 130043 | 194338 | 130452 | 188226 | 13 | 130043,130079,130203,130359,130449,130532,131117,131252,131472,133759,187527,188121,194261, | 130070,130100,130219,130408,130532,130574,131206,131463,132165,133933,187623,188418,194338, |
mrps26.L | NM_001091176 | chr1 | - | 200921 | 205292 | 200930 | 205265 | 5 | 200921,201382,203466,205059,205235, | 201065,201506,203613,205235,205292, |
loxl3b | NM_001145684 | chr1 | + | 263129 | 324305 | 263129 | 324302 | 13 | 263129,263593,265371,274812,276003,277895,282114,284401,285972,286198,288415,294496,324228, | 263326,263756,265398,274982,276163,277934,282273,284643,286086,286202,288550,294608,324305, |
loxl3a | NM_001199870 | chr1 | + | 263135 | 294610 | 263135 | 294610 | 12 | 263135,263593,265464,274812,276007,278016,282117,284401,285970,286199,288415,294496, | 263326,263753,265539,274986,276157,278040,282273,284641,286087,286202,288550,294610, |
Loxl3 | NM_001107866 | chr1 | + | 263138 | 324302 | 263138 | 324302 | 14 | 263138,263589,265362,265419,274812,276076,277883,282601,284401,285972,286099,288415,294500,324230, | 263322,263756,265395,265566,274986,276100,278048,282703,284643,286087,286102,288554,294610,324302, |
LOXL3 | NM_001192969 | chr1 | + | 263138 | 324302 | 263138 | 324302 | 13 | 263138,263589,265368,265419,274812,282180,282601,284401,285972,286099,288415,294496,324228, | 263322,263756,265395,265566,274986,282255,282703,284643,286087,286102,288550,294608,324302, |
LOXL3 | NM_001289164 | chr1 | + | 263138 | 324308 | 263138 | 324302 | 11 | 263138,263589,274812,282180,282601,284401,285972,286099,288415,294496,324230, | 263322,263753,274986,282255,282703,284643,286087,286102,288550,294610,324308, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|