aboutsummaryrefslogtreecommitdiff
path: root/wqflask/base/trait.py
diff options
context:
space:
mode:
authorzsloan2020-04-06 17:41:19 -0500
committerGN22020-04-06 17:41:58 -0500
commitdce4f524ae9640553eb8aa319ed593de9d603231 (patch)
tree3bfbcbd862fa8c935ded7bab0399e4beec795f4e /wqflask/base/trait.py
parent05c172a8330f28c9c81300448d9f2630a6d7ff0f (diff)
downloadgenenetwork2-dce4f524ae9640553eb8aa319ed593de9d603231.tar.gz
Added Mean column for phenotype traits in search and global search result tables
Diffstat (limited to 'wqflask/base/trait.py')
-rw-r--r--wqflask/base/trait.py5
1 files changed, 3 insertions, 2 deletions
diff --git a/wqflask/base/trait.py b/wqflask/base/trait.py
index 8e779a11..5525472e 100644
--- a/wqflask/base/trait.py
+++ b/wqflask/base/trait.py
@@ -354,7 +354,7 @@ def retrieve_trait_info(trait, dataset, get_qtl_info=False):
SELECT
PublishXRef.Id, InbredSet.InbredSetCode, Publication.PubMed_ID,
Phenotype.Pre_publication_description, Phenotype.Post_publication_description, Phenotype.Original_description,
- Phenotype.Pre_publication_abbreviation, Phenotype.Post_publication_abbreviation,
+ Phenotype.Pre_publication_abbreviation, Phenotype.Post_publication_abbreviation, PublishXRef.mean,
Phenotype.Lab_code, Phenotype.Submitter, Phenotype.Owner, Phenotype.Authorized_Users,
Publication.Authors, Publication.Title, Publication.Abstract,
Publication.Journal, Publication.Volume, Publication.Pages,
@@ -503,8 +503,9 @@ def retrieve_trait_info(trait, dataset, get_qtl_info=False):
#LRS and its location
trait.LRS_score_repr = "N/A"
trait.LRS_location_repr = "N/A"
- trait.locus = trait.locus_chr = trait.locus_mb = trait.lrs = trait.pvalue = trait.mean = trait.additive = ""
+ trait.locus = trait.locus_chr = trait.locus_mb = trait.lrs = trait.pvalue = trait.additive = ""
if dataset.type == 'ProbeSet' and not trait.cellid:
+ trait.mean = ""
query = """
SELECT
ProbeSetXRef.Locus, ProbeSetXRef.LRS, ProbeSetXRef.pValue, ProbeSetXRef.mean, ProbeSetXRef.additive