aboutsummaryrefslogtreecommitdiff
path: root/gn3/db/traits.py
diff options
context:
space:
mode:
Diffstat (limited to 'gn3/db/traits.py')
-rw-r--r--gn3/db/traits.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/gn3/db/traits.py b/gn3/db/traits.py
index f686097..04b2a70 100644
--- a/gn3/db/traits.py
+++ b/gn3/db/traits.py
@@ -84,7 +84,7 @@ def get_trait_csv_sample_data(conn: Any,
"""Fetch a trait and return it as a csv string"""
__query = ("SELECT concat(st.Name, ',', ifnull(pd.value, 'x'), ',', "
"ifnull(ps.error, 'x'), ',', ifnull(ns.count, 'x')) as 'Data' "
- "ifnull(ca.Name, 'x') as 'CaseAttr', "
+ ",ifnull(ca.Name, 'x') as 'CaseAttr', "
"ifnull(cxref.value, 'x') as 'Value' "
"FROM PublishFreeze pf "
"JOIN PublishXRef px ON px.InbredSetId = pf.InbredSetId "
@@ -97,7 +97,7 @@ def get_trait_csv_sample_data(conn: Any,
"LEFT JOIN CaseAttributeXRefNew cxref ON "
"(cxref.InbredSetId = px.InbredSetId AND "
"cxref.StrainId = st.Id) "
- "LEFT JOIN CaseAttribute ca ON ca.Id = cxref.CaseAttributeId"
+ "LEFT JOIN CaseAttribute ca ON ca.Id = cxref.CaseAttributeId "
"WHERE px.Id = %s AND px.PhenotypeId = %s ORDER BY st.Name")
case_attr_columns = set()
csv_data = {}