consensus_index

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

27 rows where inchi_id = 87559

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
5486 5486 1646 1646 87559 8 0.344262295081967
19758 19758 5793 5793 87559 6 0.341968911917098
80309 80309 28981 28981 87559 6 0.341968911917098
192507 192507 68435 68435 87559 6 0.341968911917098
201602 201602 71522 71522 87559 8 0.344262295081967
218381 218381 75713 75713 87559 5 0.340909090909091
342082 342082 115453 115453 87559 1 0.126509670997988
427883 427883 154250 154250 87559 5 0.340909090909091
444937 444937 159461 159461 87559 3 0.461538461538462
479008 479008 175027 175027 87559 1 0.126509670997988
515195 515195 206578 206578 87559 5 0.226744186046512
532685 532685 211291 211291 87559 8 0.268156424581006
667173 667173 238967 238967 87559 5 0.340909090909091
735773 735773 259526 259526 87559 9 0.344827586206897
857768 857768 296717 296717 87559 6 0.341968911917098
857772 857772 296718 296718 87559 3 0.338028169014085
888584 888584 309927 309927 87559 3 0.336
1174736 1174736 394262 394262 87559 6 0.341968911917098
1174740 1174740 394263 394263 87559 6 0.341968911917098
1430118 1430118 445896 445896 87559 6 0.341968911917098
1430122 1430122 445897 445897 87559 6 0.341968911917098
1430126 1430126 445898 445898 87559 6 0.341968911917098
1430130 1430130 445899 445899 87559 6 0.341968911917098
1587237 1587237 479141 479141 87559 6 0.341968911917098
1607166 1607166 485539 485539 87559 6 0.341968911917098
1613514 1613514 487121 487121 87559 6 0.341968911917098
1718335 1718335 526263 526263 87559 5 0.339622641509434 
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)
);