Schema for bioCycPathway
  Database: mm10    Primary Table: bioCycPathway    Row Count: 2,383   Data last updated: 2019-09-21
Format description: BioCyc Pathway to Known Gene cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENSMUST00000141118.8varchar(40) values Known Gene ID
geneID Alas1varchar(40) values Gene (RefSeq) ID
mapID PWY-5920varchar(40) values BioCyc pathway map ID

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via bioCycPathway.kgID)
      knownGeneV39.ceBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.dmBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.drBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.foldUtr3.name (via bioCycPathway.kgID)
      knownGeneV39.foldUtr5.name (via bioCycPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      knownGeneV39.kgAlias.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgColor.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgProtAlias.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgSpAlias.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgTargetAli.qName (via bioCycPathway.kgID)
      knownGeneV39.kgXref.kgID (via bioCycPathway.kgID)
      knownGeneV39.knownAttrs.kgID (via bioCycPathway.kgID)
      knownGeneV39.knownBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.knownBlastTab.target (via bioCycPathway.kgID)
      knownGeneV39.knownCanonical.protein (via bioCycPathway.kgID)
      knownGeneV39.knownCanonical.transcript (via bioCycPathway.kgID)
      knownGeneV39.knownCds.name (via bioCycPathway.kgID)
      knownGeneV39.knownGene.name (via bioCycPathway.kgID)
      knownGeneV39.knownGeneMrna.name (via bioCycPathway.kgID)
      knownGeneV39.knownGenePep.name (via bioCycPathway.kgID)
      knownGeneV39.knownIsoforms.transcript (via bioCycPathway.kgID)
      knownGeneV39.knownToEnsembl.name (via bioCycPathway.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      knownGeneV39.knownToHprd.name (via bioCycPathway.kgID)
      knownGeneV39.knownToLocusLink.name (via bioCycPathway.kgID)
      knownGeneV39.knownToMrna.name (via bioCycPathway.kgID)
      knownGeneV39.knownToMrnaSingle.name (via bioCycPathway.kgID)
      knownGeneV39.knownToMupit.name (via bioCycPathway.kgID)
      knownGeneV39.knownToPfam.name (via bioCycPathway.kgID)
      knownGeneV39.knownToRefSeq.name (via bioCycPathway.kgID)
      knownGeneV39.knownToSuper.gene (via bioCycPathway.kgID)
      knownGeneV39.knownToTag.name (via bioCycPathway.kgID)
      knownGeneV39.knownToU133.name (via bioCycPathway.kgID)
      knownGeneV39.knownToU95.name (via bioCycPathway.kgID)
      knownGeneV39.knownToVisiGene.name (via bioCycPathway.kgID)
      knownGeneV39.knownToWikipedia.name (via bioCycPathway.kgID)
      knownGeneV39.mmBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.rnBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.scBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.ucscScop.ucscId (via bioCycPathway.kgID)
      mm10.ccdsKgMap.geneId (via bioCycPathway.kgID)
      mm10.ceBlastTab.query (via bioCycPathway.kgID)
      mm10.dmBlastTab.query (via bioCycPathway.kgID)
      mm10.drBlastTab.query (via bioCycPathway.kgID)
      mm10.foldUtr3.name (via bioCycPathway.kgID)
      mm10.foldUtr5.name (via bioCycPathway.kgID)
      mm10.hgBlastTab.query (via bioCycPathway.kgID)
      mm10.keggPathway.kgID (via bioCycPathway.kgID)
      mm10.kgAlias.kgID (via bioCycPathway.kgID)
      mm10.kgColor.kgID (via bioCycPathway.kgID)
      mm10.kgProtAlias.kgID (via bioCycPathway.kgID)
      mm10.kgProtMap2.qName (via bioCycPathway.kgID)
      mm10.kgSpAlias.kgID (via bioCycPathway.kgID)
      mm10.kgTargetAli.qName (via bioCycPathway.kgID)
      mm10.kgTxInfo.name (via bioCycPathway.kgID)
      mm10.kgXref.kgID (via bioCycPathway.kgID)
      mm10.knownAttrs.kgID (via bioCycPathway.kgID)
      mm10.knownBlastTab.query (via bioCycPathway.kgID)
      mm10.knownBlastTab.target (via bioCycPathway.kgID)
      mm10.knownCanonical.transcript (via bioCycPathway.kgID)
      mm10.knownCds.name (via bioCycPathway.kgID)
      mm10.knownGene.name (via bioCycPathway.kgID)
      mm10.knownGeneMrna.name (via bioCycPathway.kgID)
      mm10.knownGenePep.name (via bioCycPathway.kgID)
      mm10.knownIsoforms.transcript (via bioCycPathway.kgID)
      mm10.knownToEnsembl.name (via bioCycPathway.kgID)
      mm10.knownToKeggEntrez.name (via bioCycPathway.kgID)
      mm10.knownToLocusLink.name (via bioCycPathway.kgID)
      mm10.knownToLynx.name (via bioCycPathway.kgID)
      mm10.knownToMrna.name (via bioCycPathway.kgID)
      mm10.knownToMrnaSingle.name (via bioCycPathway.kgID)
      mm10.knownToPfam.name (via bioCycPathway.kgID)
      mm10.knownToRefSeq.name (via bioCycPathway.kgID)
      mm10.knownToSuper.gene (via bioCycPathway.kgID)
      mm10.knownToTag.name (via bioCycPathway.kgID)
      mm10.knownToVisiGene.name (via bioCycPathway.kgID)
      mm10.knownToWikipedia.name (via bioCycPathway.kgID)
      mm10.rnBlastTab.query (via bioCycPathway.kgID)
      mm10.scBlastTab.query (via bioCycPathway.kgID)
      mm10.ucscScop.ucscId (via bioCycPathway.kgID)
      mm10.bioCycMapDesc.mapID (via bioCycPathway.mapID)

Sample Rows
 
kgIDgeneIDmapID
ENSMUST00000141118.8Alas1PWY-5920
ENSMUST00000066337.12Alas2PWY-5920
ENSMUST00000030090.3AladPWY-5920
ENSMUST00000077353.14HmbsPWY-5920
ENSMUST00000033276.10UrosPWY-5920
ENSMUST00000030446.14UrodPWY-5920
ENSMUST00000073120.10PpoxPWY-5920
ENSMUST00000236586.1FechPWY-5920
ENSMUST00000060077.6CpoxPWY-5920
ENSMUST00000031117.12Gnpda2GLCMANNANAUT-PWY

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