api_results

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

9 rows where query_id = 28969

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
61903 61903 28969 28969 PubChem (compound) 1 123111 123111 1
383056 383056 28969 28969 PubChem (substance) 2 103651 103651 4
383638 383638 28969 28969 PubChem (substance) 2 123111 123111 1
620801 620801 28969 28969 PubChem (substance) 2 119614 119614 5
728938 728938 28969 28969 PubChem (substance) 2 238328 238328 2
728939 728939 28969 28969 PubChem (substance) 2 332500 332500 3
728940 728940 28969 28969 PubChem (substance) 2 296319 296319 6
983657 983657 28969 28969 CAS Common Chemistry 3 1441 1441 1
1186641 1186641 28969 28969 Computational Toxicology and Exposure Data 4 123111 123111 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)
);