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/CHEMBL7363

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.