home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 361828

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21329 21329 361828 361828 PubChem (compound) 1 28063 28063 1
325842 325842 361828 361828 PubChem (substance) 2 28901 28901 3
325943 325943 361828 361828 PubChem (substance) 2 28063 28063 1
383707 383707 361828 361828 PubChem (substance) 2 1614 1614 2
657920 657920 361828 361828 PubChem (substance) 2 97658 97658 13
694784 694784 361828 361828 PubChem (substance) 2 232061 232061 4
699962 699962 361828 361828 PubChem (substance) 2 142925 142925 12
765090 765090 361828 361828 PubChem (substance) 2 199519 199519 5
765092 765092 361828 361828 PubChem (substance) 2 201077 201077 6
765093 765093 361828 361828 PubChem (substance) 2 206121 206121 7
765097 765097 361828 361828 PubChem (substance) 2 201205 201205 8
765100 765100 361828 361828 PubChem (substance) 2 169894 169894 9
765103 765103 361828 361828 PubChem (substance) 2 169899 169899 10
765105 765105 361828 361828 PubChem (substance) 2 204874 204874 11
765107 765107 361828 361828 PubChem (substance) 2 150434 150434 14
765111 765111 361828 361828 PubChem (substance) 2 28063 28063 15
953921 953921 361828 361828 CAS Common Chemistry 3 28063 28063 1
1153309 1153309 361828 361828 Computational Toxicology and Exposure Data 4 28901 28901 3
1153315 1153315 361828 361828 Computational Toxicology and Exposure Data 4 1614 1614 2
1153378 1153378 361828 361828 Computational Toxicology and Exposure Data 4 123863 123863 1
1154495 1154495 361828 361828 Computational Toxicology and Exposure Data 4 120402 120402 4
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 471.684ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website