consensus_index

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

28 rows where inchi_id = 47438

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3527 3527 983 983 47438 2 0.273846507881717
3535 3535 984 984 47438 3 0.239043824701195
141607 141607 50494 50494 47438 3 0.198827516128875
148284 148284 53334 53334 47438 3 0.148180838467517
171270 171270 61085 61085 47438 6 0.258061100037489
203846 203846 72250 72250 47438 3 0.311688311688312
203851 203851 72251 72251 47438 2 0.273846507881717
203907 203907 72260 72260 47438 3 0.239043824701195
529587 529587 210241 210241 47438 8 0.258650048708911
529594 529594 210242 210242 47438 3 0.311688311688312
529904 529904 210328 210328 47438 4 0.267460251621379
546059 546059 216066 216066 47438 2 0.273846507881717
556775 556775 219347 219347 47438 3 0.239043824701195
708524 708524 251520 251520 47438 9 0.258809432214265
721039 721039 254886 254886 47438 5 0.21893893349945
806727 806727 280961 280961 47438 3 0.311688311688312
806733 806733 280962 280962 47438 6 0.258061100037489
826029 826029 286709 286709 47438 1 0.168674698795181
826032 826032 286710 286710 47438 1 0.168674698795181
826805 826805 286977 286977 47438 1 0.3
826807 826807 286978 286978 47438 1 0.3
827096 827096 287073 287073 47438 2 0.273846507881717
827104 827104 287074 287074 47438 2 0.273846507881717
861498 861498 297848 297848 47438 2 0.0935178856870586
942703 942703 337524 337524 47438 2 0.273846507881717
1755721 1755721 538117 538117 47438 6 0.315789473684211
1758442 1758442 539354 539354 47438 2 0.273846507881717
1760428 1760428 540426 540426 47438 2 0.0936622664088699 
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)
);