|
|
Database: thaSir1 Primary Table: xenoRefFlat Row Count: 447,067   Data last updated: 2018-07-31
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | THBS1 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NM_001244536 | varchar(255) | values | Name of gene |
chrom | NW_013657680v1 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 51639 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 66624 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 52201 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 66624 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 24 | int(10) unsigned | range | Number of exons |
exonStarts | 51639,51723,52201,52462,527... | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 51660,51745,52339,52558,530... | 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 |
---|
THBS1 | NM_001244536 | NW_013657680v1 | - | 51639 | 66624 | 52201 | 66624 | 24 | 51639,51723,52201,52462,52798,53798,54655,56350,56940,57713,58304,59349,59600,59847,60009,60315,60377,60983,60995,61942,64864,65 ... | 51660,51745,52339,52558,53066,54028,54890,56467,57103,57754,58521,59504,59724,59851,60179,60319,60548,60987,61164,62035,64918,65 ... |
fgfr2 | NM_001243004 | NW_013659898v1 | - | 59204 | 66961 | 59204 | 66961 | 4 | 59204,61033,64069,66841, | 59339,61118,64206,66961, |
fgfr2 | NM_001243004 | NW_013660352v1 | + | 68719 | 108007 | 68719 | 108007 | 12 | 68719,70333,72838,74676,91455,93381,93633,96770,100846,102025,103756,107788, | 68827,70357,72997,74682,91579,93572,93636,96911,101017,102112,103876,108007, |
VN2R555 | NM_001102452 | NW_013658114v1 | - | 644207 | 644782 | 644207 | 644782 | 2 | 644207,644692, | 644273,644782, |
VN2R555 | NM_001102452 | NW_013658467v1 | - | 192694 | 203728 | 192694 | 195228 | 3 | 192694,195177,203644, | 192805,195228,203728, |
VN2R555 | NM_001102452 | NW_013658472v1 | - | 449976 | 479127 | 449976 | 479127 | 3 | 449976,450234,479082, | 450090,450483,479127, |
CRAT | NM_001346548 | NW_013660485v1 | + | 4095 | 17958 | 4095 | 17946 | 10 | 4095,9538,10235,10354,11390,12436,13094,15695,16974,17730, | 4221,9701,10238,10530,11492,12550,13216,15819,17041,17958, |
CRAT | NM_001346547 | NW_013660485v1 | + | 4095 | 17958 | 4095 | 17946 | 10 | 4095,9538,10235,10354,11390,12436,13094,15695,16974,17730, | 4221,9701,10238,10530,11492,12550,13216,15819,17041,17958, |
Olfr1120 | NM_147029 | NW_013658632v1 | + | 281113 | 354890 | 281113 | 354890 | 3 | 281113,354698,354833, | 281206,354743,354890, |
Olfr1120 | NM_147029 | NW_013658733v1 | + | 37540 | 69398 | 37540 | 69398 | 3 | 37540,69191,69311, | 37648,69281,69398, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|