Schema for knownCanonical
  Database: hg16    Primary Table: knownCanonical    Row Count: 21,364   Data last updated: 2004-03-29
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chr1varchar(255) values Chromosome
chromStart 364535int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 368303int(11) range End position (non-inclusive). Represents transcription end for + strand genes, start for - strand genes
clusterId 1int(10) unsigned range Which cluster of transcripts this belongs to in knownIsoforms
transcript AK128780varchar(255) values Corresponds to knownGene name field.
protein BAC87609varchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        hg16.knownIsoforms.clusterId (via knownCanonical.clusterId)
      knownGeneV39.knownCanonical.clusterId (via knownCanonical.clusterId)
      knownGeneV39.knownIsoforms.clusterId (via knownCanonical.clusterId)
      go.goaPart.dbObjectSymbol (via knownCanonical.protein)
      hg16.dupSpMrna.dupProteinID (via knownCanonical.protein)
      hg16.dupSpMrna.proteinID (via knownCanonical.protein)
      hg16.kgProtAlias.displayID (via knownCanonical.protein)
      hg16.kgXref.spDisplayID (via knownCanonical.protein)
      hg16.spMrna.spID (via knownCanonical.protein)
      knownGeneV39.kgProtAlias.displayID (via knownCanonical.protein)
      knownGeneV39.kgSpAlias.alias (via knownCanonical.protein)
      knownGeneV39.kgXref.spDisplayID (via knownCanonical.protein)
      knownGeneV39.knownCanonical.protein (via knownCanonical.protein)
      proteome.spOldNew.newDisplayId (via knownCanonical.protein)
      proteome.spOldNew.oldDisplayId (via knownCanonical.protein)
      uniProt.displayId.val (via knownCanonical.protein)
      hg16.bioCycPathway.kgID (via knownCanonical.transcript)
      hg16.dmBlastTab.query (via knownCanonical.transcript)
      hg16.drBlastTab.query (via knownCanonical.transcript)
      hg16.dupSpMrna.mrnaID (via knownCanonical.transcript)
      hg16.foldUtr3.name (via knownCanonical.transcript)
      hg16.foldUtr5.name (via knownCanonical.transcript)
      hg16.gnfAtlas2Distance.query (via knownCanonical.transcript)
      hg16.gnfAtlas2Distance.target (via knownCanonical.transcript)
      hg16.gnfU95Distance.query (via knownCanonical.transcript)
      hg16.gnfU95Distance.target (via knownCanonical.transcript)
      hg16.hg17Kg.name (via knownCanonical.transcript)
      hg16.keggPathway.kgID (via knownCanonical.transcript)
      hg16.kgAlias.kgID (via knownCanonical.transcript)
      hg16.kgProtAlias.kgID (via knownCanonical.transcript)
      hg16.kgXref.kgID (via knownCanonical.transcript)
      hg16.knownBlastTab.query (via knownCanonical.transcript)
      hg16.knownBlastTab.target (via knownCanonical.transcript)
      hg16.knownGene.name (via knownCanonical.transcript)
      hg16.knownGeneLink.name (via knownCanonical.transcript)
      hg16.knownGeneMrna.name (via knownCanonical.transcript)
      hg16.knownGenePep.name (via knownCanonical.transcript)
      hg16.knownIsoforms.transcript (via knownCanonical.transcript)
      hg16.knownToEnsembl.name (via knownCanonical.transcript)
      hg16.knownToGnfAtlas2.name (via knownCanonical.transcript)
      hg16.knownToHInv.name (via knownCanonical.transcript)
      hg16.knownToLocusLink.name (via knownCanonical.transcript)
      hg16.knownToPfam.name (via knownCanonical.transcript)
      hg16.knownToRefSeq.name (via knownCanonical.transcript)
      hg16.knownToSuper.gene (via knownCanonical.transcript)
      hg16.knownToU133.name (via knownCanonical.transcript)
      hg16.knownToU95.name (via knownCanonical.transcript)
      hg16.scBlastTab.query (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
chr13645353683031AK128780BAC87609
chr15021345034532BC031359Q8N5W6
chr17926137950773AK097327Q8N852
chr18317608324914BC015393Q96BN7
chr1101534310393715AK124125BAC85781
chr1107187510755526AY050570Q96L58
chr1107608810764767BC015549Q96BI9
chr1109536410959738AF116687Q9P1E8
chr1112354611334629AK093239SCAD_HUMAN
chr11150051115311410BC034304Q8N0Z8

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