consensus_index

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

21 rows where inchi_id = 37

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2016 2016 538 538 37 11 0.416666666666667
21216 21216 6261 6261 37 8 0.519685039370079
96975 96975 34366 34366 37 8 0.519685039370079
188057 188057 66947 66947 37 15 0.419117647058824
201028 201028 71393 71393 37 11 0.416666666666667
243076 243076 82667 82667 37 1 0.171428571428571
340967 340967 115045 115045 37 3 0.346034940914341
428962 428962 154564 154564 37 8 0.519685039370079
478609 478609 174757 174757 37 3 0.346034940914341
516105 516105 206820 206820 37 8 0.519685039370079
516108 516108 206821 206821 37 8 0.519685039370079
669255 669255 239746 239746 37 12 0.526315789473684
694650 694650 247749 247749 37 1 0.272727272727273
700613 700613 249614 249614 37 1 0.266245718268997
738043 738043 260191 260191 37 8 0.519685039370079
738046 738046 260192 260192 37 8 0.519685039370079
924956 924956 328723 328723 37 4 0.506024096385542
962331 962331 346424 346424 37 1 0.150943396226415
1614570 1614570 487477 487477 37 8 0.519685039370079
1674768 1674768 508336 508336 37 4 0.656703184093677
1718988 1718988 526469 526469 37 8 0.519685039370079 
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)
);