Schema for keggPathway
  Database: hg17    Primary Table: keggPathway    Row Count: 28,132   Data last updated: 2010-06-18
Format description: KEGG pathway cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID NM_000015varchar(40) values Known Gene ID
locusID 10varchar(40) values LocusLink ID
mapID hsa00232varchar(40) values KEGG pathway map ID

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

Sample Rows
 
kgIDlocusIDmapID
NM_00001510hsa00232
NM_00001510hsa00983
NM_00001510hsa01100
NM_000022100hsa00230
NM_000022100hsa01100
NM_000022100hsa05340
NM_0017921000hsa04514
NM_0017921000hsa05412
NM_18169010000hsa04010
NM_00546510000hsa04010

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