diff options
Diffstat (limited to 'gn3/db')
| -rw-r--r-- | gn3/db/traits.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gn3/db/traits.py b/gn3/db/traits.py index 85cccfa..f66ead3 100644 --- a/gn3/db/traits.py +++ b/gn3/db/traits.py @@ -7,7 +7,7 @@ from gn3.db.datasets import retrieve_trait_dataset def get_trait_csv_sample_data(conn: Any, trait_name: int, phenotype_id: int): """Fetch a trait and return it as a csv string""" - sql = ("SELECT Strain.Id, PublishData.Id, Strain.Name, " + sql = ("SELECT DISTINCT Strain.Id, PublishData.Id, Strain.Name, " "PublishData.value, " "PublishSE.error, NStrain.count FROM " "(PublishData, Strain, PublishXRef, PublishFreeze) " |