a9c9cf2828c124535a1562f709bd4437b1bf60a2 braney Mon Jun 22 16:41:31 2020 -0700 starting on making hgGene use and external database for the know* tables diff --git src/hg/hgGene/synonym.c src/hg/hgGene/synonym.c index 174f751..452bd96 100644 --- src/hg/hgGene/synonym.c +++ src/hg/hgGene/synonym.c @@ -350,31 +350,31 @@ else /* do not show URL link if it is not found in gbCdnaInfoTable */ { hPrintf("<B>Representative RNA: %s </B>", mrnaAcc); } } if (protAcc != NULL) { kgProteinID = cloneString(""); if (hTableExists(sqlGetDatabase(conn), "knownGene") && (isNotEmpty(curGeneChrom) && differentWord(curGeneChrom,"none"))) { sqlSafefFrag(condStr, sizeof(condStr), "name = '%s' and chrom = '%s' and txStart=%d and txEnd=%d", id, curGeneChrom, curGeneStart, curGeneEnd); - kgProteinID = sqlGetField(database, "knownGene", "proteinID", condStr); + kgProteinID = sqlGetField(sqlGetDatabase(conn), "knownGene", "proteinID", condStr); } hPrintf("<B>Protein: "); if (strstr(kgProteinID, "-") != NULL) { parAcc = cloneString(kgProteinID); chp = strstr(parAcc, "-"); *chp = '\0'; /* show variant splice protein and the UniProt link here */ hPrintf("<A HREF=\"http://www.uniprot.org/uniprot/%s\" " "TARGET=_blank>%s</A></B>, splice isoform of ", kgProteinID, kgProteinID); hPrintf("<A HREF=\"http://www.uniprot.org/uniprot/%s\" " "TARGET=_blank>%s</A></B>\n",