consensus_index

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

20 rows where inventory_id = 76194

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
220058 220058 76194 76194 649 4 0.202496822578549
220059 220059 76194 76194 95113 1 0.0168747352148791
220060 220060 76194 76194 130681 1 0.0155766786598884
220061 220061 76194 76194 137100 3 0.0637825023258854
220062 220062 76194 76194 137613 1 0.0202496822578549
220063 220063 76194 76194 139632 1 0.0337494704297582
220064 220064 76194 76194 140403 1 0.0184088020525954
220065 220065 76194 76194 140404 3 0.0569308115941871
220066 220066 76194 76194 140408 1 0.0224996469531721
220067 220067 76194 76194 149856 4 0.202496822578549
220068 220068 76194 76194 152808 3 0.0803609172953517
220069 220069 76194 76194 173359 2 0.0191341512079861
220070 220070 76194 76194 173406 1 0.0674989408595164
220071 220071 76194 76194 183336 1 0.0224996469531721
220072 220072 76194 76194 186330 3 0.0381113611560688
220073 220073 76194 76194 190821 2 0.0197616663926252
220074 220074 76194 76194 196337 3 0.0198852126786024
220075 220075 76194 76194 199923 1 0.0253121028223187
220076 220076 76194 76194 224163 1 0.0289281175112213
220077 220077 76194 76194 267569 1 0.0202496822578549 
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)
);