api_results

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

14 rows where query_id = 21967

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
48768 48768 21967 21967 PubChem (compound) 1 25842 25842 1
365111 365111 21967 21967 PubChem (substance) 2 25842 25842 1
368466 368466 21967 21967 PubChem (substance) 2 157362 157362 3
436370 436370 21967 21967 PubChem (substance) 2 37153 37153 6
464873 464873 21967 21967 PubChem (substance) 2 19092 19092 9
473833 473833 21967 21967 PubChem (substance) 2 83501 83501 2
721362 721362 21967 21967 PubChem (substance) 2 169437 169437 4
721363 721363 21967 21967 PubChem (substance) 2 260145 260145 5
721365 721365 21967 21967 PubChem (substance) 2 169023 169023 7
721366 721366 21967 21967 PubChem (substance) 2 138652 138652 8
721376 721376 21967 21967 PubChem (substance) 2 136419 136419 10
721379 721379 21967 21967 PubChem (substance) 2 272598 272598 11
973566 973566 21967 21967 CAS Common Chemistry 3 25842 25842 1
1176244 1176244 21967 21967 Computational Toxicology and Exposure Data 4 25842 25842 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)
);