api_results

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

11 rows where inchi_id = 41773

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
122367 122367 99996 99996 PubChem (compound) 1 41773 41773 1
122368 122368 397588 397588 PubChem (compound) 1 41773 41773 1
468247 468247 71150 71150 PubChem (substance) 2 41773 41773 2
468248 468248 99996 99996 PubChem (substance) 2 41773 41773 1
468249 468249 360653 360653 PubChem (substance) 2 41773 41773 2
468250 468250 310983 310983 PubChem (substance) 2 41773 41773 1
468251 468251 397588 397588 PubChem (substance) 2 41773 41773 1
468252 468252 348677 348677 PubChem (substance) 2 41773 41773 2
468253 468253 6421 6421 PubChem (substance) 2 41773 41773 2
468254 468254 134654 134654 PubChem (substance) 2 41773 41773 1
1027090 1027090 99996 99996 CAS Common Chemistry 3 41773 41773 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)
);