consensus_index

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

15 rows where inchi_id = 79197

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
72777 72777 24885 24885 79197 5 0.455696202531646
93789 93789 33353 33353 79197 4 0.315789473684211
156676 156676 56357 56357 79197 11 0.465116279069767
397493 397493 137685 137685 79197 7 0.45993031358885
535848 535848 212659 212659 79197 7 0.45993031358885
726770 726770 256666 256666 79197 1 0.266245718268997
731886 731886 258098 258098 79197 8 0.461538461538462
850510 850510 294255 294255 79197 7 0.372670807453416
850516 850516 294256 294256 79197 8 0.461538461538462
850520 850520 294257 294257 79197 5 0.455696202531646
860529 860529 297590 297590 79197 1 0.262020410288673
904960 904960 319226 319226 79197 4 0.452830188679245
1709561 1709561 522949 522949 79197 8 0.461538461538462
1761146 1761146 540742 540742 79197 1 0.266245718268997
1762194 1762194 541170 541170 79197 8 0.461538461538462 
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)
);