consensus_index

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

14 rows where inventory_id = 71958

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
203030 203030 71958 71958 1688 2 0.114377902079882
203031 203031 71958 71958 27975 1 0.0400239282779614
203032 203032 71958 71958 44863 1 0.046694582990955
203033 203033 71958 71958 51026 1 0.0215513459958254
203034 203034 71958 71958 76684 1 0.056033499589146
203035 203035 71958 71958 76685 12 0.264442904559275
203036 203036 71958 71958 116272 1 0.0700418744864325
203037 203037 71958 71958 169774 1 0.0933891659819099
203038 203038 71958 71958 185740 1 0.03112972199397
203039 203039 71958 71958 199768 1 0.0233472914954775
203040 203040 71958 71958 216617 1 0.140083748972865
203041 203041 71958 71958 220765 1 0.0254697725405209
203042 203042 71958 71958 254209 1 0.028016749794573
203043 203043 71958 71958 314502 1 0.0350209372432162 
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)
);