api_results

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

14 rows where inchi_id = 68676

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
4547 4547 2400 2400 PubChem (compound) 1 68676 68676 1
4548 4548 306480 306480 PubChem (compound) 1 68676 68676 1
4549 4549 2401 2401 PubChem (compound) 1 68676 68676 1
4550 4550 296382 296382 PubChem (compound) 1 68676 68676 1
301900 301900 2400 2400 PubChem (substance) 2 68676 68676 1
301901 301901 97707 97707 PubChem (substance) 2 68676 68676 2
301902 301902 2401 2401 PubChem (substance) 2 68676 68676 1
301903 301903 296382 296382 PubChem (substance) 2 68676 68676 1
301904 301904 67944 67944 PubChem (substance) 2 68676 68676 2
301905 301905 306480 306480 PubChem (substance) 2 68676 68676 1
941492 941492 2400 2400 CAS Common Chemistry 3 68676 68676 1
941493 941493 296382 296382 CAS Common Chemistry 3 68676 68676 1
941494 941494 2401 2401 CAS Common Chemistry 3 68676 68676 1
941495 941495 306480 306480 CAS Common Chemistry 3 68676 68676 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)
);