consensus_index

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

12 rows where inventory_id = 223445

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
569817 569817 223445 223445 19092 1 0.030505112324058
569818 569818 223445 223445 25842 5 0.239006184454082
569819 569819 223445 223445 37153 1 0.0457576684860869
569820 569820 223445 223445 63014 2 0.112082939610343
569821 569821 223445 223445 83501 3 0.21790731327128
569822 569822 223445 223445 136419 1 0.0274546010916522
569823 569823 223445 223445 138652 1 0.0343182513645652
569824 569824 223445 223445 157362 1 0.0915153369721739
569825 569825 223445 223445 169023 1 0.0392208587023602
569826 569826 223445 223445 169437 1 0.0686365027291304
569827 569827 223445 223445 260145 1 0.0549092021833043
569828 569828 223445 223445 272598 1 0.0249587282651383 
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)
);