api_results

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

10 rows where inchi_id = 171888

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
195370 195370 176909 176909 PubChem (compound) 1 171888 171888 3
564794 564794 32249 32249 PubChem (substance) 2 171888 171888 7
564795 564795 97958 97958 PubChem (substance) 2 171888 171888 2
564796 564796 257677 257677 PubChem (substance) 2 171888 171888 3
564797 564797 97946 97946 PubChem (substance) 2 171888 171888 2
564798 564798 28469 28469 PubChem (substance) 2 171888 171888 5
564799 564799 395446 395446 PubChem (substance) 2 171888 171888 3
564800 564800 35569 35569 PubChem (substance) 2 171888 171888 2
564801 564801 252972 252972 PubChem (substance) 2 171888 171888 2
564802 564802 176909 176909 PubChem (substance) 2 171888 171888 3 
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)
);