From 515d1e627ea019153449c57c5e8963a2a6e0db53 Mon Sep 17 00:00:00 2001 From: Diane Trout Date: Fri, 11 May 2012 17:49:36 -0700 Subject: [PATCH] I found this version more useful for trying to answer Flo's questions about what we had submitted. --- encode_submission/find-lib-by-cell.sparql | 15 +++++++++------ 1 file changed, 9 insertions(+), 6 deletions(-) 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: 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 -- 2.30.2