home / zeropm-v0-0-4

api_results

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

25 rows where inchi_id = 47103

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
15026 15026 61728 61728 PubChem (compound) 1 47103 47103 1
15027 15027 72155 72155 PubChem (compound) 1 47103 47103 1
15028 15028 72154 72154 PubChem (compound) 1 47103 47103 1
15029 15029 11301 11301 PubChem (compound) 1 47103 47103 1
15030 15030 362504 362504 PubChem (compound) 1 47103 47103 1
15031 15031 61729 61729 PubChem (compound) 1 47103 47103 1
15032 15032 8032 8032 PubChem (compound) 1 47103 47103 1
15033 15033 8034 8034 PubChem (compound) 1 47103 47103 1
15034 15034 300890 300890 PubChem (compound) 1 47103 47103 1
316787 316787 300890 300890 PubChem (substance) 2 47103 47103 1
316788 316788 72154 72154 PubChem (substance) 2 47103 47103 1
316789 316789 8034 8034 PubChem (substance) 2 47103 47103 1
316790 316790 8032 8032 PubChem (substance) 2 47103 47103 1
316791 316791 362504 362504 PubChem (substance) 2 47103 47103 1
316792 316792 300891 300891 PubChem (substance) 2 47103 47103 5
316793 316793 61728 61728 PubChem (substance) 2 47103 47103 1
316794 316794 72155 72155 PubChem (substance) 2 47103 47103 1
316795 316795 11301 11301 PubChem (substance) 2 47103 47103 1
316796 316796 61729 61729 PubChem (substance) 2 47103 47103 1
949372 949372 300891 300891 CAS Common Chemistry 3 47103 47103 2
949373 949373 8032 8032 CAS Common Chemistry 3 47103 47103 1
949374 949374 72155 72155 CAS Common Chemistry 3 47103 47103 1
949375 949375 72154 72154 CAS Common Chemistry 3 47103 47103 1
949376 949376 11301 11301 CAS Common Chemistry 3 47103 47103 1
949377 949377 362504 362504 CAS Common Chemistry 3 47103 47103 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 495.899ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website