aboutsummaryrefslogtreecommitdiff
path: root/uploader/phenotypes/models.py
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2025-03-17 13:49:35 -0500
committerFrederick Muriuki Muriithi2025-03-17 13:49:35 -0500
commita4b32dee1b1b638ab60c56df27ace221d6a77c3a (patch)
tree5e76c34c41977367c5ffaa8c6b3896458cf130a0 /uploader/phenotypes/models.py
parent4cabd6b7e29153789ecf90898ce08ed2148bf632 (diff)
downloadgn-uploader-a4b32dee1b1b638ab60c56df27ace221d6a77c3a.tar.gz
Include InbredSetId: Useful for querying data.
Diffstat (limited to 'uploader/phenotypes/models.py')
-rw-r--r--uploader/phenotypes/models.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/uploader/phenotypes/models.py b/uploader/phenotypes/models.py
index e1ec0c9..98278e5 100644
--- a/uploader/phenotypes/models.py
+++ b/uploader/phenotypes/models.py
@@ -75,7 +75,7 @@ def dataset_phenotypes(conn: mdb.Connection,
limit: Optional[int] = None) -> tuple[dict, ...]:
"""Fetch the actual phenotypes."""
_query = (
- "SELECT pheno.*, pxr.Id AS xref_id, ist.InbredSetCode FROM Phenotype AS pheno "
+ "SELECT pheno.*, pxr.Id AS xref_id, pxr.InbredSetId, ist.InbredSetCode FROM Phenotype AS pheno "
"INNER JOIN PublishXRef AS pxr ON pheno.Id=pxr.PhenotypeId "
"INNER JOIN PublishFreeze AS pf ON pxr.InbredSetId=pf.InbredSetId "
"INNER JOIN InbredSet AS ist ON pf.InbredSetId=ist.Id "