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
fieldexampleSQL type info description
name ENSMUST00000193812.1varchar(255) values Name of gene
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
strand +char(1) values + or - for strand
txStart 3073252int(10) unsigned range Transcription start position (or end position for minus strand item)
txEnd 3074322int(10) unsigned range Transcription end position (or start position for minus strand item)
cdsStart 3073252int(10) unsigned range Coding region start (or end position if for minus strand item)
cdsEnd 3073252int(10) unsigned range Coding region end (or start position if for minus strand item)
exonCount 1int(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.1varchar(255) values Unique identifier (GENCODE transcript ID for GENCODE Basic)

Connected Tables and Joining Fields
        mm10.kg10ToKg11.oldId (via knownGeneOld11.name)
      mm10.kgXrefOld11.kgID (via knownGeneOld11.name)

Sample Rows
 
namechromstrandtxStarttxEndcdsStartcdsEndexonCountexonStartsexonEndsproteinIDalignID
ENSMUST00000193812.1chr1+307325230743223073252307325213073252,3074322,uc287gdb.1
ENSMUST00000082908.1chr1+310201531021253102015310201513102015,3102125,uc287gdc.1
ENSMUST00000162897.1chr1-320590032163443205900320590023205900,3213608,3207317,3216344,uc287gdd.1
ENSMUST00000159265.1chr1-320652232156323206522320652223206522,3213438,3207317,3215632,uc007aet.2
ENSMUST00000070533.4chr1-321448136714983216021367134833214481,3421701,3670551,3216968,3421901,3671498,Q5GH67uc007aeu.1
ENSMUST00000195335.1chr1-336573033685493365730336573013365730,3368549,uc287gdf.1
ENSMUST00000192336.1chr1-337555533777883375555337555513375555,3377788,uc287gdg.1
ENSMUST00000194099.1chr1-346497634672853464976346497613464976,3467285,uc287gdh.1
ENSMUST00000161581.1chr1+346658635135533466586346658623466586,3513404,3466687,3513553,uc287gdi.1
ENSMUST00000192973.1chr1-351245035145073512450351245013512450,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.