consensus_index

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

27 rows where inventory_id = 57148

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
158686 158686 57148 57148 1235 1 0.0479607273472953
158687 158687 57148 57148 3000 1 0.0147571468760909
158688 158688 57148 57148 20408 1 0.011284877022893
158689 158689 57148 57148 23817 1 0.0479607273472953
158690 158690 57148 57148 27609 1 0.0959214546945906
158691 158691 57148 57148 28468 10 0.191842909389181
158692 158692 57148 57148 29202 2 0.0495336262101518
158693 158693 57148 57148 31008 1 0.00959214546945906
158694 158694 57148 57148 39645 1 0.0100969952310095
158695 158695 57148 57148 40658 2 0.0151665136655779
158696 158696 57148 57148 41014 1 0.0106579394105101
158697 158697 57148 57148 41660 2 0.0324273702219527
158698 158698 57148 57148 48605 3 0.0177384462735224
158699 158699 57148 57148 52274 2 0.0391597698978735
158700 158700 57148 57148 58632 1 0.0239803636736476
158701 158701 57148 57148 59568 1 0.0639476364630604
158702 158702 57148 57148 59933 2 0.0959214546945906
158703 158703 57148 57148 68113 1 0.0127895272926121
158704 158704 57148 57148 73291 1 0.0159869091157651
158705 158705 57148 57148 83645 1 0.0639476364630604
158706 158706 57148 57148 138286 2 0.0247668131050759
158707 158707 57148 57148 149872 2 0.0218625285436852
158708 158708 57148 57148 170161 1 0.0213158788210201
158709 158709 57148 57148 185912 1 0.0213158788210201
158710 158710 57148 57148 223258 1 0.00913537663758005
158711 158711 57148 57148 228883 1 0.00872013224496278
158712 158712 57148 57148 231092 2 0.0181274510369597 
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)
);