home / zeropm-v0-0-4

api_results

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

17 rows where query_id = 18598

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
41225 41225 18598 18598 PubChem (compound) 1 58574 58574 1
299378 299378 18598 18598 PubChem (substance) 2 2662 2662 10
307302 307302 18598 18598 PubChem (substance) 2 11441 11441 7
307596 307596 18598 18598 PubChem (substance) 2 3489 3489 14
312277 312277 18598 18598 PubChem (substance) 2 3709 3709 11
312872 312872 18598 18598 PubChem (substance) 2 3331 3331 5
314139 314139 18598 18598 PubChem (substance) 2 73287 73287 13
339974 339974 18598 18598 PubChem (substance) 2 3728 3728 9
340299 340299 18598 18598 PubChem (substance) 2 4045 4045 3
343200 343200 18598 18598 PubChem (substance) 2 7017 7017 4
354372 354372 18598 18598 PubChem (substance) 2 58569 58569 12
354399 354399 18598 18598 PubChem (substance) 2 58572 58572 6
354420 354420 18598 18598 PubChem (substance) 2 58574 58574 1
357919 357919 18598 18598 PubChem (substance) 2 4103 4103 8
717504 717504 18598 18598 PubChem (substance) 2 169913 169913 2
968285 968285 18598 18598 CAS Common Chemistry 3 58574 58574 1
1170362 1170362 18598 18598 Computational Toxicology and Exposure Data 4 58574 58574 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 1096.617ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website