diff options
| author | zsloan | 2022-12-01 21:36:28 +0000 |
|---|---|---|
| committer | zsloan | 2022-12-01 21:36:28 +0000 |
| commit | f5988b60e9fc184fb3a7b1e9cdcfc3a85aafe82b (patch) | |
| tree | 0aeb38745ac091851c36d06c2b3defda38c9bf54 | |
| parent | fb0fffb7a3470c648cef8effeb1792e6ac3c7504 (diff) | |
| download | genenetwork2-f5988b60e9fc184fb3a7b1e9cdcfc3a85aafe82b.tar.gz | |
Return Chr and Mb separately for phenotype /traits API request
| -rw-r--r-- | wqflask/wqflask/api/router.py | 4 |
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'] |