sparql-examples

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

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

5

Find all properties of the orthologous group 6400at314295 by its URI

Use at

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX up: <http://purl.uniprot.org/core/>
PREFIX odbgroup: <http://purl.orthodb.org/odbgroup/>
PREFIX : <http://purl.orthodb.org/>

SELECT *
WHERE {
    ?og a :OrthoGroup;
        rdfs:label ?label;
        :name ?description;
        :ogBuiltAt [up:scientificName ?clade];
        :ogEvolRate ?evolRate;
        :ogPercentSingleCopy ?percentSingleCopy;
        :ogPercentInSpecies ?percentInSpecies;
        :ogTotalGenesCount ?totalGenesCount;
        :ogMultiCopyGenesCount ?multiCopyGenesCount;
        :ogSingleCopyGenesCount ?singleCopyGenesCount;
        :ogInSpeciesCount ?inSpeciesCount;
        :cladeTotalSpeciesCount ?cladeTotalSpeciesCount .
    OPTIONAL { ?og :ogMedianProteinLength ?medianProteinLength}
    OPTIONAL { ?og :ogStddevProteinLength ?stddevProteinLength}
    OPTIONAL { ?og :ogMedianExonsCount ?medianExonsCount}
    OPTIONAL { ?og :ogStddevExonsCount ?stddevExonsCount}
    FILTER(?og = odbgroup:6400at314295)
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?clade"):::projected 
  v12("?cladeTotalSpeciesCount"):::projected 
  v3("?description"):::projected 
  v5("?evolRate"):::projected 
  v11("?inSpeciesCount"):::projected 
  v2("?label"):::projected 
  v15("?medianExonsCount"):::projected 
  v13("?medianProteinLength"):::projected 
  v9("?multiCopyGenesCount"):::projected 
  v1("?og"):::projected 
  v7("?percentInSpecies"):::projected 
  v6("?percentSingleCopy"):::projected 
  v10("?singleCopyGenesCount"):::projected 
  v16("?stddevExonsCount"):::projected 
  v14("?stddevProteinLength"):::projected 
  v8("?totalGenesCount"):::projected 
  a1((" "))
  c3([":OrthoGroup"]):::iri 
  f0[["?og = ':odbgroup/6400at314295'"]]
  f0 --> v1
  v1 --"a"-->  c3
  v1 --"rdfs:label"-->  v2
  v1 --":name"-->  v3
  a1 --"up:scientificName"-->  v4
  v1 --":ogBuiltAt"-->  a1
  v1 --":ogEvolRate"-->  v5
  v1 --":ogPercentSingleCopy"-->  v6
  v1 --":ogPercentInSpecies"-->  v7
  v1 --":ogTotalGenesCount"-->  v8
  v1 --":ogMultiCopyGenesCount"-->  v9
  v1 --":ogSingleCopyGenesCount"-->  v10
  v1 --":ogInSpeciesCount"-->  v11
  v1 --":cladeTotalSpeciesCount"-->  v12
  subgraph optional0["(optional)"]
  style optional0 fill:#bbf,stroke-dasharray: 5 5;
    v1 -.":ogMedianProteinLength".->  v13
  end
  subgraph optional1["(optional)"]
  style optional1 fill:#bbf,stroke-dasharray: 5 5;
    v1 -.":ogStddevProteinLength".->  v14
  end
  subgraph optional2["(optional)"]
  style optional2 fill:#bbf,stroke-dasharray: 5 5;
    v1 -.":ogMedianExonsCount".->  v15
  end
  subgraph optional3["(optional)"]
  style optional3 fill:#bbf,stroke-dasharray: 5 5;
    v1 -.":ogStddevExonsCount".->  v16
  end