api_results

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

12 rows where query_id = 302117

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
321630 321630 302117 302117 PubChem (substance) 2 6233 6233 9
344858 344858 302117 302117 PubChem (substance) 2 10717 10717 1
448363 448363 302117 302117 PubChem (substance) 2 90455 90455 4
455876 455876 302117 302117 PubChem (substance) 2 90610 90610 12
463431 463431 302117 302117 PubChem (substance) 2 15906 15906 6
649560 649560 302117 302117 PubChem (substance) 2 19437 19437 7
657191 657191 302117 302117 PubChem (substance) 2 66669 66669 2
714042 714042 302117 302117 PubChem (substance) 2 137798 137798 8
846046 846046 302117 302117 PubChem (substance) 2 231907 231907 3
846049 846049 302117 302117 PubChem (substance) 2 136695 136695 5
846052 846052 302117 302117 PubChem (substance) 2 225494 225494 10
846055 846055 302117 302117 PubChem (substance) 2 258356 258356 11 
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)
);