# Endpoint: https://rdfportal.org/pubchem/sparql
# Description: List the pairs of PubChem substance and its counterpart in PubChem Compound
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX bao: <http://www.bioassayontology.org/bao#>
PREFIX sio: <http://semanticscience.org/resource/>
SELECT DISTINCT ?PubChemSubstance ?substance_normalized_counterpart
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/compound>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/substance>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/descriptor/compound>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/descriptor/substance>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/synonym>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/inchikey>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/measuregroup>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/endpoint>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/bioassay>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/protein>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/pathway>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/conserveddomain>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/gene>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/reference>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/source>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/concept>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/patent>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/taxonomy>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/cell>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/cooccurrence>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/disease>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/book>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/journal>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/author>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/organization>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/grant>
FROM <http://rdf.ncbi.nlm.nih.gov/pubchem/void>
WHERE {
OPTIONAL {
?PubChemSubstance sio:CHEMINF_000477 ?substance_normalized_counterpart .
}
}
LIMIT 100