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 ucscSubmission:name ?name ;
  10            ucscSubmission:library_urn ?liburn ;
  11            libraryOntology:date ?submission_date.
  12     ?liburn libraryOntology:cell_line ?cell ;
  13             libraryOntology:replicate ?replicate ;
  14             libraryOntology:species_name ?species .
  15     OPTIONAL { ?liburn libraryOntology:treatement ?treatment . }
  16     FILTER(regex(?species, "Homo sapiens", "i"))
  17     #filter(?submission_date > "2011-04-01T00:00:00Z"^^xsd:dateTime)
  18     #filter(!bound(?liburn))
  19 }
  20 ORDER BY ?cell ?replicate ?liburn ?submission_date