api_results

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

12 rows where inchi_id = 423

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
728396 728396 28636 28636 PubChem (substance) 2 423 423 3
728397 728397 62576 62576 PubChem (substance) 2 423 423 2
983091 983091 346552 346552 CAS Common Chemistry 3 423 423 1
983092 983092 28636 28636 CAS Common Chemistry 3 423 423 1
983093 983093 346549 346549 CAS Common Chemistry 3 423 423 1
983094 983094 84892 84892 CAS Common Chemistry 3 423 423 1
983095 983095 62576 62576 CAS Common Chemistry 3 423 423 1
983096 983096 346550 346550 CAS Common Chemistry 3 423 423 1
1013918 1013918 62575 62575 CAS Common Chemistry 3 423 423 1
1013919 1013919 62574 62574 CAS Common Chemistry 3 423 423 1
1013920 1013920 346549 346549 CAS Common Chemistry 3 423 423 2
1013921 1013921 346552 346552 CAS Common Chemistry 3 423 423 2 
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)
);