api_results

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

11 rows where query_id = 111301

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
130323 130323 111301 111301 PubChem (compound) 1 34964 34964 1
479301 479301 111301 111301 PubChem (substance) 2 34964 34964 1
557784 557784 111301 111301 PubChem (substance) 2 152244 152244 3
777891 777891 111301 111301 PubChem (substance) 2 170663 170663 2
777895 777895 111301 111301 PubChem (substance) 2 137908 137908 4
777897 777897 111301 111301 PubChem (substance) 2 238100 238100 5
777899 777899 111301 111301 PubChem (substance) 2 242098 242098 6
777900 777900 111301 111301 PubChem (substance) 2 262059 262059 7
777901 777901 111301 111301 PubChem (substance) 2 334449 334449 8
1032675 1032675 111301 111301 CAS Common Chemistry 3 34964 34964 1
1235606 1235606 111301 111301 Computational Toxicology and Exposure Data 4 34964 34964 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)
);