api_results

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

13 rows where query_id = 102156

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
123590 123590 102156 102156 PubChem (compound) 1 229642 229642 1
123592 123592 102156 102156 PubChem (compound) 1 289276 289276 2
332310 332310 102156 102156 PubChem (substance) 2 23481 23481 8
470019 470019 102156 102156 PubChem (substance) 2 229642 229642 1
470023 470023 102156 102156 PubChem (substance) 2 289276 289276 2
470025 470025 102156 102156 PubChem (substance) 2 183483 183483 3
769963 769963 102156 102156 PubChem (substance) 2 229158 229158 4
769966 769966 102156 102156 PubChem (substance) 2 252721 252721 5
769968 769968 102156 102156 PubChem (substance) 2 230750 230750 6
769970 769970 102156 102156 PubChem (substance) 2 90559 90559 7
769972 769972 102156 102156 PubChem (substance) 2 189908 189908 9
1027842 1027842 102156 102156 CAS Common Chemistry 3 90559 90559 1
1230563 1230563 102156 102156 Computational Toxicology and Exposure Data 4 130728 130728 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)
);