Schema for keggPathway
  Database: mm10    Primary Table: keggPathway    Row Count: 85,742   Data last updated: 2019-09-21
Format description: KEGG pathway cross reference
fieldexampleSQL type info description
kgID ENSMUST00000037828.7varchar(40) values Known Gene ID
locusID 100017varchar(40) values LocusLink ID
mapID mmu04144varchar(40) values KEGG pathway map ID

Connected Tables and Joining Fields
        mm10.bioCycPathway.kgID (via keggPathway.kgID)
      mm10.ccdsKgMap.geneId (via keggPathway.kgID)
      mm10.ceBlastTab.query (via keggPathway.kgID)
      mm10.dmBlastTab.query (via keggPathway.kgID)
      mm10.drBlastTab.query (via keggPathway.kgID)
      mm10.foldUtr3.name (via keggPathway.kgID)
      mm10.foldUtr5.name (via keggPathway.kgID)
      mm10.hgBlastTab.query (via keggPathway.kgID)
      mm10.kgAlias.kgID (via keggPathway.kgID)
      mm10.kgColor.kgID (via keggPathway.kgID)
      mm10.kgProtAlias.kgID (via keggPathway.kgID)
      mm10.kgProtMap2.qName (via keggPathway.kgID)
      mm10.kgSpAlias.kgID (via keggPathway.kgID)
      mm10.kgTargetAli.qName (via keggPathway.kgID)
      mm10.kgTxInfo.name (via keggPathway.kgID)
      mm10.kgXref.kgID (via keggPathway.kgID)
      mm10.knownAttrs.kgID (via keggPathway.kgID)
      mm10.knownBlastTab.query (via keggPathway.kgID)
      mm10.knownBlastTab.target (via keggPathway.kgID)
      mm10.knownCanonical.transcript (via keggPathway.kgID)
      mm10.knownCds.name (via keggPathway.kgID)
      mm10.knownGene.name (via keggPathway.kgID)
      mm10.knownGeneMrna.name (via keggPathway.kgID)
      mm10.knownGenePep.name (via keggPathway.kgID)
      mm10.knownIsoforms.transcript (via keggPathway.kgID)
      mm10.knownToEnsembl.name (via keggPathway.kgID)
      mm10.knownToKeggEntrez.name (via keggPathway.kgID)
      mm10.knownToLocusLink.name (via keggPathway.kgID)
      mm10.knownToLynx.name (via keggPathway.kgID)
      mm10.knownToMrna.name (via keggPathway.kgID)
      mm10.knownToMrnaSingle.name (via keggPathway.kgID)
      mm10.knownToPfam.name (via keggPathway.kgID)
      mm10.knownToRefSeq.name (via keggPathway.kgID)
      mm10.knownToSuper.gene (via keggPathway.kgID)
      mm10.knownToTag.name (via keggPathway.kgID)
      mm10.knownToVisiGene.name (via keggPathway.kgID)
      mm10.knownToWikipedia.name (via keggPathway.kgID)
      mm10.rnBlastTab.query (via keggPathway.kgID)
      mm10.scBlastTab.query (via keggPathway.kgID)
      mm10.ucscScop.ucscId (via keggPathway.kgID)
      hgFixed.refLink.locusLinkId (via keggPathway.locusID)
      mm10.knownToLocusLink.value (via keggPathway.locusID)
      mm10.keggMapDesc.mapID (via keggPathway.mapID)
      mm10.knownToKeggEntrez.value (via keggPathway.mapID)

Sample Rows
 
kgIDlocusIDmapID
ENSMUST00000037828.7100017mmu04144
ENSMUST00000148479.1100017mmu04144
ENSMUST00000140678.1100017mmu04144
ENSMUST00000071642.10100019mmu03008
ENSMUST00000178134.1100019mmu03008
ENSMUST00000151626.1100019mmu03008
ENSMUST00000133403.1100019mmu03008
ENSMUST00000136608.1100019mmu03008
ENSMUST00000125323.1100019mmu03008
ENSMUST00000150934.7100019mmu03008

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