api_results

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

10 rows where query_id = 121814

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
141755 141755 121814 121814 PubChem (compound) 1 187835 187835 1
141757 141757 121814 121814 PubChem (compound) 1 4308 4308 2
141759 141759 121814 121814 PubChem (compound) 1 187836 187836 3
494119 494119 121814 121814 PubChem (substance) 2 4156 4156 4
494345 494345 121814 121814 PubChem (substance) 2 187835 187835 1
494348 494348 121814 121814 PubChem (substance) 2 4308 4308 3
494351 494351 121814 121814 PubChem (substance) 2 187836 187836 2
786211 786211 121814 121814 PubChem (substance) 2 267270 267270 5
1041563 1041563 121814 121814 CAS Common Chemistry 3 4308 4308 1
1244524 1244524 121814 121814 Computational Toxicology and Exposure Data 4 4308 4308 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)
);