Schema for Old UCSC Genes - Previous Version of UCSC Genes
|
|
Database: mm10 Primary Table: knownGeneOld11 Row Count: 138,930   Data last updated: 2019-09-19
Format description: Transcript from default gene set in UCSC browser On download server: MariaDB table dump directory
field | example | SQL type | info | description |
name | ENSMUST00000193812.1 | varchar(255) | values | Name of gene |
chrom | chr1 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | + | char(1) | values | + or - for strand |
txStart | 3073252 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 3074322 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 3073252 | int(10) unsigned | range | Coding region start (or end position if for minus strand item) |
cdsEnd | 3073252 | int(10) unsigned | range | Coding region end (or start position if for minus strand item) |
exonCount | 1 | int(10) unsigned | range | Number of exons |
exonStarts | 3073252, | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 3074322, | longblob | | Exon end positions (or start positions for minus strand item) |
proteinID | | varchar(40) | values | UniProt display ID, UniProt accession, or RefSeq protein ID |
alignID | uc287gdb.1 | varchar(255) | values | Unique identifier (GENCODE transcript ID for GENCODE Basic) |
|
| |
|
|
Sample Rows
|
|
name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds | proteinID | alignID |
---|
ENSMUST00000193812.1 | chr1 | + | 3073252 | 3074322 | 3073252 | 3073252 | 1 | 3073252, | 3074322, | | uc287gdb.1 |
ENSMUST00000082908.1 | chr1 | + | 3102015 | 3102125 | 3102015 | 3102015 | 1 | 3102015, | 3102125, | | uc287gdc.1 |
ENSMUST00000162897.1 | chr1 | - | 3205900 | 3216344 | 3205900 | 3205900 | 2 | 3205900,3213608, | 3207317,3216344, | | uc287gdd.1 |
ENSMUST00000159265.1 | chr1 | - | 3206522 | 3215632 | 3206522 | 3206522 | 2 | 3206522,3213438, | 3207317,3215632, | | uc007aet.2 |
ENSMUST00000070533.4 | chr1 | - | 3214481 | 3671498 | 3216021 | 3671348 | 3 | 3214481,3421701,3670551, | 3216968,3421901,3671498, | Q5GH67 | uc007aeu.1 |
ENSMUST00000195335.1 | chr1 | - | 3365730 | 3368549 | 3365730 | 3365730 | 1 | 3365730, | 3368549, | | uc287gdf.1 |
ENSMUST00000192336.1 | chr1 | - | 3375555 | 3377788 | 3375555 | 3375555 | 1 | 3375555, | 3377788, | | uc287gdg.1 |
ENSMUST00000194099.1 | chr1 | - | 3464976 | 3467285 | 3464976 | 3464976 | 1 | 3464976, | 3467285, | | uc287gdh.1 |
ENSMUST00000161581.1 | chr1 | + | 3466586 | 3513553 | 3466586 | 3466586 | 2 | 3466586,3513404, | 3466687,3513553, | | uc287gdi.1 |
ENSMUST00000192973.1 | chr1 | - | 3512450 | 3514507 | 3512450 | 3512450 | 1 | 3512450, | 3514507, | | uc287gdj.1 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
Old UCSC Genes (knownGeneOld11) Track Description
|
|
Description
The Old UCSC Genes track shows genes from the previous version of
the UCSC Genes build.
Read the current version's description page
for more information on how that track was built.
| |
|
|
|