home / zeropm-v0-0-4

api_results

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

16 rows where query_id = 62270

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102625 102625 62270 62270 PubChem (compound) 1 29658 29658 1
102628 102628 62270 62270 PubChem (compound) 1 29658 29658 2
102630 102630 62270 62270 PubChem (compound) 1 29658 29658 3
102632 102632 62270 62270 PubChem (compound) 1 29658 29658 4
102634 102634 62270 62270 PubChem (compound) 1 292611 292611 5
440935 440935 62270 62270 PubChem (substance) 2 29658 29658 1
440938 440938 62270 62270 PubChem (substance) 2 29658 29658 2
440942 440942 62270 62270 PubChem (substance) 2 29658 29658 3
440944 440944 62270 62270 PubChem (substance) 2 29658 29658 4
440946 440946 62270 62270 PubChem (substance) 2 292611 292611 9
752687 752687 62270 62270 PubChem (substance) 2 218314 218314 5
752688 752688 62270 62270 PubChem (substance) 2 276010 276010 6
752689 752689 62270 62270 PubChem (substance) 2 177017 177017 7
752692 752692 62270 62270 PubChem (substance) 2 292611 292611 8
1013716 1013716 62270 62270 CAS Common Chemistry 3 29658 29658 1
1215878 1215878 62270 62270 Computational Toxicology and Exposure Data 4 29658 29658 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 421.449ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website