home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 19556

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
43615 43615 19556 19556 PubChem (compound) 1 124031 124031 1
43619 43619 19556 19556 PubChem (compound) 1 124031 124031 2
43623 43623 19556 19556 PubChem (compound) 1 117427 117427 3
43633 43633 19556 19556 PubChem (compound) 1 3895 3895 4
43635 43635 19556 19556 PubChem (compound) 1 124031 124031 5
43636 43636 19556 19556 PubChem (compound) 1 124031 124031 6
357623 357623 19556 19556 PubChem (substance) 2 124031 124031 1
357633 357633 19556 19556 PubChem (substance) 2 124031 124031 2
357644 357644 19556 19556 PubChem (substance) 2 117427 117427 3
357659 357659 19556 19556 PubChem (substance) 2 3895 3895 4
357661 357661 19556 19556 PubChem (substance) 2 124031 124031 6
357667 357667 19556 19556 PubChem (substance) 2 124031 124031 12
432758 432758 19556 19556 PubChem (substance) 2 218701 218701 7
436697 436697 19556 19556 PubChem (substance) 2 139175 139175 10
436710 436710 19556 19556 PubChem (substance) 2 218701 218701 15
436717 436717 19556 19556 PubChem (substance) 2 12050 12050 13
718540 718540 19556 19556 PubChem (substance) 2 258481 258481 5
718545 718545 19556 19556 PubChem (substance) 2 276643 276643 8
718551 718551 19556 19556 PubChem (substance) 2 274629 274629 9
718555 718555 19556 19556 PubChem (substance) 2 260249 260249 11
718556 718556 19556 19556 PubChem (substance) 2 323710 323710 14
970090 970090 19556 19556 CAS Common Chemistry 3 3895 3895 1
1172338 1172338 19556 19556 Computational Toxicology and Exposure Data 4 124031 124031 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 541.303ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website