consensus_index

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

9 rows where inventory_id = 12455

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
41090 41090 12455 12455 32888 1 0.0864612639813353
41091 41091 12455 12455 52988 7 0.345845055925341
41092 41092 12455 12455 68379 1 0.115281685308447
41093 41093 12455 12455 143273 1 0.0432306319906677
41094 41094 12455 12455 170277 1 0.0494064365607631
41095 41095 12455 12455 171194 1 0.172922527962671
41096 41096 12455 12455 185282 1 0.0576408426542236
41097 41097 12455 12455 216013 1 0.0691690111850683
41098 41098 12455 12455 295102 1 0.038427228436149 
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)
);