Schema for bioCycPathway
  Database: mm39    Primary Table: bioCycPathway    Row Count: 2,384   Data last updated: 2024-08-15
Format description: BioCyc Pathway to Known Gene cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENSMUST00000027989.13varchar(40) values Known Gene ID
geneID Hsd17b7varchar(40) values Gene (RefSeq) ID
mapID PWY66-3varchar(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)
      mm39.ceBlastTab.query (via bioCycPathway.kgID)
      mm39.dmBlastTab.query (via bioCycPathway.kgID)
      mm39.drBlastTab.query (via bioCycPathway.kgID)
      mm39.foldUtr3.name (via bioCycPathway.kgID)
      mm39.foldUtr5.name (via bioCycPathway.kgID)
      mm39.hgBlastTab.query (via bioCycPathway.kgID)
      mm39.kgAlias.kgID (via bioCycPathway.kgID)
      mm39.kgColor.kgID (via bioCycPathway.kgID)
      mm39.kgProtAlias.kgID (via bioCycPathway.kgID)
      mm39.kgSpAlias.kgID (via bioCycPathway.kgID)
      mm39.kgTargetAli.qName (via bioCycPathway.kgID)
      mm39.kgXref.kgID (via bioCycPathway.kgID)
      mm39.knownAttrs.kgID (via bioCycPathway.kgID)
      mm39.knownBlastTab.query (via bioCycPathway.kgID)
      mm39.knownBlastTab.target (via bioCycPathway.kgID)
      mm39.knownCanonical.transcript (via bioCycPathway.kgID)
      mm39.knownCds.name (via bioCycPathway.kgID)
      mm39.knownGene.name (via bioCycPathway.kgID)
      mm39.knownGeneMrna.name (via bioCycPathway.kgID)
      mm39.knownIsoforms.transcript (via bioCycPathway.kgID)
      mm39.knownToEnsembl.name (via bioCycPathway.kgID)
      mm39.knownToLocusLink.name (via bioCycPathway.kgID)
      mm39.knownToMrna.name (via bioCycPathway.kgID)
      mm39.knownToMrnaSingle.name (via bioCycPathway.kgID)
      mm39.knownToMupit.name (via bioCycPathway.kgID)
      mm39.knownToNextProt.name (via bioCycPathway.kgID)
      mm39.knownToPfam.name (via bioCycPathway.kgID)
      mm39.knownToRefSeq.name (via bioCycPathway.kgID)
      mm39.knownToSuper.gene (via bioCycPathway.kgID)
      mm39.knownToTag.name (via bioCycPathway.kgID)
      mm39.knownToVisiGene.name (via bioCycPathway.kgID)
      mm39.knownToWikipedia.name (via bioCycPathway.kgID)
      mm39.rnBlastTab.query (via bioCycPathway.kgID)
      mm39.scBlastTab.query (via bioCycPathway.kgID)
      mm39.ucscScop.ucscId (via bioCycPathway.kgID)
      mm39.bioCycMapDesc.mapID (via bioCycPathway.mapID)

Sample Rows
 
kgIDgeneIDmapID
ENSMUST00000027989.13Hsd17b7PWY66-3
ENSMUST00000033509.15EbpPWY66-3
ENSMUST00000073878.12Dhcr7PWY66-3
ENSMUST00000224625.2Fdft1PWY66-3
ENSMUST00000022977.14SqlePWY66-3
ENSMUST00000052725.15Sc5dPWY66-3
ENSMUST00000048678.7LssPWY66-3
ENSMUST00000034547.6Acat1PWY-5177
ENSMUST00000007005.14Acat2PWY-5177
ENSMUST00000026289.10Hsd17b10PWY-5177

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