home / zeropm-v0-0-4

api_results

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

18 rows where inchi_id = 31904

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
129879 129879 406910 406910 PubChem (compound) 1 31904 31904 1
129880 129880 110909 110909 PubChem (compound) 1 31904 31904 1
129881 129881 110910 110910 PubChem (compound) 1 31904 31904 1
478699 478699 4789 4789 PubChem (substance) 2 31904 31904 2
478700 478700 81243 81243 PubChem (substance) 2 31904 31904 6
478701 478701 110909 110909 PubChem (substance) 2 31904 31904 1
478702 478702 406910 406910 PubChem (substance) 2 31904 31904 1
478703 478703 84848 84848 PubChem (substance) 2 31904 31904 2
478704 478704 110910 110910 PubChem (substance) 2 31904 31904 2
478705 478705 38440 38440 PubChem (substance) 2 31904 31904 4
478706 478706 110909 110909 PubChem (substance) 2 31904 31904 2
478707 478707 406910 406910 PubChem (substance) 2 31904 31904 2
478708 478708 110910 110910 PubChem (substance) 2 31904 31904 1
1032330 1032330 110909 110909 CAS Common Chemistry 3 31904 31904 1
1032331 1032331 406910 406910 CAS Common Chemistry 3 31904 31904 1
1235247 1235247 110910 110910 Computational Toxicology and Exposure Data 4 31904 31904 1
1235248 1235248 110909 110909 Computational Toxicology and Exposure Data 4 31904 31904 1
1235249 1235249 406910 406910 Computational Toxicology and Exposure Data 4 31904 31904 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 1882.845ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website