api_results

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

6 rows where query_id = 110770

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
129749 129749 110770 110770 PubChem (compound) 1 29743 29743 1
342423 342423 110770 110770 PubChem (substance) 2 6226 6226 3
478507 478507 110770 110770 PubChem (substance) 2 29743 29743 1
552415 552415 110770 110770 PubChem (substance) 2 29026 29026 2
1032228 1032228 110770 110770 CAS Common Chemistry 3 29743 29743 1
1235140 1235140 110770 110770 Computational Toxicology and Exposure Data 4 29743 29743 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)
);