api_results

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

13 rows where query_id = 318596

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124391 124391 318596 318596 PubChem (compound) 1 206036 206036 2
124398 124398 318596 318596 PubChem (compound) 1 205828 205828 1
260586 260586 318596 318596 PubChem (compound) 1 320322 320322 3
260587 260587 318596 318596 PubChem (compound) 1 204458 204458 4
471135 471135 318596 318596 PubChem (substance) 2 206036 206036 2
471146 471146 318596 318596 PubChem (substance) 2 205828 205828 1
645644 645644 318596 318596 PubChem (substance) 2 320322 320322 4
645645 645645 318596 318596 PubChem (substance) 2 204458 204458 7
645647 645647 318596 318596 PubChem (substance) 2 254040 254040 3
645649 645649 318596 318596 PubChem (substance) 2 201341 201341 6
848309 848309 318596 318596 PubChem (substance) 2 249896 249896 5
848311 848311 318596 318596 PubChem (substance) 2 266437 266437 8
848312 848312 318596 318596 PubChem (substance) 2 243506 243506 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)
);