consensus_index

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

11 rows where inchi_id = 39843

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
257483 257483 87172 87172 39843 2 0.15752862526695
263801 263801 89360 89360 39843 1 0.238095238095238
352917 352917 119356 119356 39843 7 0.422535211267606
685038 685038 244373 244373 39843 1 0.206896551724138
767871 767871 268789 268789 39843 1 0.206896551724138
767875 767875 268790 268790 39843 1 0.310344827586207
906464 906464 319919 319919 39843 4 0.417633410672854
948862 948862 340265 340265 39843 1 0.3
1635156 1635156 494277 494277 39843 1 0.206896551724138
1637889 1637889 495318 495318 39843 1 0.3125
1679660 1679660 510203 510203 39843 8 0.362548942188169 
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)
);