home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 15856

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
33940 33940 15856 15856 PubChem (compound) 1 130556 130556 1
33948 33948 15856 15856 PubChem (compound) 1 130556 130556 2
33951 33951 15856 15856 PubChem (compound) 1 7801 7801 3
33953 33953 15856 15856 PubChem (compound) 1 230121 230121 4
344121 344121 15856 15856 PubChem (substance) 2 130556 130556 1
344131 344131 15856 15856 PubChem (substance) 2 130556 130556 7
344138 344138 15856 15856 PubChem (substance) 2 7801 7801 9
344140 344140 15856 15856 PubChem (substance) 2 230121 230121 15
441022 441022 15856 15856 PubChem (substance) 2 267987 267987 4
452605 452605 15856 15856 PubChem (substance) 2 245401 245401 8
709527 709527 15856 15856 PubChem (substance) 2 136391 136391 3
713746 713746 15856 15856 PubChem (substance) 2 229306 229306 2
713753 713753 15856 15856 PubChem (substance) 2 332546 332546 5
713757 713757 15856 15856 PubChem (substance) 2 255538 255538 6
713763 713763 15856 15856 PubChem (substance) 2 197767 197767 10
713770 713770 15856 15856 PubChem (substance) 2 197769 197769 11
713778 713778 15856 15856 PubChem (substance) 2 197771 197771 12
713784 713784 15856 15856 PubChem (substance) 2 277630 277630 13
713791 713791 15856 15856 PubChem (substance) 2 310149 310149 14
713793 713793 15856 15856 PubChem (substance) 2 227352 227352 16
713794 713794 15856 15856 PubChem (substance) 2 264660 264660 17
962910 962910 15856 15856 CAS Common Chemistry 3 7801 7801 1
1164217 1164217 15856 15856 Computational Toxicology and Exposure Data 4 130556 130556 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 456.186ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website