api_results

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

13 rows where query_id = 20371

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
44447 44447 20371 20371 PubChem (compound) 1 7370 7370 3
45067 45067 20371 20371 PubChem (compound) 1 138373 138373 1
45068 45068 20371 20371 PubChem (compound) 1 232836 232836 2
358846 358846 20371 20371 PubChem (substance) 2 7370 7370 3
359940 359940 20371 20371 PubChem (substance) 2 138373 138373 1
359951 359951 20371 20371 PubChem (substance) 2 232836 232836 2
719677 719677 20371 20371 PubChem (substance) 2 282131 282131 4
719682 719682 20371 20371 PubChem (substance) 2 249120 249120 5
719683 719683 20371 20371 PubChem (substance) 2 248977 248977 6
719684 719684 20371 20371 PubChem (substance) 2 264578 264578 7
719687 719687 20371 20371 PubChem (substance) 2 292602 292602 8
719688 719688 20371 20371 PubChem (substance) 2 326246 326246 9
719692 719692 20371 20371 PubChem (substance) 2 264580 264580 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)
);