consensus_index

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

8 rows where inventory_id = 31806

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
89019 89019 31806 31806 28058 2 0.141683655405858
89020 89020 31806 31806 28085 1 0.0416510796718302
89021 89021 31806 31806 129078 5 0.261962136007116
89022 89022 31806 31806 198937 1 0.187429858523236
89023 89023 31806 31806 227602 1 0.046857464630809
89024 89024 31806 31806 253155 1 0.093714929261618
89025 89025 31806 31806 317104 1 0.0749719434092944
89026 89026 31806 31806 332381 1 0.124953239015491 
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)
);