Database: hg19    Primary Table: bioCycPathway    Row Count: 1,916
Format description: BioCyc Pathway to Known Gene cross reference

field	example	SQL type	info	description
kgID	uc001kpr.2	varchar(40)	values	Known Gene ID
geneID	GOT1	varchar(40)	values	Gene (RefSeq) ID
mapID	ASPASN-PWY	varchar(40)	values	BioCyc pathway map ID

      hg19.ccdsKgMap.geneId (via bioCycPathway.kgID)
      hg19.ceBlastTab.query (via bioCycPathway.kgID)
      hg19.dmBlastTab.query (via bioCycPathway.kgID)
      hg19.drBlastTab.query (via bioCycPathway.kgID)
      hg19.foldUtr3.name (via bioCycPathway.kgID)
      hg19.foldUtr5.name (via bioCycPathway.kgID)
      hg19.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      hg19.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      hg19.humanHprdP2P.query (via bioCycPathway.kgID)
      hg19.humanHprdP2P.target (via bioCycPathway.kgID)
      hg19.humanVidalP2P.query (via bioCycPathway.kgID)
      hg19.humanVidalP2P.target (via bioCycPathway.kgID)
      hg19.humanWankerP2P.query (via bioCycPathway.kgID)
      hg19.humanWankerP2P.target (via bioCycPathway.kgID)
      hg19.keggPathway.kgID (via bioCycPathway.kgID)
      hg19.kg4ToKg5.newId (via bioCycPathway.kgID)
      hg19.kgAlias.kgID (via bioCycPathway.kgID)
      hg19.kgColor.kgID (via bioCycPathway.kgID)
      hg19.kgProtAlias.kgID (via bioCycPathway.kgID)
      hg19.kgProtMap2.qName (via bioCycPathway.kgID)
      hg19.kgSpAlias.kgID (via bioCycPathway.kgID)
      hg19.kgTargetAli.qName (via bioCycPathway.kgID)
      hg19.kgTxInfo.name (via bioCycPathway.kgID)
      hg19.kgXref.kgID (via bioCycPathway.kgID)
      hg19.knownBlastTab.query (via bioCycPathway.kgID)
      hg19.knownBlastTab.target (via bioCycPathway.kgID)
      hg19.knownCanonical.protein (via bioCycPathway.kgID)
      hg19.knownCanonical.transcript (via bioCycPathway.kgID)
      hg19.knownGene.name (via bioCycPathway.kgID)
      hg19.knownGeneMrna.name (via bioCycPathway.kgID)
      hg19.knownGenePep.name (via bioCycPathway.kgID)
      hg19.knownIsoforms.transcript (via bioCycPathway.kgID)
      hg19.knownToAllenBrain.name (via bioCycPathway.kgID)
      hg19.knownToEnsembl.name (via bioCycPathway.kgID)
      hg19.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      hg19.knownToHprd.name (via bioCycPathway.kgID)
      hg19.knownToLocusLink.name (via bioCycPathway.kgID)
      hg19.knownToPfam.name (via bioCycPathway.kgID)
      hg19.knownToRefSeq.name (via bioCycPathway.kgID)
      hg19.knownToSuper.gene (via bioCycPathway.kgID)
      hg19.knownToTreefam.name (via bioCycPathway.kgID)
      hg19.knownToU133.name (via bioCycPathway.kgID)
      hg19.knownToVisiGene.name (via bioCycPathway.kgID)
      hg19.mmBlastTab.query (via bioCycPathway.kgID)
      hg19.rnBlastTab.query (via bioCycPathway.kgID)
      hg19.scBlastTab.query (via bioCycPathway.kgID)
      hg19.bioCycMapDesc.mapID (via bioCycPathway.mapID)

kgID	geneID	mapID
uc001kpr.2	GOT1	ASPASN-PWY
uc002eof.1	GOT2	ASPASN-PWY
uc011lbj.1	GOT1L1	ASPASN-PWY
uc001ntf.3	ASRGL1	ASPASN-PWY
uc001yop.1	ASPG	ASPASN-PWY
uc001rgd.3	BCAT1	BRANCHED-CHAIN-AA-SYN-PWY
uc002pkr.2	BCAT2	BRANCHED-CHAIN-AA-SYN-PWY
uc002nam.2	ILVBL	BRANCHED-CHAIN-AA-SYN-PWY
uc001tvg.2	SDS	BRANCHED-CHAIN-AA-SYN-PWY
uc001tvi.2	SDSL	BRANCHED-CHAIN-AA-SYN-PWY

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