Schema for knownCanonical
  Database: hg17    Primary Table: knownCanonical    Row Count: 20,181   Data last updated: 2005-06-04
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chrYvarchar(255) values Chromosome
chromStart 132991int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 160020int(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 NM_018390varchar(255) values Corresponds to knownGene name field.
protein Q9NUJ7_HUMANvarchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        hg17.knownIsoforms.clusterId (via knownCanonical.clusterId)
      knownGeneV39.knownCanonical.clusterId (via knownCanonical.clusterId)
      knownGeneV39.knownIsoforms.clusterId (via knownCanonical.clusterId)
      go.goaPart.dbObjectSymbol (via knownCanonical.protein)
      hg17.dupSpMrna.dupProteinID (via knownCanonical.protein)
      hg17.dupSpMrna.proteinID (via knownCanonical.protein)
      hg17.kgProtAlias.displayID (via knownCanonical.protein)
      hg17.kgSpAlias.alias (via knownCanonical.protein)
      hg17.kgXref.spDisplayID (via knownCanonical.protein)
      hg17.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)
      hg17.bioCycPathway.kgID (via knownCanonical.transcript)
      hg17.ccdsKgMap.geneId (via knownCanonical.transcript)
      hg17.ceBlastTab.query (via knownCanonical.transcript)
      hg17.dmBlastTab.query (via knownCanonical.transcript)
      hg17.drBlastTab.query (via knownCanonical.transcript)
      hg17.dupSpMrna.mrnaID (via knownCanonical.transcript)
      hg17.foldUtr3.name (via knownCanonical.transcript)
      hg17.foldUtr5.name (via knownCanonical.transcript)
      hg17.gladHumESDistance.query (via knownCanonical.transcript)
      hg17.gladHumESDistance.target (via knownCanonical.transcript)
      hg17.gnfAtlas2Distance.query (via knownCanonical.transcript)
      hg17.gnfAtlas2Distance.target (via knownCanonical.transcript)
      hg17.gnfU95Distance.query (via knownCanonical.transcript)
      hg17.gnfU95Distance.target (via knownCanonical.transcript)
      hg17.humanHprdP2P.query (via knownCanonical.transcript)
      hg17.humanHprdP2P.target (via knownCanonical.transcript)
      hg17.humanVidalP2P.query (via knownCanonical.transcript)
      hg17.humanVidalP2P.target (via knownCanonical.transcript)
      hg17.humanWankerP2P.query (via knownCanonical.transcript)
      hg17.humanWankerP2P.target (via knownCanonical.transcript)
      hg17.keggPathway.kgID (via knownCanonical.transcript)
      hg17.kgAlias.kgID (via knownCanonical.transcript)
      hg17.kgProtAlias.kgID (via knownCanonical.transcript)
      hg17.kgSpAlias.kgID (via knownCanonical.transcript)
      hg17.kgTargetAli.qName (via knownCanonical.transcript)
      hg17.kgXref.kgID (via knownCanonical.transcript)
      hg17.knownBlastTab.query (via knownCanonical.transcript)
      hg17.knownBlastTab.target (via knownCanonical.transcript)
      hg17.knownExpDistance.query (via knownCanonical.transcript)
      hg17.knownExpDistance.target (via knownCanonical.transcript)
      hg17.knownGene.name (via knownCanonical.transcript)
      hg17.knownGeneLink.name (via knownCanonical.transcript)
      hg17.knownGeneMrna.name (via knownCanonical.transcript)
      hg17.knownGenePep.name (via knownCanonical.transcript)
      hg17.knownIsoforms.transcript (via knownCanonical.transcript)
      hg17.knownToAllenBrain.name (via knownCanonical.transcript)
      hg17.knownToEnsembl.name (via knownCanonical.transcript)
      hg17.knownToGnf1h.name (via knownCanonical.transcript)
      hg17.knownToGnfAtlas2.name (via knownCanonical.transcript)
      hg17.knownToHInv.name (via knownCanonical.transcript)
      hg17.knownToHprd.name (via knownCanonical.transcript)
      hg17.knownToKeggEntrez.name (via knownCanonical.transcript)
      hg17.knownToLocusLink.name (via knownCanonical.transcript)
      hg17.knownToPfam.name (via knownCanonical.transcript)
      hg17.knownToRefSeq.name (via knownCanonical.transcript)
      hg17.knownToSuper.gene (via knownCanonical.transcript)
      hg17.knownToU133.name (via knownCanonical.transcript)
      hg17.knownToU133Plus2.name (via knownCanonical.transcript)
      hg17.knownToU95.name (via knownCanonical.transcript)
      hg17.knownToVisiGene.name (via knownCanonical.transcript)
      hg17.mmBlastTab.query (via knownCanonical.transcript)
      hg17.rankProp.query (via knownCanonical.transcript)
      hg17.rankProp.target (via knownCanonical.transcript)
      hg17.rnBlastTab.query (via knownCanonical.transcript)
      hg17.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
chrY1329911600201NM_018390Q9NUJ7_HUMAN
chrY5550785823182NM_000451SHOX_HUMAN
chrY149918715454083NM_002183IL3RA_HUMAN
chrY155649415582744AK123701Q6ZW28_HUMAN
chrY156464015781465AK023392Q9H8Q0_HUMAN
chrY175431217652366NM_005088XE7_HUMAN
chrY260258826527097NM_002414MIC2_HUMAN
chrY275301427783538NM_001008RS4Y_HUMAN
chrY284690628932529NM_003411ZFY_HUMAN
chrY3490486349144110NM_139214TF2LY_HUMAN

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