consensus_index

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

19 rows where inventory_id = 387998

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1147859 1147859 387998 387998 274 1 0.0229601425377309
1147860 1147860 387998 387998 7710 2 0.0459202850754619
1147861 1147861 387998 387998 12920 1 0.0918405701509237
1147862 1147862 387998 387998 75177 10 0.230324799016563
1147863 1147863 387998 387998 75665 1 0.0162071594383983
1147864 1147864 387998 387998 77231 2 0.0371513398585791
1147865 1147865 387998 387998 123602 1 0.0551043420905542
1147866 1147866 387998 387998 139279 1 0.0275521710452771
1147867 1147867 387998 387998 140716 1 0.0183681140301847
1147868 1147868 387998 387998 168956 1 0.0153067616918206
1147869 1147869 387998 387998 186046 1 0.0688804276131928
1147870 1147870 387998 387998 188379 1 0.0459202850754619
1147871 1147871 387998 387998 188380 1 0.0393602443503959
1147872 1147872 387998 387998 192032 1 0.0196801221751979
1147873 1147873 387998 387998 233012 1 0.0172201069032982
1147874 1147874 387998 387998 240462 1 0.137760855226386
1147875 1147875 387998 387998 241343 1 0.0211939777271362
1147876 1147876 387998 387998 261752 1 0.0459202850754619
1147877 1147877 387998 387998 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)
);