consensus_index

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

10 rows where inventory_id = 243456

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
681655 681655 243456 243456 9030 12 0.28444538894321
681656 681656 243456 243456 84288 1 0.150679695973003
681657 681657 243456 243456 149598 1 0.150679695973003
681658 681658 243456 243456 149774 1 0.100453130648669
681659 681659 243456 243456 149796 1 0.0753398479865017
681660 681660 243456 243456 179637 1 0.0502265653243344
681661 681661 243456 243456 222179 1 0.0334843768828896
681662 681662 243456 243456 223259 1 0.0602718783892013
681663 681663 243456 243456 223263 1 0.0376699239932508
681664 681664 243456 243456 228959 1 0.0430513417065724 
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)
);