Schema for keggPathway
  Database: hg38    Primary Table: keggPathway    Row Count: 139,390   Data last updated: 2021-01-27
Format description: KEGG pathway cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENST00000520116.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
        hg38.bioCycPathway.kgID (via keggPathway.kgID)
      hg38.ccdsKgMap.geneId (via keggPathway.kgID)
      hg38.ceBlastTab.query (via keggPathway.kgID)
      hg38.dmBlastTab.query (via keggPathway.kgID)
      hg38.drBlastTab.query (via keggPathway.kgID)
      hg38.foldUtr3.name (via keggPathway.kgID)
      hg38.foldUtr5.name (via keggPathway.kgID)
      hg38.gnfAtlas2Distance.query (via keggPathway.kgID)
      hg38.gnfAtlas2Distance.target (via keggPathway.kgID)
      hg38.gnfU95Distance.query (via keggPathway.kgID)
      hg38.gnfU95Distance.target (via keggPathway.kgID)
      hg38.humanHprdP2P.query (via keggPathway.kgID)
      hg38.humanHprdP2P.target (via keggPathway.kgID)
      hg38.humanVidalP2P.query (via keggPathway.kgID)
      hg38.humanVidalP2P.target (via keggPathway.kgID)
      hg38.humanWankerP2P.query (via keggPathway.kgID)
      hg38.humanWankerP2P.target (via keggPathway.kgID)
      hg38.kgAlias.kgID (via keggPathway.kgID)
      hg38.kgColor.kgID (via keggPathway.kgID)
      hg38.kgProtAlias.kgID (via keggPathway.kgID)
      hg38.kgSpAlias.kgID (via keggPathway.kgID)
      hg38.kgTargetAli.qName (via keggPathway.kgID)
      hg38.kgXref.kgID (via keggPathway.kgID)
      hg38.knownAttrs.kgID (via keggPathway.kgID)
      hg38.knownBlastTab.query (via keggPathway.kgID)
      hg38.knownBlastTab.target (via keggPathway.kgID)
      hg38.knownCanonical.transcript (via keggPathway.kgID)
      hg38.knownCds.name (via keggPathway.kgID)
      hg38.knownGene.name (via keggPathway.kgID)
      hg38.knownGeneMrna.name (via keggPathway.kgID)
      hg38.knownGenePep.name (via keggPathway.kgID)
      hg38.knownIsoforms.transcript (via keggPathway.kgID)
      hg38.knownToEnsembl.name (via keggPathway.kgID)
      hg38.knownToGnfAtlas2.name (via keggPathway.kgID)
      hg38.knownToHprd.name (via keggPathway.kgID)
      hg38.knownToKeggEntrez.name (via keggPathway.kgID)
      hg38.knownToLocusLink.name (via keggPathway.kgID)
      hg38.knownToLynx.name (via keggPathway.kgID)
      hg38.knownToMrna.name (via keggPathway.kgID)
      hg38.knownToMrnaSingle.name (via keggPathway.kgID)
      hg38.knownToMupit.name (via keggPathway.kgID)
      hg38.knownToNextProt.name (via keggPathway.kgID)
      hg38.knownToPfam.name (via keggPathway.kgID)
      hg38.knownToRefSeq.name (via keggPathway.kgID)
      hg38.knownToSuper.gene (via keggPathway.kgID)
      hg38.knownToTag.name (via keggPathway.kgID)
      hg38.knownToU133.name (via keggPathway.kgID)
      hg38.knownToU95.name (via keggPathway.kgID)
      hg38.knownToVisiGene.name (via keggPathway.kgID)
      hg38.knownToWikipedia.name (via keggPathway.kgID)
      hg38.mmBlastTab.query (via keggPathway.kgID)
      hg38.rnBlastTab.query (via keggPathway.kgID)
      hg38.scBlastTab.query (via keggPathway.kgID)
      hg38.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)
      hg38.knownToLocusLink.value (via keggPathway.locusID)
      hg38.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)
      hg38.keggMapDesc.mapID (via keggPathway.mapID)
      hg38.knownToKeggEntrez.value (via keggPathway.mapID)

Sample Rows
 
kgIDlocusIDmapID
ENST00000520116.110hsa00232
ENST00000286479.410hsa00232
ENST00000520116.110hsa00983
ENST00000286479.410hsa00983
ENST00000520116.110hsa01100
ENST00000286479.410hsa01100
ENST00000372874.9100hsa00230
ENST00000464097.5100hsa00230
ENST00000536532.5100hsa00230
ENST00000537820.1100hsa00230

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