Schema for knownCanonical
  Database: knownGeneV39    Primary Table: knownCanonical    Row Count: 67,882   Data last updated: 2022-01-17
On download server: MariaDB table dump directory
fieldexampleSQL type info
chrom chrXvarchar(255) values
chromStart 100627107int(11) range
chromEnd 100636806int(11) range
clusterId 1int(11) range
transcript ENST00000373020.9varchar(255) values
protein ENSG00000000003.15varchar(255) values

Connected Tables and Joining Fields
        hg16.knownCanonical.clusterId (via knownCanonical.clusterId)
      hg16.knownIsoforms.clusterId (via knownCanonical.clusterId)
      hg17.knownCanonical.clusterId (via knownCanonical.clusterId)
      hg17.knownIsoforms.clusterId (via knownCanonical.clusterId)
      hg18.knownCanonical.clusterId (via knownCanonical.clusterId)
      hg18.knownIsoforms.clusterId (via knownCanonical.clusterId)
      hg19.knownCanonical.clusterId (via knownCanonical.clusterId)
      hg19.knownIsoforms.clusterId (via knownCanonical.clusterId)
      hg38.knownCanonical.clusterId (via knownCanonical.clusterId)
      hg38.knownIsoforms.clusterId (via knownCanonical.clusterId)
      knownGeneV39.knownIsoforms.clusterId (via knownCanonical.clusterId)
      mm10.knownCanonical.clusterId (via knownCanonical.clusterId)
      mm10.knownIsoforms.clusterId (via knownCanonical.clusterId)
      mm39.knownCanonical.clusterId (via knownCanonical.clusterId)
      mm39.knownIsoforms.clusterId (via knownCanonical.clusterId)
      mm7.knownCanonical.clusterId (via knownCanonical.clusterId)
      mm7.knownIsoforms.clusterId (via knownCanonical.clusterId)
      mm8.knownCanonical.clusterId (via knownCanonical.clusterId)
      mm8.knownIsoforms.clusterId (via knownCanonical.clusterId)
      mm9.knownCanonical.clusterId (via knownCanonical.clusterId)
      mm9.knownIsoforms.clusterId (via knownCanonical.clusterId)
      rn3.knownCanonical.clusterId (via knownCanonical.clusterId)
      rn3.knownIsoforms.clusterId (via knownCanonical.clusterId)
      dm1.bdgpSwissProt.spSymbol (via knownCanonical.protein)
      dm1.flyBaseSwissProt.spSymbol (via knownCanonical.protein)
      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.knownCanonical.protein (via knownCanonical.protein)
      hg16.spMrna.spID (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.knownCanonical.protein (via knownCanonical.protein)
      hg17.spMrna.spID (via knownCanonical.protein)
      hg18.kgXref.spDisplayID (via knownCanonical.protein)
      hg18.spMrna.spID (via knownCanonical.protein)
      hg19.kgXref.spDisplayID (via knownCanonical.protein)
      hg19.spMrna.spID (via knownCanonical.protein)
      hg38.kgXref.spDisplayID (via knownCanonical.protein)
      hg38.spMrna.spID (via knownCanonical.protein)
      knownGeneV39.kgProtAlias.displayID (via knownCanonical.protein)
      knownGeneV39.kgSpAlias.alias (via knownCanonical.protein)
      knownGeneV39.kgXref.spDisplayID (via knownCanonical.protein)
      mm10.kgXref.spDisplayID (via knownCanonical.protein)
      mm10.spMrna.spID (via knownCanonical.protein)
      mm39.spMrna.spID (via knownCanonical.protein)
      mm7.dupSpMrna.dupProteinID (via knownCanonical.protein)
      mm7.dupSpMrna.proteinID (via knownCanonical.protein)
      mm7.kgProtAlias.displayID (via knownCanonical.protein)
      mm7.kgSpAlias.alias (via knownCanonical.protein)
      mm7.kgXref.spDisplayID (via knownCanonical.protein)
      mm7.knownCanonical.protein (via knownCanonical.protein)
      mm7.spMrna.spID (via knownCanonical.protein)
      mm8.dupSpMrna.dupProteinID (via knownCanonical.protein)
      mm8.dupSpMrna.proteinID (via knownCanonical.protein)
      mm8.kgProtAlias.displayID (via knownCanonical.protein)
      mm8.kgSpAlias.alias (via knownCanonical.protein)
      mm8.kgXref.spDisplayID (via knownCanonical.protein)
      mm8.knownCanonical.protein (via knownCanonical.protein)
      mm8.spMrna.spID (via knownCanonical.protein)
      mm9.kgXref.spDisplayID (via knownCanonical.protein)
      mm9.spMrna.spID (via knownCanonical.protein)
      proteome.spOldNew.newDisplayId (via knownCanonical.protein)
      proteome.spOldNew.oldDisplayId (via knownCanonical.protein)
      rn3.dupSpMrna.dupProteinID (via knownCanonical.protein)
      rn3.dupSpMrna.proteinID (via knownCanonical.protein)
      rn3.kgProtAlias.displayID (via knownCanonical.protein)
      rn3.kgSpAlias.alias (via knownCanonical.protein)
      rn3.kgXref.spDisplayID (via knownCanonical.protein)
      rn3.knownCanonical.protein (via knownCanonical.protein)
      rn3.spMrna.spID (via knownCanonical.protein)
      rn4.spMrna.spID (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.knownCanonical.transcript (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)
      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.knownCanonical.transcript (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)
      hg18.bioCycPathway.kgID (via knownCanonical.transcript)
      hg18.ccdsKgMap.geneId (via knownCanonical.transcript)
      hg18.ceBlastTab.query (via knownCanonical.transcript)
      hg18.dmBlastTab.query (via knownCanonical.transcript)
      hg18.drBlastTab.query (via knownCanonical.transcript)
      hg18.foldUtr3.name (via knownCanonical.transcript)
      hg18.foldUtr5.name (via knownCanonical.transcript)
      hg18.gnfAtlas2Distance.query (via knownCanonical.transcript)
      hg18.gnfAtlas2Distance.target (via knownCanonical.transcript)
      hg18.gnfU95Distance.query (via knownCanonical.transcript)
      hg18.gnfU95Distance.target (via knownCanonical.transcript)
      hg18.humanHprdP2P.query (via knownCanonical.transcript)
      hg18.humanHprdP2P.target (via knownCanonical.transcript)
      hg18.humanVidalP2P.query (via knownCanonical.transcript)
      hg18.humanVidalP2P.target (via knownCanonical.transcript)
      hg18.humanWankerP2P.query (via knownCanonical.transcript)
      hg18.humanWankerP2P.target (via knownCanonical.transcript)
      hg18.keggPathway.kgID (via knownCanonical.transcript)
      hg18.kgAlias.kgID (via knownCanonical.transcript)
      hg18.kgColor.kgID (via knownCanonical.transcript)
      hg18.kgProtAlias.kgID (via knownCanonical.transcript)
      hg18.kgProtMap2.qName (via knownCanonical.transcript)
      hg18.kgSpAlias.kgID (via knownCanonical.transcript)
      hg18.kgTargetAli.qName (via knownCanonical.transcript)
      hg18.kgTxInfo.name (via knownCanonical.transcript)
      hg18.kgXref.kgID (via knownCanonical.transcript)
      hg18.knownBlastTab.query (via knownCanonical.transcript)
      hg18.knownBlastTab.target (via knownCanonical.transcript)
      hg18.knownCanonToDecipher.name (via knownCanonical.transcript)
      hg18.knownCanonical.protein (via knownCanonical.transcript)
      hg18.knownCanonical.transcript (via knownCanonical.transcript)
      hg18.knownGene.name (via knownCanonical.transcript)
      hg18.knownGeneMrna.name (via knownCanonical.transcript)
      hg18.knownGenePep.name (via knownCanonical.transcript)
      hg18.knownIsoforms.transcript (via knownCanonical.transcript)
      hg18.knownToAllenBrain.name (via knownCanonical.transcript)
      hg18.knownToDecipher.name (via knownCanonical.transcript)
      hg18.knownToEnsembl.name (via knownCanonical.transcript)
      hg18.knownToGnf1h.name (via knownCanonical.transcript)
      hg18.knownToGnfAtlas2.name (via knownCanonical.transcript)
      hg18.knownToHInv.name (via knownCanonical.transcript)
      hg18.knownToHprd.name (via knownCanonical.transcript)
      hg18.knownToKeggEntrez.name (via knownCanonical.transcript)
      hg18.knownToLocusLink.name (via knownCanonical.transcript)
      hg18.knownToMupit.name (via knownCanonical.transcript)
      hg18.knownToPfam.name (via knownCanonical.transcript)
      hg18.knownToRefSeq.name (via knownCanonical.transcript)
      hg18.knownToSuper.gene (via knownCanonical.transcript)
      hg18.knownToTreefam.name (via knownCanonical.transcript)
      hg18.knownToU133.name (via knownCanonical.transcript)
      hg18.knownToU133Plus2.name (via knownCanonical.transcript)
      hg18.knownToU95.name (via knownCanonical.transcript)
      hg18.knownToVisiGene.name (via knownCanonical.transcript)
      hg18.mmBlastTab.query (via knownCanonical.transcript)
      hg18.rnBlastTab.query (via knownCanonical.transcript)
      hg18.scBlastTab.query (via knownCanonical.transcript)
      hg18.ucscScop.ucscId (via knownCanonical.transcript)
      hg19.bioCycPathway.kgID (via knownCanonical.transcript)
      hg19.ceBlastTab.query (via knownCanonical.transcript)
      hg19.dmBlastTab.query (via knownCanonical.transcript)
      hg19.drBlastTab.query (via knownCanonical.transcript)
      hg19.foldUtr3.name (via knownCanonical.transcript)
      hg19.foldUtr5.name (via knownCanonical.transcript)
      hg19.gnfAtlas2Distance.query (via knownCanonical.transcript)
      hg19.gnfAtlas2Distance.target (via knownCanonical.transcript)
      hg19.gnfU95Distance.query (via knownCanonical.transcript)
      hg19.gnfU95Distance.target (via knownCanonical.transcript)
      hg19.humanHprdP2P.query (via knownCanonical.transcript)
      hg19.humanHprdP2P.target (via knownCanonical.transcript)
      hg19.humanVidalP2P.query (via knownCanonical.transcript)
      hg19.humanVidalP2P.target (via knownCanonical.transcript)
      hg19.humanWankerP2P.query (via knownCanonical.transcript)
      hg19.humanWankerP2P.target (via knownCanonical.transcript)
      hg19.keggPathway.kgID (via knownCanonical.transcript)
      hg19.kgAlias.kgID (via knownCanonical.transcript)
      hg19.kgColor.kgID (via knownCanonical.transcript)
      hg19.kgProtAlias.kgID (via knownCanonical.transcript)
      hg19.kgProtMap2.qName (via knownCanonical.transcript)
      hg19.kgSpAlias.kgID (via knownCanonical.transcript)
      hg19.kgTargetAli.qName (via knownCanonical.transcript)
      hg19.kgTxInfo.name (via knownCanonical.transcript)
      hg19.kgXref.kgID (via knownCanonical.transcript)
      hg19.knownAttrs.kgID (via knownCanonical.transcript)
      hg19.knownBlastTab.query (via knownCanonical.transcript)
      hg19.knownBlastTab.target (via knownCanonical.transcript)
      hg19.knownCanonToDecipher.name (via knownCanonical.transcript)
      hg19.knownCanonical.transcript (via knownCanonical.transcript)
      hg19.knownCds.name (via knownCanonical.transcript)
      hg19.knownGene.name (via knownCanonical.transcript)
      hg19.knownGeneMrna.name (via knownCanonical.transcript)
      hg19.knownGenePep.name (via knownCanonical.transcript)
      hg19.knownGeneTxMrna.name (via knownCanonical.transcript)
      hg19.knownGeneTxPep.name (via knownCanonical.transcript)
      hg19.knownIsoforms.transcript (via knownCanonical.transcript)
      hg19.knownToAllenBrain.name (via knownCanonical.transcript)
      hg19.knownToDecipher.name (via knownCanonical.transcript)
      hg19.knownToEnsembl.name (via knownCanonical.transcript)
      hg19.knownToGnfAtlas2.name (via knownCanonical.transcript)
      hg19.knownToHInv.name (via knownCanonical.transcript)
      hg19.knownToHprd.name (via knownCanonical.transcript)
      hg19.knownToKeggEntrez.name (via knownCanonical.transcript)
      hg19.knownToLocusLink.name (via knownCanonical.transcript)
      hg19.knownToLynx.name (via knownCanonical.transcript)
      hg19.knownToMrna.name (via knownCanonical.transcript)
      hg19.knownToMrnaSingle.name (via knownCanonical.transcript)
      hg19.knownToMupit.name (via knownCanonical.transcript)
      hg19.knownToNextProt.name (via knownCanonical.transcript)
      hg19.knownToPfam.name (via knownCanonical.transcript)
      hg19.knownToRefSeq.name (via knownCanonical.transcript)
      hg19.knownToSuper.gene (via knownCanonical.transcript)
      hg19.knownToTag.name (via knownCanonical.transcript)
      hg19.knownToTreefam.name (via knownCanonical.transcript)
      hg19.knownToU133.name (via knownCanonical.transcript)
      hg19.knownToU133Plus2.name (via knownCanonical.transcript)
      hg19.knownToU95.name (via knownCanonical.transcript)
      hg19.knownToVisiGene.name (via knownCanonical.transcript)
      hg19.knownToWikipedia.name (via knownCanonical.transcript)
      hg19.mmBlastTab.query (via knownCanonical.transcript)
      hg19.rnBlastTab.query (via knownCanonical.transcript)
      hg19.scBlastTab.query (via knownCanonical.transcript)
      hg19.ucscScop.ucscId (via knownCanonical.transcript)
      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.knownCanonical.transcript (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.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)
      mm10.bioCycPathway.kgID (via knownCanonical.transcript)
      mm10.ccdsKgMap.geneId (via knownCanonical.transcript)
      mm10.ceBlastTab.query (via knownCanonical.transcript)
      mm10.dmBlastTab.query (via knownCanonical.transcript)
      mm10.drBlastTab.query (via knownCanonical.transcript)
      mm10.foldUtr3.name (via knownCanonical.transcript)
      mm10.foldUtr5.name (via knownCanonical.transcript)
      mm10.hgBlastTab.query (via knownCanonical.transcript)
      mm10.keggPathway.kgID (via knownCanonical.transcript)
      mm10.kgAlias.kgID (via knownCanonical.transcript)
      mm10.kgColor.kgID (via knownCanonical.transcript)
      mm10.kgProtAlias.kgID (via knownCanonical.transcript)
      mm10.kgProtMap2.qName (via knownCanonical.transcript)
      mm10.kgSpAlias.kgID (via knownCanonical.transcript)
      mm10.kgTargetAli.qName (via knownCanonical.transcript)
      mm10.kgTxInfo.name (via knownCanonical.transcript)
      mm10.kgXref.kgID (via knownCanonical.transcript)
      mm10.knownAttrs.kgID (via knownCanonical.transcript)
      mm10.knownBlastTab.query (via knownCanonical.transcript)
      mm10.knownBlastTab.target (via knownCanonical.transcript)
      mm10.knownCanonical.transcript (via knownCanonical.transcript)
      mm10.knownCds.name (via knownCanonical.transcript)
      mm10.knownGene.name (via knownCanonical.transcript)
      mm10.knownGeneMrna.name (via knownCanonical.transcript)
      mm10.knownGenePep.name (via knownCanonical.transcript)
      mm10.knownIsoforms.transcript (via knownCanonical.transcript)
      mm10.knownToEnsembl.name (via knownCanonical.transcript)
      mm10.knownToKeggEntrez.name (via knownCanonical.transcript)
      mm10.knownToLocusLink.name (via knownCanonical.transcript)
      mm10.knownToLynx.name (via knownCanonical.transcript)
      mm10.knownToMrna.name (via knownCanonical.transcript)
      mm10.knownToMrnaSingle.name (via knownCanonical.transcript)
      mm10.knownToPfam.name (via knownCanonical.transcript)
      mm10.knownToRefSeq.name (via knownCanonical.transcript)
      mm10.knownToSuper.gene (via knownCanonical.transcript)
      mm10.knownToTag.name (via knownCanonical.transcript)
      mm10.knownToVisiGene.name (via knownCanonical.transcript)
      mm10.knownToWikipedia.name (via knownCanonical.transcript)
      mm10.rnBlastTab.query (via knownCanonical.transcript)
      mm10.scBlastTab.query (via knownCanonical.transcript)
      mm10.ucscScop.ucscId (via knownCanonical.transcript)
      mm39.bioCycPathway.kgID (via knownCanonical.transcript)
      mm39.ceBlastTab.query (via knownCanonical.transcript)
      mm39.dmBlastTab.query (via knownCanonical.transcript)
      mm39.drBlastTab.query (via knownCanonical.transcript)
      mm39.foldUtr3.name (via knownCanonical.transcript)
      mm39.foldUtr5.name (via knownCanonical.transcript)
      mm39.hgBlastTab.query (via knownCanonical.transcript)
      mm39.kgAlias.kgID (via knownCanonical.transcript)
      mm39.kgColor.kgID (via knownCanonical.transcript)
      mm39.kgProtAlias.kgID (via knownCanonical.transcript)
      mm39.kgSpAlias.kgID (via knownCanonical.transcript)
      mm39.kgTargetAli.qName (via knownCanonical.transcript)
      mm39.kgXref.kgID (via knownCanonical.transcript)
      mm39.knownAttrs.kgID (via knownCanonical.transcript)
      mm39.knownBlastTab.query (via knownCanonical.transcript)
      mm39.knownBlastTab.target (via knownCanonical.transcript)
      mm39.knownCanonical.transcript (via knownCanonical.transcript)
      mm39.knownCds.name (via knownCanonical.transcript)
      mm39.knownGene.name (via knownCanonical.transcript)
      mm39.knownGeneMrna.name (via knownCanonical.transcript)
      mm39.knownIsoforms.transcript (via knownCanonical.transcript)
      mm39.knownToEnsembl.name (via knownCanonical.transcript)
      mm39.knownToLocusLink.name (via knownCanonical.transcript)
      mm39.knownToMrna.name (via knownCanonical.transcript)
      mm39.knownToMrnaSingle.name (via knownCanonical.transcript)
      mm39.knownToMupit.name (via knownCanonical.transcript)
      mm39.knownToNextProt.name (via knownCanonical.transcript)
      mm39.knownToPfam.name (via knownCanonical.transcript)
      mm39.knownToRefSeq.name (via knownCanonical.transcript)
      mm39.knownToSuper.gene (via knownCanonical.transcript)
      mm39.knownToTag.name (via knownCanonical.transcript)
      mm39.knownToVisiGene.name (via knownCanonical.transcript)
      mm39.knownToWikipedia.name (via knownCanonical.transcript)
      mm39.rnBlastTab.query (via knownCanonical.transcript)
      mm39.scBlastTab.query (via knownCanonical.transcript)
      mm39.ucscScop.ucscId (via knownCanonical.transcript)
      mm7.affyGnfU74ADistance.query (via knownCanonical.transcript)
      mm7.affyGnfU74ADistance.target (via knownCanonical.transcript)
      mm7.affyGnfU74BDistance.query (via knownCanonical.transcript)
      mm7.affyGnfU74BDistance.target (via knownCanonical.transcript)
      mm7.affyGnfU74CDistance.query (via knownCanonical.transcript)
      mm7.affyGnfU74CDistance.target (via knownCanonical.transcript)
      mm7.dmBlastTab.query (via knownCanonical.transcript)
      mm7.drBlastTab.query (via knownCanonical.transcript)
      mm7.dupSpMrna.mrnaID (via knownCanonical.transcript)
      mm7.foldUtr3.name (via knownCanonical.transcript)
      mm7.foldUtr5.name (via knownCanonical.transcript)
      mm7.gnfAtlas2Distance.query (via knownCanonical.transcript)
      mm7.gnfAtlas2Distance.target (via knownCanonical.transcript)
      mm7.hgBlastTab.query (via knownCanonical.transcript)
      mm7.keggPathway.kgID (via knownCanonical.transcript)
      mm7.kgAlias.kgID (via knownCanonical.transcript)
      mm7.kgProtAlias.kgID (via knownCanonical.transcript)
      mm7.kgSpAlias.kgID (via knownCanonical.transcript)
      mm7.kgXref.kgID (via knownCanonical.transcript)
      mm7.knownBlastTab.query (via knownCanonical.transcript)
      mm7.knownBlastTab.target (via knownCanonical.transcript)
      mm7.knownCanonical.transcript (via knownCanonical.transcript)
      mm7.knownGene.name (via knownCanonical.transcript)
      mm7.knownGeneLink.name (via knownCanonical.transcript)
      mm7.knownGeneMrna.name (via knownCanonical.transcript)
      mm7.knownGenePep.name (via knownCanonical.transcript)
      mm7.knownIsoforms.transcript (via knownCanonical.transcript)
      mm7.knownToAllenBrain.name (via knownCanonical.transcript)
      mm7.knownToEnsembl.name (via knownCanonical.transcript)
      mm7.knownToGnfAtlas2.name (via knownCanonical.transcript)
      mm7.knownToKeggEntrez.name (via knownCanonical.transcript)
      mm7.knownToLocusLink.name (via knownCanonical.transcript)
      mm7.knownToPfam.name (via knownCanonical.transcript)
      mm7.knownToRefSeq.name (via knownCanonical.transcript)
      mm7.knownToVisiGene.name (via knownCanonical.transcript)
      mm7.rnBlastTab.query (via knownCanonical.transcript)
      mm7.scBlastTab.query (via knownCanonical.transcript)
      mm8.affyGnfU74ADistance.query (via knownCanonical.transcript)
      mm8.affyGnfU74ADistance.target (via knownCanonical.transcript)
      mm8.affyGnfU74BDistance.query (via knownCanonical.transcript)
      mm8.affyGnfU74BDistance.target (via knownCanonical.transcript)
      mm8.affyGnfU74CDistance.query (via knownCanonical.transcript)
      mm8.affyGnfU74CDistance.target (via knownCanonical.transcript)
      mm8.ccdsKgMap.geneId (via knownCanonical.transcript)
      mm8.ceBlastTab.query (via knownCanonical.transcript)
      mm8.dmBlastTab.query (via knownCanonical.transcript)
      mm8.drBlastTab.query (via knownCanonical.transcript)
      mm8.dupSpMrna.mrnaID (via knownCanonical.transcript)
      mm8.foldUtr3.name (via knownCanonical.transcript)
      mm8.foldUtr5.name (via knownCanonical.transcript)
      mm8.gnfAtlas2Distance.query (via knownCanonical.transcript)
      mm8.gnfAtlas2Distance.target (via knownCanonical.transcript)
      mm8.hgBlastTab.query (via knownCanonical.transcript)
      mm8.keggPathway.kgID (via knownCanonical.transcript)
      mm8.kgAlias.kgID (via knownCanonical.transcript)
      mm8.kgProtAlias.kgID (via knownCanonical.transcript)
      mm8.kgSpAlias.kgID (via knownCanonical.transcript)
      mm8.kgTargetAli.qName (via knownCanonical.transcript)
      mm8.kgXref.kgID (via knownCanonical.transcript)
      mm8.knownBlastTab.query (via knownCanonical.transcript)
      mm8.knownBlastTab.target (via knownCanonical.transcript)
      mm8.knownCanonical.transcript (via knownCanonical.transcript)
      mm8.knownGene.name (via knownCanonical.transcript)
      mm8.knownGeneMrna.name (via knownCanonical.transcript)
      mm8.knownGenePep.name (via knownCanonical.transcript)
      mm8.knownIsoforms.transcript (via knownCanonical.transcript)
      mm8.knownToAllenBrain.name (via knownCanonical.transcript)
      mm8.knownToEnsembl.name (via knownCanonical.transcript)
      mm8.knownToGnfAtlas2.name (via knownCanonical.transcript)
      mm8.knownToKeggEntrez.name (via knownCanonical.transcript)
      mm8.knownToLocusLink.name (via knownCanonical.transcript)
      mm8.knownToPfam.name (via knownCanonical.transcript)
      mm8.knownToRefSeq.name (via knownCanonical.transcript)
      mm8.knownToSuper.gene (via knownCanonical.transcript)
      mm8.knownToVisiGene.name (via knownCanonical.transcript)
      mm8.rnBlastTab.query (via knownCanonical.transcript)
      mm8.scBlastTab.query (via knownCanonical.transcript)
      mm9.affyGnfU74ADistance.query (via knownCanonical.transcript)
      mm9.affyGnfU74ADistance.target (via knownCanonical.transcript)
      mm9.affyGnfU74BDistance.query (via knownCanonical.transcript)
      mm9.affyGnfU74BDistance.target (via knownCanonical.transcript)
      mm9.affyGnfU74CDistance.query (via knownCanonical.transcript)
      mm9.affyGnfU74CDistance.target (via knownCanonical.transcript)
      mm9.bioCycPathway.kgID (via knownCanonical.transcript)
      mm9.ccdsKgMap.geneId (via knownCanonical.transcript)
      mm9.ceBlastTab.query (via knownCanonical.transcript)
      mm9.dmBlastTab.query (via knownCanonical.transcript)
      mm9.drBlastTab.query (via knownCanonical.transcript)
      mm9.foldUtr3.name (via knownCanonical.transcript)
      mm9.foldUtr5.name (via knownCanonical.transcript)
      mm9.gnfAtlas2Distance.query (via knownCanonical.transcript)
      mm9.gnfAtlas2Distance.target (via knownCanonical.transcript)
      mm9.hgBlastTab.query (via knownCanonical.transcript)
      mm9.keggPathway.kgID (via knownCanonical.transcript)
      mm9.kgAlias.kgID (via knownCanonical.transcript)
      mm9.kgColor.kgID (via knownCanonical.transcript)
      mm9.kgProtAlias.kgID (via knownCanonical.transcript)
      mm9.kgProtMap2.qName (via knownCanonical.transcript)
      mm9.kgSpAlias.kgID (via knownCanonical.transcript)
      mm9.kgTargetAli.qName (via knownCanonical.transcript)
      mm9.kgTxInfo.name (via knownCanonical.transcript)
      mm9.kgXref.kgID (via knownCanonical.transcript)
      mm9.knownBlastTab.query (via knownCanonical.transcript)
      mm9.knownBlastTab.target (via knownCanonical.transcript)
      mm9.knownCanonical.protein (via knownCanonical.transcript)
      mm9.knownCanonical.transcript (via knownCanonical.transcript)
      mm9.knownGene.name (via knownCanonical.transcript)
      mm9.knownGeneMrna.name (via knownCanonical.transcript)
      mm9.knownGenePep.name (via knownCanonical.transcript)
      mm9.knownIsoforms.transcript (via knownCanonical.transcript)
      mm9.knownToAllenBrain.name (via knownCanonical.transcript)
      mm9.knownToEnsembl.name (via knownCanonical.transcript)
      mm9.knownToGnfAtlas2.name (via knownCanonical.transcript)
      mm9.knownToKeggEntrez.name (via knownCanonical.transcript)
      mm9.knownToLocusLink.name (via knownCanonical.transcript)
      mm9.knownToPfam.name (via knownCanonical.transcript)
      mm9.knownToRefSeq.name (via knownCanonical.transcript)
      mm9.knownToSuper.gene (via knownCanonical.transcript)
      mm9.knownToVisiGene.name (via knownCanonical.transcript)
      mm9.rnBlastTab.query (via knownCanonical.transcript)
      mm9.scBlastTab.query (via knownCanonical.transcript)
      mm9.ucscScop.ucscId (via knownCanonical.transcript)
      rn3.dmBlastTab.query (via knownCanonical.transcript)
      rn3.drBlastTab.query (via knownCanonical.transcript)
      rn3.dupSpMrna.mrnaID (via knownCanonical.transcript)
      rn3.gnfAtlas2Distance.query (via knownCanonical.transcript)
      rn3.gnfAtlas2Distance.target (via knownCanonical.transcript)
      rn3.hgBlastTab.query (via knownCanonical.transcript)
      rn3.keggPathway.kgID (via knownCanonical.transcript)
      rn3.kgAlias.kgID (via knownCanonical.transcript)
      rn3.kgProtAlias.kgID (via knownCanonical.transcript)
      rn3.kgSpAlias.kgID (via knownCanonical.transcript)
      rn3.kgXref.kgID (via knownCanonical.transcript)
      rn3.knownBlastTab.query (via knownCanonical.transcript)
      rn3.knownBlastTab.target (via knownCanonical.transcript)
      rn3.knownCanonical.transcript (via knownCanonical.transcript)
      rn3.knownGene.name (via knownCanonical.transcript)
      rn3.knownGeneLink.name (via knownCanonical.transcript)
      rn3.knownGeneMrna.name (via knownCanonical.transcript)
      rn3.knownGenePep.name (via knownCanonical.transcript)
      rn3.knownIsoforms.transcript (via knownCanonical.transcript)
      rn3.knownToEnsembl.name (via knownCanonical.transcript)
      rn3.knownToGnfAtlas2.name (via knownCanonical.transcript)
      rn3.knownToLocusLink.name (via knownCanonical.transcript)
      rn3.knownToPfam.name (via knownCanonical.transcript)
      rn3.knownToRefSeq.name (via knownCanonical.transcript)
      rn3.knownToSuper.gene (via knownCanonical.transcript)
      rn3.scBlastTab.query (via knownCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chrX1006271071006368061ENST00000373020.9ENSG00000000003.15
chrX1005849351005998852ENST00000373031.5ENSG00000000005.6
chr2050934869509585323ENST00000371588.10ENSG00000000419.14
chr11698530731698888884ENST00000367770.5ENSG00000000457.14
chr11697950391698540805ENST00000359326.9ENSG00000000460.17
chr127612063276351856ENST00000374005.8ENSG00000000938.13
chr11966520421967475047ENST00000367429.9ENSG00000000971.16
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.