api_results

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

13 rows where query_id = 18791

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
41722 41722 18791 18791 PubChem (compound) 1 121687 121687 1
41726 41726 18791 18791 PubChem (compound) 1 253375 253375 2
41727 41727 18791 18791 PubChem (compound) 1 224986 224986 3
41728 41728 18791 18791 PubChem (compound) 1 23850 23850 4
41729 41729 18791 18791 PubChem (compound) 1 63440 63440 5
355116 355116 18791 18791 PubChem (substance) 2 121687 121687 1
355122 355122 18791 18791 PubChem (substance) 2 253375 253375 2
355128 355128 18791 18791 PubChem (substance) 2 224986 224986 3
355132 355132 18791 18791 PubChem (substance) 2 23850 23850 5
355133 355133 18791 18791 PubChem (substance) 2 63440 63440 4
717729 717729 18791 18791 PubChem (substance) 2 159593 159593 6
968684 968684 18791 18791 CAS Common Chemistry 3 63440 63440 1
1170800 1170800 18791 18791 Computational Toxicology and Exposure Data 4 121687 121687 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)
);