aboutsummaryrefslogtreecommitdiff
path: root/wqflask
diff options
context:
space:
mode:
authorzsloan2022-12-01 21:36:28 +0000
committerzsloan2022-12-01 21:36:28 +0000
commitf5988b60e9fc184fb3a7b1e9cdcfc3a85aafe82b (patch)
tree0aeb38745ac091851c36d06c2b3defda38c9bf54 /wqflask
parentfb0fffb7a3470c648cef8effeb1792e6ac3c7504 (diff)
downloadgenenetwork2-f5988b60e9fc184fb3a7b1e9cdcfc3a85aafe82b.tar.gz
Return Chr and Mb separately for phenotype /traits API request
Diffstat (limited to 'wqflask')
-rw-r--r--wqflask/wqflask/api/router.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/wqflask/wqflask/api/router.py b/wqflask/wqflask/api/router.py
index bae1d129..1e0c53a7 100644
--- a/wqflask/wqflask/api/router.py
+++ b/wqflask/wqflask/api/router.py
@@ -424,7 +424,7 @@ def fetch_traits(dataset_name, file_format="json"):
PublishXRef.`LRS`,
PublishXRef.`additive`,
PublishXRef.`Locus`,
- CONCAT('Chr', Geno.`Chr`, ': ', Geno.`Mb`)
+ Geno.`Chr`, Geno.`Mb`
FROM Species
INNER JOIN InbredSet ON InbredSet.`SpeciesId` = Species.`Id`
INNER JOIN PublishXRef ON PublishXRef.`InbredSetId` = InbredSet.`Id`
@@ -441,7 +441,7 @@ def fetch_traits(dataset_name, file_format="json"):
PublishXRef.Id"""
field_list = ["Id", "Authors", "Year", "PubMedID", "Mean",
- "LRS", "Additive", "Locus", "Position"]
+ "LRS", "Additive", "Locus", "Chr", "Mb"]
if 'limit_to' in request.args:
limit_number = request.args['limit_to']