home / zeropm-v0-0-4

api_results

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

16 rows where query_id = 360642

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
350877 350877 360642 360642 PubChem (substance) 2 111453 111453 6
465616 465616 360642 360642 PubChem (substance) 2 43760 43760 12
729871 729871 360642 360642 PubChem (substance) 2 140974 140974 1
729876 729876 360642 360642 PubChem (substance) 2 201286 201286 4
729886 729886 360642 360642 PubChem (substance) 2 180163 180163 15
729893 729893 360642 360642 PubChem (substance) 2 220268 220268 7
729895 729895 360642 360642 PubChem (substance) 2 263369 263369 2
729903 729903 360642 360642 PubChem (substance) 2 190118 190118 3
912626 912626 360642 360642 PubChem (substance) 2 177748 177748 13
915687 915687 360642 360642 PubChem (substance) 2 39758 39758 5
915688 915688 360642 360642 PubChem (substance) 2 275460 275460 8
915689 915689 360642 360642 PubChem (substance) 2 276715 276715 9
915690 915690 360642 360642 PubChem (substance) 2 190118 190118 10
915691 915691 360642 360642 PubChem (substance) 2 321373 321373 11
915692 915692 360642 360642 PubChem (substance) 2 254890 254890 14
984437 984437 360642 360642 CAS Common Chemistry 3 39758 39758 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 450.849ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website