013ccd312d93bfb526241f9d81c4327a3b169b2e kate Tue Aug 9 14:52:59 2016 -0700 Extend gtexAse file format to include quartiles, donors. Add GTEx abbreviation to tissue table. Generalize the new hub as GTex analysis. diff --git src/hg/inc/gtexAse.h src/hg/inc/gtexAse.h index 0d8031c..b4fa94e 100644 --- src/hg/inc/gtexAse.h +++ src/hg/inc/gtexAse.h @@ -1,43 +1,49 @@ /* gtexAse.h was originally generated by the autoSql program, which also * generated gtexAse.c and gtexAse.sql. This header links the database and * the RAM representation of objects. */ #ifndef GTEXASE_H #define GTEXASE_H #include "jksql.h" -#define GTEXASE_NUM_COLS 12 +#define GTEXASE_NUM_COLS 18 extern char *gtexAseCommaSepFieldNames; struct gtexAse /* BED9+ with additional fields for ASE, coverage, and sample count */ { struct gtexAse *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; /* SNP Id */ unsigned score; /* Score from 0-1000; derived from median ASE level */ char strand[2]; /* n/a */ unsigned thickStart; /* n/a */ unsigned thickEnd; /* n/a */ - unsigned rgb; /* Color by ASE value */ - float ASE; /* Allelic imbalance (0-.5) */ + unsigned itemRgb; /* Color by binned ASE value (none, moderate, strong) */ + float medianASE; /* Allelic imbalance (0-.5) median */ float coverage; /* RNA-seq reads overlapping this position */ unsigned samples; /* Sample count */ + unsigned donors; /* Donor count */ + float minASE; /* Minimum ASE */ + float q1ASE; /* Q1 ASE */ + float q3ASE; /* Q3 ASE */ + float maxASE; /* Maximum ASE */ + float stdASE; /* ASE standard deviation */ }; void gtexAseStaticLoad(char **row, struct gtexAse *ret); /* Load a row from gtexAse table into ret. The contents of ret will * be replaced at the next call to this function. */ struct gtexAse *gtexAseLoadByQuery(struct sqlConnection *conn, char *query); /* Load all gtexAse 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 gtexAseFreeList(). */ void gtexAseSaveToDb(struct sqlConnection *conn, struct gtexAse *el, char *tableName, int updateSize); /* Save gtexAse as a row to the table specified by tableName.