|
|
Database: panPan2 Primary Table: xenoRefFlat Row Count: 240,975   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 | LOC101929415 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NR_125813 | varchar(255) | values | Name of gene |
chrom | chr8 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 50239022 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 50340887 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 50340887 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 50340887 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 3 | int(10) unsigned | range | Number of exons |
exonStarts | 50239022,50289279,50340814, | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 50239715,50289412,50340887, | 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 |
---|
LOC101929415 | NR_125813 | chr8 | + | 50239022 | 50340887 | 50340887 | 50340887 | 3 | 50239022,50289279,50340814, | 50239715,50289412,50340887, |
TRIM38 | NM_001290237 | chr6 | + | 26458062 | 26475147 | 26458062 | 26475126 | 4 | 26458062,26463328,26464623,26474601, | 26458306,26463561,26464728,26475147, |
RBMY1A1 | NM_001320944 | chrX | - | 136269091 | 136273989 | 136269091 | 136273989 | 7 | 136269091,136269990,136271079,136272516,136272600,136273579,136273881, | 136269155,136270074,136271226,136272600,136272655,136273663,136273989, |
CEP85 | NM_001319944 | chr1 | + | 26562790 | 26607852 | 26568333 | 26606336 | 14 | 26562790,26568315,26572695,26583619,26586071,26586616,26588077,26597540,26598517,26600071,26601076,26604003,26605576,26606178, | 26562901,26568388,26572848,26584314,26586205,26586734,26588263,26597693,26598672,26600165,26601127,26604111,26605802,26607852, |
dst | NM_001164955 | chr1 | + | 40059552 | 40090787 | 40059552 | 40090787 | 11 | 40059552,40061987,40064697,40065869,40069327,40070132,40071593,40071762,40072820,40079543,40090701, | 40059630,40062149,40064793,40065989,40069381,40070195,40071741,40071764,40072922,40079661,40090787, |
PURA | NM_001009447 | chr5 | + | 141599007 | 141599878 | 141599007 | 141599762 | 4 | 141599007,141599090,141599708,141599829, | 141599085,141599670,141599774,141599878, |
sin3b | NM_001078821 | chr19 | + | 17296254 | 17345509 | 17296254 | 17345509 | 20 | 17296254,17296539,17298229,17309211,17314340,17320411,17321532,17329708,17329783,17331026,17333335,17334297,17334503,17337388,17 ... | 17296275,17296635,17298394,17309346,17314484,17320501,17321652,17329777,17329915,17331146,17333571,17334481,17334506,17337586,17 ... |
LOC693063 | NM_001044051 | chr14 | + | 66818460 | 66835924 | 66818460 | 66835924 | 6 | 66818460,66828190,66830127,66834115,66835003,66835858, | 66818692,66828243,66830235,66834173,66835101,66835924, |
TINAG | NM_001278025 | chr6 | + | 55517891 | 55581004 | 55517891 | 55581004 | 5 | 55517891,55534330,55538442,55545576,55580911, | 55517993,55534427,55538582,55545633,55581004, |
Slc22a26 | NM_146232 | chr11 | - | 61868570 | 61935096 | 61868618 | 61935088 | 6 | 61868570,61869587,61870311,61889605,61923066,61934687, | 61868651,61869746,61870347,61889734,61923117,61935096, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|