api_results

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

16 rows where query_id = 300891

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
316792 316792 300891 300891 PubChem (substance) 2 47103 47103 5
330063 330063 300891 300891 PubChem (substance) 2 79609 79609 1
355457 355457 300891 300891 PubChem (substance) 2 190604 190604 6
361818 361818 300891 300891 PubChem (substance) 2 15414 15414 4
369540 369540 300891 300891 PubChem (substance) 2 7286 7286 8
440107 440107 300891 300891 PubChem (substance) 2 54850 54850 3
476029 476029 300891 300891 PubChem (substance) 2 4641 4641 2
570868 570868 300891 300891 PubChem (substance) 2 100410 100410 10
845823 845823 300891 300891 PubChem (substance) 2 169511 169511 7
845824 845824 300891 300891 PubChem (substance) 2 152279 152279 9
949372 949372 300891 300891 CAS Common Chemistry 3 47103 47103 2
955829 955829 300891 300891 CAS Common Chemistry 3 79609 79609 4
1013297 1013297 300891 300891 CAS Common Chemistry 3 54850 54850 3
1030916 1030916 300891 300891 CAS Common Chemistry 3 4641 4641 1
1155828 1155828 300891 300891 Computational Toxicology and Exposure Data 4 79609 79609 2
1215435 1215435 300891 300891 Computational Toxicology and Exposure Data 4 54850 54850 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)
);