Schema for knownToKeggEntrez
  Database: hg17    Primary Table: knownToKeggEntrez    Row Count: 28,132   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 AB000409varchar(255) values Same as name field in rgdGene2 gene
value hsa04010varchar(255) values KEGG ID
keggEntrez hsa04010+8569varchar(255) values KEGG ID + Entrez ID

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownToKeggEntrez.name)
      hg17.ccdsKgMap.geneId (via knownToKeggEntrez.name)
      hg17.ceBlastTab.query (via knownToKeggEntrez.name)
      hg17.dmBlastTab.query (via knownToKeggEntrez.name)
      hg17.drBlastTab.query (via knownToKeggEntrez.name)
      hg17.dupSpMrna.mrnaID (via knownToKeggEntrez.name)
      hg17.foldUtr3.name (via knownToKeggEntrez.name)
      hg17.foldUtr5.name (via knownToKeggEntrez.name)
      hg17.gladHumESDistance.query (via knownToKeggEntrez.name)
      hg17.gladHumESDistance.target (via knownToKeggEntrez.name)
      hg17.gnfAtlas2Distance.query (via knownToKeggEntrez.name)
      hg17.gnfAtlas2Distance.target (via knownToKeggEntrez.name)
      hg17.gnfU95Distance.query (via knownToKeggEntrez.name)
      hg17.gnfU95Distance.target (via knownToKeggEntrez.name)
      hg17.humanHprdP2P.query (via knownToKeggEntrez.name)
      hg17.humanHprdP2P.target (via knownToKeggEntrez.name)
      hg17.humanVidalP2P.query (via knownToKeggEntrez.name)
      hg17.humanVidalP2P.target (via knownToKeggEntrez.name)
      hg17.humanWankerP2P.query (via knownToKeggEntrez.name)
      hg17.humanWankerP2P.target (via knownToKeggEntrez.name)
      hg17.keggPathway.kgID (via knownToKeggEntrez.name)
      hg17.kgAlias.kgID (via knownToKeggEntrez.name)
      hg17.kgProtAlias.kgID (via knownToKeggEntrez.name)
      hg17.kgSpAlias.kgID (via knownToKeggEntrez.name)
      hg17.kgTargetAli.qName (via knownToKeggEntrez.name)
      hg17.kgXref.kgID (via knownToKeggEntrez.name)
      hg17.knownBlastTab.query (via knownToKeggEntrez.name)
      hg17.knownBlastTab.target (via knownToKeggEntrez.name)
      hg17.knownCanonical.transcript (via knownToKeggEntrez.name)
      hg17.knownExpDistance.query (via knownToKeggEntrez.name)
      hg17.knownExpDistance.target (via knownToKeggEntrez.name)
      hg17.knownGene.name (via knownToKeggEntrez.name)
      hg17.knownGeneLink.name (via knownToKeggEntrez.name)
      hg17.knownGeneMrna.name (via knownToKeggEntrez.name)
      hg17.knownGenePep.name (via knownToKeggEntrez.name)
      hg17.knownIsoforms.transcript (via knownToKeggEntrez.name)
      hg17.knownToAllenBrain.name (via knownToKeggEntrez.name)
      hg17.knownToEnsembl.name (via knownToKeggEntrez.name)
      hg17.knownToGnf1h.name (via knownToKeggEntrez.name)
      hg17.knownToGnfAtlas2.name (via knownToKeggEntrez.name)
      hg17.knownToHInv.name (via knownToKeggEntrez.name)
      hg17.knownToHprd.name (via knownToKeggEntrez.name)
      hg17.knownToLocusLink.name (via knownToKeggEntrez.name)
      hg17.knownToPfam.name (via knownToKeggEntrez.name)
      hg17.knownToRefSeq.name (via knownToKeggEntrez.name)
      hg17.knownToSuper.gene (via knownToKeggEntrez.name)
      hg17.knownToU133.name (via knownToKeggEntrez.name)
      hg17.knownToU133Plus2.name (via knownToKeggEntrez.name)
      hg17.knownToU95.name (via knownToKeggEntrez.name)
      hg17.knownToVisiGene.name (via knownToKeggEntrez.name)
      hg17.mmBlastTab.query (via knownToKeggEntrez.name)
      hg17.rankProp.query (via knownToKeggEntrez.name)
      hg17.rankProp.target (via knownToKeggEntrez.name)
      hg17.rnBlastTab.query (via knownToKeggEntrez.name)
      hg17.scBlastTab.query (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)
      hg17.keggMapDesc.mapID (via knownToKeggEntrez.value)
      hg17.keggPathway.mapID (via knownToKeggEntrez.value)

Sample Rows
 
namevaluekeggEntrez
AB000409hsa04010hsa04010+8569
AB000409hsa04910hsa04910+8569
AB000463hsa04650hsa04650+6452
AB000815hsa04710hsa04710+406
AB001025hsa04020hsa04020+6263
AB001025hsa05010hsa05010+6263
AB002336hsa04530hsa04530+2036
AB002341hsa04514hsa04514+4897
AB002454hsa00590hsa00590+4051
AB002454hsa01100hsa01100+4051

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