home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 238612

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
158968 158968 238612 238612 PubChem (compound) 1 51478 51478 1
303371 303371 238612 238612 PubChem (substance) 2 58549 58549 8
305581 305581 238612 238612 PubChem (substance) 2 2054 2054 14
309337 309337 238612 238612 PubChem (substance) 2 3690 3690 9
310151 310151 238612 238612 PubChem (substance) 2 2666 2666 19
310202 310202 238612 238612 PubChem (substance) 2 3721 3721 7
340147 340147 238612 238612 PubChem (substance) 2 4032 4032 10
340232 340232 238612 238612 PubChem (substance) 2 4040 4040 18
341414 341414 238612 238612 PubChem (substance) 2 4055 4055 13
341495 341495 238612 238612 PubChem (substance) 2 4065 4065 3
366054 366054 238612 238612 PubChem (substance) 2 28116 28116 4
370239 370239 238612 238612 PubChem (substance) 2 42742 42742 6
371341 371341 238612 238612 PubChem (substance) 2 44389 44389 12
395510 395510 238612 238612 PubChem (substance) 2 25158 25158 15
428946 428946 238612 238612 PubChem (substance) 2 25145 25145 11
516907 516907 238612 238612 PubChem (substance) 2 51478 51478 1
548518 548518 238612 238612 PubChem (substance) 2 24986 24986 16
699929 699929 238612 238612 PubChem (substance) 2 270351 270351 17
797713 797713 238612 238612 PubChem (substance) 2 171319 171319 2
797716 797716 238612 238612 PubChem (substance) 2 169807 169807 5
1054462 1054462 238612 238612 CAS Common Chemistry 3 51478 51478 1
1257204 1257204 238612 238612 Computational Toxicology and Exposure Data 4 51478 51478 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 489.266ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website