Schema for knownToKeggEntrez
  Database: mm7    Primary Table: knownToKeggEntrez    Row Count: 21,521   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 AB005654varchar(255) values Same as name field in rgdGene2 gene
value mmu04010varchar(255) values KEGG ID
keggEntrez mmu04010+26400varchar(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)
      mm7.affyGnfU74ADistance.query (via knownToKeggEntrez.name)
      mm7.affyGnfU74ADistance.target (via knownToKeggEntrez.name)
      mm7.affyGnfU74BDistance.query (via knownToKeggEntrez.name)
      mm7.affyGnfU74BDistance.target (via knownToKeggEntrez.name)
      mm7.affyGnfU74CDistance.query (via knownToKeggEntrez.name)
      mm7.affyGnfU74CDistance.target (via knownToKeggEntrez.name)
      mm7.dmBlastTab.query (via knownToKeggEntrez.name)
      mm7.drBlastTab.query (via knownToKeggEntrez.name)
      mm7.dupSpMrna.mrnaID (via knownToKeggEntrez.name)
      mm7.foldUtr3.name (via knownToKeggEntrez.name)
      mm7.foldUtr5.name (via knownToKeggEntrez.name)
      mm7.gnfAtlas2Distance.query (via knownToKeggEntrez.name)
      mm7.gnfAtlas2Distance.target (via knownToKeggEntrez.name)
      mm7.hgBlastTab.query (via knownToKeggEntrez.name)
      mm7.keggPathway.kgID (via knownToKeggEntrez.name)
      mm7.kgAlias.kgID (via knownToKeggEntrez.name)
      mm7.kgProtAlias.kgID (via knownToKeggEntrez.name)
      mm7.kgSpAlias.kgID (via knownToKeggEntrez.name)
      mm7.kgXref.kgID (via knownToKeggEntrez.name)
      mm7.knownBlastTab.query (via knownToKeggEntrez.name)
      mm7.knownBlastTab.target (via knownToKeggEntrez.name)
      mm7.knownCanonical.transcript (via knownToKeggEntrez.name)
      mm7.knownGene.name (via knownToKeggEntrez.name)
      mm7.knownGeneLink.name (via knownToKeggEntrez.name)
      mm7.knownGeneMrna.name (via knownToKeggEntrez.name)
      mm7.knownGenePep.name (via knownToKeggEntrez.name)
      mm7.knownIsoforms.transcript (via knownToKeggEntrez.name)
      mm7.knownToAllenBrain.name (via knownToKeggEntrez.name)
      mm7.knownToEnsembl.name (via knownToKeggEntrez.name)
      mm7.knownToGnfAtlas2.name (via knownToKeggEntrez.name)
      mm7.knownToLocusLink.name (via knownToKeggEntrez.name)
      mm7.knownToPfam.name (via knownToKeggEntrez.name)
      mm7.knownToRefSeq.name (via knownToKeggEntrez.name)
      mm7.knownToVisiGene.name (via knownToKeggEntrez.name)
      mm7.rnBlastTab.query (via knownToKeggEntrez.name)
      mm7.scBlastTab.query (via knownToKeggEntrez.name)
      mm7.keggMapDesc.mapID (via knownToKeggEntrez.value)
      mm7.keggPathway.mapID (via knownToKeggEntrez.value)

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

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