Schema for keggPathway
  Database: hg18    Primary Table: keggPathway    Row Count: 47,054   Data last updated: 2010-06-17
Format description: KEGG pathway cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc003wyw.1varchar(40) values Known Gene ID
locusID 10varchar(40) values LocusLink ID
mapID hsa00232varchar(40) values KEGG pathway map ID

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via keggPathway.kgID)
      hg18.ccdsKgMap.geneId (via keggPathway.kgID)
      hg18.ceBlastTab.query (via keggPathway.kgID)
      hg18.dmBlastTab.query (via keggPathway.kgID)
      hg18.drBlastTab.query (via keggPathway.kgID)
      hg18.foldUtr3.name (via keggPathway.kgID)
      hg18.foldUtr5.name (via keggPathway.kgID)
      hg18.gnfAtlas2Distance.query (via keggPathway.kgID)
      hg18.gnfAtlas2Distance.target (via keggPathway.kgID)
      hg18.gnfU95Distance.query (via keggPathway.kgID)
      hg18.gnfU95Distance.target (via keggPathway.kgID)
      hg18.humanHprdP2P.query (via keggPathway.kgID)
      hg18.humanHprdP2P.target (via keggPathway.kgID)
      hg18.humanVidalP2P.query (via keggPathway.kgID)
      hg18.humanVidalP2P.target (via keggPathway.kgID)
      hg18.humanWankerP2P.query (via keggPathway.kgID)
      hg18.humanWankerP2P.target (via keggPathway.kgID)
      hg18.kgAlias.kgID (via keggPathway.kgID)
      hg18.kgColor.kgID (via keggPathway.kgID)
      hg18.kgProtAlias.kgID (via keggPathway.kgID)
      hg18.kgProtMap2.qName (via keggPathway.kgID)
      hg18.kgSpAlias.kgID (via keggPathway.kgID)
      hg18.kgTargetAli.qName (via keggPathway.kgID)
      hg18.kgTxInfo.name (via keggPathway.kgID)
      hg18.kgXref.kgID (via keggPathway.kgID)
      hg18.knownBlastTab.query (via keggPathway.kgID)
      hg18.knownBlastTab.target (via keggPathway.kgID)
      hg18.knownCanonToDecipher.name (via keggPathway.kgID)
      hg18.knownCanonical.protein (via keggPathway.kgID)
      hg18.knownCanonical.transcript (via keggPathway.kgID)
      hg18.knownGene.name (via keggPathway.kgID)
      hg18.knownGeneMrna.name (via keggPathway.kgID)
      hg18.knownGenePep.name (via keggPathway.kgID)
      hg18.knownIsoforms.transcript (via keggPathway.kgID)
      hg18.knownToAllenBrain.name (via keggPathway.kgID)
      hg18.knownToDecipher.name (via keggPathway.kgID)
      hg18.knownToEnsembl.name (via keggPathway.kgID)
      hg18.knownToGnf1h.name (via keggPathway.kgID)
      hg18.knownToGnfAtlas2.name (via keggPathway.kgID)
      hg18.knownToHInv.name (via keggPathway.kgID)
      hg18.knownToHprd.name (via keggPathway.kgID)
      hg18.knownToKeggEntrez.name (via keggPathway.kgID)
      hg18.knownToLocusLink.name (via keggPathway.kgID)
      hg18.knownToMupit.name (via keggPathway.kgID)
      hg18.knownToPfam.name (via keggPathway.kgID)
      hg18.knownToRefSeq.name (via keggPathway.kgID)
      hg18.knownToSuper.gene (via keggPathway.kgID)
      hg18.knownToTreefam.name (via keggPathway.kgID)
      hg18.knownToU133.name (via keggPathway.kgID)
      hg18.knownToU133Plus2.name (via keggPathway.kgID)
      hg18.knownToU95.name (via keggPathway.kgID)
      hg18.knownToVisiGene.name (via keggPathway.kgID)
      hg18.mmBlastTab.query (via keggPathway.kgID)
      hg18.rnBlastTab.query (via keggPathway.kgID)
      hg18.scBlastTab.query (via keggPathway.kgID)
      hg18.ucscScop.ucscId (via keggPathway.kgID)
      knownGeneV39.bioCycPathway.kgID (via keggPathway.kgID)
      knownGeneV39.ceBlastTab.query (via keggPathway.kgID)
      knownGeneV39.dmBlastTab.query (via keggPathway.kgID)
      knownGeneV39.drBlastTab.query (via keggPathway.kgID)
      knownGeneV39.foldUtr3.name (via keggPathway.kgID)
      knownGeneV39.foldUtr5.name (via keggPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via keggPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via keggPathway.kgID)
      knownGeneV39.kgAlias.kgID (via keggPathway.kgID)
      knownGeneV39.kgColor.kgID (via keggPathway.kgID)
      knownGeneV39.kgProtAlias.kgID (via keggPathway.kgID)
      knownGeneV39.kgSpAlias.kgID (via keggPathway.kgID)
      knownGeneV39.kgTargetAli.qName (via keggPathway.kgID)
      knownGeneV39.kgXref.kgID (via keggPathway.kgID)
      knownGeneV39.knownAttrs.kgID (via keggPathway.kgID)
      knownGeneV39.knownBlastTab.query (via keggPathway.kgID)
      knownGeneV39.knownBlastTab.target (via keggPathway.kgID)
      knownGeneV39.knownCanonical.protein (via keggPathway.kgID)
      knownGeneV39.knownCanonical.transcript (via keggPathway.kgID)
      knownGeneV39.knownCds.name (via keggPathway.kgID)
      knownGeneV39.knownGene.name (via keggPathway.kgID)
      knownGeneV39.knownGeneMrna.name (via keggPathway.kgID)
      knownGeneV39.knownGenePep.name (via keggPathway.kgID)
      knownGeneV39.knownIsoforms.transcript (via keggPathway.kgID)
      knownGeneV39.knownToEnsembl.name (via keggPathway.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via keggPathway.kgID)
      knownGeneV39.knownToHprd.name (via keggPathway.kgID)
      knownGeneV39.knownToLocusLink.name (via keggPathway.kgID)
      knownGeneV39.knownToMrna.name (via keggPathway.kgID)
      knownGeneV39.knownToMrnaSingle.name (via keggPathway.kgID)
      knownGeneV39.knownToMupit.name (via keggPathway.kgID)
      knownGeneV39.knownToPfam.name (via keggPathway.kgID)
      knownGeneV39.knownToRefSeq.name (via keggPathway.kgID)
      knownGeneV39.knownToSuper.gene (via keggPathway.kgID)
      knownGeneV39.knownToTag.name (via keggPathway.kgID)
      knownGeneV39.knownToU133.name (via keggPathway.kgID)
      knownGeneV39.knownToU95.name (via keggPathway.kgID)
      knownGeneV39.knownToVisiGene.name (via keggPathway.kgID)
      knownGeneV39.knownToWikipedia.name (via keggPathway.kgID)
      knownGeneV39.mmBlastTab.query (via keggPathway.kgID)
      knownGeneV39.rnBlastTab.query (via keggPathway.kgID)
      knownGeneV39.scBlastTab.query (via keggPathway.kgID)
      knownGeneV39.ucscScop.ucscId (via keggPathway.kgID)
      hg18.knownToLocusLink.value (via keggPathway.locusID)
      hg18.omim2gene.geneId (via keggPathway.locusID)
      hgFixed.refLink.locusLinkId (via keggPathway.locusID)
      knownGeneV39.knownToLocusLink.value (via keggPathway.locusID)
      hg18.keggMapDesc.mapID (via keggPathway.mapID)
      hg18.knownToKeggEntrez.value (via keggPathway.mapID)

Sample Rows
 
kgIDlocusIDmapID
uc003wyw.110hsa00232
uc010lte.110hsa00232
uc003wyw.110hsa00983
uc010lte.110hsa00983
uc003wyw.110hsa01100
uc010lte.110hsa01100
uc002xmj.1100hsa00230
uc010ggt.1100hsa00230
uc002xmj.1100hsa01100
uc010ggt.1100hsa01100

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