consensus_index

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

29 rows where inventory_id = 472488

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1555766 1555766 472488 472488 54380 2 0.0255153579234943
1555767 1555767 472488 472488 70103 1 0.0155901412091072
1555768 1555768 472488 472488 73281 8 0.233852118136607
1555769 1555769 472488 472488 149379 1 0.0779507060455358
1555770 1555770 472488 472488 150425 1 0.0584630295341519
1555771 1555771 472488 472488 154056 1 0.0389753530227679
1555772 1555772 472488 472488 160254 1 0.0167037227240434
1555773 1555773 472488 472488 169362 1 0.0584630295341519
1555774 1555774 472488 472488 169847 1 0.0467704236273215
1555775 1555775 472488 472488 173730 2 0.116926059068304
1555776 1555776 472488 472488 184719 1 0.0292315147670759
1555777 1555777 472488 472488 184784 1 0.014615757383538
1555778 1555778 472488 472488 194778 1 0.0233852118136607
1555779 1555779 472488 472488 203147 1 0.0259835686818453
1555780 1555780 472488 472488 203675 1 0.0179886244720467
1555781 1555781 472488 472488 206414 1 0.0212592834669643
1555782 1555782 472488 472488 207079 1 0.0093540847254643
1555783 1555783 472488 472488 208924 1 0.019487676511384
1555784 1555784 472488 472488 218096 1 0.00974383825569198
1555785 1555785 472488 472488 219002 1 0.0137560069492122
1555786 1555786 472488 472488 221535 1 0.0101674833972438
1555787 1555787 472488 472488 233687 1 0.0129917843409226
1555788 1555788 472488 472488 239414 1 0.0116926059068304
1555789 1555789 472488 472488 243433 1 0.0334074454480868
1555790 1555790 472488 472488 243632 1 0.0111358151493623
1555791 1555791 472488 472488 244397 1 0.00866118956061509
1555792 1555792 472488 472488 249372 1 0.00899431223602336
1555793 1555793 472488 472488 249384 1 0.0106296417334822
1555794 1555794 472488 472488 256390 1 0.0123080062177162 
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)
);