api_results

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

13 rows where inchi_id = 90

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
127159 127159 107555 107555 PubChem (compound) 1 90 90 1
127160 127160 107556 107556 PubChem (compound) 1 90 90 1
475039 475039 346654 346654 PubChem (substance) 2 90 90 1
475040 475040 107555 107555 PubChem (substance) 2 90 90 1
475041 475041 72353 72353 PubChem (substance) 2 90 90 2
475042 475042 346655 346655 PubChem (substance) 2 90 90 1
475043 475043 107556 107556 PubChem (substance) 2 90 90 1
1030337 1030337 107555 107555 CAS Common Chemistry 3 90 90 1
1030338 1030338 346654 346654 CAS Common Chemistry 3 90 90 1
1030339 1030339 346655 346655 CAS Common Chemistry 3 90 90 1
1030340 1030340 107556 107556 CAS Common Chemistry 3 90 90 1
1233215 1233215 107555 107555 Computational Toxicology and Exposure Data 4 90 90 1
1233216 1233216 346655 346655 Computational Toxicology and Exposure Data 4 90 90 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)
);