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 = 104031

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
7389 7389 104031 104031 PubChem (compound) 1 60355 60355 1
305583 305583 104031 104031 PubChem (substance) 2 2054 2054 16
305754 305754 104031 104031 PubChem (substance) 2 60355 60355 1
310011 310011 104031 104031 PubChem (substance) 2 63043 63043 10
341500 341500 104031 104031 PubChem (substance) 2 4065 4065 11
351414 351414 104031 104031 PubChem (substance) 2 51044 51044 3
646680 646680 104031 104031 PubChem (substance) 2 149874 149874 6
671616 671616 104031 104031 PubChem (substance) 2 120281 120281 12
697786 697786 104031 104031 PubChem (substance) 2 255399 255399 14
697842 697842 104031 104031 PubChem (substance) 2 296183 296183 2
697845 697845 104031 104031 PubChem (substance) 2 204914 204914 4
697848 697848 104031 104031 PubChem (substance) 2 147746 147746 5
697851 697851 104031 104031 PubChem (substance) 2 169840 169840 7
697854 697854 104031 104031 PubChem (substance) 2 192411 192411 8
697856 697856 104031 104031 PubChem (substance) 2 220244 220244 9
697859 697859 104031 104031 PubChem (substance) 2 208139 208139 13
697863 697863 104031 104031 PubChem (substance) 2 253780 253780 15
943585 943585 104031 104031 CAS Common Chemistry 3 60355 60355 1
1141257 1141257 104031 104031 Computational Toxicology and Exposure Data 4 60355 60355 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 979.181ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website