consensus_index

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

26 rows where inchi_id = 3343

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
23137 23137 6787 6787 3343 8 0.478260869565217
81843 81843 29467 29467 3343 8 0.478260869565217
134150 134150 47625 47625 3343 16 0.392156862745098
222420 222420 76882 76882 3343 7 0.620689655172414
394349 394349 136194 136194 3343 1 0.19047619047619
430941 430941 155121 155121 3343 8 0.478260869565217
518013 518013 207257 207257 3343 8 0.478260869565217
518016 518016 207258 207258 3343 8 0.478260869565217
518019 518019 207259 207259 3343 8 0.478260869565217
592344 592344 230970 230970 3343 8 0.478260869565217
598168 598168 235597 235597 3343 11 0.482758620689655
598171 598171 235598 235598 3343 8 0.625
673591 673591 240882 240882 3343 8 0.478260869565217
746714 746714 262650 262650 3343 8 0.478260869565217
746717 746717 262651 262651 3343 7 0.620689655172414
746719 746719 262652 262652 3343 8 0.625
746721 746721 262653 262653 3343 8 0.625
746723 746723 262654 262654 3343 8 0.478260869565217
877855 877855 304486 304486 3343 4 0.6
990510 990510 355617 355617 3343 8 0.478260869565217
1200498 1200498 399737 399737 3343 8 0.478260869565217
1200501 1200501 399738 399738 3343 8 0.478260869565217
1447626 1447626 449870 449870 3343 8 0.478260869565217
1591039 1591039 480252 480252 3343 8 0.478260869565217
1617655 1617655 488446 488446 3343 8 0.478260869565217
1720466 1720466 526923 526923 3343 8 0.478260869565217 
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)
);