diff options
| author | Frederick Muriuki Muriithi | 2022-12-02 06:56:46 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2022-12-02 06:56:46 +0300 |
| commit | c02d027dbd6476d375821e7dcbe3a719252ca092 (patch) | |
| tree | 8c33abdfd475adabfc3f7cd5b18722f0ee1866a0 | |
| parent | 2bfbfd46a4490c32e5de483d0f10cd7db3b55f67 (diff) | |
| download | genenetwork2-c02d027dbd6476d375821e7dcbe3a719252ca092.tar.gz | |
correlations: Fix description
* wqflask/wqflask/correlation/rust_correlation.py: Add
`Probe_Target_Description` to the description field for "ProbeSet"
traits.
| -rw-r--r-- | wqflask/wqflask/correlation/rust_correlation.py | 3 |
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 |