api_results

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

13 rows where inchi_id = 226171

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
18264 18264 9712 9712 PubChem (compound) 1 226171 226171 1
18265 18265 244585 244585 PubChem (compound) 1 226171 226171 1
18266 18266 244586 244586 PubChem (compound) 1 226171 226171 1
18267 18267 351147 351147 PubChem (compound) 1 226171 226171 1
18268 18268 441471 441471 PubChem (compound) 1 226171 226171 1
321481 321481 244586 244586 PubChem (substance) 2 226171 226171 1
321482 321482 244585 244585 PubChem (substance) 2 226171 226171 1
321483 321483 9712 9712 PubChem (substance) 2 226171 226171 1
321484 321484 9711 9711 PubChem (substance) 2 226171 226171 1
321485 321485 78255 78255 PubChem (substance) 2 226171 226171 1
321486 321486 351147 351147 PubChem (substance) 2 226171 226171 1
321487 321487 441471 441471 PubChem (substance) 2 226171 226171 1
321488 321488 351146 351146 PubChem (substance) 2 226171 226171 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)
);