Schema for knownToKeggEntrez
  Database: hg18    Primary Table: knownToKeggEntrez    Row Count: 47,054   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 uc001aal.1varchar(255) values Same as name field in rgdGene2 gene
value hsa04740varchar(255) values KEGG ID
keggEntrez hsa04740+79501varchar(255) values KEGG ID + Entrez ID

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownToKeggEntrez.name)
      hg18.ccdsKgMap.geneId (via knownToKeggEntrez.name)
      hg18.ceBlastTab.query (via knownToKeggEntrez.name)
      hg18.dmBlastTab.query (via knownToKeggEntrez.name)
      hg18.drBlastTab.query (via knownToKeggEntrez.name)
      hg18.foldUtr3.name (via knownToKeggEntrez.name)
      hg18.foldUtr5.name (via knownToKeggEntrez.name)
      hg18.gnfAtlas2Distance.query (via knownToKeggEntrez.name)
      hg18.gnfAtlas2Distance.target (via knownToKeggEntrez.name)
      hg18.gnfU95Distance.query (via knownToKeggEntrez.name)
      hg18.gnfU95Distance.target (via knownToKeggEntrez.name)
      hg18.humanHprdP2P.query (via knownToKeggEntrez.name)
      hg18.humanHprdP2P.target (via knownToKeggEntrez.name)
      hg18.humanVidalP2P.query (via knownToKeggEntrez.name)
      hg18.humanVidalP2P.target (via knownToKeggEntrez.name)
      hg18.humanWankerP2P.query (via knownToKeggEntrez.name)
      hg18.humanWankerP2P.target (via knownToKeggEntrez.name)
      hg18.keggPathway.kgID (via knownToKeggEntrez.name)
      hg18.kgAlias.kgID (via knownToKeggEntrez.name)
      hg18.kgColor.kgID (via knownToKeggEntrez.name)
      hg18.kgProtAlias.kgID (via knownToKeggEntrez.name)
      hg18.kgProtMap2.qName (via knownToKeggEntrez.name)
      hg18.kgSpAlias.kgID (via knownToKeggEntrez.name)
      hg18.kgTargetAli.qName (via knownToKeggEntrez.name)
      hg18.kgTxInfo.name (via knownToKeggEntrez.name)
      hg18.kgXref.kgID (via knownToKeggEntrez.name)
      hg18.knownBlastTab.query (via knownToKeggEntrez.name)
      hg18.knownBlastTab.target (via knownToKeggEntrez.name)
      hg18.knownCanonToDecipher.name (via knownToKeggEntrez.name)
      hg18.knownCanonical.protein (via knownToKeggEntrez.name)
      hg18.knownCanonical.transcript (via knownToKeggEntrez.name)
      hg18.knownGene.name (via knownToKeggEntrez.name)
      hg18.knownGeneMrna.name (via knownToKeggEntrez.name)
      hg18.knownGenePep.name (via knownToKeggEntrez.name)
      hg18.knownIsoforms.transcript (via knownToKeggEntrez.name)
      hg18.knownToAllenBrain.name (via knownToKeggEntrez.name)
      hg18.knownToDecipher.name (via knownToKeggEntrez.name)
      hg18.knownToEnsembl.name (via knownToKeggEntrez.name)
      hg18.knownToGnf1h.name (via knownToKeggEntrez.name)
      hg18.knownToGnfAtlas2.name (via knownToKeggEntrez.name)
      hg18.knownToHInv.name (via knownToKeggEntrez.name)
      hg18.knownToHprd.name (via knownToKeggEntrez.name)
      hg18.knownToLocusLink.name (via knownToKeggEntrez.name)
      hg18.knownToMupit.name (via knownToKeggEntrez.name)
      hg18.knownToPfam.name (via knownToKeggEntrez.name)
      hg18.knownToRefSeq.name (via knownToKeggEntrez.name)
      hg18.knownToSuper.gene (via knownToKeggEntrez.name)
      hg18.knownToTreefam.name (via knownToKeggEntrez.name)
      hg18.knownToU133.name (via knownToKeggEntrez.name)
      hg18.knownToU133Plus2.name (via knownToKeggEntrez.name)
      hg18.knownToU95.name (via knownToKeggEntrez.name)
      hg18.knownToVisiGene.name (via knownToKeggEntrez.name)
      hg18.mmBlastTab.query (via knownToKeggEntrez.name)
      hg18.rnBlastTab.query (via knownToKeggEntrez.name)
      hg18.scBlastTab.query (via knownToKeggEntrez.name)
      hg18.ucscScop.ucscId (via knownToKeggEntrez.name)
      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)
      hg18.keggMapDesc.mapID (via knownToKeggEntrez.value)
      hg18.keggPathway.mapID (via knownToKeggEntrez.value)

Sample Rows
 
namevaluekeggEntrez
uc001aal.1hsa04740hsa04740+79501
uc001aaw.1hsa04740hsa04740+81399
uc001abd.1hsa04740hsa04740+81399
uc001acj.2hsa04622hsa04622+9636
uc001ack.1hsa04512hsa04512+375790
uc001ada.1hsa04060hsa04060+8784
uc001adb.1hsa04060hsa04060+8784
uc001adc.1hsa04060hsa04060+8784
uc001add.1hsa04060hsa04060+8784
uc001ade.1hsa04060hsa04060+7293

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