home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 9873

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
18721 18721 9873 9873 PubChem (compound) 1 7814 7814 1
322117 322117 9873 9873 PubChem (substance) 2 7814 7814 1
322127 322127 9873 9873 PubChem (substance) 2 136466 136466 2
456932 456932 9873 9873 PubChem (substance) 2 137782 137782 4
456982 456982 9873 9873 PubChem (substance) 2 52391 52391 13
456988 456988 9873 9873 PubChem (substance) 2 169143 169143 9
484711 484711 9873 9873 PubChem (substance) 2 177859 177859 6
645468 645468 9873 9873 PubChem (substance) 2 190639 190639 18
656492 656492 9873 9873 PubChem (substance) 2 189480 189480 3
705249 705249 9873 9873 PubChem (substance) 2 277406 277406 5
705255 705255 9873 9873 PubChem (substance) 2 237760 237760 7
705258 705258 9873 9873 PubChem (substance) 2 239250 239250 8
705262 705262 9873 9873 PubChem (substance) 2 173351 173351 10
705270 705270 9873 9873 PubChem (substance) 2 195505 195505 11
705278 705278 9873 9873 PubChem (substance) 2 213929 213929 12
705281 705281 9873 9873 PubChem (substance) 2 277345 277345 14
705282 705282 9873 9873 PubChem (substance) 2 291836 291836 15
705285 705285 9873 9873 PubChem (substance) 2 257204 257204 16
705286 705286 9873 9873 PubChem (substance) 2 309772 309772 17
952148 952148 9873 9873 CAS Common Chemistry 3 7814 7814 1
1151359 1151359 9873 9873 Computational Toxicology and Exposure Data 4 7814 7814 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 446.295ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website