home / zeropm-v0-0-4

api_results

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

15 rows where query_id = 83331

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
25126 25126 83331 83331 PubChem (compound) 1 83483 83483 2
34091 34091 83331 83331 PubChem (compound) 1 47694 47694 1
34103 34103 83331 83331 PubChem (compound) 1 12669 12669 3
318761 318761 83331 83331 PubChem (substance) 2 121344 121344 7
331578 331578 83331 83331 PubChem (substance) 2 83483 83483 2
344348 344348 83331 83331 PubChem (substance) 2 47694 47694 1
344372 344372 83331 83331 PubChem (substance) 2 12669 12669 3
710115 710115 83331 83331 PubChem (substance) 2 147176 147176 4
729402 729402 83331 83331 PubChem (substance) 2 259380 259380 9
761800 761800 83331 83331 PubChem (substance) 2 232163 232163 5
761806 761806 83331 83331 PubChem (substance) 2 137601 137601 6
761807 761807 83331 83331 PubChem (substance) 2 141751 141751 8
956673 956673 83331 83331 CAS Common Chemistry 3 83483 83483 1
1156768 1156768 83331 83331 Computational Toxicology and Exposure Data 4 83483 83483 1
1213132 1213132 83331 83331 Computational Toxicology and Exposure Data 4 114328 114328 2
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 744.753ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website