api_results

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

14 rows where query_id = 170937

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
189614 189614 170937 170937 PubChem (compound) 1 33958 33958 1
189616 189616 170937 170937 PubChem (compound) 1 208491 208491 2
557419 557419 170937 170937 PubChem (substance) 2 33958 33958 1
557424 557424 170937 170937 PubChem (substance) 2 208491 208491 4
650678 650678 170937 170937 PubChem (substance) 2 143774 143774 2
818043 818043 170937 170937 PubChem (substance) 2 250547 250547 3
818044 818044 170937 170937 PubChem (substance) 2 233620 233620 5
818045 818045 170937 170937 PubChem (substance) 2 245452 245452 6
818047 818047 170937 170937 PubChem (substance) 2 196905 196905 7
818048 818048 170937 170937 PubChem (substance) 2 243244 243244 8
818049 818049 170937 170937 PubChem (substance) 2 213787 213787 9
818050 818050 170937 170937 PubChem (substance) 2 177682 177682 10
1076764 1076764 170937 170937 CAS Common Chemistry 3 33958 33958 1
1278183 1278183 170937 170937 Computational Toxicology and Exposure Data 4 33958 33958 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)
);