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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
74581 74581 36791 36791 PubChem (compound) 1 193636 193636 1
74582 74582 36791 36791 PubChem (compound) 1 37783 37783 2
74583 74583 36791 36791 PubChem (compound) 1 192689 192689 3
74585 74585 36791 36791 PubChem (compound) 1 197573 197573 4
74586 74586 36791 36791 PubChem (compound) 1 249637 249637 5
74587 74587 36791 36791 PubChem (compound) 1 233993 233993 6
74588 74588 36791 36791 PubChem (compound) 1 320196 320196 7
74589 74589 36791 36791 PubChem (compound) 1 228315 228315 8
401644 401644 36791 36791 PubChem (substance) 2 193636 193636 1
401648 401648 36791 36791 PubChem (substance) 2 37783 37783 2
401653 401653 36791 36791 PubChem (substance) 2 192689 192689 3
401657 401657 36791 36791 PubChem (substance) 2 197573 197573 4
401663 401663 36791 36791 PubChem (substance) 2 249637 249637 5
401667 401667 36791 36791 PubChem (substance) 2 233993 233993 6
401670 401670 36791 36791 PubChem (substance) 2 320196 320196 8
401671 401671 36791 36791 PubChem (substance) 2 228315 228315 11
736111 736111 36791 36791 PubChem (substance) 2 196765 196765 7
736115 736115 36791 36791 PubChem (substance) 2 287900 287900 9
736116 736116 36791 36791 PubChem (substance) 2 234314 234314 10
992674 992674 36791 36791 CAS Common Chemistry 3 37783 37783 1
1195724 1195724 36791 36791 Computational Toxicology and Exposure Data 4 129218 129218 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.204ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website