From: Diane Trout <diane@caltech.edu>
Date: Fri, 30 Sep 2011 23:13:22 +0000 (-0700)
Subject: Sparql query to back create protocol & treatment from submitted ddfs
X-Git-Tag: v0.5.5~83^2~9
X-Git-Url: http://woldlab.caltech.edu/gitweb/?p=htsworkflow.git;a=commitdiff_plain;h=1186e0b52c8001871bd189a393ab1aedc4915b47

Sparql query to back create protocol & treatment from submitted ddfs
(Use by looking at the database created by encode_find)
---

diff --git a/extra/ucsc_encode_submission/add-treatment-to-library.sparql b/extra/ucsc_encode_submission/add-treatment-to-library.sparql
new file mode 100755
index 0000000..c97dce2
--- /dev/null
+++ b/extra/ucsc_encode_submission/add-treatment-to-library.sparql
@@ -0,0 +1,19 @@
+# Produce list of submissions associated with a cell/replicate
+PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
+PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
+PREFIX ucscSubmission:<http://jumpgate.caltech.edu/wiki/UcscSubmissionOntology#>
+PREFIX libraryOntology:<http://jumpgate.caltech.edu/wiki/LibraryOntology#>
+PREFIX daf: <http://jumpgate.caltech.edu/wiki/UcscDaf#>
+PREFIX ddf: <http://encodesubmit.ucsc.edu/pipeline/download_ddf#>
+
+construct { ?library ddf:treatment ?treatment ;
+                     ddf:protocol ?pcr . }
+WHERE {
+   ?status ucscSubmission:has_file ?file .
+   ?submission ucscSubmission:has_status ?status ;
+               ucscSubmission:library_urn ?library ;
+               ucscSubmission:name ?name .
+   ?file ddf:treatment ?treatment ;
+         ddf:protocol ?pcr .
+}
+