aboutsummaryrefslogtreecommitdiff
path: root/gn2/base/data_set
diff options
context:
space:
mode:
authorzsloan2024-08-30 22:12:20 +0000
committerzsloan2024-08-30 22:12:59 +0000
commit7c2d18143f608b98be577e41257db8954a0c3c7f (patch)
tree4556cb28208b64a8416880f1c57c701becc4d212 /gn2/base/data_set
parent39cb5deed5f33122ea2cc8502945f171367db5df (diff)
downloadgenenetwork2-7c2d18143f608b98be577e41257db8954a0c3c7f.tar.gz
Fix bug that caused genotype trait case attributes to be offset by 1
Diffstat (limited to 'gn2/base/data_set')
-rw-r--r--gn2/base/data_set/genotypedataset.py10
1 files changed, 5 insertions, 5 deletions
diff --git a/gn2/base/data_set/genotypedataset.py b/gn2/base/data_set/genotypedataset.py
index 77af1dad..a5b65772 100644
--- a/gn2/base/data_set/genotypedataset.py
+++ b/gn2/base/data_set/genotypedataset.py
@@ -50,7 +50,7 @@ GenoFreeze.Name = %s"""
with database_connection(get_setting("SQL_URI")) as conn, conn.cursor() as cursor:
cursor.execute(
"SELECT Strain.Name, GenoData.value, "
- "GenoSE.error, 'N/A', Strain.Name2 "
+ "GenoSE.error, NULL, Strain.Name2 "
"FROM (GenoData, GenoFreeze, Strain, Geno, "
"GenoXRef) LEFT JOIN GenoSE ON "
"(GenoSE.DataId = GenoData.Id AND "
@@ -68,9 +68,9 @@ GenoFreeze.Name = %s"""
if self.group.name in webqtlUtil.ParInfo:
f1_1, f1_2, ref, nonref = webqtlUtil.ParInfo[self.group.name]
- results.append([f1_1, 0, None, "N/A", f1_1])
- results.append([f1_2, 0, None, "N/A", f1_2])
- results.append([ref, -1, None, "N/A", ref])
- results.append([nonref, 1, None, "N/A", nonref])
+ results.append([f1_1, 0, None, None, f1_1])
+ results.append([f1_2, 0, None, None, f1_2])
+ results.append([ref, -1, None, None, ref])
+ results.append([nonref, 1, None, None, nonref])
return results