home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 387738

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
276691 276691 387738 387738 PubChem (compound) 1 143941 143941 1
276692 276692 387738 387738 PubChem (compound) 1 71644 71644 2
276693 276693 387738 387738 PubChem (compound) 1 262072 262072 3
276694 276694 387738 387738 PubChem (compound) 1 198339 198339 4
276695 276695 387738 387738 PubChem (compound) 1 237873 237873 5
276696 276696 387738 387738 PubChem (compound) 1 322064 322064 6
668133 668133 387738 387738 PubChem (substance) 2 143941 143941 1
668134 668134 387738 387738 PubChem (substance) 2 71644 71644 2
668135 668135 387738 387738 PubChem (substance) 2 262072 262072 3
668136 668136 387738 387738 PubChem (substance) 2 198339 198339 9
668137 668137 387738 387738 PubChem (substance) 2 237873 237873 11
668138 668138 387738 387738 PubChem (substance) 2 322064 322064 10
781736 781736 387738 387738 PubChem (substance) 2 95955 95955 4
925818 925818 387738 387738 PubChem (substance) 2 240038 240038 5
925819 925819 387738 387738 PubChem (substance) 2 240658 240658 6
925820 925820 387738 387738 PubChem (substance) 2 332445 332445 7
925821 925821 387738 387738 PubChem (substance) 2 226075 226075 8
1121707 1121707 387738 387738 CAS Common Chemistry 3 71644 71644 1
1334970 1334970 387738 387738 Computational Toxicology and Exposure Data 4 100660 100660 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 2381.413ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website