home / zeropm-v0-0-4

api_results

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

21 rows where inchi_id = 47797

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
68631 68631 339454 339454 PubChem (compound) 1 47797 47797 1
68632 68632 33045 33045 PubChem (compound) 1 47797 47797 1
68633 68633 113914 113914 PubChem (compound) 1 47797 47797 1
68634 68634 113913 113913 PubChem (compound) 1 47797 47797 1
68635 68635 33044 33044 PubChem (compound) 1 47797 47797 1
68636 68636 232001 232001 PubChem (compound) 1 47797 47797 1
393434 393434 33044 33044 PubChem (substance) 2 47797 47797 1
393435 393435 113913 113913 PubChem (substance) 2 47797 47797 1
393436 393436 33045 33045 PubChem (substance) 2 47797 47797 1
393437 393437 339454 339454 PubChem (substance) 2 47797 47797 1
393438 393438 164874 164874 PubChem (substance) 2 47797 47797 2
393439 393439 232001 232001 PubChem (substance) 2 47797 47797 1
393440 393440 113914 113914 PubChem (substance) 2 47797 47797 1
1034948 1034948 113913 113913 CAS Common Chemistry 3 47797 47797 1
1034949 1034949 339454 339454 CAS Common Chemistry 3 47797 47797 1
1034950 1034950 113914 113914 CAS Common Chemistry 3 47797 47797 1
1034951 1034951 232001 232001 CAS Common Chemistry 3 47797 47797 1
1237927 1237927 113913 113913 Computational Toxicology and Exposure Data 4 47797 47797 1
1237928 1237928 339454 339454 Computational Toxicology and Exposure Data 4 47797 47797 1
1237929 1237929 113914 113914 Computational Toxicology and Exposure Data 4 47797 47797 1
1237930 1237930 232001 232001 Computational Toxicology and Exposure Data 4 47797 47797 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 1312.395ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website