consensus_index

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

10 rows where inventory_id = 216627

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
547857 547857 216627 216627 60138 2 0.115147948506096
547858 547858 216627 216627 94164 2 0.0940179062560695
547859 547859 216627 216627 114896 6 0.32568758091352
547860 547860 216627 216627 228466 2 0.0767652990040642
547861 547861 216627 216627 248619 3 0.16284379045676
547862 547862 216627 216627 248863 1 0.04652679727336
547863 547863 216627 216627 262108 1 0.0651375161827041
547864 547864 216627 216627 264830 1 0.032568758091352
547865 547865 216627 216627 309531 1 0.0361875089903911
547866 547866 216627 216627 334479 1 0.0296079619012291 
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);