12431b42d1616cb02adead491a305b8dc163ca71 kate Mon Mar 28 11:59:03 2016 -0700 Add support for filter on score. Show total median expression (from which score is computed) on details page. refs #15645 diff --git src/hg/inc/gtexGeneBed.h src/hg/inc/gtexGeneBed.h index c820b9c..fa2364e 100644 --- src/hg/inc/gtexGeneBed.h +++ src/hg/inc/gtexGeneBed.h @@ -11,31 +11,31 @@ extern char *gtexGeneBedCommaSepFieldNames; struct gtexGeneBed /* BED6+ with additional fields for gene and transcript IDs, and expression experiment scores */ { struct gtexGeneBed *next; /* Next in singly linked list. */ char *chrom; /* Reference sequence chromosome or scaffold */ unsigned chromStart; /* Start position in chromosome */ unsigned chromEnd; /* End position in chromosome */ char *name; /* Gene symbol */ unsigned score; /* Score from 0-1000 */ char strand[2]; /* + or - for strand */ char *geneId; /* Ensembl gene ID, referenced in GTEx data tables */ char *geneType; /* GENCODE gene biotype */ unsigned expCount; /* Number of experiment values */ - float *expScores; /* Comma separated list of experiment scores */ + float *expScores; /* Experiment scores */ }; struct gtexGeneBed *gtexGeneBedLoadByQuery(struct sqlConnection *conn, char *query); /* Load all gtexGeneBed from table that satisfy the query given. * Where query is of the form 'select * from example where something=something' * or 'select example.* from example, anotherTable where example.something = * anotherTable.something'. * Dispose of this with gtexGeneBedFreeList(). */ void gtexGeneBedSaveToDb(struct sqlConnection *conn, struct gtexGeneBed *el, char *tableName, int updateSize); /* Save gtexGeneBed as a row to the table specified by tableName. * As blob fields may be arbitrary size updateSize specifies the approx size * of a string that would contain the entire query. Arrays of native types are * converted to comma separated strings and loaded as such, User defined types are * inserted as NULL. This function automatically escapes quoted strings for mysql. */ @@ -80,17 +80,20 @@ /* -------------------------------- End autoSql Generated Code -------------------------------- */ void gtexGeneBedCreateTable(struct sqlConnection *conn, char *table); /* Create expression record format table of given name. */ char *gtexVersionSuffix(char *table); /* Return version string for a GTEx track table. For now, just supporting V4 (no suffix) and V6 */ char *gtexGeneClass(struct gtexGeneBed *geneBed); /* Return gene "class" (analogous to GENCODE transcriptClass) for a GENCODE gene biotype */ boolean gtexGeneIsCoding(struct gtexGeneBed *geneBed); /* Return TRUE if biotype indicates this is a protein coding gene */ +float gtexGeneTotalMedianExpression(struct gtexGeneBed *geneBed); +/* Return total of all tissue medians */ + #endif /* GTEXGENEBED_H */