diff options
| -rw-r--r-- | wqflask/wqflask/interval_analyst/GeneUtil.py | 12 |
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] |