home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 59977

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99741 99741 59977 59977 PubChem (compound) 1 60783 60783 1
436849 436849 59977 59977 PubChem (substance) 2 4475 4475 9
436865 436865 59977 59977 PubChem (substance) 2 60783 60783 1
749873 749873 59977 59977 PubChem (substance) 2 136970 136970 6
749921 749921 59977 59977 PubChem (substance) 2 216879 216879 2
749924 749924 59977 59977 PubChem (substance) 2 210077 210077 3
749927 749927 59977 59977 PubChem (substance) 2 60783 60783 4
749930 749930 59977 59977 PubChem (substance) 2 175717 175717 5
749934 749934 59977 59977 PubChem (substance) 2 243360 243360 7
749937 749937 59977 59977 PubChem (substance) 2 260175 260175 8
749938 749938 59977 59977 PubChem (substance) 2 263741 263741 10
749941 749941 59977 59977 PubChem (substance) 2 270875 270875 11
749943 749943 59977 59977 PubChem (substance) 2 308065 308065 12
749944 749944 59977 59977 PubChem (substance) 2 291385 291385 13
749946 749946 59977 59977 PubChem (substance) 2 326569 326569 14
749948 749948 59977 59977 PubChem (substance) 2 343769 343769 15
1011737 1011737 59977 59977 CAS Common Chemistry 3 60783 60783 1
1213849 1213849 59977 59977 Computational Toxicology and Exposure Data 4 60783 60783 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)
);
Powered by Datasette · Queries took 560.164ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website