api_results

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

13 rows where query_id = 12200

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
24012 24012 12200 12200 PubChem (compound) 1 79622 79622 1
330086 330086 12200 12200 PubChem (substance) 2 79622 79622 1
384788 384788 12200 12200 PubChem (substance) 2 185614 185614 2
484722 484722 12200 12200 PubChem (substance) 2 52393 52393 8
596809 596809 12200 12200 PubChem (substance) 2 77807 77807 3
709630 709630 12200 12200 PubChem (substance) 2 239024 239024 4
709632 709632 12200 12200 PubChem (substance) 2 199797 199797 5
709633 709633 12200 12200 PubChem (substance) 2 253112 253112 6
709635 709635 12200 12200 PubChem (substance) 2 250944 250944 7
709637 709637 12200 12200 PubChem (substance) 2 308360 308360 9
709639 709639 12200 12200 PubChem (substance) 2 259756 259756 10
955843 955843 12200 12200 CAS Common Chemistry 3 79622 79622 1
1155843 1155843 12200 12200 Computational Toxicology and Exposure Data 4 79622 79622 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)
);