How to find all pathways in specific tissue

[heydar ghiasi]

Hi,

How can I find all pathways reported for one organ? For example, I want to extract all reported pathways in the ovary for cows.

Regards

Heydar

--

 

Heydar Ghiasi

PhD, Genetics and Animal Breeding

Payame Noor University , Qazvin, Iran
 

[Delia Moreno]

Hello, I honestly don't know if it can be extracted from an organ, what I did was put it so that it had the name of the organ and the organism.

PREFIX wp: <http://vocabularies.wikipathways.org/wp#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX oboInOwl: <http://www.geneontology.org/formats/oboInOwl#>

SELECT DISTINCT ?pathway ?ID ?title  ?organismName
WHERE {
   ?pathway a wp:Pathway ;
     
      dcterms:identifier ?ID;
      dc:title ?title ;
      wp:organismName ?organismName;
      wp:ontologyTag ?disease .
    ?disease oboInOwl:hasDbXref ?xref_lang ;
            rdfs:label ?label_lang .
   
   ?interaction dcterms:isPartOf ?pathway ;
      a wp:Interaction ;
      rdf:type ?Tipo;
      wp:participants ?participants ;
      rdf:type ?interactionType .  
   ?participants a wp:DataNode ;
      rdfs:label ?DataNodeLabel .
   OPTIONAL {
      ?interaction wp:source ?source ;
                   wp:target ?target .
      ?source rdfs:label ?sourceLabel .
      OPTIONAL {
         ?source wp:bdbEnsembl ?sourceEnsembl .
      }
      ?target rdfs:label ?targetLabel .
      OPTIONAL {
         ?target wp:bdbEnsembl ?targetEnsembl .
      }
   }
   FILTER(REGEX(?organismName, "Bos taurus", "i"))
   FILTER(REGEX(?title, "ovarian", "i"))