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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
31370 31370 74836 74836 PubChem (compound) 1 4032 4032 1
303747 303747 74836 74836 PubChem (substance) 2 3505 3505 8
305587 305587 74836 74836 PubChem (substance) 2 2054 2054 5
305749 305749 74836 74836 PubChem (substance) 2 60355 60355 13
305879 305879 74836 74836 PubChem (substance) 2 3513 3513 9
309332 309332 74836 74836 PubChem (substance) 2 3690 3690 3
310149 310149 74836 74836 PubChem (substance) 2 2666 2666 7
310201 310201 74836 74836 PubChem (substance) 2 3721 3721 6
340034 340034 74836 74836 PubChem (substance) 2 3734 3734 4
340151 340151 74836 74836 PubChem (substance) 2 4032 4032 1
758527 758527 74836 74836 PubChem (substance) 2 154760 154760 2
758530 758530 74836 74836 PubChem (substance) 2 265173 265173 10
758531 758531 74836 74836 PubChem (substance) 2 265881 265881 11
758534 758534 74836 74836 PubChem (substance) 2 292846 292846 12
758535 758535 74836 74836 PubChem (substance) 2 274232 274232 14
758537 758537 74836 74836 PubChem (substance) 2 271544 271544 15
758542 758542 74836 74836 PubChem (substance) 2 227159 227159 16
758544 758544 74836 74836 PubChem (substance) 2 330487 330487 17
758547 758547 74836 74836 PubChem (substance) 2 250947 250947 18
758548 758548 74836 74836 PubChem (substance) 2 333241 333241 19
758550 758550 74836 74836 PubChem (substance) 2 219333 219333 20
961258 961258 74836 74836 CAS Common Chemistry 3 4032 4032 1
1162189 1162189 74836 74836 Computational Toxicology and Exposure Data 4 4032 4032 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 432.054ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website