api_results

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

13 rows where inchi_id = 33958

✎ 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
189615 189615 418848 418848 PubChem (compound) 1 33958 33958 1
557419 557419 170937 170937 PubChem (substance) 2 33958 33958 1
557420 557420 337290 337290 PubChem (substance) 2 33958 33958 1
557421 557421 170939 170939 PubChem (substance) 2 33958 33958 11
557422 557422 418848 418848 PubChem (substance) 2 33958 33958 1
557423 557423 170938 170938 PubChem (substance) 2 33958 33958 1
1076764 1076764 170937 170937 CAS Common Chemistry 3 33958 33958 1
1076765 1076765 337290 337290 CAS Common Chemistry 3 33958 33958 1
1076766 1076766 418848 418848 CAS Common Chemistry 3 33958 33958 1
1278181 1278181 337290 337290 Computational Toxicology and Exposure Data 4 33958 33958 1
1278182 1278182 418848 418848 Computational Toxicology and Exposure Data 4 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)
);