home / zeropm-v0-0-4

api_results

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

26 rows where query_id = 24699

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
54682 54682 24699 24699 PubChem (compound) 1 133510 133510 1
54686 54686 24699 24699 PubChem (compound) 1 50858 50858 2
54687 54687 24699 24699 PubChem (compound) 1 314266 314266 3
54688 54688 24699 24699 PubChem (compound) 1 133510 133510 4
54689 54689 24699 24699 PubChem (compound) 1 133510 133510 5
372976 372976 24699 24699 PubChem (substance) 2 133510 133510 1
372984 372984 24699 24699 PubChem (substance) 2 50858 50858 3
372985 372985 24699 24699 PubChem (substance) 2 314266 314266 5
372986 372986 24699 24699 PubChem (substance) 2 133510 133510 6
372987 372987 24699 24699 PubChem (substance) 2 133510 133510 11
709668 709668 24699 24699 PubChem (substance) 2 238390 238390 16
724099 724099 24699 24699 PubChem (substance) 2 315114 315114 2
724101 724101 24699 24699 PubChem (substance) 2 332371 332371 4
724104 724104 24699 24699 PubChem (substance) 2 314012 314012 7
724108 724108 24699 24699 PubChem (substance) 2 315569 315569 8
724109 724109 24699 24699 PubChem (substance) 2 266812 266812 9
724110 724110 24699 24699 PubChem (substance) 2 274897 274897 10
724112 724112 24699 24699 PubChem (substance) 2 318079 318079 12
724113 724113 24699 24699 PubChem (substance) 2 318108 318108 13
724114 724114 24699 24699 PubChem (substance) 2 318123 318123 14
724115 724115 24699 24699 PubChem (substance) 2 238389 238389 15
724116 724116 24699 24699 PubChem (substance) 2 326533 326533 17
724117 724117 24699 24699 PubChem (substance) 2 238389 238389 18
724119 724119 24699 24699 PubChem (substance) 2 326533 326533 19
978150 978150 24699 24699 CAS Common Chemistry 3 50858 50858 1
1181022 1181022 24699 24699 Computational Toxicology and Exposure Data 4 133510 133510 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 672.004ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website