Difference between revisions of "Manuscript Details"
From Knoesis wiki
Line 8: | Line 8: | ||
=== Query 2 === | === Query 2 === | ||
− | + | ==== SPARQL Query: ==== | |
− | + | <nowiki>PREFIX BASE: <http://knoesis.wright.edu/ParasiteExperiment.owl#> | |
− | + | PREFIX PATHWAY: <http://purl.org/obo/owlapi/pathway#> | |
+ | PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | ||
+ | PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | ||
+ | PREFIX so: <http://purl.org/obo/owl/sequence#> | ||
+ | PREFIX owl: <http://www.w3.org/2002/07/owl#> | ||
+ | PREFIX NCI: <http://ncicb.nci.nih.gov/xml/owl/EVS/Thesaurus.owl#> | ||
+ | |||
+ | SELECT ?gene ?microarray ?pathwaylabel ?logbasevalue ?entry ?pathway | ||
+ | FROM <http://knoesis.wright.edu/tcruzi4> | ||
+ | WHERE { GRAPH <http://knoesis.wright.edu/tcruzi4> | ||
+ | { | ||
+ | ?microarray BASE:has_output_value ?gene . | ||
+ | ?microarray BASE:has_output_value ?logbase . | ||
+ | ?microarray rdf:type NCI:Microarray_Analysis . | ||
+ | ?logbase rdf:type BASE:log_base2_ratio . | ||
+ | ?logbase BASE:has_value ?logbasevalue . | ||
+ | ?gene rdf:type so:gene . | ||
+ | ?entry owl:sameAs ?gene . | ||
+ | ?entry rdf:type so:gene . | ||
+ | ?entry BASE:involved_in ?pathway . | ||
+ | ?pathway rdf:type BASE:pathway . | ||
+ | ?pathway rdfs:label ?pathwaylabel | ||
+ | FILTER regex(?microarray , "epimastigote") . | ||
+ | FILTER (?logbasevalue < -1) . | ||
+ | { | ||
+ | SELECT ?gene count(?pathway) | ||
+ | FROM <http://knoesis.wright.edu/tcruzi4> | ||
+ | WHERE { GRAPH <http://knoesis.wright.edu/tcruzi4> | ||
+ | { | ||
+ | ?microarray BASE:has_output_value ?gene . | ||
+ | ?microarray rdf:type NCI:Microarray_Analysis . | ||
+ | ?gene rdf:type so:gene . | ||
+ | ?entry owl:sameAs ?gene . | ||
+ | ?entry rdf:type so:gene . | ||
+ | ?entry BASE:involved_in ?pathway . | ||
+ | ?pathway rdf:type BASE:pathway . | ||
+ | ?pathway rdfs:label ?pathwaylabel | ||
+ | FILTER regex(?microarray , "epimastigote") . | ||
+ | } | ||
+ | } | ||
+ | group by ?gene | ||
+ | having count(?pathway) = 1 | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | </nowiki> | ||
+ | |||
+ | ==== Cuebee Query ==== | ||
**[http://jade.cs.uga.edu:8080/download/query2.avi| Query 2 in Cuebee] | **[http://jade.cs.uga.edu:8080/download/query2.avi| Query 2 in Cuebee] | ||
Revision as of 14:15, 9 June 2011
Contents
[hide]Query 1
- SPARQL Query:
- Cuebee Query
Query 2
SPARQL Query:
PREFIX BASE: <http://knoesis.wright.edu/ParasiteExperiment.owl#> PREFIX PATHWAY: <http://purl.org/obo/owlapi/pathway#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX so: <http://purl.org/obo/owl/sequence#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX NCI: <http://ncicb.nci.nih.gov/xml/owl/EVS/Thesaurus.owl#> SELECT ?gene ?microarray ?pathwaylabel ?logbasevalue ?entry ?pathway FROM <http://knoesis.wright.edu/tcruzi4> WHERE { GRAPH <http://knoesis.wright.edu/tcruzi4> { ?microarray BASE:has_output_value ?gene . ?microarray BASE:has_output_value ?logbase . ?microarray rdf:type NCI:Microarray_Analysis . ?logbase rdf:type BASE:log_base2_ratio . ?logbase BASE:has_value ?logbasevalue . ?gene rdf:type so:gene . ?entry owl:sameAs ?gene . ?entry rdf:type so:gene . ?entry BASE:involved_in ?pathway . ?pathway rdf:type BASE:pathway . ?pathway rdfs:label ?pathwaylabel FILTER regex(?microarray , "epimastigote") . FILTER (?logbasevalue < -1) . { SELECT ?gene count(?pathway) FROM <http://knoesis.wright.edu/tcruzi4> WHERE { GRAPH <http://knoesis.wright.edu/tcruzi4> { ?microarray BASE:has_output_value ?gene . ?microarray rdf:type NCI:Microarray_Analysis . ?gene rdf:type so:gene . ?entry owl:sameAs ?gene . ?entry rdf:type so:gene . ?entry BASE:involved_in ?pathway . ?pathway rdf:type BASE:pathway . ?pathway rdfs:label ?pathwaylabel FILTER regex(?microarray , "epimastigote") . } } group by ?gene having count(?pathway) = 1 } } }
Cuebee Query
Query 3
- SPARQL Query:
- Cuebee Query