consensus_index

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

25 rows where inventory_id = 214744

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
542729 542729 214744 214744 14029 1 0.0386972054577725
542730 542730 214744 214744 70662 7 0.105824758655371
542731 542731 214744 214744 82954 7 0.113836088653543
542732 542732 214744 214744 137161 2 0.0235771158634378
542733 542733 214744 214744 160007 1 0.0386972054577725
542734 542734 214744 214744 173779 1 0.0193486027288863
542735 542735 214744 214744 189130 3 0.0628657808606858
542736 542736 214744 214744 189131 1 0.0169300273877755
542737 542737 214744 214744 192037 3 0.0761564699909498
542738 542738 214744 214744 208696 2 0.0349705141993013
542739 542739 214744 214744 219883 4 0.0215251288724931
542740 542740 214744 214744 224754 3 0.118317929547289
542741 542741 214744 214744 231967 1 0.0225733698503673
542742 542742 214744 214744 239082 2 0.0494557754638128
542743 542743 214744 214744 240597 1 0.033860054775551
542744 542744 214744 214744 243358 1 0.033860054775551
542745 542745 214744 214744 250835 1 0.0159341434237887
542746 542746 214744 214744 270110 1 0.0128990684859242
542747 542747 214744 214744 276444 1 0.0300978264671564
542748 542748 214744 214744 292163 2 0.021828167761037
542749 542749 214744 214744 294582 1 0.0208369567849544
542750 542750 214744 214744 296213 1 0.0193486027288863
542751 542751 214744 214744 310252 2 0.0265620123125931
542752 542752 214744 214744 320433 1 0.0180586958802939
542753 542753 214744 214744 333211 2 0.0188274919505719 
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)
);