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 = 370873

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
14145 14145 370873 370873 PubChem (compound) 1 75177 75177 1
315577 315577 370873 370873 PubChem (substance) 2 75177 75177 1
380783 380783 370873 370873 PubChem (substance) 2 75665 75665 17
382402 382402 370873 370873 PubChem (substance) 2 274 274 12
383621 383621 370873 370873 PubChem (substance) 2 123602 123602 5
440293 440293 370873 370873 PubChem (substance) 2 241343 241343 13
444919 444919 370873 370873 PubChem (substance) 2 7710 7710 9
450994 450994 370873 370873 PubChem (substance) 2 77231 77231 11
457036 457036 370873 370873 PubChem (substance) 2 12920 12920 3
496274 496274 370873 370873 PubChem (substance) 2 192032 192032 14
570021 570021 370873 370873 PubChem (substance) 2 168956 168956 18
702574 702574 370873 370873 PubChem (substance) 2 75177 75177 2
727196 727196 370873 370873 PubChem (substance) 2 186046 186046 4
727199 727199 370873 370873 PubChem (substance) 2 188379 188379 6
727202 727202 370873 370873 PubChem (substance) 2 188380 188380 7
727205 727205 370873 370873 PubChem (substance) 2 284659 284659 8
727208 727208 370873 370873 PubChem (substance) 2 139279 139279 10
727211 727211 370873 370873 PubChem (substance) 2 140716 140716 15
727214 727214 370873 370873 PubChem (substance) 2 233012 233012 16
948706 948706 370873 370873 CAS Common Chemistry 3 75177 75177 1
1147266 1147266 370873 370873 Computational Toxicology and Exposure Data 4 75177 75177 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 928.069ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website