PRA3006-SPARQL

substances.rq

Database	ChEMBL
SPARQl endpoint	https://chemblmirror.rdf.bigcat-bioinformatics.org/sparql
License	CC-BY-SA 3.0 Unported

Code examples: curl

SPARQL

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX dbpedia2: <http://dbpedia.org/property/>
PREFIX dbpedia: <http://dbpedia.org/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>

PREFIX cco: <http://rdf.ebi.ac.uk/terms/chembl#>
SELECT ?molecule
WHERE {
  ?molecule a ?type .
  ?type rdfs:subClassOf* cco:Substance .
} limit 20

Run or Edit

Output

molecule

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL286494

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201580

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201586

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201608

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201439

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201575

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201583

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201584

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201585

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201587

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201825

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201831

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201833

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1201834

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL3137721

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1743009

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1743012

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1743016

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1743018

http://rdf.ebi.ac.uk/resource/chembl/molecule/CHEMBL1743023

Code examples

curl

curl -o substances.rq https://raw.githubusercontent.com/BiGCAT-UM/PRA3006-SPARQL/master/sparql/substances.rq
curl -H "Accept: text/tab-separated-values" -G https://chemblmirror.rdf.bigcat-bioinformatics.org/sparql --data-urlencode query@substances.rq

This SPARQL query is available under CCZero.

This site is open source. Improve this page.