api_results

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

14 rows where inchi_id = 152055

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
70460 70460 166228 166228 PubChem (compound) 1 152055 152055 1
70461 70461 417862 417862 PubChem (compound) 1 152055 152055 1
70462 70462 34671 34671 PubChem (compound) 1 152055 152055 1
70463 70463 34152 34152 PubChem (compound) 1 152055 152055 1
70464 70464 34672 34672 PubChem (compound) 1 152055 152055 1
70465 70465 34153 34153 PubChem (compound) 1 152055 152055 1
70466 70466 164444 164444 PubChem (compound) 1 152055 152055 1
395954 395954 34671 34671 PubChem (substance) 2 152055 152055 1
395955 395955 34672 34672 PubChem (substance) 2 152055 152055 1
395956 395956 417862 417862 PubChem (substance) 2 152055 152055 1
395957 395957 166228 166228 PubChem (substance) 2 152055 152055 1
395958 395958 34152 34152 PubChem (substance) 2 152055 152055 1
395959 395959 164444 164444 PubChem (substance) 2 152055 152055 2
395960 395960 34153 34153 PubChem (substance) 2 152055 152055 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)
);