home / zeropm-v0-0-4

api_results

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

27 rows where inchi_id = 28741

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
126850 126850 107144 107144 PubChem (compound) 1 28741 28741 1
126851 126851 107145 107145 PubChem (compound) 1 28741 28741 1
126852 126852 405746 405746 PubChem (compound) 1 28741 28741 1
126853 126853 295847 295847 PubChem (compound) 1 28741 28741 1
126854 126854 375887 375887 PubChem (compound) 1 28741 28741 1
126855 126855 385167 385167 PubChem (compound) 1 28741 28741 1
474641 474641 13215 13215 PubChem (substance) 2 28741 28741 3
474642 474642 405746 405746 PubChem (substance) 2 28741 28741 1
474643 474643 107144 107144 PubChem (substance) 2 28741 28741 1
474644 474644 385167 385167 PubChem (substance) 2 28741 28741 1
474645 474645 375887 375887 PubChem (substance) 2 28741 28741 2
474646 474646 296476 296476 PubChem (substance) 2 28741 28741 2
474647 474647 107145 107145 PubChem (substance) 2 28741 28741 1
474648 474648 296477 296477 PubChem (substance) 2 28741 28741 2
474649 474649 107287 107287 PubChem (substance) 2 28741 28741 2
474650 474650 296478 296478 PubChem (substance) 2 28741 28741 2
474651 474651 135644 135644 PubChem (substance) 2 28741 28741 2
474652 474652 295847 295847 PubChem (substance) 2 28741 28741 1
474653 474653 385172 385172 PubChem (substance) 2 28741 28741 1
474654 474654 296479 296479 PubChem (substance) 2 28741 28741 2
474655 474655 296269 296269 PubChem (substance) 2 28741 28741 2
1030089 1030089 405746 405746 CAS Common Chemistry 3 28741 28741 1
1030090 1030090 295847 295847 CAS Common Chemistry 3 28741 28741 1
1030091 1030091 107144 107144 CAS Common Chemistry 3 28741 28741 1
1030092 1030092 107145 107145 CAS Common Chemistry 3 28741 28741 1
1120943 1120943 385172 385172 CAS Common Chemistry 3 28741 28741 1
1120944 1120944 385167 385167 CAS Common Chemistry 3 28741 28741 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 765.636ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website