diff options
| -rw-r--r-- | gn3/db/partial_correlations.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/gn3/db/partial_correlations.py b/gn3/db/partial_correlations.py index 9a4d814..8c4ec65 100644 --- a/gn3/db/partial_correlations.py +++ b/gn3/db/partial_correlations.py @@ -733,8 +733,8 @@ def set_homologene_id(conn, traits): "SELECT InbredSet.Name AS `group`, Homologene.GeneId AS geneid, " "HomologeneId " "FROM Homologene, Species, InbredSet " - "WHERE Homologene.GeneId = ({geneids}) " - "AND InbredSet.Name = ({groups}) " + "WHERE Homologene.GeneId IN ({geneids}) " + "AND InbredSet.Name IN ({groups}) " "AND InbredSet.SpeciesId = Species.Id " "AND Species.TaxonomyId = Homologene.TaxonomyId").format( geneids=", ".join(["%s"] * len(geneids)), |