SPARQL example query

◀ ▶

104_uniprot_recomended_protein_full_name: The recommended protein full names for UniProtKB entries

 
1
PREFIX up: <http://purl.uniprot.org/core/>
2
SELECT ?protein
3
  ?fullName
4
WHERE {
5
  ?protein a up:Protein ;
6
           up:recommendedName ?recommendedName .
7
  ?recommendedName up:fullName ?fullName .
8
}
Use

105_uniprot_recomended_protein_short_name: The recommended protein short names for UniProtKB entries

xxxxxxxxxx
8
 
1
PREFIX up: <http://purl.uniprot.org/core/>
2
SELECT ?protein
3
  ?fullName
4
WHERE {
5
  ?protein a up:Protein ;
6
           up:recommendedName ?recommendedName .
7
  ?recommendedName up:shortName ?fullName .
8
}
Use

106_uniprot_reviewed_or_not: List all UniProtKB proteins and if they are reviewed (Swiss-Prot) or unreviewed (TrEMBL)

xxxxxxxxxx
8
 
1
PREFIX up: <http://purl.uniprot.org/core/>
2
SELECT
3
  ?protein
4
  ?reviewed
5
WHERE {
6
  ?protein a up:Protein .
7
  ?protein up:reviewed ?reviewed .
8
}
Use

107_uniprot_sequences_and_mark_which_is_cannonical_for_human: List all human UniProtKB entries and their sequences, marking if the sequence listed is the cannonical sequence of the matching entry.

xxxxxxxxxx
29
 
1
PREFIX taxon: <http://purl.uniprot.org/taxonomy/>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT ?entry ?sequence ?isCanonical
4
WHERE {
5
  # We don't want to look into the UniParc graph which will
6
  # confuse matters
7
  GRAPH <http://sparql.uniprot.org/uniprot> {
8
      # we need the UniProt entries that are human
9
      ?entry a up:Protein ;
10
    up:organism taxon:9606 ;
11
        up:sequence ?sequence .
12
      # If the sequence is a "Simple_Sequence" it is likely to be the
13
      # cannonical sequence
14
      OPTIONAL {
15
        ?sequence a up:Simple_Sequence .
16
        BIND(true AS ?likelyIsCanonical)
17
      }
18
      # unless we are dealing with an external isoform
19
      # see https://www.uniprot.org/help/canonical_and_isoforms
20
      OPTIONAL {
21
        FILTER(?likelyIsCanonical)
22
        ?sequence a up:External_Sequence .
23
        BIND(true AS ?isComplicated)
24
      }
25
      # If it is an external isoform it's id would not match the
26
      # entry primary accession
27
      BIND(IF(?isComplicated, STRENDS(STR(?entry), STRBEFORE(SUBSTR(STR(?sequence), 34),'-')),?likelyIsCanonical) AS ?isCanonical)
28
  }
29
}
Use

108_uniprot_signature_match_start_end: List all InterPro member database signature match start and end for a specific UniProtKB protein.

xxxxxxxxxx
22
 
1
PREFIX faldo: <http://biohackathon.org/resource/faldo#>
2
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
3
PREFIX up: <http://purl.uniprot.org/core/>
4
SELECT
5
  ?protein ?interproMemberDatabaseXref ?matchStart ?matchEnd
6
WHERE{
7
  GRAPH <http://sparql.uniprot.org/uniprot> {
8
    VALUES ?protein {<http://purl.uniprot.org/uniprot/P05067>} .
9
    ?protein rdfs:seeAlso ?sa .
10
  }
11
  GRAPH <http://sparql.uniprot.org/uniparc> {
12
    ?uniparc up:sequenceFor ?protein ;
13
      rdfs:seeAlso ?interproMemberDatabaseXref .
14
    ?interproDatabaseXref up:signatureSequenceMatch ?sam .
15
    ?sam faldo:begin ?sab ;
16
      faldo:end ?sae .
17
    ?sab faldo:position ?matchStart ;
18
      faldo:reference ?uniparc .
19
    ?sae  faldo:position ?matchEnd ;
20
      faldo:reference ?uniparc .
21
  }
22
}
Use

109_uniprot_transporter_in_liver: Find human transporter proteins in reviewed UniProtKB/Swiss-Prot, that are expressed in the liver (Uses Bgee and UBERON).

xxxxxxxxxx
29
 
1
PREFIX genex: <http://purl.org/genex#>
2
PREFIX lscr: <http://purl.org/lscr#>
3
PREFIX obo: <http://purl.obolibrary.org/obo/>
4
PREFIX orth: <http://purl.org/net/orth#>
5
PREFIX rh: <http://rdf.rhea-db.org/>
6
PREFIX taxon: <http://purl.uniprot.org/taxonomy/>
7
PREFIX uberon: <http://purl.obolibrary.org/obo/uo#>
8
PREFIX up: <http://purl.uniprot.org/core/>
9
SELECT
10
  ?rhea
11
  ?protein
12
  ?anat
13
WHERE
14
{
15
  GRAPH <https://sparql.rhea-db.org/rhea> {
16
    ?rhea rh:isTransport true .
17
  }
18
  ?protein up:annotation ?ann .
19
  ?protein up:organism taxon:9606 .
20
  ?ann up:catalyticActivity ?ca .
21
  ?ca up:catalyzedReaction ?rhea .
22
  BIND(uberon:0002107 AS ?anat)
23
  SERVICE <https://www.bgee.org/sparql> {
24
    ?seq genex:isExpressedIn ?anat .
25
    ?seq lscr:xrefUniprot ?protein .
26
    ?seq orth:organism ?organism .
27
    ?organism obo:RO_0002162 taxon:9606 .
28
  }
29
}
Use

110_uniprot_unamed_plasmids: Sometimes it is known that a gene encoding a protein UniProtKB is located on a plasmid or an organelle, but the name of the plasmid is unknown.

xxxxxxxxxx
13
 
1
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT
4
    ?protein
5
    ?plasmidOrOrganelle
6
    ?label
7
WHERE {
8
    ?protein a up:Protein ;
9
      up:encodedIn ?plasmidOrOrganelle .
10
    OPTIONAL {
11
        ?plasmidOrOrganelle rdfs:label ?label .
12
    }
13
}
Use

111_uniprot_make_chain_sequence_fasta: Given an UniProt chain identifier, generate the matching sequence as a FASTA

xxxxxxxxxx
12
 
1
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
PREFIX faldo: <http://biohackathon.org/resource/faldo#>
4
SELECT (CONCAT('>', ?chainSeqId, '\n', (SUBSTR(?iupacAA, ?begin, (?end-?begin+1))))  AS ?chainFasta)
5
WHERE {
6
  BIND("PRO_0000268053" AS ?chainSeqId)
7
  BIND(IRI(CONCAT("http://purl.uniprot.org/annotation/", ?chainSeqId)) AS ?annId)
8
  ?annId up:range ?range .
9
  ?range faldo:begin [ faldo:reference ?reference ; faldo:position ?begin ] ;
10
     faldo:end [ faldo:position ?end ] .
11
  ?reference rdf:value ?iupacAA .
12
}
Use

62_diseases_involving_enzymes: Find diseases that are thought to be related to enzymes

xxxxxxxxxx
11
 
1
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT
4
?disease ?diseaseLabel
5
WHERE {
6
 ?protein up:enzyme|up:annotation/up:catalyticActivity/up:enzymeClass ?enzyme ;
7
                   up:annotation ?diseaseAnnotation .
8
 ?diseaseAnnotation a up:Disease_Annotation ;
9
                    up:disease ?disease .
10
 ?disease skos:prefLabel ?diseaseLabel .
11
}
Use

63_diseases_involving_enzymes_located_in_mitochondrion: Find (Human genetic) diseases that are thought to be related to Enzymes, known to be located in the Mitochondrion

xxxxxxxxxx
22
 
1
PREFIX taxon: <http://purl.uniprot.org/taxonomy/>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT
4
  DISTINCT
5
    ?disease
6
WHERE {
7
  ?protein a up:Protein ;
8
  up:organism taxon:9606 ;
9
  up:annotation ?disease_annotation ,
10
                ?subcellularLocation .
11
  {
12
    ?protein up:enzyme [] .
13
  } UNION {
14
    ?protein up:annotation/a up:Catalytic_Activity_Annotation .
15
  }
16
  ?disease_annotation a up:Disease_Annotation ;
17
    up:disease ?disease .
18
  ?subcellularLocation a up:Subcellular_Location_Annotation ;
19
    up:locatedIn ?location .
20
  ?location up:cellularComponent ?component .
21
  ?component up:partOf* <http://purl.uniprot.org/locations/173> .
22
}
Use

64_diseases_related_to_mutation_in_active_site: Find (Human Genetic) diseases, that are related to a natural variant on the active site of an enzyme.

xxxxxxxxxx
33
 
1
PREFIX faldo: <http://biohackathon.org/resource/faldo#>
2
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
3
PREFIX taxon: <http://purl.uniprot.org/taxonomy/>
4
PREFIX up: <http://purl.uniprot.org/core/>
5
SELECT
6
  DISTINCT
7
   ?disease
8
WHERE {
9
  ?protein a up:Protein ;
10
    up:organism taxon:9606 ;
11
    up:annotation ?disease_annotation, ?active_site_annotation, ?natural_variant_annotation .
12
  {
13
    ?protein up:enzyme [] .
14
  } UNION {
15
  ?protein up:annotation/a up:Catalytic_Activity_Annotation .
16
  }
17
  ?disease_annotation a up:Disease_Annotation ;
18
  up:disease ?disease .
19
  ?active_site_annotation a up:Active_Site_Annotation ;
20
  up:range ?active_site_range .
21
  ?active_site_range faldo:begin ?active_site_begin .
22
  ?active_site_begin faldo:position ?active_site_position ;
23
                     faldo:reference ?sequence .
24
  ?natural_variant_annotation a up:Natural_Variant_Annotation ;
25
  up:range ?natural_variant_range ;
26
  skos:related ?disease .
27
  ?natural_variant_range faldo:begin ?natural_variant_begin ;
28
                         faldo:end ?natural_variant_end .
29
  ?natural_variant_begin faldo:position ?natural_variant_begin_position .
30
  ?natural_variant_end faldo:position ?natural_variant_end_position ;
31
                       faldo:reference ?sequence .
32
  FILTER(?natural_variant_begin_position >= ?active_site_position && ?active_site_position <= ?natural_variant_end_position)
33
}
Use

65_distinct_extinct_organisms_in_uniprotkb: How many distinct extinct organisms are represented in UniProtKB

xxxxxxxxxx
15
 
1
PREFIX keywords: <http://purl.uniprot.org/keywords/>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT
4
  ?taxon
5
  (SAMPLE(?name) AS ?anName)
6
  (COUNT(DISTINCT ?protein) AS ?entriesPerExtinctTaxon)
7
WHERE
8
{
9
  GRAPH<http://sparql.uniprot.org/taxonomy>{
10
    ?taxon a up:Taxon ;
11
           up:scientificName ?name .
12
  }
13
  ?protein up:organism ?taxon ;
14
           up:classifiedWith keywords:952 .
15
} GROUP BY ?taxon ORDER BY ?taxon
Use

66_distinct_rhea_transport_in_reviewed_uniprot: Count number of unique Rhea transport reactions annotated in reviewed UniProtKB entries.

xxxxxxxxxx
13
 
1
PREFIX rh: <http://rdf.rhea-db.org/>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT
4
(COUNT(DISTINCT ?rhea) AS ?distinctRheaTransportInUniProt)
5
WHERE
6
{
7
  GRAPH <https://sparql.rhea-db.org/rhea> {
8
    ?rhea rh:isTransport true .
9
  }
10
  ?protein up:annotation ?ann .
11
  ?ann up:catalyticActivity ?ca .
12
  ?ca up:catalyzedReaction ?rhea .
13
}
Use

67_draft_human_metabolome: Generate a draft human metabolome

xxxxxxxxxx
18
 
1
PREFIX chebislash: <http://purl.obolibrary.org/obo/chebi/>
2
PREFIX rh: <http://rdf.rhea-db.org/>
3
PREFIX taxon: <http://purl.uniprot.org/taxonomy/>
4
PREFIX up: <http://purl.uniprot.org/core/>
5
SELECT
6
?uniprot ?mnemonic ?rhea ?chebi ?smiles ?inchiKey
7
WHERE
8
{
9
  ?uniprot up:annotation/up:catalyticActivity/up:catalyzedReaction ?rhea ;
10
        up:organism taxon:9606 ;
11
        up:mnemonic ?mnemonic .
12
  SERVICE <https://sparql.rhea-db.org/sparql> {
13
    ?rhea rh:side/rh:contains/rh:compound ?compound .
14
    ?compound (rh:chebi|(rh:reactivePart/rh:chebi)|(rh:underlyingChebi/rh:chebi)) ?chebi .
15
   }
16
   ?chebi chebislash:smiles ?smiles ;
17
          chebislash:inchikey ?inchiKey .
18
}
Use

70_enzymes_interacting_with_molecules_similar_to_dopamine: Look for enzymes catalyzing reactions with molecules similar to dopamine.

xxxxxxxxxx
22
 
1
PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_>
2
PREFIX rh: <http://rdf.rhea-db.org/>
3
PREFIX sachem: <http://bioinfo.uochb.cas.cz/rdf/v1.0/sachem#>
4
PREFIX up: <http://purl.uniprot.org/core/>
5
SELECT
6
  ?protein
7
  ?rhea
8
  ?chebi
9
WHERE {
10
  # Use the smiles of dopamine CHEBI:18243
11
  SERVICE <https://idsm.elixir-czech.cz/sparql/endpoint/chebi>{
12
    ?chebi sachem:similarCompoundSearch [
13
      sachem:query "NCCc1ccc(O)c(O)c1" ] .
14
  }
15
  GRAPH<https://sparql.rhea-db.org/rhea>{
16
    ?rhea rh:side/rh:contains/rh:compound ?compound .
17
    ?compound (rh:chebi|(rh:reactivePart/rh:chebi)|(rh:underlyingChebi/rh:chebi)) ?chebi .
18
  }
19
  ?protein up:reviewed true ;
20
    up:annotation ?caa .
21
  ?caa up:catalyticActivity/up:catalyzedReaction ?rhea .
22
}
Use

71_enzymes_interacting_with_molecules_similar_to_dopamine_with_variants_related_to_disease: Look for enzymes catalyzing reactions with molecules similar to dopamine, with natural variants related to a disease.

xxxxxxxxxx
28
 
1
PREFIX CHEBI: <http://purl.obolibrary.org/obo/CHEBI_>
2
PREFIX rh: <http://rdf.rhea-db.org/>
3
PREFIX sachem: <http://bioinfo.uochb.cas.cz/rdf/v1.0/sachem#>
4
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
5
PREFIX up: <http://purl.uniprot.org/core/>
6
SELECT
7
  ?protein
8
  ?rhea
9
  ?chebi
10
  ?disease
11
WHERE {
12
  # Use the smiles of dopamine CHEBI:18243
13
  SERVICE <https://idsm.elixir-czech.cz/sparql/endpoint/chebi>{
14
    ?chebi sachem:similarCompoundSearch [
15
      sachem:query "NCCc1ccc(O)c(O)c1" ] .
16
  }
17
  GRAPH<https://sparql.rhea-db.org/rhea>{
18
    ?rhea rh:side/rh:contains/rh:compound ?compound .
19
    ?compound (rh:chebi|(rh:reactivePart/rh:chebi)|(rh:underlyingChebi/rh:chebi)) ?chebi .
20
  }
21
  ?protein up:reviewed true ;
22
    up:annotation ?caa, ?natural_variant_annotation, ?disease_annotation .
23
  ?caa up:catalyticActivity/up:catalyzedReaction ?rhea .
24
  ?natural_variant_annotation a up:Natural_Variant_Annotation ;
25
    skos:related ?disease .
26
  ?disease_annotation a up:Disease_Annotation ;
27
     up:disease ?disease .
28
}
Use

72_enzymes_mapping_to_PDB: Select a mapping of UniProtKB enzymes to PDB entries using the UniProtKB cross-references to the PDB database.

xxxxxxxxxx
17
 
1
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
2
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
3
PREFIX up: <http://purl.uniprot.org/core/>
4
SELECT
5
  ?protein
6
  ?db
7
WHERE
8
{
9
  ?protein a up:Protein .
10
  ?protein rdfs:seeAlso ?db .
11
  ?db up:database <http://purl.uniprot.org/database/PDB> .
12
  {
13
    ?protein up:enzyme ?enzyme .
14
  } UNION {
15
    ?protein up:annotation/rdf:type up:Catalytic_Activity_Annotation .
16
  }
17
}
Use

73_enzymes_related_to_protein: Select Enzyme Classification (EC) classes that have a protein associated to them

xxxxxxxxxx
19
 
1
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT
4
  DISTINCT ?enzyme
5
WHERE {
6
  ?protein a up:Protein .
7
  {
8
    ?protein up:enzyme ?enzyme .
9
  } UNION {
10
    ?protein up:annotation ?caa .
11
    ?caa a up:Catalytic_Activity_Annotation .
12
    ?caa up:catalyticActivity ?ca .
13
    ?ca up:enzymeClass ?enzyme
14
  } UNION {
15
    ?protein up:component/up:enzyme ?enzyme .
16
  } UNION {
17
    ?protein up:domain/up:enzyme ?enzyme .
18
  }
19
}
Use

74_enzymes_with_at_least_two_transmembrane_domains: Find Hydrolases (enzymes that catalyse the hydrolysis of various bonds) that have at least two transmembrane domains

xxxxxxxxxx
10
 
1
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT
4
  ?protein
5
WHERE {
6
 ?protein up:enzyme|up:annotation/up:catalyticActivity/up:enzymeClass ?enzymeClass ;
7
                   up:annotation ?transMembraneAnnotation .
8
 ?enzymeClass rdfs:subClassOf <http://purl.uniprot.org/enzyme/3.-.-.-> .
9
 ?transMembraneAnnotation a up:Transmembrane_Annotation .
10
} GROUP BY ?protein HAVING (COUNT(DISTINCT ?transMembraneAnnotation) >= 2)
Use

75_enzymes_with_at_least_two_transmembrane_domains_PDB_xray: Find enzymes that have at least two transmembrane domains, whose 3D structure is elucidated through X-Ray analysis

xxxxxxxxxx
17
 
1
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT
4
  ?protein
5
WHERE {
6
  ?protein a up:Protein ;
7
    up:annotation ?transmembrane_annotation ;
8
    rdfs:seeAlso ?wwPDB .
9
  {
10
    ?protein up:enzyme ?enzyme .
11
  } UNION {
12
    ?protein up:annotation/a up:Catalytic_Activity_Annotation .
13
  }
14
  ?wwPDB up:database <http://purl.uniprot.org/database/PDB> ;
15
    up:method up:X-Ray_Crystallography .
16
  ?transmembrane_annotation a up:Transmembrane_Annotation .
17
} GROUP BY ?protein HAVING(COUNT(DISTINCT ?transmembrane_annotation ) >= 2)
Use

76_enzymes_with_mutagenesis_affecting_active_site: Find enzymes, where the active site is a region affected by mutagenesis and show the comment regarding mutagenesis effect.

xxxxxxxxxx
23
 
1
PREFIX faldo: <http://biohackathon.org/resource/faldo#>
2
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
3
PREFIX up: <http://purl.uniprot.org/core/>
4
SELECT
5
  ?protein ?mutagenesisBeginPosition ?activeSiteBeginPosition ?mutagenesisRangeEndPosition ?mutagenesisComment
6
WHERE {
7
  ?protein up:annotation ?activeSiteAnnotation ,
8
      ?mutagenesisAnnotation .
9
  ?mutagenesisAnnotation a up:Mutagenesis_Annotation ;
10
     up:range ?mutagenesisRange ;
11
     rdfs:comment ?mutagenesisComment .
12
  ?activeSiteAnnotation a up:Active_Site_Annotation ;
13
    up:range ?activeSiteRange .
14
  ?activeSiteRange faldo:begin ?activeSiteBegin .
15
  ?activeSiteBegin faldo:position ?activeSiteBeginPosition ;
16
    faldo:reference ?sequence .
17
  ?mutagenesisRange faldo:begin ?mutagenesisRangeBegin ;
18
    faldo:end ?mutagenesisRangeEnd .
19
  ?mutagenesisRangeBegin faldo:position ?mutagenesisBeginPosition ;
20
    faldo:reference ?sequence .
21
  ?mutagenesisRangeEnd faldo:position ?mutagenesisRangeEndPosition .
22
  FILTER(?mutagenesisBeginPosition <= ?activeSiteBeginPosition && ?activeSiteBeginPosition <= ?mutagenesisRangeEndPosition)
23
}
Use

78_genetic_disease_related_proteins: List all UniProtKB proteins annotated to be related to a genetic disease.

xxxxxxxxxx
20
 
1
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
2
PREFIX up: <http://purl.uniprot.org/core/>
3
SELECT
4
  ?uniprot ?disease ?diseaseComment ?mim
5
WHERE
6
{
7
  GRAPH <http://sparql.uniprot.org/uniprot> {
8
    ?uniprot a up:Protein ;
9
       up:annotation ?diseaseAnnotation .
10
    ?diseaseAnnotation up:disease ?disease .
11
  }
12
  GRAPH <http://sparql.uniprot.org/diseases> {
13
    ?disease a up:Disease ;
14
             rdfs:comment ?diseaseComment .
15
    OPTIONAL {
16
      ?disease rdfs:seeAlso ?mim .
17
       ?mim up:database <http://purl.uniprot.org/database/MIM> .
18
    }
19
  }
20
}
Use

79_mnemonic_also_known_as_id: List all UniProtKB protein ID (mnemonic) for current UniProtKB entries.

xxxxxxxxxx
10
 
1
PREFIX up: <http://purl.uniprot.org/core/>
2
SELECT
3
  ?uniprot ?mnemonic
4
WHERE
5
{
6
  GRAPH <http://sparql.uniprot.org/uniprot> {
7
        ?uniprot a up:Protein ;
8
            up:mnemonic ?mnemonic .
9
    }
10
}
Use

80_obsolete_mnemonic_also_known_as_id: List all UniProtKB protein ID (mnemonic) that where used in the past for current UniProtKB entries.

xxxxxxxxxx
10
 
1
PREFIX up: <http://purl.uniprot.org/core/>
2
SELECT
3
  ?uniprot ?obsoleteMnemonic
4
WHERE
5
{
6
  GRAPH <http://sparql.uniprot.org/uniprot> {
7
        ?uniprot a up:Protein ;
8
            up:oldMnemonic ?obsoleteMnemonic .
9
    }
10
}
Use

81_rhea_reactions_annotated_as_experimental_and_only_small_molecules: Find all Rhea (only small molecule) that are used in UniProtKB where the annotation has a paper and is tagged having experimental evidence.

xxxxxxxxxx
31
 
1
PREFIX ECO: <http://purl.obolibrary.org/obo/ECO_>
2
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
3
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
4
PREFIX rh: <http://rdf.rhea-db.org/>
5
PREFIX up: <http://purl.uniprot.org/core/>
6
SELECT
7
  ?rhea
8
  ?catalyzedReaction
9
  ?source
10
WHERE {
11
  {  
12
    SELECT
13
      DISTINCT
14
        ?rhea
15
      WHERE {
16
        GRAPh<https://sparql.rhea-db.org/rhea> {
17
          ?rhea rdfs:subClassOf rh:Reaction .
18
          ?rhea rh:side/rh:contains/rh:compound ?compound2 .
19
          ?uc rdfs:subClassOf rh:Compound .
20
        }
21
        ?compound2 rdfs:subClassOf ?uc .
22
        BIND(IF(?uc = rh:SmallMolecule, 0, 1) AS ?c)  
23
     } GROUP BY ?rhea  HAVING (SUM(?c) = 0)
24
  }
25
  ?catalyzedReaction up:catalyzedReaction ?rhea .
26
  ?reif rdf:object ?catalyzedReaction ;
27
        up:attribution ?attr .
28
  ?attr up:evidence ECO:0000269 ;
29
        up:source ?source .
30
  ?source a up:Citation .
31
}
Use

82_rhea_reactions_associated_with_ec_in_uniprotkb: List Rhea reactions associated with an EC (enzyme classification).

xxxxxxxxxx
8
 
1
PREFIX up: <http://purl.uniprot.org/core/>
2
SELECT
3
  ?rhea
4
  ?EC
5
WHERE {
6
  ?CatalyticActivity  up:catalyzedReaction   ?rhea ;
7
    up:enzymeClass         ?EC .
8
}
Use
◀ ▶