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("\n");
-if (differentWord("n/a", nrl->protAcc))
+if (differentWord("", nrl->protAcc))
{
puts("- \n");
hgcAnchorSomewhere("htcTranslatedProtein", nrl->protAcc, "ncbiRefSeqPepTable", seqName);
printf("Predicted Protein \n");
puts("
\n");
}
puts("- \n");
hgcAnchorSomewhere("ncbiRefSeqSequence", itemName, "ncbiRefSeqPsl", seqName);
printf("%s may be different from the genomic sequence.\n",
"Predicted mRNA");
puts("
\n");
puts("- \n");
hgcAnchorSomewhere("getDna", itemName, tdb->track, seqName);
printf("Genomic Sequence from assembly\n");
puts("
\n");