api_results

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

24 rows where inchi_id = 100

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
43351 43351 19448 19448 PubChem (compound) 1 100 100 1
43352 43352 346373 346373 PubChem (compound) 1 100 100 1
43353 43353 19449 19449 PubChem (compound) 1 100 100 1
43354 43354 319996 319996 PubChem (compound) 1 100 100 1
43355 43355 403501 403501 PubChem (compound) 1 100 100 1
43356 43356 88560 88560 PubChem (compound) 1 100 100 1
43357 43357 120756 120756 PubChem (compound) 1 100 100 1
357278 357278 403501 403501 PubChem (substance) 2 100 100 1
357279 357279 120756 120756 PubChem (substance) 2 100 100 1
357280 357280 19449 19449 PubChem (substance) 2 100 100 1
357281 357281 19448 19448 PubChem (substance) 2 100 100 1
357282 357282 88560 88560 PubChem (substance) 2 100 100 1
357283 357283 346373 346373 PubChem (substance) 2 100 100 1
357284 357284 319996 319996 PubChem (substance) 2 100 100 1
969885 969885 19448 19448 CAS Common Chemistry 3 100 100 1
969886 969886 319996 319996 CAS Common Chemistry 3 100 100 1
969887 969887 403501 403501 CAS Common Chemistry 3 100 100 1
969888 969888 19449 19449 CAS Common Chemistry 3 100 100 1
969889 969889 120756 120756 CAS Common Chemistry 3 100 100 1
1172120 1172120 19448 19448 Computational Toxicology and Exposure Data 4 100 100 1
1172121 1172121 403501 403501 Computational Toxicology and Exposure Data 4 100 100 1
1172122 1172122 19449 19449 Computational Toxicology and Exposure Data 4 100 100 1
1172123 1172123 319996 319996 Computational Toxicology and Exposure Data 4 100 100 1
1172124 1172124 120756 120756 Computational Toxicology and Exposure Data 4 100 100 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)
);