home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 101

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
229 229 101 101 PubChem (compound) 1 55055 55055 1
295814 295814 101 101 PubChem (substance) 2 55055 55055 1
426937 426937 101 101 PubChem (substance) 2 56712 56712 19
486021 486021 101 101 PubChem (substance) 2 55227 55227 13
508127 508127 101 101 PubChem (substance) 2 35273 35273 7
692139 692139 101 101 PubChem (substance) 2 208270 208270 2
692142 692142 101 101 PubChem (substance) 2 138229 138229 3
692147 692147 101 101 PubChem (substance) 2 143682 143682 4
692150 692150 101 101 PubChem (substance) 2 177342 177342 5
692154 692154 101 101 PubChem (substance) 2 139685 139685 6
692156 692156 101 101 PubChem (substance) 2 141955 141955 8
692159 692159 101 101 PubChem (substance) 2 259457 259457 9
692163 692163 101 101 PubChem (substance) 2 259458 259458 10
692165 692165 101 101 PubChem (substance) 2 201556 201556 11
692168 692168 101 101 PubChem (substance) 2 283633 283633 12
692172 692172 101 101 PubChem (substance) 2 243841 243841 14
692173 692173 101 101 PubChem (substance) 2 184050 184050 15
692178 692178 101 101 PubChem (substance) 2 323916 323916 16
692181 692181 101 101 PubChem (substance) 2 323921 323921 17
692183 692183 101 101 PubChem (substance) 2 323922 323922 18
692185 692185 101 101 PubChem (substance) 2 215211 215211 20
692188 692188 101 101 PubChem (substance) 2 227167 227167 21
938310 938310 101 101 CAS Common Chemistry 3 55055 55055 1
1134946 1134946 101 101 Computational Toxicology and Exposure Data 4 55055 55055 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 459.51ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website