consensus_index

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

12 rows where inchi_id = 84040

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
13615 13615 4177 4177 84040 6 0.384615384615385
13646 13646 4187 4187 84040 3 0.447063999565355
19072 19072 5602 5602 84040 6 0.384615384615385
63382 63382 20504 20504 84040 3 0.447063999565355
106963 106963 37664 37664 84040 1 0.3
155430 155430 55894 55894 84040 1 0.3
366307 366307 124535 124535 84040 2 0.16597510373444
713189 713189 252634 252634 84040 3 0.315789473684211
814537 814537 283059 283059 84040 1 0.138461538461538
814541 814541 283060 283060 84040 3 0.315789473684211
926768 926768 329607 329607 84040 1 0.3
1685044 1685044 512390 512390 84040 2 0.314285714285714 
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)
);