diff options
| author | Frederick Muriuki Muriithi | 2025-03-17 13:49:35 -0500 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2025-03-17 13:49:35 -0500 |
| commit | a4b32dee1b1b638ab60c56df27ace221d6a77c3a (patch) | |
| tree | 5e76c34c41977367c5ffaa8c6b3896458cf130a0 /uploader/phenotypes/models.py | |
| parent | 4cabd6b7e29153789ecf90898ce08ed2148bf632 (diff) | |
| download | gn-uploader-a4b32dee1b1b638ab60c56df27ace221d6a77c3a.tar.gz | |
Include InbredSetId: Useful for querying data.
Diffstat (limited to 'uploader/phenotypes/models.py')
| -rw-r--r-- | uploader/phenotypes/models.py | 2 |
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 " |