api_results

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

9 rows where query_id = 327658

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
261556 261556 327658 327658 PubChem (compound) 1 263687 263687 1
309907 309907 327658 327658 PubChem (substance) 2 63043 63043 5
646825 646825 327658 327658 PubChem (substance) 2 263687 263687 1
817099 817099 327658 327658 PubChem (substance) 2 139563 139563 7
908324 908324 327658 327658 PubChem (substance) 2 266028 266028 2
908325 908325 327658 327658 PubChem (substance) 2 763 763 3
908326 908326 327658 327658 PubChem (substance) 2 332987 332987 4
908327 908327 327658 327658 PubChem (substance) 2 291156 291156 6
1114236 1114236 327658 327658 CAS Common Chemistry 3 763 763 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)
);