6e69d9250f787c86467bcb1b149eff9065905213
kate
  Wed Feb 10 15:51:42 2016 -0800
Query for transcript description in version agnostic way to accomodate changes to knownToEnsembl table (hg38 vs hg19)

diff --git src/hg/hgc/gtexClick.c src/hg/hgc/gtexClick.c
index 08ef1c7..9152616 100644
--- src/hg/hgc/gtexClick.c
+++ src/hg/hgc/gtexClick.c
@@ -172,37 +172,40 @@
     *maxValRet = maxVal;
 return tsList;
 }
 
 void doGtexGeneExpr(struct trackDb *tdb, char *item)
 /* Details of GTEx gene expression item */
 {
 struct gtexGeneBed *gtexGene = getGtexGene(item, tdb->table);
 if (gtexGene == NULL)
     errAbort("Can't find gene %s in GTEx gene table %s\n", item, tdb->table);
 
 genericHeader(tdb, item);
 // TODO: link to UCSC gene
 printf("<b>Gene:</b> %s<br>", gtexGene->name);
 char query[256];
+char *transcriptId = cloneString(gtexGene->transcriptId);
+chopSuffix(transcriptId);
 sqlSafef(query, sizeof(query), 
-        "select kgXref.description from kgXref, knownToEnsembl where knownToEnsembl.value='%s' and knownToEnsembl.name=kgXref.kgID", gtexGene->transcriptId);
+        "select kgXref.description from kgXref, knownToEnsembl where knownToEnsembl.value like '%%%s%%' and knownToEnsembl.name=kgXref.kgID", transcriptId);
 struct sqlConnection *conn = hAllocConn(database);
 char *desc = sqlQuickString(conn, query);
 hFreeConn(&conn);
 if (desc != NULL)
     printf("<b>Description:</b> %s<br>\n", desc);
-printf("<b>Ensembl ID:</b> %s<br>\n", gtexGene->geneId);
+printf("<b>Ensembl Gene ID:</b> %s<br>\n", gtexGene->geneId);
+printf("<b>Ensembl Transcript ID:</b> %s<br>\n", transcriptId);
 printf("<a target='_blank' href='http://www.gtexportal.org/home/gene/%s'>View at GTEx portal</a><br>\n", gtexGene->geneId);
 puts("<p>");
 
 boolean doLogTransform = cartUsualBooleanClosestToHome(cart, tdb, FALSE, GTEX_LOG_TRANSFORM,
                                                 GTEX_LOG_TRANSFORM_DEFAULT);
 double maxVal = 0.0;
 char *versionSuffix = gtexVersionSuffix(tdb->table);
 struct tissueSampleVals *tsvs = getTissueSampleVals(gtexGene, doLogTransform, 
                                                         versionSuffix, &maxVal);
 char *version = gtexVersion(tdb->table);
 drawGtexRBoxplot(gtexGene, tsvs, doLogTransform, version);
 
 printTrackHtml(tdb);
 }