743f1e268d2f3f658a48309a72227ce9fce85c97 angie Fri Apr 3 16:43:57 2015 -0700 Added a special annoStreamer for knownGene, to tack on kgXref.geneSymbol at the end. Now in hgVai, the geneSymbol is shown instead of the protein ID. The new column is also available in hgIntegrator. Now users can get the gene symbol that goes with their items, without changing gene track. refs #11752 #14579 diff --git src/hg/inc/annoStreamDbKnownGene.h src/hg/inc/annoStreamDbKnownGene.h new file mode 100644 index 0000000..737d1a2 --- /dev/null +++ src/hg/inc/annoStreamDbKnownGene.h @@ -0,0 +1,21 @@ +/* annoStreamDbKnownGene -- subclass of annoStreamer for adding gene symbol to knownGene table */ + +#ifndef ANNOSTREAMDBKNOWNGENE_H +#define ANNOSTREAMDBKNOWNGENE_H + +#include "annoStreamer.h" + +struct asObject *annoStreamDbKnownGeneAsObj(); +/* Return an autoSql object that describs fields of a joining query on knownGene and + * kgXref.geneSymbol. */ + +struct annoStreamer *annoStreamDbKnownGeneNew(char *db, struct annoAssembly *aa, int maxOutRows); +/* Create an annoStreamer (subclass) object using two database tables: + * knownGene: the UCSC Genes main track table + * kgXref: the related table that contains the HGNC gene symbol that everyone wants to see + * This streamer's rows are just like a plain annoStreamDb on knownGene, but with an + * extra column at the end, 'name2', which is recognized as a gene symbol column due to + * its use in refGene. + */ + +#endif//ndef ANNOSTREAMDBKNOWNGENE_H