api_results

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

18 rows where query_id = 147114

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
326915 326915 147114 147114 PubChem (substance) 2 136425 136425 4
331630 331630 147114 147114 PubChem (substance) 2 136286 136286 3
331669 331669 147114 147114 PubChem (substance) 2 115990 115990 8
346127 346127 147114 147114 PubChem (substance) 2 1605 1605 1
376910 376910 147114 147114 PubChem (substance) 2 30468 30468 2
376921 376921 147114 147114 PubChem (substance) 2 203736 203736 5
376926 376926 147114 147114 PubChem (substance) 2 260074 260074 6
483855 483855 147114 147114 PubChem (substance) 2 49389 49389 11
706842 706842 147114 147114 PubChem (substance) 2 231788 231788 10
710133 710133 147114 147114 PubChem (substance) 2 169037 169037 9
728965 728965 147114 147114 PubChem (substance) 2 242013 242013 7
728968 728968 147114 147114 PubChem (substance) 2 211522 211522 12
728969 728969 147114 147114 PubChem (substance) 2 198519 198519 13
728972 728972 147114 147114 PubChem (substance) 2 214952 214952 14
728973 728973 147114 147114 PubChem (substance) 2 260354 260354 15
983696 983696 147114 147114 CAS Common Chemistry 3 1605 1605 1
1165422 1165422 147114 147114 Computational Toxicology and Exposure Data 4 12673 12673 1
1186675 1186675 147114 147114 Computational Toxicology and Exposure Data 4 1605 1605 2 
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)
);