extra/ucsc_encode_submission/find-lib-by-cell.sparql

   1 # Produce list of submissions associated with a cell/replicate
   2 PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
   3 PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
   4 PREFIX ucscSubmission:<http://jumpgate.caltech.edu/wiki/UcscSubmissionOntology#>
   5 PREFIX libraryOntology:<http://jumpgate.caltech.edu/wiki/LibraryOntology#>
   6
   7 SELECT distinct ?liburn ?cell ?replicate ?subid ?name ?submission_date
   8 WHERE {
   9     ?subid libraryOntology:date ?submission_date ;
  10            ucscSubmission:name ?name .
  11     OPTIONAL { ?subid ucscSubmission:library_urn ?liburn .
  12                ?liburn libraryOntology:cell_line ?cell ;
  13                        libraryOntology:replicate ?replicate . }
  14     #filter(?submission_date > "2011-04-01T00:00:00Z"^^xsd:dateTime)
  15 }
  16 ORDER BY ?submission_date ?cell ?replicate ?liburn