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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
493399 493399 350625 350625 PubChem (substance) 2 235264 235264 14
493407 493407 350625 350625 PubChem (substance) 2 186087 186087 3
785711 785711 350625 350625 PubChem (substance) 2 231933 231933 12
786829 786829 350625 350625 PubChem (substance) 2 141289 141289 1
786830 786830 350625 350625 PubChem (substance) 2 285527 285527 11
786833 786833 350625 350625 PubChem (substance) 2 261751 261751 2
786835 786835 350625 350625 PubChem (substance) 2 239057 239057 8
786838 786838 350625 350625 PubChem (substance) 2 270178 270178 4
786840 786840 350625 350625 PubChem (substance) 2 276462 276462 5
786842 786842 350625 350625 PubChem (substance) 2 243377 243377 18
786844 786844 350625 350625 PubChem (substance) 2 307819 307819 10
786846 786846 350625 350625 PubChem (substance) 2 322035 322035 6
786849 786849 350625 350625 PubChem (substance) 2 246721 246721 15
786851 786851 350625 350625 PubChem (substance) 2 270210 270210 9
786853 786853 350625 350625 PubChem (substance) 2 207302 207302 7
786855 786855 350625 350625 PubChem (substance) 2 255540 255540 16
786857 786857 350625 350625 PubChem (substance) 2 277419 277419 20
786859 786859 350625 350625 PubChem (substance) 2 333637 333637 22
786861 786861 350625 350625 PubChem (substance) 2 333038 333038 23
840297 840297 350625 350625 PubChem (substance) 2 232096 232096 13
915036 915036 350625 350625 PubChem (substance) 2 255628 255628 17
915037 915037 350625 350625 PubChem (substance) 2 261272 261272 19
915038 915038 350625 350625 PubChem (substance) 2 238746 238746 21
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 458.327ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website