home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 191382

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
208899 208899 191382 191382 PubChem (compound) 1 62682 62682 1
208900 208900 191382 191382 PubChem (compound) 1 222484 222484 2
208901 208901 191382 191382 PubChem (compound) 1 139884 139884 3
208902 208902 191382 191382 PubChem (compound) 1 258375 258375 4
582117 582117 191382 191382 PubChem (substance) 2 62682 62682 1
582121 582121 191382 191382 PubChem (substance) 2 222484 222484 2
582123 582123 191382 191382 PubChem (substance) 2 139884 139884 5
582127 582127 191382 191382 PubChem (substance) 2 258375 258375 7
828738 828738 191382 191382 PubChem (substance) 2 225473 225473 3
828739 828739 191382 191382 PubChem (substance) 2 224769 224769 4
828740 828740 191382 191382 PubChem (substance) 2 258373 258373 6
828741 828741 191382 191382 PubChem (substance) 2 239327 239327 8
828742 828742 191382 191382 PubChem (substance) 2 222527 222527 9
828743 828743 191382 191382 PubChem (substance) 2 271654 271654 10
828744 828744 191382 191382 PubChem (substance) 2 291925 291925 11
828745 828745 191382 191382 PubChem (substance) 2 297890 297890 12
828746 828746 191382 191382 PubChem (substance) 2 277919 277919 13
828747 828747 191382 191382 PubChem (substance) 2 228964 228964 14
828748 828748 191382 191382 PubChem (substance) 2 267319 267319 15
1089941 1089941 191382 191382 CAS Common Chemistry 3 62682 62682 1
1291671 1291671 191382 191382 Computational Toxicology and Exposure Data 4 62682 62682 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 632.131ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website