home / zeropm-v0-0-4

api_results

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

18 rows where inchi_id = 77231

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
109988 109988 372051 372051 PubChem (compound) 1 77231 77231 1
109989 109989 305104 305104 PubChem (compound) 1 77231 77231 1
109990 109990 75911 75911 PubChem (compound) 1 77231 77231 1
109991 109991 302121 302121 PubChem (compound) 1 77231 77231 1
109992 109992 75912 75912 PubChem (compound) 1 77231 77231 1
450988 450988 27586 27586 PubChem (substance) 2 77231 77231 11
450989 450989 7531 7531 PubChem (substance) 2 77231 77231 5
450990 450990 75911 75911 PubChem (substance) 2 77231 77231 1
450991 450991 372051 372051 PubChem (substance) 2 77231 77231 1
450992 450992 323202 323202 PubChem (substance) 2 77231 77231 11
450993 450993 75912 75912 PubChem (substance) 2 77231 77231 1
450994 450994 370873 370873 PubChem (substance) 2 77231 77231 11
450995 450995 302121 302121 PubChem (substance) 2 77231 77231 1
450996 450996 305104 305104 PubChem (substance) 2 77231 77231 1
1018704 1018704 305104 305104 CAS Common Chemistry 3 77231 77231 1
1018705 1018705 372051 372051 CAS Common Chemistry 3 77231 77231 1
1018706 1018706 75911 75911 CAS Common Chemistry 3 77231 77231 1
1018707 1018707 302121 302121 CAS Common Chemistry 3 77231 77231 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)
);
Powered by Datasette · Queries took 481.938ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website