From: Diane Trout <diane@caltech.edu>
Date: Sat, 12 May 2012 00:49:36 +0000 (-0700)
Subject: I found this version more useful for trying to
X-Git-Tag: v0.5.5~29
X-Git-Url: http://woldlab.caltech.edu/gitweb/?p=htsworkflow.git;a=commitdiff_plain;h=515d1e627ea019153449c57c5e8963a2a6e0db53

I found this version more useful for trying to
answer Flo's questions about what we had submitted.
---

diff --git a/encode_submission/find-lib-by-cell.sparql b/encode_submission/find-lib-by-cell.sparql
index c4585c5..eac66c1 100644
--- a/encode_submission/find-lib-by-cell.sparql
+++ b/encode_submission/find-lib-by-cell.sparql
@@ -6,12 +6,15 @@ PREFIX libraryOntology:<http://jumpgate.caltech.edu/wiki/LibraryOntology#>
 
 SELECT distinct ?liburn ?cell ?replicate ?subid ?name ?submission_date
 WHERE {
-    ?subid ucscSubmission:name ?name .
-    OPTIONAL { ?subid ucscSubmission:library_urn ?liburn ;
-                       libraryOntology:date ?submission_date .
-               ?liburn libraryOntology:cell_line ?cell ;
-                       libraryOntology:replicate ?replicate . }
+    ?subid ucscSubmission:name ?name ;
+           ucscSubmission:library_urn ?liburn ;
+           libraryOntology:date ?submission_date.
+    ?liburn libraryOntology:cell_line ?cell ;
+            libraryOntology:replicate ?replicate ;
+            libraryOntology:species ?species .
+    OPTIONAL { ?liburn libraryOntology:treatement ?treatment . }
+    FILTER(regex(?species, "Homo sapiens", "i"))
     #filter(?submission_date > "2011-04-01T00:00:00Z"^^xsd:dateTime)
     #filter(!bound(?liburn))
 }
-ORDER BY ?submission_date ?cell ?replicate ?liburn
+ORDER BY  ?liburn ?submission_date
\ No newline at end of file