consensus_index

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

12 rows where inventory_id = 5306

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18151 18151 5306 5306 81173 7 0.311136515118536
18152 18152 5306 5306 136607 1 0.0518560858530893
18153 18153 5306 5306 238390 3 0.0679506953684208
18154 18154 5306 5306 313743 2 0.0695722398087437
18155 18155 5306 5306 313782 2 0.155568257559268
18156 18156 5306 5306 314223 2 0.0463814932058292
18157 18157 5306 5306 314493 2 0.0449086876896022
18158 18158 5306 5306 315455 1 0.103712171706179
18159 18159 5306 5306 316306 1 0.0444480735883623
18160 18160 5306 5306 317428 2 0.0354572966205512
18161 18161 5306 5306 317468 1 0.0311136515118536
18162 18162 5306 5306 317880 1 0.0259280429265447 
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)
);