From 1186e0b52c8001871bd189a393ab1aedc4915b47 Mon Sep 17 00:00:00 2001
From: Diane Trout <diane@caltech.edu>
Date: Fri, 30 Sep 2011 16:13:22 -0700
Subject: [PATCH] Sparql query to back create protocol & treatment from
 submitted ddfs (Use by looking at the database created by encode_find)

---
 .../add-treatment-to-library.sparql           | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100755 extra/ucsc_encode_submission/add-treatment-to-library.sparql

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 .
+}
+
-- 
2.30.2