api_results

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

9 rows where query_id = 377817

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
271027 271027 377817 377817 PubChem (compound) 1 91617 91617 1
661062 661062 377817 377817 PubChem (substance) 2 91617 91617 1
661075 661075 377817 377817 PubChem (substance) 2 91616 91616 3
661078 661078 377817 377817 PubChem (substance) 2 1769 1769 4
921204 921204 377817 377817 PubChem (substance) 2 174347 174347 2
921205 921205 377817 377817 PubChem (substance) 2 253703 253703 5
921206 921206 377817 377817 PubChem (substance) 2 255520 255520 6
1118491 1118491 377817 377817 CAS Common Chemistry 3 91617 91617 1
1330490 1330490 377817 377817 Computational Toxicology and Exposure Data 4 128333 128333 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)
);