home / zeropm-v0-0-4

api_results

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

16 rows where inchi_id = 42868

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
93037 93037 54578 54578 PubChem (compound) 1 42868 42868 1
93038 93038 54577 54577 PubChem (compound) 1 42868 42868 1
93039 93039 112271 112271 PubChem (compound) 1 42868 42868 1
427106 427106 108780 108780 PubChem (substance) 2 42868 42868 3
427107 427107 112271 112271 PubChem (substance) 2 42868 42868 1
427108 427108 54577 54577 PubChem (substance) 2 42868 42868 1
427109 427109 54578 54578 PubChem (substance) 2 42868 42868 1
745075 745075 54577 54577 PubChem (substance) 2 42868 42868 5
745076 745076 112271 112271 PubChem (substance) 2 42868 42868 4
1007111 1007111 112271 112271 CAS Common Chemistry 3 42868 42868 1
1007112 1007112 406339 406339 CAS Common Chemistry 3 42868 42868 1
1007113 1007113 54577 54577 CAS Common Chemistry 3 42868 42868 1
1007114 1007114 54578 54578 CAS Common Chemistry 3 42868 42868 1
1209039 1209039 54577 54577 Computational Toxicology and Exposure Data 4 42868 42868 1
1209040 1209040 406339 406339 Computational Toxicology and Exposure Data 4 42868 42868 1
1209041 1209041 112271 112271 Computational Toxicology and Exposure Data 4 42868 42868 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 2150.41ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website