Schema for knownCanonical
  Database: hg38    Primary Table: knownCanonical    Row Count: 70,116   Data last updated: 2023-08-22
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chrXvarchar(255) values Chromosome
chromStart 100627107int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 100636806int(11) range End position (non-inclusive). Represents transcription end for + strand genes, start for - strand genes
clusterId 1int(11) range Which cluster of transcripts this belongs to in knownIsoforms
transcript ENST00000373020.9varchar(255) values Corresponds to knownGene name field.
protein ENSG00000000003.16varchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        hg38.knownIsoforms.clusterId (via knownCanonical.clusterId)
      knownGeneV39.knownCanonical.clusterId (via knownCanonical.clusterId)
      knownGeneV39.knownIsoforms.clusterId (via knownCanonical.clusterId)
      hg38.bioCycPathway.kgID (via knownCanonical.transcript)
      hg38.ccdsKgMap.geneId (via knownCanonical.transcript)
      hg38.ceBlastTab.query (via knownCanonical.transcript)
      hg38.dmBlastTab.query (via knownCanonical.transcript)
      hg38.drBlastTab.query (via knownCanonical.transcript)
      hg38.foldUtr3.name (via knownCanonical.transcript)
      hg38.foldUtr5.name (via knownCanonical.transcript)
      hg38.gnfAtlas2Distance.query (via knownCanonical.transcript)
      hg38.gnfAtlas2Distance.target (via knownCanonical.transcript)
      hg38.gnfU95Distance.query (via knownCanonical.transcript)
      hg38.gnfU95Distance.target (via knownCanonical.transcript)
      hg38.humanHprdP2P.query (via knownCanonical.transcript)
      hg38.humanHprdP2P.target (via knownCanonical.transcript)
      hg38.humanVidalP2P.query (via knownCanonical.transcript)
      hg38.humanVidalP2P.target (via knownCanonical.transcript)
      hg38.humanWankerP2P.query (via knownCanonical.transcript)
      hg38.humanWankerP2P.target (via knownCanonical.transcript)
      hg38.keggPathway.kgID (via knownCanonical.transcript)
      hg38.kgAlias.kgID (via knownCanonical.transcript)
      hg38.kgColor.kgID (via knownCanonical.transcript)
      hg38.kgProtAlias.kgID (via knownCanonical.transcript)
      hg38.kgSpAlias.kgID (via knownCanonical.transcript)
      hg38.kgTargetAli.qName (via knownCanonical.transcript)
      hg38.kgXref.kgID (via knownCanonical.transcript)
      hg38.knownAttrs.kgID (via knownCanonical.transcript)
      hg38.knownBlastTab.query (via knownCanonical.transcript)
      hg38.knownBlastTab.target (via knownCanonical.transcript)
      hg38.knownCds.name (via knownCanonical.transcript)
      hg38.knownGene.name (via knownCanonical.transcript)
      hg38.knownGeneMrna.name (via knownCanonical.transcript)
      hg38.knownGenePep.name (via knownCanonical.transcript)
      hg38.knownIsoforms.transcript (via knownCanonical.transcript)
      hg38.knownToEnsembl.name (via knownCanonical.transcript)
      hg38.knownToGnfAtlas2.name (via knownCanonical.transcript)
      hg38.knownToHprd.name (via knownCanonical.transcript)
      hg38.knownToKeggEntrez.name (via knownCanonical.transcript)
      hg38.knownToLocusLink.name (via knownCanonical.transcript)
      hg38.knownToLynx.name (via knownCanonical.transcript)
      hg38.knownToMrna.name (via knownCanonical.transcript)
      hg38.knownToMrnaSingle.name (via knownCanonical.transcript)
      hg38.knownToMupit.name (via knownCanonical.transcript)
      hg38.knownToNextProt.name (via knownCanonical.transcript)
      hg38.knownToPfam.name (via knownCanonical.transcript)
      hg38.knownToRefSeq.name (via knownCanonical.transcript)
      hg38.knownToSuper.gene (via knownCanonical.transcript)
      hg38.knownToTag.name (via knownCanonical.transcript)
      hg38.knownToU133.name (via knownCanonical.transcript)
      hg38.knownToU95.name (via knownCanonical.transcript)
      hg38.knownToVisiGene.name (via knownCanonical.transcript)
      hg38.knownToWikipedia.name (via knownCanonical.transcript)
      hg38.mmBlastTab.query (via knownCanonical.transcript)
      hg38.rnBlastTab.query (via knownCanonical.transcript)
      hg38.scBlastTab.query (via knownCanonical.transcript)
      hg38.ucscScop.ucscId (via knownCanonical.transcript)
      knownGeneV39.bioCycPathway.kgID (via knownCanonical.transcript)
      knownGeneV39.ceBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.dmBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.drBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.foldUtr3.name (via knownCanonical.transcript)
      knownGeneV39.foldUtr5.name (via knownCanonical.transcript)
      knownGeneV39.gnfAtlas2Distance.query (via knownCanonical.transcript)
      knownGeneV39.gnfAtlas2Distance.target (via knownCanonical.transcript)
      knownGeneV39.kgAlias.kgID (via knownCanonical.transcript)
      knownGeneV39.kgColor.kgID (via knownCanonical.transcript)
      knownGeneV39.kgProtAlias.kgID (via knownCanonical.transcript)
      knownGeneV39.kgSpAlias.kgID (via knownCanonical.transcript)
      knownGeneV39.kgTargetAli.qName (via knownCanonical.transcript)
      knownGeneV39.kgXref.kgID (via knownCanonical.transcript)
      knownGeneV39.knownAttrs.kgID (via knownCanonical.transcript)
      knownGeneV39.knownBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.knownBlastTab.target (via knownCanonical.transcript)
      knownGeneV39.knownCanonical.protein (via knownCanonical.transcript)
      knownGeneV39.knownCanonical.transcript (via knownCanonical.transcript)
      knownGeneV39.knownCds.name (via knownCanonical.transcript)
      knownGeneV39.knownGene.name (via knownCanonical.transcript)
      knownGeneV39.knownGeneMrna.name (via knownCanonical.transcript)
      knownGeneV39.knownGenePep.name (via knownCanonical.transcript)
      knownGeneV39.knownIsoforms.transcript (via knownCanonical.transcript)
      knownGeneV39.knownToEnsembl.name (via knownCanonical.transcript)
      knownGeneV39.knownToGnfAtlas2.name (via knownCanonical.transcript)
      knownGeneV39.knownToHprd.name (via knownCanonical.transcript)
      knownGeneV39.knownToLocusLink.name (via knownCanonical.transcript)
      knownGeneV39.knownToMrna.name (via knownCanonical.transcript)
      knownGeneV39.knownToMrnaSingle.name (via knownCanonical.transcript)
      knownGeneV39.knownToMupit.name (via knownCanonical.transcript)
      knownGeneV39.knownToPfam.name (via knownCanonical.transcript)
      knownGeneV39.knownToRefSeq.name (via knownCanonical.transcript)
      knownGeneV39.knownToSuper.gene (via knownCanonical.transcript)
      knownGeneV39.knownToTag.name (via knownCanonical.transcript)
      knownGeneV39.knownToU133.name (via knownCanonical.transcript)
      knownGeneV39.knownToU95.name (via knownCanonical.transcript)
      knownGeneV39.knownToVisiGene.name (via knownCanonical.transcript)
      knownGeneV39.knownToWikipedia.name (via knownCanonical.transcript)
      knownGeneV39.mmBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.rnBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.scBlastTab.query (via knownCanonical.transcript)
      knownGeneV39.ucscScop.ucscId (via knownCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chrX1006271071006368061ENST00000373020.9ENSG00000000003.16
chrX1005849351005998852ENST00000373031.5ENSG00000000005.6
chr2050934869509585323ENST00000371588.10ENSG00000000419.14
chr11698496301698938964ENST00000367771.11ENSG00000000457.14
chr11697950391698540805ENST00000359326.9ENSG00000000460.17
chr127612063276351856ENST00000374005.8ENSG00000000938.13
chr11966520421967475047ENST00000367429.9ENSG00000000971.17
chr61434948111435117208ENST00000002165.11ENSG00000001036.14
chr653497340535451019ENST00000650454.1ENSG00000001084.13
chr6410729734110240310ENST00000341376.11ENSG00000001167.15

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.