api_results

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

14 rows where inchi_id = 242204

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
107530 107530 71397 71397 PubChem (compound) 1 242204 242204 1
107531 107531 340811 340811 PubChem (compound) 1 242204 242204 1
107532 107532 105047 105047 PubChem (compound) 1 242204 242204 1
107533 107533 230150 230150 PubChem (compound) 1 242204 242204 1
107534 107534 366484 366484 PubChem (compound) 1 242204 242204 2
447704 447704 11516 11516 PubChem (substance) 2 242204 242204 13
447705 447705 71397 71397 PubChem (substance) 2 242204 242204 1
447706 447706 230150 230150 PubChem (substance) 2 242204 242204 1
447707 447707 366484 366484 PubChem (substance) 2 242204 242204 2
447708 447708 83804 83804 PubChem (substance) 2 242204 242204 5
447709 447709 340811 340811 PubChem (substance) 2 242204 242204 1
447710 447710 105176 105176 PubChem (substance) 2 242204 242204 4
447711 447711 105047 105047 PubChem (substance) 2 242204 242204 1
772445 772445 105047 105047 PubChem (substance) 2 242204 242204 5 
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)
);