consensus_index

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

22 rows where inventory_id = 254425

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
719701 719701 254425 254425 59611 2 0.0245619354268779
719702 719702 254425 254425 60973 5 0.108231942306138
719703 719703 254425 254425 111382 7 0.251684943035896
719704 719704 254425 254425 136778 1 0.0139824968353276
719705 719705 254425 254425 188661 2 0.0296613549905387
719706 719706 254425 254425 198273 1 0.0209737452529914
719707 719707 254425 254425 199360 1 0.0359549918622709
719708 719708 254425 254425 215554 2 0.0239972177461135
719709 719709 254425 254425 229249 3 0.0337152298361126
719710 719710 254425 254425 229523 7 0.0712483427416529
719711 719711 254425 254425 229669 4 0.0408570129059667
719712 719712 254425 254425 230094 3 0.0362029651593937
719713 719713 254425 254425 230470 5 0.0575483979721784
719714 719714 254425 254425 230543 4 0.0359587365888605
719715 719715 254425 254425 230554 1 0.0251684943035896
719716 719716 254425 254425 234962 5 0.0730348229776842
719717 719717 254425 254425 284929 2 0.0194179149227285
719718 719718 254425 254425 289218 1 0.0167789962023931
719719 719719 254425 254425 298040 2 0.0143878705441097
719720 719720 254425 254425 315601 1 0.0279649936706552
719721 719721 254425 254425 328730 2 0.0129111651550307
719722 719722 254425 254425 329551 2 0.0218238523285536 
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)
);