consensus_index

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

19 rows where inventory_id = 474344

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1568748 1568748 474344 474344 274 1 0.0229601425377309
1568749 1568749 474344 474344 7710 2 0.0459202850754619
1568750 1568750 474344 474344 12920 1 0.0918405701509237
1568751 1568751 474344 474344 75177 10 0.230324799016563
1568752 1568752 474344 474344 75665 1 0.0162071594383983
1568753 1568753 474344 474344 77231 2 0.0371513398585791
1568754 1568754 474344 474344 123602 1 0.0551043420905542
1568755 1568755 474344 474344 139279 1 0.0275521710452771
1568756 1568756 474344 474344 140716 1 0.0183681140301847
1568757 1568757 474344 474344 168956 1 0.0153067616918206
1568758 1568758 474344 474344 186046 1 0.0688804276131928
1568759 1568759 474344 474344 188379 1 0.0459202850754619
1568760 1568760 474344 474344 188380 1 0.0393602443503959
1568761 1568761 474344 474344 192032 1 0.0196801221751979
1568762 1568762 474344 474344 233012 1 0.0172201069032982
1568763 1568763 474344 474344 240462 1 0.137760855226386
1568764 1568764 474344 474344 241343 1 0.0211939777271362
1568765 1568765 474344 474344 261752 1 0.0459202850754619
1568766 1568766 474344 474344 284659 1 0.0344402138065964 
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)
);