consensus_index

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

12 rows where inventory_id = 70670

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
198792 198792 70670 70670 8928 2 0.0371326152144148
198793 198793 70670 70670 38789 1 0.0364384864350087
198794 198794 70670 70670 43760 1 0.0655892755830157
198795 198795 70670 70670 45094 4 0.117832482088287
198796 198796 70670 70670 97453 8 0.262140384614287
198797 198797 70670 70670 99486 1 0.0468494825592969
198798 198798 70670 70670 102682 1 0.109315459305026
198799 198799 70670 70670 110453 2 0.0403674086188387
198800 198800 70670 70670 188501 1 0.0327946377915079
198801 198801 70670 70670 223483 2 0.115946553844659
198802 198802 70670 70670 232089 1 0.0409932972393848
198803 198803 70670 70670 259839 1 0.0819865944787696 
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)
);