about summary refs log tree commit diff
path: root/examples/phenotype-datasets.scm
diff options
context:
space:
mode:
Diffstat (limited to 'examples/phenotype-datasets.scm')
-rwxr-xr-xexamples/phenotype-datasets.scm4
1 files changed, 2 insertions, 2 deletions
diff --git a/examples/phenotype-datasets.scm b/examples/phenotype-datasets.scm
index c8657fc..c005621 100755
--- a/examples/phenotype-datasets.scm
+++ b/examples/phenotype-datasets.scm
@@ -18,7 +18,7 @@
   (tables (Species
            (inner-join InbredSet "ON InbredSet.SpeciesId = Species.Id")
            (inner-join PublishFreeze "ON PublishFreeze.InbredSetId = InbredSet.Id"))
-          "WHERE PublishFreeze.public > 0 AND Species.Name != 'monkey' GROUP BY Species.Name, PublishFreeze.ShortName")
+          "WHERE PublishFreeze.public > 0 AND PublishFreeze.confidentiality < 1 AND Species.Name != 'monkey' GROUP BY Species.Name, PublishFreeze.ShortName")
   (triples (string->identifier "set" (field InbredSet Name InbredSetName) #:separator "_")
     (multiset gnt:has_phenotype_data
               (map (cut string->identifier "dataset" <> #:separator "_")
@@ -34,7 +34,7 @@
            (inner-join PublishFreeze "ON PublishFreeze.InbredSetId = InbredSet.Id")
            (inner-join Publication "ON Publication.Id = PublishXRef.PublicationId")
            (inner-join Phenotype "ON Phenotype.Id = PublishXRef.PhenotypeId"))
-          "WHERE InbredSet.public > 0")
+          "WHERE InbredSet.public > 0 AND PublishFreeze.public > 0 AND PublishFreeze.confidentiality < 1")
   (triples (string->identifier "dataset" (field PublishFreeze Name) #:separator "_")
     (set gnt:has_phenotype_trait
          (let ((post-abbrev (blank-p (field Phenotype Post_publication_abbreviation)))