consensus_index

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

24 rows where inchi_id = 23506

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
8010 8010 2424 2424 23506 1 0.206896551724138
25849 25849 7575 7575 23506 1 0.206896551724138
36020 36020 10736 10736 23506 8 0.625
83186 83186 29960 29960 23506 1 0.206896551724138
166852 166852 59681 59681 23506 1 0.209302325581395
205298 205298 72778 72778 23506 1 0.206896551724138
227214 227214 78148 78148 23506 1 0.206896551724138
264368 264368 89565 89565 23506 7 0.519685039370079
264371 264371 89567 89567 23506 1 0.0518838789376158
434007 434007 155956 155956 23506 1 0.253012048192771
519880 519880 207720 207720 23506 1 0.206896551724138
583025 583025 227916 227916 23506 2 0.263157894736842
660342 660342 236388 236388 23506 1 0.206896551724138
681512 681512 243416 243416 23506 1 0.206896551724138
692344 692344 246915 246915 23506 8 0.625
761571 761571 267145 267145 23506 1 0.257142857142857
761574 761574 267146 267146 23506 1 0.253012048192771
761578 761578 267147 267147 23506 1 0.206896551724138
761581 761581 267148 267148 23506 1 0.20625
779256 779256 272498 272498 23506 8 0.625
779258 779258 272499 272499 23506 4 0.6
908983 908983 320965 320965 23506 4 0.6
1620314 1620314 489287 489287 23506 1 0.206896551724138
1722647 1722647 527569 527569 23506 1 0.258620689655172 
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)
);