home / zeropm-v0-0-4

api_results

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

16 rows where inchi_id = 16127

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
46514 46514 283445 283445 PubChem (compound) 1 16127 16127 1
46515 46515 21012 21012 PubChem (compound) 1 16127 16127 1
46516 46516 21011 21011 PubChem (compound) 1 16127 16127 1
46517 46517 124496 124496 PubChem (compound) 1 16127 16127 1
46518 46518 354279 354279 PubChem (compound) 1 16127 16127 1
362096 362096 21011 21011 PubChem (substance) 2 16127 16127 1
362097 362097 21012 21012 PubChem (substance) 2 16127 16127 1
362098 362098 35659 35659 PubChem (substance) 2 16127 16127 2
362099 362099 35660 35660 PubChem (substance) 2 16127 16127 2
362100 362100 124496 124496 PubChem (substance) 2 16127 16127 1
362101 362101 283445 283445 PubChem (substance) 2 16127 16127 1
362102 362102 358743 358743 PubChem (substance) 2 16127 16127 2
362103 362103 354279 354279 PubChem (substance) 2 16127 16127 1
971888 971888 283445 283445 CAS Common Chemistry 3 16127 16127 1
971889 971889 21012 21012 CAS Common Chemistry 3 16127 16127 1
971890 971890 21011 21011 CAS Common Chemistry 3 16127 16127 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 1183.522ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website