api_results

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

15 rows where query_id = 11302

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21456 21456 11302 11302 PubChem (compound) 1 48081 48081 1
326157 326157 11302 11302 PubChem (substance) 2 48081 48081 1
326161 326161 11302 11302 PubChem (substance) 2 179834 179834 9
707044 707044 11302 11302 PubChem (substance) 2 136284 136284 2
707050 707050 11302 11302 PubChem (substance) 2 207146 207146 3
707052 707052 11302 11302 PubChem (substance) 2 204326 204326 4
707057 707057 11302 11302 PubChem (substance) 2 208623 208623 5
707058 707058 11302 11302 PubChem (substance) 2 144340 144340 6
707062 707062 11302 11302 PubChem (substance) 2 249668 249668 7
707064 707064 11302 11302 PubChem (substance) 2 291098 291098 8
707066 707066 11302 11302 PubChem (substance) 2 202583 202583 10
707068 707068 11302 11302 PubChem (substance) 2 186336 186336 11
707071 707071 11302 11302 PubChem (substance) 2 197263 197263 12
954034 954034 11302 11302 CAS Common Chemistry 3 48081 48081 1
1153519 1153519 11302 11302 Computational Toxicology and Exposure Data 4 48081 48081 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)
);