Schema for knownToKeggEntrez
  Database: hg19    Primary Table: knownToKeggEntrez    Row Count: 58,073   Data last updated: 2013-06-15
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
        hg19.bioCycPathway.kgID (via knownToKeggEntrez.name)
      hg19.ceBlastTab.query (via knownToKeggEntrez.name)
      hg19.dmBlastTab.query (via knownToKeggEntrez.name)
      hg19.drBlastTab.query (via knownToKeggEntrez.name)
      hg19.foldUtr3.name (via knownToKeggEntrez.name)
      hg19.foldUtr5.name (via knownToKeggEntrez.name)
      hg19.gnfAtlas2Distance.query (via knownToKeggEntrez.name)
      hg19.gnfAtlas2Distance.target (via knownToKeggEntrez.name)
      hg19.gnfU95Distance.query (via knownToKeggEntrez.name)
      hg19.gnfU95Distance.target (via knownToKeggEntrez.name)
      hg19.humanHprdP2P.query (via knownToKeggEntrez.name)
      hg19.humanHprdP2P.target (via knownToKeggEntrez.name)
      hg19.humanVidalP2P.query (via knownToKeggEntrez.name)
      hg19.humanVidalP2P.target (via knownToKeggEntrez.name)
      hg19.humanWankerP2P.query (via knownToKeggEntrez.name)
      hg19.humanWankerP2P.target (via knownToKeggEntrez.name)
      hg19.keggPathway.kgID (via knownToKeggEntrez.name)
      hg19.kgAlias.kgID (via knownToKeggEntrez.name)
      hg19.kgColor.kgID (via knownToKeggEntrez.name)
      hg19.kgProtAlias.kgID (via knownToKeggEntrez.name)
      hg19.kgProtMap2.qName (via knownToKeggEntrez.name)
      hg19.kgSpAlias.kgID (via knownToKeggEntrez.name)
      hg19.kgTargetAli.qName (via knownToKeggEntrez.name)
      hg19.kgTxInfo.name (via knownToKeggEntrez.name)
      hg19.kgXref.kgID (via knownToKeggEntrez.name)
      hg19.knownAttrs.kgID (via knownToKeggEntrez.name)
      hg19.knownBlastTab.query (via knownToKeggEntrez.name)
      hg19.knownBlastTab.target (via knownToKeggEntrez.name)
      hg19.knownCanonToDecipher.name (via knownToKeggEntrez.name)
      hg19.knownCanonical.transcript (via knownToKeggEntrez.name)
      hg19.knownCds.name (via knownToKeggEntrez.name)
      hg19.knownGene.name (via knownToKeggEntrez.name)
      hg19.knownGeneMrna.name (via knownToKeggEntrez.name)
      hg19.knownGenePep.name (via knownToKeggEntrez.name)
      hg19.knownGeneTxMrna.name (via knownToKeggEntrez.name)
      hg19.knownGeneTxPep.name (via knownToKeggEntrez.name)
      hg19.knownIsoforms.transcript (via knownToKeggEntrez.name)
      hg19.knownToAllenBrain.name (via knownToKeggEntrez.name)
      hg19.knownToDecipher.name (via knownToKeggEntrez.name)
      hg19.knownToEnsembl.name (via knownToKeggEntrez.name)
      hg19.knownToGnfAtlas2.name (via knownToKeggEntrez.name)
      hg19.knownToHInv.name (via knownToKeggEntrez.name)
      hg19.knownToHprd.name (via knownToKeggEntrez.name)
      hg19.knownToLocusLink.name (via knownToKeggEntrez.name)
      hg19.knownToLynx.name (via knownToKeggEntrez.name)
      hg19.knownToMrna.name (via knownToKeggEntrez.name)
      hg19.knownToMrnaSingle.name (via knownToKeggEntrez.name)
      hg19.knownToMupit.name (via knownToKeggEntrez.name)
      hg19.knownToNextProt.name (via knownToKeggEntrez.name)
      hg19.knownToPfam.name (via knownToKeggEntrez.name)
      hg19.knownToRefSeq.name (via knownToKeggEntrez.name)
      hg19.knownToSuper.gene (via knownToKeggEntrez.name)
      hg19.knownToTag.name (via knownToKeggEntrez.name)
      hg19.knownToTreefam.name (via knownToKeggEntrez.name)
      hg19.knownToU133.name (via knownToKeggEntrez.name)
      hg19.knownToU133Plus2.name (via knownToKeggEntrez.name)
      hg19.knownToU95.name (via knownToKeggEntrez.name)
      hg19.knownToVisiGene.name (via knownToKeggEntrez.name)
      hg19.knownToWikipedia.name (via knownToKeggEntrez.name)
      hg19.mmBlastTab.query (via knownToKeggEntrez.name)
      hg19.rnBlastTab.query (via knownToKeggEntrez.name)
      hg19.scBlastTab.query (via knownToKeggEntrez.name)
      hg19.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)
      hg19.keggMapDesc.mapID (via knownToKeggEntrez.value)
      hg19.keggPathway.mapID (via knownToKeggEntrez.value)

Sample Rows
 
namevaluekeggEntrez
uc001aal.1hsa04740hsa04740+79501
uc001acj.4hsa04622hsa04622+9636
uc001ack.2hsa04512hsa04512+375790
uc001ada.3hsa04060hsa04060+8784
uc001adb.3hsa04060hsa04060+8784
uc001adc.3hsa04060hsa04060+8784
uc001add.3hsa04060hsa04060+8784
uc001ade.3hsa04060hsa04060+7293
uc001adf.3hsa04060hsa04060+7293
uc001adk.3hsa00532hsa00532+126792

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