home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 438076

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
39809 39809 438076 438076 PubChem (compound) 1 54376 54376 1
307313 307313 438076 438076 PubChem (substance) 2 11441 11441 5
312278 312278 438076 438076 PubChem (substance) 2 3709 3709 7
312890 312890 438076 438076 PubChem (substance) 2 3331 3331 12
339981 339981 438076 438076 PubChem (substance) 2 3728 3728 13
340310 340310 438076 438076 PubChem (substance) 2 4045 4045 6
343201 343201 438076 438076 PubChem (substance) 2 7017 7017 9
350766 350766 438076 438076 PubChem (substance) 2 49801 49801 8
352493 352493 438076 438076 PubChem (substance) 2 54376 54376 1
354411 354411 438076 438076 PubChem (substance) 2 58572 58572 4
354428 354428 438076 438076 PubChem (substance) 2 58574 58574 14
354473 354473 438076 438076 PubChem (substance) 2 58584 58584 11
357925 357925 438076 438076 PubChem (substance) 2 4103 4103 10
669527 669527 438076 438076 PubChem (substance) 2 152621 152621 3
691492 691492 438076 438076 PubChem (substance) 2 139916 139916 15
717039 717039 438076 438076 PubChem (substance) 2 149253 149253 2
967145 967145 438076 438076 CAS Common Chemistry 3 54376 54376 1
1169096 1169096 438076 438076 Computational Toxicology and Exposure Data 4 54376 54376 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 492.655ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website