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("

RefSeq Gene %s


\n", nrl->name); printf("RefSeq: %s", nrl->id); printf("  Status: %s
\n", nrl->status); printf("Description: %s
\n", nrl->product); -if (differentWord(nrl->gbkey, "n/a")) +if (differentWord(nrl->gbkey, "")) { printf("Molecule type: %s
\n", nrl->gbkey); } -if (differentWord(nrl->pseudo, "n/a")) +if (differentWord(nrl->pseudo, "")) { printf("Pseudogene: %s
\n", nrl->pseudo); } -if (differentWord(nrl->source, "n/a")) +if (differentWord(nrl->source, "")) { printf("Source: %s
\n", nrl->source); } -if (differentWord(nrl->gene_biotype, "n/a")) +if (differentWord(nrl->gene_biotype, "")) { printf("Biotype: %s
\n", nrl->gene_biotype); } -if (differentWord(nrl->gene_synonym, "n/a")) +if (differentWord(nrl->gene_synonym, "")) { printf("Synonyms: %s
\n", nrl->gene_synonym); } -if (differentWord(nrl->ncrna_class, "n/a")) +if (differentWord(nrl->ncrna_class, "")) { printf("ncRNA class: %s
\n", nrl->ncrna_class); } -if (differentWord(nrl->note, "n/a")) +if (differentWord(nrl->note, "")) { printf("Other notes: %s
\n", nrl->note); } -if (differentWord(nrl->omimId, "n/a")) +if (differentWord(nrl->omimId, "")) { printf("OMIM: %s
\n", nrl->omimId); } -if (differentWord(nrl->mrnaAcc, "n/a") && differentWord(nrl->mrnaAcc,nrl->id)) +if (differentWord(nrl->mrnaAcc, "") && differentWord(nrl->mrnaAcc,nrl->id)) { printf("mRNA: "); printf("", nrl->mrnaAcc); printf("%s
\n", nrl->mrnaAcc); } -if (differentWord(nrl->genbank, "n/a") && differentWord(nrl->genbank,nrl->id)) +if (differentWord(nrl->genbank, "") && differentWord(nrl->genbank,nrl->id)) { printf("Genbank: "); printf("", nrl->genbank); printf("%s
\n", nrl->genbank); } -if (differentWord(nrl->protAcc, "n/a")) +if (differentWord(nrl->protAcc, "")) { printf("Protein: "); printf("", nrl->protAcc); printf("%s
\n", nrl->protAcc); } -if (differentWord(nrl->hgnc, "n/a")) +if (differentWord(nrl->hgnc, "")) { printf("HGNC: "); printf("", nrl->hgnc); printf("%s
\n", nrl->hgnc); } -if (differentWord(nrl->locusLinkId, "n/a")) +if (differentWord(nrl->locusLinkId, "")) { printf("Entrez Gene: "); printf("", nrl->locusLinkId); printf("%s
\n", nrl->locusLinkId); } -if (differentWord(nrl->name,"n/a")) +if (differentWord(nrl->name,"")) { printGeneCards(nrl->name); if (startsWith("hg", database)) { printf("AceView: "); printf("", nrl->name); printf("%s
\n", nrl->name); } } if ((trackVersion != NULL) && !isEmpty(trackVersion->version)) { printf("Annotation Release: %s
", trackVersion->comment, trackVersion->version); } htmlHorizontalLine(); -if (differentWord("n/a", nrl->description)) +if (differentWord("", nrl->description)) { printf("Summary of %s
\n%s
\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("

mRNA/Genomic Alignments

"); printAlignments(pslList, start, "htcCdnaAli", "ncbiRefSeqPsl", itemName); } else { printf ("

there is NO alignment for %s


\n", itemName); } htmlHorizontalLine(); if (!sameString(tdb->track, "ncbiRefSeqPsl")) showGenePos(itemName, tdb); printf("

Links to sequence:

\n"); printf("