api_results

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

13 rows where inchi_id = 67941

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
163269 163269 143190 143190 PubChem (compound) 1 67941 67941 1
163270 163270 412911 412911 PubChem (compound) 1 67941 67941 1
163271 163271 143191 143191 PubChem (compound) 1 67941 67941 1
522599 522599 143191 143191 PubChem (substance) 2 67941 67941 1
522600 522600 143190 143190 PubChem (substance) 2 67941 67941 1
522601 522601 412911 412911 PubChem (substance) 2 67941 67941 1
522602 522602 401085 401085 PubChem (substance) 2 67941 67941 3
1057662 1057662 143190 143190 CAS Common Chemistry 3 67941 67941 1
1057663 1057663 412911 412911 CAS Common Chemistry 3 67941 67941 1
1057664 1057664 143191 143191 CAS Common Chemistry 3 67941 67941 1
1260240 1260240 143191 143191 Computational Toxicology and Exposure Data 4 67941 67941 1
1260241 1260241 143190 143190 Computational Toxicology and Exposure Data 4 67941 67941 1
1260242 1260242 412911 412911 Computational Toxicology and Exposure Data 4 67941 67941 1 
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);