api_results

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

11 rows where query_id = 57845

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
97496 97496 57845 57845 PubChem (compound) 1 78176 78176 1
433502 433502 57845 57845 PubChem (substance) 2 78176 78176 1
640419 640419 57845 57845 PubChem (substance) 2 182518 182518 3
641180 641180 57845 57845 PubChem (substance) 2 183233 183233 2
748252 748252 57845 57845 PubChem (substance) 2 200042 200042 4
748253 748253 57845 57845 PubChem (substance) 2 198175 198175 5
748254 748254 57845 57845 PubChem (substance) 2 210747 210747 6
748255 748255 57845 57845 PubChem (substance) 2 199534 199534 7
748256 748256 57845 57845 PubChem (substance) 2 196047 196047 8
1010271 1010271 57845 57845 CAS Common Chemistry 3 78176 78176 1
1212347 1212347 57845 57845 Computational Toxicology and Exposure Data 4 78176 78176 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)
);