api_results

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

14 rows where inchi_id = 231927

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
697256 697256 20299 20299 PubChem (substance) 2 231927 231927 2
697257 697257 8623 8623 PubChem (substance) 2 231927 231927 8
697258 697258 351562 351562 PubChem (substance) 2 231927 231927 8
697259 697259 349612 349612 PubChem (substance) 2 231927 231927 8
697260 697260 95244 95244 PubChem (substance) 2 231927 231927 8
697261 697261 3612 3612 PubChem (substance) 2 231927 231927 3
697262 697262 3613 3613 PubChem (substance) 2 231927 231927 1
697263 697263 351560 351560 PubChem (substance) 2 231927 231927 4
697264 697264 351559 351559 PubChem (substance) 2 231927 231927 2
697265 697265 95243 95243 PubChem (substance) 2 231927 231927 2
697266 697266 330836 330836 PubChem (substance) 2 231927 231927 2
697267 697267 122974 122974 PubChem (substance) 2 231927 231927 3
697268 697268 441040 441040 PubChem (substance) 2 231927 231927 1
697269 697269 351561 351561 PubChem (substance) 2 231927 231927 8 
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)
);