aboutsummaryrefslogtreecommitdiff
path: root/wqflask
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2022-12-02 06:56:46 +0300
committerFrederick Muriuki Muriithi2022-12-02 06:56:46 +0300
commitc02d027dbd6476d375821e7dcbe3a719252ca092 (patch)
tree8c33abdfd475adabfc3f7cd5b18722f0ee1866a0 /wqflask
parent2bfbfd46a4490c32e5de483d0f10cd7db3b55f67 (diff)
downloadgenenetwork2-c02d027dbd6476d375821e7dcbe3a719252ca092.tar.gz
correlations: Fix description
* wqflask/wqflask/correlation/rust_correlation.py: Add `Probe_Target_Description` to the description field for "ProbeSet" traits.
Diffstat (limited to 'wqflask')
-rw-r--r--wqflask/wqflask/correlation/rust_correlation.py3
1 files changed, 2 insertions, 1 deletions
diff --git a/wqflask/wqflask/correlation/rust_correlation.py b/wqflask/wqflask/correlation/rust_correlation.py
index 81c2a416..f1294dfb 100644
--- a/wqflask/wqflask/correlation/rust_correlation.py
+++ b/wqflask/wqflask/correlation/rust_correlation.py
@@ -31,7 +31,8 @@ def query_probes_metadata(dataset, trait_list):
query = """
SELECT ProbeSet.Name,ProbeSet.Chr,ProbeSet.Mb,
- ProbeSet.Symbol,ProbeSetXRef.mean,ProbeSet.description,
+ ProbeSet.Symbol,ProbeSetXRef.mean,
+ CONCAT_WS('; ', ProbeSet.description, ProbeSet.Probe_Target_Description) AS description,
ProbeSetXRef.additive,ProbeSetXRef.LRS,Geno.Chr, Geno.Mb
FROM ProbeSet INNER JOIN ProbeSetXRef
ON ProbeSet.Id=ProbeSetXRef.ProbeSetId