api_results

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

15 rows where inchi_id = 2253

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
127463 127463 107965 107965 PubChem (compound) 1 2253 2253 1
127464 127464 304683 304683 PubChem (compound) 1 2253 2253 1
127465 127465 107966 107966 PubChem (compound) 1 2253 2253 1
127466 127466 406441 406441 PubChem (compound) 1 2253 2253 1
475423 475423 406441 406441 PubChem (substance) 2 2253 2253 1
475424 475424 107966 107966 PubChem (substance) 2 2253 2253 1
475425 475425 288059 288059 PubChem (substance) 2 2253 2253 2
475426 475426 304682 304682 PubChem (substance) 2 2253 2253 2
475427 475427 304683 304683 PubChem (substance) 2 2253 2253 1
475428 475428 107965 107965 PubChem (substance) 2 2253 2253 1
475429 475429 288060 288060 PubChem (substance) 2 2253 2253 2
1030610 1030610 304683 304683 CAS Common Chemistry 3 2253 2253 1
1030611 1030611 107965 107965 CAS Common Chemistry 3 2253 2253 1
1030612 1030612 107966 107966 CAS Common Chemistry 3 2253 2253 1
1030613 1030613 406441 406441 CAS Common Chemistry 3 2253 2253 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)
);