api_results

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

9 rows where inchi_id = 190649

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
294839 294839 441632 441632 PubChem (compound) 1 190649 190649 1
294840 294840 441633 441633 PubChem (compound) 1 190649 190649 1
691010 691010 142804 142804 PubChem (substance) 2 190649 190649 2
691011 691011 124341 124341 PubChem (substance) 2 190649 190649 4
691012 691012 142803 142803 PubChem (substance) 2 190649 190649 2
691013 691013 132494 132494 PubChem (substance) 2 190649 190649 3
691014 691014 441632 441632 PubChem (substance) 2 190649 190649 1
691015 691015 359874 359874 PubChem (substance) 2 190649 190649 3
691016 691016 441633 441633 PubChem (substance) 2 190649 190649 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)
);