sparql-examples

A set of SPARQL examples that are used in different SIB resources

View the Project on GitHub sib-swiss/sparql-examples

005

What are the anatomical entities where the APOC1 gene is expressed independently of the developmental stage, sex, strain and cell type?

Use at

PREFIX efo: <http://www.ebi.ac.uk/efo/>
PREFIX genex: <http://purl.org/genex#>
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX orth: <http://purl.org/net/orth#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?anat ?anatName {
    ?seq a orth:Gene ;
        genex:isExpressedIn ?condition ;
        rdfs:label "APOC1" .
    ?condition a genex:ExpressionCondition ;
        genex:hasAnatomicalEntity ?anat ;
        genex:hasAnatomicalEntity obo:GO_0005575 ;
        genex:hasDevelopmentalStage ?stage ;
        genex:hasSex "any" ;
        genex:hasStrain ?strain .
    ?anat a genex:AnatomicalEntity ;
        rdfs:label ?anatName .
    ?stage a efo:EFO_0000399 ;
        rdfs:label "life cycle" .
    ?strain rdfs:label "wild-type" .
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v3("?anat"):::projected 
  v6("?anatName"):::projected 
  v2("?condition")
  v1("?seq")
  v4("?stage")
  v5("?strain")
  c14(["efo:EFO_0000399"]):::iri 
  c15(["life cycle"]):::literal 
  c6(["genex:ExpressionCondition"]):::iri 
  c8(["obo:GO_0005575"]):::iri 
  c2(["orth:Gene"]):::iri 
  c11(["any"]):::literal 
  c13(["genex:AnatomicalEntity"]):::iri 
  c5(["APOC1"]):::literal 
  c16(["wild-type"]):::literal 
  v1 --"a"-->  c2
  v1 --"genex:isExpressedIn"-->  v2
  v1 --"rdfs:label"-->  c5
  v2 --"a"-->  c6
  v2 --"genex:hasAnatomicalEntity"-->  v3
  v2 --"genex:hasAnatomicalEntity"-->  c8
  v2 --"genex:hasDevelopmentalStage"-->  v4
  v2 --"genex:hasSex"-->  c11
  v2 --"genex:hasStrain"-->  v5
  v3 --"a"-->  c13
  v3 --"rdfs:label"-->  v6
  v4 --"a"-->  c14
  v4 --"rdfs:label"-->  c15
  v5 --"rdfs:label"-->  c16