api_results

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

10 rows where inchi_id = 34545

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
93359 93359 54792 54792 PubChem (compound) 1 34545 34545 1
93360 93360 131762 131762 PubChem (compound) 1 34545 34545 1
93361 93361 311989 311989 PubChem (compound) 1 34545 34545 1
93362 93362 54793 54793 PubChem (compound) 1 34545 34545 1
427546 427546 54792 54792 PubChem (substance) 2 34545 34545 1
427547 427547 131762 131762 PubChem (substance) 2 34545 34545 1
427548 427548 54793 54793 PubChem (substance) 2 34545 34545 1
427549 427549 311989 311989 PubChem (substance) 2 34545 34545 1
1007339 1007339 54793 54793 CAS Common Chemistry 3 34545 34545 1
1007340 1007340 54792 54792 CAS Common Chemistry 3 34545 34545 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)
);