about summary refs log tree commit diff
diff options
context:
space:
mode:
-rw-r--r--wqflask/wqflask/interval_analyst/GeneUtil.py12
1 files changed, 6 insertions, 6 deletions
diff --git a/wqflask/wqflask/interval_analyst/GeneUtil.py b/wqflask/wqflask/interval_analyst/GeneUtil.py
index 9e56f66b..780a4db1 100644
--- a/wqflask/wqflask/interval_analyst/GeneUtil.py
+++ b/wqflask/wqflask/interval_analyst/GeneUtil.py
@@ -82,12 +82,12 @@ def loadGenes(chrName, diffCol, startMb, endMb, species='mouse'):
                         if diffCol and othSpec == 'mouse':
                             cursor.execute(
                                 "SELECT count(*) FROM BXDSnpPosition "
-                                "WHERE Chr = %s AND Mb >= %2.6f AND "
-                                "Mb < %2.6f AND StrainId1 = %d "
-                                "AND StrainId2 = %d",
-                            (chrName, f"{newdict['TxStart']:2.6f}",
-                             f"{newdict['TxEnd']:2.6f}",
-                             diffCol[0], diffCol[1]))
+                                "WHERE Chr = %s AND Mb >= %s AND "
+                                "Mb < %s AND StrainId1 = %s "
+                                "AND StrainId2 = %s",
+                                (chrName, f"{newdict['TxStart']:2.6f}",
+                                 f"{newdict['TxEnd']:2.6f}",
+                                 diffCol[0], diffCol[1]))
                             if snp_count := cursor.fetchone():
                                 newdict2["snpCount"] = snp_count[0]