api_results

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

10 rows where inchi_id = 139299

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
100640 100640 60661 60661 PubChem (compound) 1 139299 139299 1
100641 100641 60660 60660 PubChem (compound) 1 139299 139299 1
438142 438142 60660 60660 PubChem (substance) 2 139299 139299 1
438143 438143 158966 158966 PubChem (substance) 2 139299 139299 1
438144 438144 60661 60661 PubChem (substance) 2 139299 139299 1
438145 438145 147904 147904 PubChem (substance) 2 139299 139299 7
438146 438146 351087 351087 PubChem (substance) 2 139299 139299 2
438147 438147 441003 441003 PubChem (substance) 2 139299 139299 7
750908 750908 60660 60660 PubChem (substance) 2 139299 139299 3
750909 750909 60661 60661 PubChem (substance) 2 139299 139299 2 
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)
);