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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
3273 3273 27319 27319 PubChem (compound) 1 73654 73654 1
300079 300079 27319 27319 PubChem (substance) 2 73654 73654 1
375503 375503 27319 27319 PubChem (substance) 2 106602 106602 12
394567 394567 27319 27319 PubChem (substance) 2 121932 121932 9
394578 394578 27319 27319 PubChem (substance) 2 212272 212272 13
592299 592299 27319 27319 PubChem (substance) 2 96137 96137 10
659568 659568 27319 27319 PubChem (substance) 2 124382 124382 2
694707 694707 27319 27319 PubChem (substance) 2 232173 232173 3
694710 694710 27319 27319 PubChem (substance) 2 190893 190893 4
694713 694713 27319 27319 PubChem (substance) 2 190912 190912 5
694716 694716 27319 27319 PubChem (substance) 2 191014 191014 6
694719 694719 27319 27319 PubChem (substance) 2 191015 191015 7
694723 694723 27319 27319 PubChem (substance) 2 273578 273578 8
694727 694727 27319 27319 PubChem (substance) 2 139110 139110 11
694733 694733 27319 27319 PubChem (substance) 2 172867 172867 14
694736 694736 27319 27319 PubChem (substance) 2 227831 227831 15
940478 940478 27319 27319 CAS Common Chemistry 3 73654 73654 1
1137648 1137648 27319 27319 Computational Toxicology and Exposure Data 4 73654 73654 1
1137653 1137653 27319 27319 Computational Toxicology and Exposure Data 4 124382 124382 2
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 812.858ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website