api_results

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

10 rows where query_id = 2682

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
5050 5050 2682 2682 PubChem (compound) 1 10505 10505 1
302568 302568 2682 2682 PubChem (substance) 2 16773 16773 7
302574 302574 2682 2682 PubChem (substance) 2 10505 10505 1
386811 386811 2682 2682 PubChem (substance) 2 9273 9273 3
696377 696377 2682 2682 PubChem (substance) 2 243030 243030 2
696378 696378 2682 2682 PubChem (substance) 2 277662 277662 4
696379 696379 2682 2682 PubChem (substance) 2 223515 223515 5
696381 696381 2682 2682 PubChem (substance) 2 16729 16729 6
941825 941825 2682 2682 CAS Common Chemistry 3 10505 10505 1
1139183 1139183 2682 2682 Computational Toxicology and Exposure Data 4 10505 10505 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)
);