api_results

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

10 rows where inchi_id = 5109

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
718751 718751 96571 96571 PubChem (substance) 2 5109 5109 2
718752 718752 19735 19735 PubChem (substance) 2 5109 5109 2
718753 718753 144768 144768 PubChem (substance) 2 5109 5109 2
718754 718754 144767 144767 PubChem (substance) 2 5109 5109 3
970415 970415 19736 19736 CAS Common Chemistry 3 5109 5109 1
970416 970416 19735 19735 CAS Common Chemistry 3 5109 5109 1
970417 970417 96571 96571 CAS Common Chemistry 3 5109 5109 1
1025901 1025901 96571 96571 CAS Common Chemistry 3 5109 5109 2
1025902 1025902 144767 144767 CAS Common Chemistry 3 5109 5109 1
1025903 1025903 144768 144768 CAS Common Chemistry 3 5109 5109 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)
);