api_results

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

7 rows where inchi_id = 274886

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
735559 735559 36014 36014 PubChem (substance) 2 274886 274886 2
735560 735560 95769 95769 PubChem (substance) 2 274886 274886 2
735561 735561 36015 36015 PubChem (substance) 2 274886 274886 1
735562 735562 170869 170869 PubChem (substance) 2 274886 274886 1
735563 735563 45727 45727 PubChem (substance) 2 274886 274886 3
735564 735564 45728 45728 PubChem (substance) 2 274886 274886 1
735565 735565 337286 337286 PubChem (substance) 2 274886 274886 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)
);