api_results

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

13 rows where inchi_id = 235019

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
169898 169898 150633 150633 PubChem (compound) 1 235019 235019 6
169899 169899 185108 185108 PubChem (compound) 1 235019 235019 3
169911 169911 150633 150633 PubChem (compound) 1 235019 235019 13
531613 531613 150633 150633 PubChem (substance) 2 235019 235019 9
531614 531614 150634 150634 PubChem (substance) 2 235019 235019 23
531615 531615 185108 185108 PubChem (substance) 2 235019 235019 3
531627 531627 150633 150633 PubChem (substance) 2 235019 235019 14
805378 805378 162554 162554 PubChem (substance) 2 235019 235019 5
805379 805379 150633 150633 PubChem (substance) 2 235019 235019 18
805380 805380 150634 150634 PubChem (substance) 2 235019 235019 10
805381 805381 185109 185109 PubChem (substance) 2 235019 235019 8
813445 813445 162554 162554 PubChem (substance) 2 235019 235019 6
813446 813446 185109 185109 PubChem (substance) 2 235019 235019 9 
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)
);