api_results

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

12 rows where inchi_id = 31615

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
714869 714869 16494 16494 PubChem (substance) 2 31615 31615 3
714870 714870 110863 110863 PubChem (substance) 2 31615 31615 3
714871 714871 437509 437509 PubChem (substance) 2 31615 31615 2
714872 714872 16495 16495 PubChem (substance) 2 31615 31615 2
964242 964242 16494 16494 CAS Common Chemistry 3 31615 31615 1
964243 964243 404652 404652 CAS Common Chemistry 3 31615 31615 1
964244 964244 110863 110863 CAS Common Chemistry 3 31615 31615 1
964245 964245 16495 16495 CAS Common Chemistry 3 31615 31615 1
964246 964246 437509 437509 CAS Common Chemistry 3 31615 31615 1
964247 964247 312458 312458 CAS Common Chemistry 3 31615 31615 1
1022854 1022854 87925 87925 CAS Common Chemistry 3 31615 31615 1
1022855 1022855 87926 87926 CAS Common Chemistry 3 31615 31615 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)
);