diff options
author | pjotrp | 2015-11-18 11:19:01 +0100 |
---|---|---|
committer | pjotrp | 2015-11-18 11:19:01 +0100 |
commit | cb0f10fc4850b6b06f2237b532317a5c6668584a (patch) | |
tree | d143662ecceac5e05bd06afee4c87b2beb88859b /wqflask/base/mrna_assay_tissue_data.py | |
parent | 28ec342362ba068b3d0b5b9a302bc279d251f160 (diff) | |
parent | 0310301b30c59eca45235cd1bd1ff8e15923950a (diff) | |
download | genenetwork2-cb0f10fc4850b6b06f2237b532317a5c6668584a.tar.gz |
Merge branch 'master' of https://github.com/zsloan/genenetwork2 into zsloan
Diffstat (limited to 'wqflask/base/mrna_assay_tissue_data.py')
-rwxr-xr-x | wqflask/base/mrna_assay_tissue_data.py | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/wqflask/base/mrna_assay_tissue_data.py b/wqflask/base/mrna_assay_tissue_data.py index 1a05fce7..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,6 +48,8 @@ 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; @@ -58,8 +59,8 @@ class MrnaAssayTissueData(object): for result in results: symbol = result[0] - if symbol in gene_symbols: - #gene_symbols.append(symbol) + if symbol.lower() in [gene_symbol.lower() for gene_symbol in gene_symbols]: + #gene_symbols.append(symbol) symbol = symbol.lower() self.data[symbol].gene_id = result.GeneId |