consensus_index

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

18 rows where inchi_id = 120374

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
40428 40428 12248 12248 120374 1 0.466666666666667
96373 96373 34153 34153 120374 1 0.466666666666667
138128 138128 49178 49178 120374 1 0.454545454545455
282625 282625 95846 95846 120374 1 0.466666666666667
455071 455071 163507 163507 120374 1 0.454545454545455
556421 556421 219236 219236 120374 1 0.454545454545455
708890 708890 251623 251623 120374 1 0.466666666666667
807440 807440 281163 281163 120374 1 0.454545454545455
807442 807442 281164 281164 120374 2 0.470588235294118
1060452 1060452 374554 374554 120374 2 0.461538461538462
1060454 1060454 374555 374555 120374 2 0.461538461538462
1284610 1284610 422301 422301 120374 2 0.461538461538462
1284612 1284612 422302 422302 120374 2 0.461538461538462
1499726 1499726 463939 463939 120374 2 0.461538461538462
1499728 1499728 463940 463940 120374 2 0.461538461538462
1600356 1600356 483445 483445 120374 2 0.461538461538462
1646515 1646515 498537 498537 120374 2 0.461538461538462
1736440 1736440 531956 531956 120374 1 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)
);