api_results

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

13 rows where query_id = 375497

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
98405 98405 375497 375497 PubChem (compound) 1 191896 191896 3
268641 268641 375497 375497 PubChem (compound) 1 198307 198307 1
268642 268642 375497 375497 PubChem (compound) 1 191918 191918 2
268643 268643 375497 375497 PubChem (compound) 1 195784 195784 4
268644 268644 375497 375497 PubChem (compound) 1 195766 195766 5
268645 268645 375497 375497 PubChem (compound) 1 271525 271525 6
434768 434768 375497 375497 PubChem (substance) 2 191896 191896 3
658059 658059 375497 375497 PubChem (substance) 2 198307 198307 1
658060 658060 375497 375497 PubChem (substance) 2 191918 191918 2
658062 658062 375497 375497 PubChem (substance) 2 195784 195784 4
658064 658064 375497 375497 PubChem (substance) 2 195766 195766 7
658065 658065 375497 375497 PubChem (substance) 2 271525 271525 6
917831 917831 375497 375497 PubChem (substance) 2 228309 228309 5 
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)
);