api_results

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

11 rows where query_id = 80168

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
111758 111758 80168 80168 PubChem (compound) 1 2700 2700 1
453455 453455 80168 80168 PubChem (substance) 2 2700 2700 1
453457 453457 80168 80168 PubChem (substance) 2 240704 240704 8
453459 453459 80168 80168 PubChem (substance) 2 183553 183553 2
760500 760500 80168 80168 PubChem (substance) 2 232529 232529 3
760502 760502 80168 80168 PubChem (substance) 2 158707 158707 4
760503 760503 80168 80168 PubChem (substance) 2 287869 287869 5
760505 760505 80168 80168 PubChem (substance) 2 294586 294586 6
760506 760506 80168 80168 PubChem (substance) 2 309150 309150 7
1019922 1019922 80168 80168 CAS Common Chemistry 3 2700 2700 1
1222293 1222293 80168 80168 Computational Toxicology and Exposure Data 4 99753 99753 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)
);