api_results

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

8 rows where query_id = 398200

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
281610 281610 398200 398200 PubChem (compound) 1 24799 24799 1
431534 431534 398200 398200 PubChem (substance) 2 14032 14032 5
674366 674366 398200 398200 PubChem (substance) 2 24799 24799 1
931442 931442 398200 398200 PubChem (substance) 2 270483 270483 2
931443 931443 398200 398200 PubChem (substance) 2 241230 241230 3
931444 931444 398200 398200 PubChem (substance) 2 250924 250924 4
1124106 1124106 398200 398200 CAS Common Chemistry 3 24799 24799 1
1338118 1338118 398200 398200 Computational Toxicology and Exposure Data 4 24799 24799 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)
);