consensus_index

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

24 rows where inventory_id = 235297

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
597066 597066 235297 235297 365 2 0.0898031068248107
597067 597067 235297 235297 422 10 0.270817039166926
597068 597068 235297 235297 124382 2 0.0635003858074436
597069 597069 235297 235297 179620 1 0.062217417479243
597070 597070 235297 235297 223504 2 0.0803223405803808
597071 597071 235297 235297 232060 1 0.0444410124851736
597072 597072 235297 235297 232061 1 0.0388858859245269
597073 597073 235297 235297 232062 1 0.0345652319329128
597074 597074 235297 235297 232063 1 0.0311087087396215
597075 597075 235297 235297 232064 1 0.0282806443087468
597076 597076 235297 235297 232065 1 0.0259239239496846
597077 597077 235297 235297 232066 1 0.023929775953555
597078 597078 235297 235297 232067 1 0.0222205062425868
597079 597079 235297 235297 232068 1 0.0207391391597477
597080 597080 235297 235297 232069 1 0.0194429429622634
597081 597081 235297 235297 232070 1 0.0182992404350715
597082 597082 235297 235297 232071 1 0.0172826159664564
597083 597083 235297 235297 232072 1 0.0163730045998008
597084 597084 235297 235297 232073 1 0.0155543543698107
597085 597085 235297 235297 232074 1 0.0148136708283912
597086 597086 235297 235297 232075 1 0.0141403221543734
597087 597087 235297 235297 232076 1 0.0135255255389659
597088 597088 235297 235297 232077 1 0.0129619619748423
597089 597089 235297 235297 232078 1 0.0124434834958486 
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)
);