api_results

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

14 rows where query_id = 365708

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
41221 41221 365708 365708 PubChem (compound) 1 58572 58572 1
312295 312295 365708 365708 PubChem (substance) 2 3709 3709 5
339990 339990 365708 365708 PubChem (substance) 2 3728 3728 9
340308 340308 365708 365708 PubChem (substance) 2 4045 4045 8
343216 343216 365708 365708 PubChem (substance) 2 7017 7017 6
354381 354381 365708 365708 PubChem (substance) 2 58569 58569 4
354408 354408 365708 365708 PubChem (substance) 2 58572 58572 1
357924 357924 365708 365708 PubChem (substance) 2 4103 4103 7
357952 357952 365708 365708 PubChem (substance) 2 4109 4109 2
469790 469790 365708 365708 PubChem (substance) 2 136435 136435 3
709799 709799 365708 365708 PubChem (substance) 2 261392 261392 11
717500 717500 365708 365708 PubChem (substance) 2 327177 327177 10
968283 968283 365708 365708 CAS Common Chemistry 3 58572 58572 1
1170360 1170360 365708 365708 Computational Toxicology and Exposure Data 4 58572 58572 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)
);