api_results

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

12 rows where query_id = 122576

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
142593 142593 122576 122576 PubChem (compound) 1 7120 7120 1
495504 495504 122576 122576 PubChem (substance) 2 7120 7120 1
786751 786751 122576 122576 PubChem (substance) 2 137199 137199 2
786753 786753 122576 122576 PubChem (substance) 2 238992 238992 3
786755 786755 122576 122576 PubChem (substance) 2 247636 247636 4
786756 786756 122576 122576 PubChem (substance) 2 291184 291184 5
786758 786758 122576 122576 PubChem (substance) 2 154794 154794 6
786760 786760 122576 122576 PubChem (substance) 2 323948 323948 7
786761 786761 122576 122576 PubChem (substance) 2 233644 233644 8
786762 786762 122576 122576 PubChem (substance) 2 320774 320774 9
1042181 1042181 122576 122576 CAS Common Chemistry 3 7120 7120 1
1245117 1245117 122576 122576 Computational Toxicology and Exposure Data 4 7120 7120 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)
);