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#>
7 SELECT distinct ?liburn ?cell ?replicate ?subid ?name ?submission_date
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))
20 ORDER BY ?cell ?replicate ?liburn ?submission_date