e861142f5417024b3b752d6a053d4a92ba817fed
fanhsu
  Tue Jul 13 15:28:13 2010 -0700
Refined DECIPHER detailed page.
diff --git src/hg/hgc/hgc.c src/hg/hgc/hgc.c
index 2cb16f8..8740232 100644
--- src/hg/hgc/hgc.c
+++ src/hg/hgc/hgc.c
@@ -8825,10 +8825,10 @@
 
 /* link to Ensembl DECIPHER Patient View page */
 printf("<B>Patient View: </B>\n");
-printf("For more details of patient %s, click ", itemName);
+printf("More details on patient %s at ", itemName);
 printf("<A HREF=\"%s%s\" target=_blank>",
        "https://decipher.sanger.ac.uk/application/patient/", itemName);
-printf("here</A>.<BR><BR>");
+printf("DECIPHER</A>.<BR><BR>");
 
 /* print position info */
 safef(query, sizeof(query),
@@ -8843,12 +8843,12 @@
 
 /* print UCSC Genes in the reported region */
 safef(query, sizeof(query),
-      "select distinct t.name from knownToDecipher t where value ='%s'", itemName);
+      "select distinct t.name from knownCanonToDecipher t, kgXref x  where value ='%s' and x.kgId=t.name order by geneSymbol", itemName);
 sr = sqlMustGetResult(conn, query);
 row = sqlNextRow(sr);
 if (row != NULL)
     {
-    printf("<BR><B>UCSC Gene(s) in this genomic region: </B><UL>");
+    printf("<BR><B>UCSC Canonical Gene(s) in this genomic region: </B><UL>");
     while (row != NULL)
     	{
 	safef(query2, sizeof(query2),