7bc1475cf09a8da21c7cfa2e233f853700524200 hiram Tue Sep 27 11:10:23 2016 -0700 ncbiRefSeqLink now has empty strings instead of n/a refs #13673 diff --git src/hg/hgc/hgc.c src/hg/hgc/hgc.c index 647f4a0..a1a1713 100644 --- src/hg/hgc/hgc.c +++ src/hg/hgc/hgc.c @@ -11735,143 +11735,143 @@ /* get refLink entry */ sqlSafef(query, sizeof(query), "select * from ncbiRefSeqLink where id = '%s'", itemName); sr = sqlGetResult(conn, query); if ((row = sqlNextRow(sr)) == NULL) errAbort("Couldn't find %s in ncbiRefSeqLink table.", itemName); nrl = ncbiRefSeqLinkLoad(row); sqlFreeResult(&sr); printf("<h2>RefSeq Gene %s</h2><br>\n", nrl->name); printf("<b>RefSeq:</b> <a href='"); printEntrezNucleotideUrl(stdout, nrl->id); printf("' target=_blank>%s</a>", nrl->id); printf(" <b>Status: </b>%s<br>\n", nrl->status); printf("<b>Description:</b> %s<br>\n", nrl->product); -if (differentWord(nrl->gbkey, "n/a")) +if (differentWord(nrl->gbkey, "")) { printf("<b>Molecule type:</b> %s<br>\n", nrl->gbkey); } -if (differentWord(nrl->pseudo, "n/a")) +if (differentWord(nrl->pseudo, "")) { printf("<b>Pseudogene:</b> %s<br>\n", nrl->pseudo); } -if (differentWord(nrl->source, "n/a")) +if (differentWord(nrl->source, "")) { printf("<b>Source:</b> %s<br>\n", nrl->source); } -if (differentWord(nrl->gene_biotype, "n/a")) +if (differentWord(nrl->gene_biotype, "")) { printf("<b>Biotype:</b> %s<br>\n", nrl->gene_biotype); } -if (differentWord(nrl->gene_synonym, "n/a")) +if (differentWord(nrl->gene_synonym, "")) { printf("<b>Synonyms:</b> %s<br>\n", nrl->gene_synonym); } -if (differentWord(nrl->ncrna_class, "n/a")) +if (differentWord(nrl->ncrna_class, "")) { printf("<b>ncRNA class:</b> %s<br>\n", nrl->ncrna_class); } -if (differentWord(nrl->note, "n/a")) +if (differentWord(nrl->note, "")) { printf("<b>Other notes:</b> %s<br>\n", nrl->note); } -if (differentWord(nrl->omimId, "n/a")) +if (differentWord(nrl->omimId, "")) { printf("<b>OMIM:</b> <a href='"); printEntrezOMIMUrl(stdout, sqlSigned(nrl->omimId)); printf("' target=_blank>%s</a><br>\n", nrl->omimId); } -if (differentWord(nrl->mrnaAcc, "n/a") && differentWord(nrl->mrnaAcc,nrl->id)) +if (differentWord(nrl->mrnaAcc, "") && differentWord(nrl->mrnaAcc,nrl->id)) { printf("<b>mRNA:</b> "); printf("<a href='http://www.ncbi.nlm.nih.gov/nuccore/%s' target=_blank>", nrl->mrnaAcc); printf("%s</a><br>\n", nrl->mrnaAcc); } -if (differentWord(nrl->genbank, "n/a") && differentWord(nrl->genbank,nrl->id)) +if (differentWord(nrl->genbank, "") && differentWord(nrl->genbank,nrl->id)) { printf("<b>Genbank:</b> "); printf("<a href='http://www.ncbi.nlm.nih.gov/nuccore/%s' target=_blank>", nrl->genbank); printf("%s</a><br>\n", nrl->genbank); } -if (differentWord(nrl->protAcc, "n/a")) +if (differentWord(nrl->protAcc, "")) { printf("<b>Protein:</b> "); printf("<a href='http://www.ncbi.nlm.nih.gov/protein/%s' target=_blank>", nrl->protAcc); printf("%s</a><br>\n", nrl->protAcc); } -if (differentWord(nrl->hgnc, "n/a")) +if (differentWord(nrl->hgnc, "")) { printf("<b>HGNC:</b> "); printf("<a href='http://www.genenames.org/cgi-bin/gene_symbol_report?hgnc_id=HGNC:%s' target=_blank>", nrl->hgnc); printf("%s</a><br>\n", nrl->hgnc); } -if (differentWord(nrl->locusLinkId, "n/a")) +if (differentWord(nrl->locusLinkId, "")) { printf("<b>Entrez Gene:</b> "); printf("<a href='http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=gene&cmd=Retrieve&dopt=Graphics&list_uids=%s' TARGET=_blank>", nrl->locusLinkId); printf("%s</a><br>\n", nrl->locusLinkId); } -if (differentWord(nrl->name,"n/a")) +if (differentWord(nrl->name,"")) { printGeneCards(nrl->name); if (startsWith("hg", database)) { printf("<b>AceView:</b> "); printf("<a href = 'http://www.ncbi.nlm.nih.gov/IEB/Research/Acembly/av.cgi?db=human&l=%s' target=_blank>", nrl->name); printf("%s</a><br>\n", nrl->name); } } if ((trackVersion != NULL) && !isEmpty(trackVersion->version)) { printf("<B>Annotation Release:</B> <A href='%s' TARGET=_blank> %s <BR></A>", trackVersion->comment, trackVersion->version); } htmlHorizontalLine(); -if (differentWord("n/a", nrl->description)) +if (differentWord("", nrl->description)) { printf("Summary of <b>%s</b><br>\n%s<br>\n", nrl->name, nrl->description); htmlHorizontalLine(); } struct psl *pslList = getAlignments(conn, "ncbiRefSeqPsl", itemName); // if the itemName isn't found, it might be found as the nrl->mrnaAcc if (! pslList) pslList = getAlignments(conn, "ncbiRefSeqPsl", nrl->mrnaAcc); if (pslList) { int start = cartInt(cart, "o"); printf("<H3>mRNA/Genomic Alignments</H3>"); printAlignments(pslList, start, "htcCdnaAli", "ncbiRefSeqPsl", itemName); } else { printf ("<h4>there is NO alignment for %s</h4><br>\n", itemName); } htmlHorizontalLine(); if (!sameString(tdb->track, "ncbiRefSeqPsl")) showGenePos(itemName, tdb); printf("<h3>Links to sequence:</h3>\n"); printf("<ul>\n"); -if (differentWord("n/a", nrl->protAcc)) +if (differentWord("", nrl->protAcc)) { puts("<li>\n"); hgcAnchorSomewhere("htcTranslatedProtein", nrl->protAcc, "ncbiRefSeqPepTable", seqName); printf("Predicted Protein</a> \n"); puts("</li>\n"); } puts("<li>\n"); hgcAnchorSomewhere("ncbiRefSeqSequence", itemName, "ncbiRefSeqPsl", seqName); printf("%s</a> may be different from the genomic sequence.\n", "Predicted mRNA"); puts("</li>\n"); puts("<LI>\n"); hgcAnchorSomewhere("getDna", itemName, tdb->track, seqName); printf("Genomic Sequence</A> from assembly\n"); puts("</LI>\n");