Schema for bioCycPathway
  Database: hg38    Primary Table: bioCycPathway    Row Count: 2,960   Data last updated: 2023-08-22
Format description: BioCyc Pathway to Known Gene cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENST00000251810.8varchar(40) values Known Gene ID
geneID RRM2Bvarchar(40) values Gene (RefSeq) ID
mapID PWY-7226varchar(40) values BioCyc pathway map ID

Connected Tables and Joining Fields
        hg38.ccdsKgMap.geneId (via bioCycPathway.kgID)
      hg38.ceBlastTab.query (via bioCycPathway.kgID)
      hg38.dmBlastTab.query (via bioCycPathway.kgID)
      hg38.drBlastTab.query (via bioCycPathway.kgID)
      hg38.foldUtr3.name (via bioCycPathway.kgID)
      hg38.foldUtr5.name (via bioCycPathway.kgID)
      hg38.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      hg38.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      hg38.gnfU95Distance.query (via bioCycPathway.kgID)
      hg38.gnfU95Distance.target (via bioCycPathway.kgID)
      hg38.humanHprdP2P.query (via bioCycPathway.kgID)
      hg38.humanHprdP2P.target (via bioCycPathway.kgID)
      hg38.humanVidalP2P.query (via bioCycPathway.kgID)
      hg38.humanVidalP2P.target (via bioCycPathway.kgID)
      hg38.humanWankerP2P.query (via bioCycPathway.kgID)
      hg38.humanWankerP2P.target (via bioCycPathway.kgID)
      hg38.keggPathway.kgID (via bioCycPathway.kgID)
      hg38.kgAlias.kgID (via bioCycPathway.kgID)
      hg38.kgColor.kgID (via bioCycPathway.kgID)
      hg38.kgProtAlias.kgID (via bioCycPathway.kgID)
      hg38.kgSpAlias.kgID (via bioCycPathway.kgID)
      hg38.kgTargetAli.qName (via bioCycPathway.kgID)
      hg38.kgXref.kgID (via bioCycPathway.kgID)
      hg38.knownAttrs.kgID (via bioCycPathway.kgID)
      hg38.knownBlastTab.query (via bioCycPathway.kgID)
      hg38.knownBlastTab.target (via bioCycPathway.kgID)
      hg38.knownCanonical.transcript (via bioCycPathway.kgID)
      hg38.knownCds.name (via bioCycPathway.kgID)
      hg38.knownGene.name (via bioCycPathway.kgID)
      hg38.knownGeneMrna.name (via bioCycPathway.kgID)
      hg38.knownGenePep.name (via bioCycPathway.kgID)
      hg38.knownIsoforms.transcript (via bioCycPathway.kgID)
      hg38.knownToEnsembl.name (via bioCycPathway.kgID)
      hg38.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      hg38.knownToHprd.name (via bioCycPathway.kgID)
      hg38.knownToKeggEntrez.name (via bioCycPathway.kgID)
      hg38.knownToLocusLink.name (via bioCycPathway.kgID)
      hg38.knownToLynx.name (via bioCycPathway.kgID)
      hg38.knownToMrna.name (via bioCycPathway.kgID)
      hg38.knownToMrnaSingle.name (via bioCycPathway.kgID)
      hg38.knownToMupit.name (via bioCycPathway.kgID)
      hg38.knownToNextProt.name (via bioCycPathway.kgID)
      hg38.knownToPfam.name (via bioCycPathway.kgID)
      hg38.knownToRefSeq.name (via bioCycPathway.kgID)
      hg38.knownToSuper.gene (via bioCycPathway.kgID)
      hg38.knownToTag.name (via bioCycPathway.kgID)
      hg38.knownToU133.name (via bioCycPathway.kgID)
      hg38.knownToU95.name (via bioCycPathway.kgID)
      hg38.knownToVisiGene.name (via bioCycPathway.kgID)
      hg38.knownToWikipedia.name (via bioCycPathway.kgID)
      hg38.mmBlastTab.query (via bioCycPathway.kgID)
      hg38.rnBlastTab.query (via bioCycPathway.kgID)
      hg38.scBlastTab.query (via bioCycPathway.kgID)
      hg38.ucscScop.ucscId (via bioCycPathway.kgID)
      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)
      hg38.bioCycMapDesc.mapID (via bioCycPathway.mapID)

Sample Rows
 
kgIDgeneIDmapID
ENST00000251810.8RRM2BPWY-7226
ENST00000300738.10RRM1PWY-7226
ENST00000304567.10RRM2PWY-7226
ENST00000265191.4NME5PWY-7226
ENST00000393196.8NME1PWY-7226
ENST00000512737.6NME2PWY-7226
ENST00000219302.8NME3PWY-7226
ENST00000219479.7NME4PWY-7226
ENST00000426182.2NME2P1PWY-7226
ENST00000442597.6NME6PWY-7226

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