api_results

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

10 rows where query_id = 391194

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
670948 670948 391194 391194 PubChem (substance) 2 240685 240685 7
928323 928323 391194 391194 PubChem (substance) 2 242689 242689 1
928324 928324 391194 391194 PubChem (substance) 2 216845 216845 2
928325 928325 391194 391194 PubChem (substance) 2 194231 194231 3
928326 928326 391194 391194 PubChem (substance) 2 291183 291183 4
928327 928327 391194 391194 PubChem (substance) 2 258648 258648 5
928328 928328 391194 391194 PubChem (substance) 2 258880 258880 6
928329 928329 391194 391194 PubChem (substance) 2 295381 295381 8
928330 928330 391194 391194 PubChem (substance) 2 184570 184570 9
928332 928332 391194 391194 PubChem (substance) 2 247225 247225 10 
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)
);