home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 375870

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
269121 269121 375870 375870 PubChem (compound) 1 212946 212946 1
269122 269122 375870 375870 PubChem (compound) 1 227420 227420 2
269123 269123 375870 375870 PubChem (compound) 1 212945 212945 3
269124 269124 375870 375870 PubChem (compound) 1 177953 177953 4
269125 269125 375870 375870 PubChem (compound) 1 241149 241149 5
269126 269126 375870 375870 PubChem (compound) 1 212947 212947 6
269127 269127 375870 375870 PubChem (compound) 1 231838 231838 7
658660 658660 375870 375870 PubChem (substance) 2 212946 212946 1
658661 658661 375870 375870 PubChem (substance) 2 227420 227420 2
658662 658662 375870 375870 PubChem (substance) 2 212945 212945 3
658663 658663 375870 375870 PubChem (substance) 2 177953 177953 4
658664 658664 375870 375870 PubChem (substance) 2 241149 241149 5
658666 658666 375870 375870 PubChem (substance) 2 212947 212947 11
658667 658667 375870 375870 PubChem (substance) 2 231838 231838 9
744630 744630 375870 375870 PubChem (substance) 2 143750 143750 7
918542 918542 375870 375870 PubChem (substance) 2 243134 243134 6
918543 918543 375870 375870 PubChem (substance) 2 276103 276103 8
918544 918544 375870 375870 PubChem (substance) 2 257033 257033 10
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 712.953ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website