api_results

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

9 rows where query_id = 113596

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
132934 132934 113596 113596 PubChem (compound) 1 46534 46534 1
436885 436885 113596 113596 PubChem (substance) 2 45292 45292 4
482774 482774 113596 113596 PubChem (substance) 2 46534 46534 1
780130 780130 113596 113596 PubChem (substance) 2 247737 247737 5
780133 780133 113596 113596 PubChem (substance) 2 201865 201865 2
780134 780134 113596 113596 PubChem (substance) 2 194337 194337 3
780135 780135 113596 113596 PubChem (substance) 2 210790 210790 6
1034692 1034692 113596 113596 CAS Common Chemistry 3 46534 46534 1
1237667 1237667 113596 113596 Computational Toxicology and Exposure Data 4 46534 46534 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)
);