7cf33ee882ae64d20b55f50698bf6d0da1c28a3a galt Fri Jan 10 01:53:04 2025 -0800 fixes based on Braneys helpful feedback. diff --git src/hg/hgc/hgc.c src/hg/hgc/hgc.c index fb171bf..9d29497 100644 --- src/hg/hgc/hgc.c +++ src/hg/hgc/hgc.c @@ -11656,31 +11656,32 @@ showOmimDisorderTable(conn, url, itemName); } printf("</div>"); // #omimText } void printOmimLocationDetails(struct trackDb *tdb, char *itemName, boolean encode) /* Print details of an OMIM Class 3 Gene entry. */ { struct sqlConnection *conn = hAllocConn(database); struct sqlConnection *conn2 = hAllocConn(database); char query[256]; struct sqlResult *sr; char **row; char *url = tdb->url; -char *kgId = cartString(cart, "i"); +char *kgId = NULL; +// GALT RESTORE? cartString(cart, "i"); char *title1 = NULL; char *geneSymbol = NULL; char *chrom, *chromStart, *chromEnd; char *kgDescription = NULL; char *refSeq; char *omimId; chrom = cartOptionalString(cart, "c"); chromStart = cartOptionalString(cart, "o"); chromEnd = cartOptionalString(cart, "t"); omimId = itemName; if (url != NULL && url[0] != 0) { @@ -11690,30 +11691,42 @@ sqlSafef(query, sizeof(query), "select geneName from omimGeneMap2 where omimId=%s;", itemName); sr = sqlMustGetResult(conn, query); row = sqlNextRow(sr); if (row != NULL) { if (row[0] != NULL) { title1 = cloneString(row[0]); printf(": %s", title1); } } sqlFreeResult(&sr); printf("<BR>"); + /* get corresponding KG ID */ + sqlSafef(query, sizeof(query), + "select k.transcript from knownCanonical k where k.chrom='%s' and k.chromStart=%s and k.chromEnd=%s", + chrom, chromStart, chromEnd); + sr = sqlMustGetResult(conn, query); + row = sqlNextRow(sr); + if (row != NULL) + { + kgId = cloneString(row[0]); + } + sqlFreeResult(&sr); + // disable NCBI link until they work it out with OMIM /* printf("<B>OMIM page at NCBI: "); printf("<A HREF=\"%s%s\" target=_blank>", ncbiOmimUrl, itemName); printf("%s</A></B><BR>", itemName); */ printf("<B>Location: </B>"); sqlSafef(query, sizeof(query), "select location from omimGeneMap2 where omimId=%s;", itemName); sr = sqlMustGetResult(conn, query); row = sqlNextRow(sr); if (row != NULL) { if (row[0] != NULL) @@ -11915,37 +11928,34 @@ " from omimGeneMap2 m, omimAv v" " where m.omimId=%s and m.omimId=v.omimId and v.avId='%s';", itemName, avId); sr = sqlMustGetResult(conn, query); row = sqlNextRow(sr); if (row != NULL) { if (row[0] != NULL) { title1 = cloneString(row[0]); } avDesc = cloneString(row[2]); } sqlFreeResult(&sr); - if (avDesc) - { printf("<B>OMIM Allelic Variant: "); printf("<A HREF=\"%s%s\" target=_blank>", url, avString); printf("%s</A></B>", avId); - printf(" %s", avDesc); - } + printf(" %s", avDesc ? avDesc : ""); printf("<BR><B>OMIM: "); printf("<A HREF=\"%s%s\" target=_blank>", url, itemName); printf("%s</A></B>", itemName); if (title1 != NULL) printf(": %s", title1); // disable NCBI link until they work it out with OMIM /* printf("<BR>\n"); printf("<B>OMIM page at NCBI: "); printf("<A HREF=\"%s%s\" target=_blank>", ncbiOmimUrl, itemName); printf("%s</A></B><BR>", itemName); */ sqlSafef(query, sizeof(query),