|
|
Database: gorGor3 Primary Table: xenoRefFlat Row Count: 554,749   Data last updated: 2020-08-21
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | description |
geneName | SPATA33 | varchar(255) | Name of gene as it appears in genome browser. |
name | NM_001271910 | varchar(255) | Name of gene |
chrom | chr16 | varchar(255) | Reference sequence chromosome or scaffold |
strand | + | char(1) | + or - for strand |
txStart | 80395519 | int(10) unsigned | Transcription start position (or end position for minus strand item) |
txEnd | 80395976 | int(10) unsigned | Transcription end position (or start position for minus strand item) |
cdsStart | 80395976 | int(10) unsigned | Coding region start (or end position for minus strand item) |
cdsEnd | 80395976 | int(10) unsigned | Coding region end (or start position for minus strand item) |
exonCount | 2 | int(10) unsigned | Number of exons |
exonStarts | 80395519,80395546, | longblob | Exon start positions (or end positions for minus strand item) |
exonEnds | 80395537,80395976, | 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 |
---|
SPATA33 | NM_001271910 | chr16 | + | 80395519 | 80395976 | 80395976 | 80395976 | 2 | 80395519,80395546, | 80395537,80395976, |
SPATA33 | NM_001271910 | chr16 | + | 80383540 | 80396119 | 80383648 | 80395199 | 3 | 80383540,80383989,80395189, | 80383685,80384130,80396119, |
HNRNPDL | NM_001207000 | chr4 | - | 91231471 | 91239154 | 91234956 | 91238619 | 7 | 91231471,91234934,91236074,91236322,91236907,91237167,91238176, | 91233780,91235027,91236189,91236454,91237069,91237336,91239154, |
2010315B03Rik | NM_001243117 | chr19 | - | 12571770 | 12825742 | 12699912 | 12825742 | 14 | 12571770,12699494,12699635,12699912,12700269,12700616,12764378,12764698,12764766,12764934,12765102,12825038,12825106,12825691, | 12571836,12699551,12699675,12700101,12700280,12700700,12764446,12764730,12764826,12764994,12765202,12825078,12825250,12825742, |
tgfbi | NM_001140391 | chr5 | + | 119502694 | 119534496 | 119502694 | 119534496 | 17 | 119502694,119507297,119517589,119519852,119519941,119520094,119520376,119520799,119522985,119523402,119526449,119527487,11952829 ... | 119502754,119507396,119517645,119519916,119520018,119520097,119520541,119520898,119523120,119523404,119526664,119527624,11952840 ... |
MAP2K1 | NM_001143716 | chr15 | + | 45699780 | 45815924 | 45699877 | 45815015 | 13 | 45699780,45754708,45756431,45763005,45806159,45809391,45811637,45813611,45814112,45814901,45815211,45815349,45815828, | 45699957,45754919,45756578,45763086,45806286,45809595,45811699,45813673,45814158,45815156,45815322,45815797,45815924, |
TNNT3 | NM_001169067 | chr11 | + | 1878947 | 1891317 | 1878947 | 1891317 | 12 | 1878947,1879177,1881672,1882361,1884972,1886552,1886762,1887163,1887377,1887660,1889789,1891262, | 1878963,1879192,1881696,1882380,1885018,1886669,1886840,1887277,1887487,1887751,1889828,1891317, |
DCAF6 | NM_001349775 | chr1 | + | 147118487 | 147263966 | 147178362 | 147263558 | 18 | 147118487,147142659,147155085,147163326,147178359,147183333,147191240,147191376,147210862,147226819,147231489,147233049,14723336 ... | 147118621,147142721,147155178,147163512,147178473,147183471,147191376,147191701,147210922,147226937,147231605,147233136,14723369 ... |
RPL15 | NM_001244065 | chr3 | + | 24667939 | 24670703 | 24668650 | 24670297 | 7 | 24667939,24668640,24669228,24669991,24670366,24670498,24670566, | 24667964,24668822,24669365,24670342,24670482,24670522,24670703, |
RPL15 | NM_001244065 | chr4 | + | 48151289 | 48152903 | 48151324 | 48151938 | 7 | 48151289,48151769,48152009,48152065,48152250,48152461,48152882, | 48151769,48151999,48152028,48152125,48152318,48152507,48152903, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|