api_results

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

20 rows where inchi_id = 928

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99707 99707 59953 59953 PubChem (compound) 1 928 928 1
99708 99708 146704 146704 PubChem (compound) 1 928 928 1
99709 99709 59954 59954 PubChem (compound) 1 928 928 1
99710 99710 327712 327712 PubChem (compound) 1 928 928 1
436795 436795 59953 59953 PubChem (substance) 2 928 928 1
436796 436796 397572 397572 PubChem (substance) 2 928 928 4
436797 436797 146704 146704 PubChem (substance) 2 928 928 1
436798 436798 327712 327712 PubChem (substance) 2 928 928 1
436799 436799 59954 59954 PubChem (substance) 2 928 928 1
749829 749829 59953 59953 PubChem (substance) 2 928 928 2
749830 749830 146704 146704 PubChem (substance) 2 928 928 2
749831 749831 397572 397572 PubChem (substance) 2 928 928 7
1011721 1011721 59953 59953 CAS Common Chemistry 3 928 928 1
1011722 1011722 146704 146704 CAS Common Chemistry 3 928 928 1
1011723 1011723 327712 327712 CAS Common Chemistry 3 928 928 1
1011724 1011724 59954 59954 CAS Common Chemistry 3 928 928 1
1213830 1213830 59954 59954 Computational Toxicology and Exposure Data 4 928 928 1
1213831 1213831 59953 59953 Computational Toxicology and Exposure Data 4 928 928 1
1213832 1213832 146704 146704 Computational Toxicology and Exposure Data 4 928 928 1
1213833 1213833 327712 327712 Computational Toxicology and Exposure Data 4 928 928 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)
);