consensus_index

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

10 rows where inventory_id = 241001

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
674117 674117 241001 241001 3521 8 0.334362061183255
674118 674118 241001 241001 3523 1 0.111454020394418
674119 674119 241001 241001 55999 2 0.136502739874038
674120 674120 241001 241001 173397 2 0.118214840417096
674121 674121 241001 241001 198004 1 0.0417952576479069
674122 674122 241001 241001 233774 1 0.0334362061183255
674123 674123 241001 241001 246856 1 0.0557270101972092
674124 674124 241001 241001 254497 1 0.0668724122366511
674125 674125 241001 241001 318640 1 0.047766008740465
674126 674126 241001 241001 322819 1 0.0371513401314728 
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)
);