find submissions, even those without a set creation date

[htsworkflow.git] / extra / ucsc_encode_submission / find-lib-by-cell.sparql

diff --git a/extra/ucsc_encode_submission/find-lib-by-cell.sparql b/extra/ucsc_encode_submission/find-lib-by-cell.sparql
old mode 100644 (file)
new mode 100755 (executable)
index 3e149f4..c4585c5
--- a/extra/ucsc_encode_submission/find-lib-by-cell.sparql
+++ b/extra/ucsc_encode_submission/find-lib-by-cell.sparql
@@ -6,11 +6,12 @@ PREFIX libraryOntology:<http://jumpgate.caltech.edu/wiki/LibraryOntology#>
 
 SELECT distinct ?liburn ?cell ?replicate ?subid ?name ?submission_date
 WHERE {
-    ?subid libraryOntology:date ?submission_date ;
-           ucscSubmission:name ?name .
-    OPTIONAL { ?subid ucscSubmission:library_urn ?liburn . 
+    ?subid ucscSubmission:name ?name .
+    OPTIONAL { ?subid ucscSubmission:library_urn ?liburn ;
+                       libraryOntology:date ?submission_date .
                ?liburn libraryOntology:cell_line ?cell ;
                        libraryOntology:replicate ?replicate . }
     #filter(?submission_date > "2011-04-01T00:00:00Z"^^xsd:dateTime)
+    #filter(!bound(?liburn))
 }
 ORDER BY ?submission_date ?cell ?replicate ?liburn