api_results

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

14 rows where inchi_id = 24395

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102756 102756 62322 62322 PubChem (compound) 1 24395 24395 1
182350 182350 163084 163084 PubChem (compound) 1 24395 24395 1
182351 182351 417090 417090 PubChem (compound) 1 24395 24395 1
441144 441144 62323 62323 PubChem (substance) 2 24395 24395 3
441145 441145 62322 62322 PubChem (substance) 2 24395 24395 1
547786 547786 163084 163084 PubChem (substance) 2 24395 24395 1
547787 547787 62322 62322 PubChem (substance) 2 24395 24395 3
547788 547788 165948 165948 PubChem (substance) 2 24395 24395 4
547789 547789 62323 62323 PubChem (substance) 2 24395 24395 1
547790 547790 417090 417090 PubChem (substance) 2 24395 24395 1
1013777 1013777 62322 62322 CAS Common Chemistry 3 24395 24395 1
1013778 1013778 417090 417090 CAS Common Chemistry 3 24395 24395 1
1013779 1013779 163084 163084 CAS Common Chemistry 3 24395 24395 1
1013780 1013780 62323 62323 CAS Common Chemistry 3 24395 24395 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)
);