api_results

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

12 rows where query_id = 140044

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
160228 160228 140044 140044 PubChem (compound) 1 122680 122680 1
160230 160230 140044 140044 PubChem (compound) 1 122680 122680 2
476135 476135 140044 140044 PubChem (substance) 2 4905 4905 6
518610 518610 140044 140044 PubChem (substance) 2 122680 122680 1
518612 518612 140044 140044 PubChem (substance) 2 122680 122680 3
775410 775410 140044 140044 PubChem (substance) 2 315451 315451 7
798625 798625 140044 140044 PubChem (substance) 2 315629 315629 2
798626 798626 140044 140044 PubChem (substance) 2 318232 318232 4
798627 798627 140044 140044 PubChem (substance) 2 343963 343963 5
798628 798628 140044 140044 PubChem (substance) 2 55298 55298 8
1055412 1055412 140044 140044 CAS Common Chemistry 3 55298 55298 1
1258084 1258084 140044 140044 Computational Toxicology and Exposure Data 4 122680 122680 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)
);