From cd08e12d586f21053afdcd3517c2bf3e698fc1cc Mon Sep 17 00:00:00 2001 From: zsloan Date: Wed, 11 Dec 2019 11:00:14 -0600 Subject: Missed a couple more places where I needed to account for letter chromosomes --- wqflask/wqflask/do_search.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wqflask/wqflask/do_search.py b/wqflask/wqflask/do_search.py index 42aca2cb..1fafd181 100644 --- a/wqflask/wqflask/do_search.py +++ b/wqflask/wqflask/do_search.py @@ -634,7 +634,7 @@ class CisTransLrsSearch(DoSearch): ) else: if chromosome: - location_clause = "(%s.Chr = %s and %s.Chr = Geno.Chr and ABS(%s.Mb-Geno.Mb) %s %s) or (%s.Chr != Geno.Chr and Geno.Chr = %s)" % (escape(self.dataset.type), + location_clause = "(%s.Chr = '%s' and %s.Chr = Geno.Chr and ABS(%s.Mb-Geno.Mb) %s %s) or (%s.Chr != Geno.Chr and Geno.Chr = '%s')" % (escape(self.dataset.type), chromosome, escape(self.dataset.type), escape(self.dataset.type), -- cgit v1.2.3