1ae72fd3072fddf58e2d414b33b4700dd3ad70cf
lrnassar
Thu Dec 15 15:49:46 2022 -0800
Fixing hgGene linkout, refs #30404
diff --git src/hg/hgGene/pathways.c src/hg/hgGene/pathways.c
index a90f3cb..edd7da8 100644
--- src/hg/hgGene/pathways.c
+++ src/hg/hgGene/pathways.c
@@ -164,31 +164,31 @@
spID = sqlGetField(database, "rgdGene2ToUniProt", "value", condStr);
}
else
{
sqlSafef(condStr, sizeof(condStr), "kgID='%s'", geneId);
spID = sqlGetField(sqlGetDatabase(conn), "kgXref", "spID", condStr);
}
if (spID != NULL)
{
/* convert splice variant UniProt ID to its main root ID */
chp = strstr(spID, "-");
if (chp != NULL) *chp = '\0';
hPrintf(
- "
Protein %s (Reactome details) participates in the following event(s):
"
+ "
Protein %s (Reactome details) participates in the following event(s):
"
, spID, spID);
conn2= hAllocConn(database);
sqlSafef(query2,sizeof(query2),
"select eventID, eventDesc from proteome.spReactomeEvent where spID='%s'", spID);
sr2 = sqlMustGetResult(conn2, query2);
row2 = sqlNextRow(sr2);
while (row2 != NULL)
{
eventID = row2[0];
eventDesc = row2[1];
hPrintf(
"%s %s
\n",
eventID, eventID, eventDesc);
row2 = sqlNextRow(sr2);