api_results

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

7 rows where query_id = 134087

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
154191 154191 134087 134087 PubChem (compound) 1 40479 40479 1
375766 375766 134087 134087 PubChem (substance) 2 209574 209574 4
510739 510739 134087 134087 PubChem (substance) 2 40479 40479 1
794638 794638 134087 134087 PubChem (substance) 2 138676 138676 2
794640 794640 134087 134087 PubChem (substance) 2 214989 214989 3
1050868 1050868 134087 134087 CAS Common Chemistry 3 40479 40479 1
1253612 1253612 134087 134087 Computational Toxicology and Exposure Data 4 40479 40479 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)
);