diff options
author | zsloan | 2015-10-12 20:57:45 +0000 |
---|---|---|
committer | zsloan | 2015-10-12 20:57:45 +0000 |
commit | 0310301b30c59eca45235cd1bd1ff8e15923950a (patch) | |
tree | d143662ecceac5e05bd06afee4c87b2beb88859b /wqflask/base/mrna_assay_tissue_data.py | |
parent | e9727c576312c22e3fdc0a7ba153c414ad8e98da (diff) | |
download | genenetwork2-0310301b30c59eca45235cd1bd1ff8e15923950a.tar.gz |
Changed the location filter for correlation page
Diffstat (limited to 'wqflask/base/mrna_assay_tissue_data.py')
-rwxr-xr-x | wqflask/base/mrna_assay_tissue_data.py | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/wqflask/base/mrna_assay_tissue_data.py b/wqflask/base/mrna_assay_tissue_data.py index b2c0448a..54a7ce8e 100755 --- a/wqflask/base/mrna_assay_tissue_data.py +++ b/wqflask/base/mrna_assay_tissue_data.py @@ -40,7 +40,6 @@ class MrnaAssayTissueData(object): # with highest mean value # Due to the limit size of TissueProbeSetFreezeId table in DB, # performance of inner join is acceptable.MrnaAssayTissueData(gene_symbols=symbol_list) - #print("len(gene_symbols): ", len(gene_symbols)) if len(gene_symbols) == 0: query += '''Symbol!='' and Symbol Is Not Null group by Symbol) as x inner join TissueProbeSetXRef as t on t.Symbol = x.Symbol @@ -49,9 +48,11 @@ class MrnaAssayTissueData(object): else: in_clause = db_tools.create_in_clause(gene_symbols) + #ZS: This was in the query, not sure why: http://docs.python.org/2/library/string.html?highlight=lower#string.lower + query += ''' Symbol in {} group by Symbol) as x inner join TissueProbeSetXRef as t on t.Symbol = x.Symbol - and t.Mean = x.maxmean;http://docs.python.org/2/library/string.html?highlight=lower#string.lower + and t.Mean = x.maxmean; '''.format(in_clause) results = g.db.execute(query).fetchall() |