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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
5315 5315 305247 305247 PubChem (compound) 1 76708 76708 2
108601 108601 305247 305247 PubChem (compound) 1 128820 128820 1
258734 258734 305247 305247 PubChem (compound) 1 139138 139138 3
302908 302908 305247 305247 PubChem (substance) 2 76708 76708 2
302923 302923 305247 305247 PubChem (substance) 2 74592 74592 10
302930 302930 305247 305247 PubChem (substance) 2 90233 90233 3
319264 319264 305247 305247 PubChem (substance) 2 4073 4073 8
329915 329915 305247 305247 PubChem (substance) 2 78292 78292 6
341788 341788 305247 305247 PubChem (substance) 2 5035 5035 12
449079 449079 305247 305247 PubChem (substance) 2 128820 128820 1
471799 471799 305247 305247 PubChem (substance) 2 51330 51330 4
642937 642937 305247 305247 PubChem (substance) 2 139138 139138 7
738698 738698 305247 305247 PubChem (substance) 2 151475 151475 5
771754 771754 305247 305247 PubChem (substance) 2 136871 136871 9
846589 846589 305247 305247 PubChem (substance) 2 232411 232411 11
846590 846590 305247 305247 PubChem (substance) 2 187790 187790 13
942037 942037 305247 305247 CAS Common Chemistry 3 76708 76708 4
942060 942060 305247 305247 CAS Common Chemistry 3 90233 90233 5
1009428 1009428 305247 305247 CAS Common Chemistry 3 6486 6486 1
1017779 1017779 305247 305247 CAS Common Chemistry 3 22780 22780 2
1028587 1028587 305247 305247 CAS Common Chemistry 3 51330 51330 3
1139456 1139456 305247 305247 Computational Toxicology and Exposure Data 4 76708 76708 2
1220114 1220114 305247 305247 Computational Toxicology and Exposure Data 4 128820 128820 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 411.623ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website