api_results

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

13 rows where query_id = 333200

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
93815 93815 333200 333200 PubChem (compound) 1 134426 134426 1
93817 93817 333200 333200 PubChem (compound) 1 16380 16380 3
93821 93821 333200 333200 PubChem (compound) 1 173907 173907 2
428186 428186 333200 333200 PubChem (substance) 2 134426 134426 1
428192 428192 333200 333200 PubChem (substance) 2 16380 16380 3
428198 428198 333200 333200 PubChem (substance) 2 173907 173907 2
428212 428212 333200 333200 PubChem (substance) 2 6793 6793 7
428221 428221 333200 333200 PubChem (substance) 2 185650 185650 4
648431 648431 333200 333200 PubChem (substance) 2 200755 200755 6
910029 910029 333200 333200 PubChem (substance) 2 188366 188366 5
910030 910030 333200 333200 PubChem (substance) 2 175824 175824 8
1007675 1007675 333200 333200 CAS Common Chemistry 3 16380 16380 1
1209642 1209642 333200 333200 Computational Toxicology and Exposure Data 4 16380 16380 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)
);