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 = 39545

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
51887 51887 23360 23360 PubChem (compound) 1 39545 39545 1
51888 51888 23359 23359 PubChem (compound) 1 39545 39545 1
51889 51889 440205 440205 PubChem (compound) 1 39545 39545 1
51890 51890 237068 237068 PubChem (compound) 1 39545 39545 1
51891 51891 133738 133738 PubChem (compound) 1 39545 39545 1
369243 369243 440205 440205 PubChem (substance) 2 39545 39545 1
369244 369244 23359 23359 PubChem (substance) 2 39545 39545 1
369245 369245 23360 23360 PubChem (substance) 2 39545 39545 1
369246 369246 136902 136902 PubChem (substance) 2 39545 39545 4
369247 369247 374030 374030 PubChem (substance) 2 39545 39545 2
369248 369248 137009 137009 PubChem (substance) 2 39545 39545 5
369249 369249 133738 133738 PubChem (substance) 2 39545 39545 1
369250 369250 237068 237068 PubChem (substance) 2 39545 39545 1
369251 369251 142581 142581 PubChem (substance) 2 39545 39545 2
369252 369252 153883 153883 PubChem (substance) 2 39545 39545 8
976010 976010 23359 23359 CAS Common Chemistry 3 39545 39545 1
976011 976011 23360 23360 CAS Common Chemistry 3 39545 39545 1
976012 976012 440205 440205 CAS Common Chemistry 3 39545 39545 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 1060.911ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website