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
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