consensus_index

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

12 rows where inchi_id = 23749

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
36104 36104 10763 10763 23749 5 0.470588235294118
116161 116161 40513 40513 23749 5 0.470588235294118
190996 190996 67986 67986 23749 5 0.470588235294118
264595 264595 89639 89639 23749 3 0.461538461538462
523752 523752 208786 208786 23749 3 0.461538461538462
570983 570983 223827 223827 23749 6 0.476190476190476
661553 661553 237045 237045 23749 5 0.466666666666667
667584 667584 239245 239245 23749 8 0.48
779438 779438 272560 272560 23749 5 0.470588235294118
960371 960371 345605 345605 23749 3 0.454545454545455
1638214 1638214 495448 495448 23749 5 0.470588235294118
1732509 1732509 530604 530604 23749 5 0.466666666666667 
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)
);