Schema for knownToKeggEntrez
  Database: mm9    Primary Table: knownToKeggEntrez    Row Count: 34,776   Data last updated: 2010-06-17
Format description: Cross-reference of rgdGene2 gene ID to KEGG ID and KEGG ID + Entrez ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name uc007aey.1varchar(255) values Same as name field in rgdGene2 gene
value mmu04310varchar(255) values KEGG ID
keggEntrez mmu04310+20671varchar(255) values KEGG ID + Entrez ID

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToKeggEntrez.name)
      knownGeneV39.ceBlastTab.query (via knownToKeggEntrez.name)
      knownGeneV39.dmBlastTab.query (via knownToKeggEntrez.name)
      knownGeneV39.drBlastTab.query (via knownToKeggEntrez.name)
      knownGeneV39.foldUtr3.name (via knownToKeggEntrez.name)
      knownGeneV39.foldUtr5.name (via knownToKeggEntrez.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToKeggEntrez.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToKeggEntrez.name)
      knownGeneV39.kgAlias.kgID (via knownToKeggEntrez.name)
      knownGeneV39.kgColor.kgID (via knownToKeggEntrez.name)
      knownGeneV39.kgProtAlias.kgID (via knownToKeggEntrez.name)
      knownGeneV39.kgSpAlias.kgID (via knownToKeggEntrez.name)
      knownGeneV39.kgTargetAli.qName (via knownToKeggEntrez.name)
      knownGeneV39.kgXref.kgID (via knownToKeggEntrez.name)
      knownGeneV39.knownAttrs.kgID (via knownToKeggEntrez.name)
      knownGeneV39.knownBlastTab.query (via knownToKeggEntrez.name)
      knownGeneV39.knownBlastTab.target (via knownToKeggEntrez.name)
      knownGeneV39.knownCanonical.protein (via knownToKeggEntrez.name)
      knownGeneV39.knownCanonical.transcript (via knownToKeggEntrez.name)
      knownGeneV39.knownCds.name (via knownToKeggEntrez.name)
      knownGeneV39.knownGene.name (via knownToKeggEntrez.name)
      knownGeneV39.knownGeneMrna.name (via knownToKeggEntrez.name)
      knownGeneV39.knownGenePep.name (via knownToKeggEntrez.name)
      knownGeneV39.knownIsoforms.transcript (via knownToKeggEntrez.name)
      knownGeneV39.knownToEnsembl.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToHprd.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToLocusLink.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToMrna.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToMupit.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToPfam.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToRefSeq.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToSuper.gene (via knownToKeggEntrez.name)
      knownGeneV39.knownToTag.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToU133.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToU95.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToVisiGene.name (via knownToKeggEntrez.name)
      knownGeneV39.knownToWikipedia.name (via knownToKeggEntrez.name)
      knownGeneV39.mmBlastTab.query (via knownToKeggEntrez.name)
      knownGeneV39.rnBlastTab.query (via knownToKeggEntrez.name)
      knownGeneV39.scBlastTab.query (via knownToKeggEntrez.name)
      knownGeneV39.ucscScop.ucscId (via knownToKeggEntrez.name)
      mm9.affyGnfU74ADistance.query (via knownToKeggEntrez.name)
      mm9.affyGnfU74ADistance.target (via knownToKeggEntrez.name)
      mm9.affyGnfU74BDistance.query (via knownToKeggEntrez.name)
      mm9.affyGnfU74BDistance.target (via knownToKeggEntrez.name)
      mm9.affyGnfU74CDistance.query (via knownToKeggEntrez.name)
      mm9.affyGnfU74CDistance.target (via knownToKeggEntrez.name)
      mm9.bioCycPathway.kgID (via knownToKeggEntrez.name)
      mm9.ccdsKgMap.geneId (via knownToKeggEntrez.name)
      mm9.ceBlastTab.query (via knownToKeggEntrez.name)
      mm9.dmBlastTab.query (via knownToKeggEntrez.name)
      mm9.drBlastTab.query (via knownToKeggEntrez.name)
      mm9.foldUtr3.name (via knownToKeggEntrez.name)
      mm9.foldUtr5.name (via knownToKeggEntrez.name)
      mm9.gnfAtlas2Distance.query (via knownToKeggEntrez.name)
      mm9.gnfAtlas2Distance.target (via knownToKeggEntrez.name)
      mm9.hgBlastTab.query (via knownToKeggEntrez.name)
      mm9.keggPathway.kgID (via knownToKeggEntrez.name)
      mm9.kgAlias.kgID (via knownToKeggEntrez.name)
      mm9.kgColor.kgID (via knownToKeggEntrez.name)
      mm9.kgProtAlias.kgID (via knownToKeggEntrez.name)
      mm9.kgProtMap2.qName (via knownToKeggEntrez.name)
      mm9.kgSpAlias.kgID (via knownToKeggEntrez.name)
      mm9.kgTargetAli.qName (via knownToKeggEntrez.name)
      mm9.kgTxInfo.name (via knownToKeggEntrez.name)
      mm9.kgXref.kgID (via knownToKeggEntrez.name)
      mm9.knownBlastTab.query (via knownToKeggEntrez.name)
      mm9.knownBlastTab.target (via knownToKeggEntrez.name)
      mm9.knownCanonical.protein (via knownToKeggEntrez.name)
      mm9.knownCanonical.transcript (via knownToKeggEntrez.name)
      mm9.knownGene.name (via knownToKeggEntrez.name)
      mm9.knownGeneMrna.name (via knownToKeggEntrez.name)
      mm9.knownGenePep.name (via knownToKeggEntrez.name)
      mm9.knownIsoforms.transcript (via knownToKeggEntrez.name)
      mm9.knownToAllenBrain.name (via knownToKeggEntrez.name)
      mm9.knownToEnsembl.name (via knownToKeggEntrez.name)
      mm9.knownToGnfAtlas2.name (via knownToKeggEntrez.name)
      mm9.knownToLocusLink.name (via knownToKeggEntrez.name)
      mm9.knownToPfam.name (via knownToKeggEntrez.name)
      mm9.knownToRefSeq.name (via knownToKeggEntrez.name)
      mm9.knownToSuper.gene (via knownToKeggEntrez.name)
      mm9.knownToVisiGene.name (via knownToKeggEntrez.name)
      mm9.rnBlastTab.query (via knownToKeggEntrez.name)
      mm9.scBlastTab.query (via knownToKeggEntrez.name)
      mm9.ucscScop.ucscId (via knownToKeggEntrez.name)
      mm9.keggMapDesc.mapID (via knownToKeggEntrez.value)
      mm9.keggPathway.mapID (via knownToKeggEntrez.value)

Sample Rows
 
namevaluekeggEntrez
uc007aey.1mmu04310mmu04310+20671
uc007aez.1mmu04310mmu04310+20671
uc007afa.1mmu04310mmu04310+20671
uc007afb.1mmu04310mmu04310+20671
uc007afc.1mmu04310mmu04310+20671
uc007afg.1mmu00564mmu00564+18777
uc007afh.1mmu00564mmu00564+18777
uc007afm.1mmu00190mmu00190+108664
uc007afm.1mmu01100mmu01100+108664
uc007afm.1mmu04142mmu04142+108664

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