api_results

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

13 rows where inchi_id = 443

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
165989 165989 413490 413490 PubChem (compound) 1 443 443 1
165990 165990 146434 146434 PubChem (compound) 1 443 443 1
165991 165991 146435 146435 PubChem (compound) 1 443 443 1
526228 526228 15643 15643 PubChem (substance) 2 443 443 8
526229 526229 146434 146434 PubChem (substance) 2 443 443 1
526230 526230 146435 146435 PubChem (substance) 2 443 443 1
526231 526231 413490 413490 PubChem (substance) 2 443 443 1
1059634 1059634 146434 146434 CAS Common Chemistry 3 443 443 1
1059635 1059635 413490 413490 CAS Common Chemistry 3 443 443 1
1059636 1059636 146435 146435 CAS Common Chemistry 3 443 443 1
1262159 1262159 240702 240702 Computational Toxicology and Exposure Data 4 443 443 1
1262160 1262160 146434 146434 Computational Toxicology and Exposure Data 4 443 443 1
1262161 1262161 413490 413490 Computational Toxicology and Exposure Data 4 443 443 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)
);