api_results

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

8 rows where query_id = 27868

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
60563 60563 27868 27868 PubChem (compound) 1 76213 76213 1
381513 381513 27868 27868 PubChem (substance) 2 76213 76213 1
667055 667055 27868 27868 PubChem (substance) 2 139656 139656 5
727660 727660 27868 27868 PubChem (substance) 2 252111 252111 2
727662 727662 27868 27868 PubChem (substance) 2 243113 243113 3
727663 727663 27868 27868 PubChem (substance) 2 259467 259467 4
982715 982715 27868 27868 CAS Common Chemistry 3 76213 76213 1
1185721 1185721 27868 27868 Computational Toxicology and Exposure Data 4 76213 76213 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)
);