Difference between revisions of "Manuscript Details"

From Knoesis wiki
Jump to: navigation, search
Line 8: Line 8:
  
 
=== Query 2 ===
 
=== Query 2 ===
* SPARQL Query:
+
==== SPARQL Query: ====
**
+
<nowiki>PREFIX BASE: <http://knoesis.wright.edu/ParasiteExperiment.owl#>
*Cuebee Query
+
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


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