api_results

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

9 rows where inchi_id = 51283

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
267602 267602 363537 363537 PubChem (compound) 1 51283 51283 1
267603 267603 363538 363538 PubChem (compound) 1 51283 51283 1
656669 656669 363537 363537 PubChem (substance) 2 51283 51283 1
656670 656670 363538 363538 PubChem (substance) 2 51283 51283 1
656671 656671 262800 262800 PubChem (substance) 2 51283 51283 2
1032479 1032479 387864 387864 CAS Common Chemistry 3 51283 51283 1
1032480 1032480 111082 111082 CAS Common Chemistry 3 51283 51283 2
1032481 1032481 363538 363538 CAS Common Chemistry 3 51283 51283 1
1032482 1032482 363537 363537 CAS Common Chemistry 3 51283 51283 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)
);