Schema for keggPathway
  Database: hg19    Primary Table: keggPathway    Row Count: 58,073   Data last updated: 2013-06-15
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
        hg19.bioCycPathway.kgID (via keggPathway.kgID)
      hg19.ccdsKgMap.geneId (via keggPathway.kgID)
      hg19.ceBlastTab.query (via keggPathway.kgID)
      hg19.dmBlastTab.query (via keggPathway.kgID)
      hg19.drBlastTab.query (via keggPathway.kgID)
      hg19.foldUtr3.name (via keggPathway.kgID)
      hg19.foldUtr5.name (via keggPathway.kgID)
      hg19.gnfAtlas2Distance.query (via keggPathway.kgID)
      hg19.gnfAtlas2Distance.target (via keggPathway.kgID)
      hg19.gnfU95Distance.query (via keggPathway.kgID)
      hg19.gnfU95Distance.target (via keggPathway.kgID)
      hg19.humanHprdP2P.query (via keggPathway.kgID)
      hg19.humanHprdP2P.target (via keggPathway.kgID)
      hg19.humanVidalP2P.query (via keggPathway.kgID)
      hg19.humanVidalP2P.target (via keggPathway.kgID)
      hg19.humanWankerP2P.query (via keggPathway.kgID)
      hg19.humanWankerP2P.target (via keggPathway.kgID)
      hg19.kgAlias.kgID (via keggPathway.kgID)
      hg19.kgColor.kgID (via keggPathway.kgID)
      hg19.kgProtAlias.kgID (via keggPathway.kgID)
      hg19.kgProtMap2.qName (via keggPathway.kgID)
      hg19.kgSpAlias.kgID (via keggPathway.kgID)
      hg19.kgTargetAli.qName (via keggPathway.kgID)
      hg19.kgTxInfo.name (via keggPathway.kgID)
      hg19.kgXref.kgID (via keggPathway.kgID)
      hg19.knownBlastTab.query (via keggPathway.kgID)
      hg19.knownBlastTab.target (via keggPathway.kgID)
      hg19.knownCanonical.transcript (via keggPathway.kgID)
      hg19.knownGene.name (via keggPathway.kgID)
      hg19.knownGeneMrna.name (via keggPathway.kgID)
      hg19.knownGenePep.name (via keggPathway.kgID)
      hg19.knownGeneTxMrna.name (via keggPathway.kgID)
      hg19.knownGeneTxPep.name (via keggPathway.kgID)
      hg19.knownIsoforms.transcript (via keggPathway.kgID)
      hg19.knownToAllenBrain.name (via keggPathway.kgID)
      hg19.knownToEnsembl.name (via keggPathway.kgID)
      hg19.knownToGnfAtlas2.name (via keggPathway.kgID)
      hg19.knownToHInv.name (via keggPathway.kgID)
      hg19.knownToHprd.name (via keggPathway.kgID)
      hg19.knownToKeggEntrez.name (via keggPathway.kgID)
      hg19.knownToLocusLink.name (via keggPathway.kgID)
      hg19.knownToLynx.name (via keggPathway.kgID)
      hg19.knownToMupit.name (via keggPathway.kgID)
      hg19.knownToNextProt.name (via keggPathway.kgID)
      hg19.knownToPfam.name (via keggPathway.kgID)
      hg19.knownToRefSeq.name (via keggPathway.kgID)
      hg19.knownToSuper.gene (via keggPathway.kgID)
      hg19.knownToTreefam.name (via keggPathway.kgID)
      hg19.knownToU133.name (via keggPathway.kgID)
      hg19.knownToU133Plus2.name (via keggPathway.kgID)
      hg19.knownToU95.name (via keggPathway.kgID)
      hg19.knownToVisiGene.name (via keggPathway.kgID)
      hg19.knownToWikipedia.name (via keggPathway.kgID)
      hg19.mmBlastTab.query (via keggPathway.kgID)
      hg19.rnBlastTab.query (via keggPathway.kgID)
      hg19.scBlastTab.query (via keggPathway.kgID)
      hg19.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)
      hg19.knownToLocusLink.value (via keggPathway.locusID)
      hg19.omim2gene.geneId (via keggPathway.locusID) Note: genome-wide queries are not available for this table.
      hgFixed.refLink.locusLinkId (via keggPathway.locusID)
      knownGeneV39.knownToLocusLink.value (via keggPathway.locusID)
      hg19.keggMapDesc.mapID (via keggPathway.mapID)
      hg19.knownToKeggEntrez.value (via keggPathway.mapID)

Sample Rows
 
kgIDlocusIDmapID
uc003wyw.110hsa00232
uc003wyw.110hsa00983
uc003wyw.110hsa01100
uc002xmj.3100hsa00230
uc002xmj.3100hsa01100
uc002xmj.3100hsa05340
uc010xbn.11000hsa04514
uc002kwg.21000hsa04514
uc010xbn.11000hsa05412
uc002kwg.21000hsa05412

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