consensus_index

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

17 rows where inventory_id = 71019

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
199661 199661 71019 71019 73654 8 0.235274668141672
199662 199662 71019 71019 96137 1 0.0235274668141672
199663 199663 71019 71019 106602 1 0.0196062223451394
199664 199664 71019 71019 121932 1 0.0261416297935192
199665 199665 71019 71019 124382 2 0.117637334070836
199666 199666 71019 71019 139110 1 0.0213886061946975
199667 199667 71019 71019 172867 1 0.0168053334386909
199668 199668 71019 71019 188473 1 0.117637334070836
199669 199669 71019 71019 190893 1 0.0588186670354181
199670 199670 71019 71019 190912 1 0.0470549336283345
199671 199671 71019 71019 191014 1 0.0392124446902787
199672 199672 71019 71019 191015 1 0.0336106668773818
199673 199673 71019 71019 212272 2 0.0326267261462528
199674 199674 71019 71019 227831 1 0.0156849778761115
199675 199675 71019 71019 232173 1 0.0784248893805575
199676 199676 71019 71019 273578 1 0.029409333517709
199677 199677 71019 71019 281900 1 0.0784248893805575 
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)
);