consensus_index

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

19 rows where inventory_id = 387995

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1147802 1147802 387995 387995 274 1 0.0229601425377309
1147803 1147803 387995 387995 7710 2 0.0459202850754619
1147804 1147804 387995 387995 12920 1 0.0918405701509237
1147805 1147805 387995 387995 75177 10 0.230324799016563
1147806 1147806 387995 387995 75665 1 0.0162071594383983
1147807 1147807 387995 387995 77231 2 0.0371513398585791
1147808 1147808 387995 387995 123602 1 0.0551043420905542
1147809 1147809 387995 387995 139279 1 0.0275521710452771
1147810 1147810 387995 387995 140716 1 0.0183681140301847
1147811 1147811 387995 387995 168956 1 0.0153067616918206
1147812 1147812 387995 387995 186046 1 0.0688804276131928
1147813 1147813 387995 387995 188379 1 0.0459202850754619
1147814 1147814 387995 387995 188380 1 0.0393602443503959
1147815 1147815 387995 387995 192032 1 0.0196801221751979
1147816 1147816 387995 387995 233012 1 0.0172201069032982
1147817 1147817 387995 387995 240462 1 0.137760855226386
1147818 1147818 387995 387995 241343 1 0.0211939777271362
1147819 1147819 387995 387995 261752 1 0.0459202850754619
1147820 1147820 387995 387995 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)
);