Merge branch 'main' of github.com:genenetwork/genenetwork3 into heatmap_decompose_db_retrieval

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) "