api_results

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

10 rows where inchi_id = 189775

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28008 28008 36692 36692 PubChem (compound) 1 189775 189775 2
28009 28009 13656 13656 PubChem (compound) 1 189775 189775 2
28010 28010 13657 13657 PubChem (compound) 1 189775 189775 3
335549 335549 173395 173395 PubChem (substance) 2 189775 189775 1
335550 335550 36693 36693 PubChem (substance) 2 189775 189775 3
335551 335551 13656 13656 PubChem (substance) 2 189775 189775 2
335552 335552 13657 13657 PubChem (substance) 2 189775 189775 3
335553 335553 36692 36692 PubChem (substance) 2 189775 189775 2
335554 335554 173396 173396 PubChem (substance) 2 189775 189775 1
335555 335555 173519 173519 PubChem (substance) 2 189775 189775 3 
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)
);