api_results

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

10 rows where inchi_id = 314771

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
63079 63079 29787 29787 PubChem (compound) 1 314771 314771 1
63080 63080 242463 242463 PubChem (compound) 1 314771 314771 1
63081 63081 350058 350058 PubChem (compound) 1 314771 314771 1
63082 63082 79542 79542 PubChem (compound) 1 314771 314771 1
385487 385487 29787 29787 PubChem (substance) 2 314771 314771 1
385488 385488 25290 25290 PubChem (substance) 2 314771 314771 3
385489 385489 29786 29786 PubChem (substance) 2 314771 314771 1
385490 385490 242463 242463 PubChem (substance) 2 314771 314771 1
385491 385491 79542 79542 PubChem (substance) 2 314771 314771 1
385492 385492 350058 350058 PubChem (substance) 2 314771 314771 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)
);