consensus_index

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

19 rows where inchi_id = 47917

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
40427 40427 12248 12248 47917 5 0.466666666666667
96372 96372 34153 34153 47917 5 0.466666666666667
138127 138127 49178 49178 47917 3 0.454545454545455
282624 282624 95846 95846 47917 5 0.466666666666667
455070 455070 163507 163507 47917 3 0.454545454545455
502804 502804 201180 201180 47917 2 0.487728457387774
556420 556420 219236 219236 47917 3 0.454545454545455
708889 708889 251623 251623 47917 5 0.466666666666667
807439 807439 281163 281163 47917 3 0.454545454545455
807441 807441 281164 281164 47917 5 0.470588235294118
1060451 1060451 374554 374554 47917 3 0.461538461538462
1060453 1060453 374555 374555 47917 3 0.461538461538462
1284609 1284609 422301 422301 47917 3 0.461538461538462
1284611 1284611 422302 422302 47917 3 0.461538461538462
1499725 1499725 463939 463939 47917 3 0.461538461538462
1499727 1499727 463940 463940 47917 3 0.461538461538462
1600355 1600355 483445 483445 47917 3 0.461538461538462
1646514 1646514 498537 498537 47917 3 0.461538461538462
1736439 1736439 531956 531956 47917 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)
);