api_results

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

14 rows where inchi_id = 139175

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99645 99645 59897 59897 PubChem (compound) 1 139175 139175 1
436696 436696 30886 30886 PubChem (substance) 2 139175 139175 2
436697 436697 19556 19556 PubChem (substance) 2 139175 139175 10
436698 436698 30887 30887 PubChem (substance) 2 139175 139175 2
436699 436699 126103 126103 PubChem (substance) 2 139175 139175 3
436700 436700 57437 57437 PubChem (substance) 2 139175 139175 6
436701 436701 331788 331788 PubChem (substance) 2 139175 139175 2
436702 436702 59897 59897 PubChem (substance) 2 139175 139175 1
436703 436703 126102 126102 PubChem (substance) 2 139175 139175 2
436704 436704 59898 59898 PubChem (substance) 2 139175 139175 3
436705 436705 119936 119936 PubChem (substance) 2 139175 139175 4
436706 436706 152414 152414 PubChem (substance) 2 139175 139175 2
436707 436707 233719 233719 PubChem (substance) 2 139175 139175 4
436708 436708 331789 331789 PubChem (substance) 2 139175 139175 3 
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)
);