Schema for knownToKeggEntrez
  Database: mm8    Primary Table: knownToKeggEntrez    Row Count: 22,131   Data last updated: 2010-06-18
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 AB001750varchar(255) values Same as name field in rgdGene2 gene
value mmu04144varchar(255) values KEGG ID
keggEntrez mmu04144+54189varchar(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)
      mm8.affyGnfU74ADistance.query (via knownToKeggEntrez.name)
      mm8.affyGnfU74ADistance.target (via knownToKeggEntrez.name)
      mm8.affyGnfU74BDistance.query (via knownToKeggEntrez.name)
      mm8.affyGnfU74BDistance.target (via knownToKeggEntrez.name)
      mm8.affyGnfU74CDistance.query (via knownToKeggEntrez.name)
      mm8.affyGnfU74CDistance.target (via knownToKeggEntrez.name)
      mm8.ccdsKgMap.geneId (via knownToKeggEntrez.name)
      mm8.ceBlastTab.query (via knownToKeggEntrez.name)
      mm8.dmBlastTab.query (via knownToKeggEntrez.name)
      mm8.drBlastTab.query (via knownToKeggEntrez.name)
      mm8.dupSpMrna.mrnaID (via knownToKeggEntrez.name)
      mm8.foldUtr3.name (via knownToKeggEntrez.name)
      mm8.foldUtr5.name (via knownToKeggEntrez.name)
      mm8.gnfAtlas2Distance.query (via knownToKeggEntrez.name)
      mm8.gnfAtlas2Distance.target (via knownToKeggEntrez.name)
      mm8.hgBlastTab.query (via knownToKeggEntrez.name)
      mm8.keggPathway.kgID (via knownToKeggEntrez.name)
      mm8.kgAlias.kgID (via knownToKeggEntrez.name)
      mm8.kgProtAlias.kgID (via knownToKeggEntrez.name)
      mm8.kgSpAlias.kgID (via knownToKeggEntrez.name)
      mm8.kgTargetAli.qName (via knownToKeggEntrez.name)
      mm8.kgXref.kgID (via knownToKeggEntrez.name)
      mm8.knownBlastTab.query (via knownToKeggEntrez.name)
      mm8.knownBlastTab.target (via knownToKeggEntrez.name)
      mm8.knownCanonical.transcript (via knownToKeggEntrez.name)
      mm8.knownGene.name (via knownToKeggEntrez.name)
      mm8.knownGeneMrna.name (via knownToKeggEntrez.name)
      mm8.knownGenePep.name (via knownToKeggEntrez.name)
      mm8.knownIsoforms.transcript (via knownToKeggEntrez.name)
      mm8.knownToAllenBrain.name (via knownToKeggEntrez.name)
      mm8.knownToEnsembl.name (via knownToKeggEntrez.name)
      mm8.knownToGnfAtlas2.name (via knownToKeggEntrez.name)
      mm8.knownToLocusLink.name (via knownToKeggEntrez.name)
      mm8.knownToPfam.name (via knownToKeggEntrez.name)
      mm8.knownToRefSeq.name (via knownToKeggEntrez.name)
      mm8.knownToSuper.gene (via knownToKeggEntrez.name)
      mm8.knownToVisiGene.name (via knownToKeggEntrez.name)
      mm8.rnBlastTab.query (via knownToKeggEntrez.name)
      mm8.scBlastTab.query (via knownToKeggEntrez.name)
      mm8.keggMapDesc.mapID (via knownToKeggEntrez.value)
      mm8.keggPathway.mapID (via knownToKeggEntrez.value)

Sample Rows
 
namevaluekeggEntrez
AB001750mmu04144mmu04144+54189
AB005654mmu04010mmu04010+26400
AB005654mmu04012mmu04012+26400
AB005654mmu04620mmu04620+26400
AB005654mmu04660mmu04660+26400
AB005654mmu04664mmu04664+26400
AB005654mmu04722mmu04722+26400
AB005654mmu04912mmu04912+26400
AB005662mmu04010mmu04010+30957
AB006034mmu00100mmu00100+13115

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