consensus_index

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

24 rows where inchi_id = 16547

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
11367 11367 3463 3463 16547 1 0.0788818156656518
35150 35150 10422 10422 16547 8 0.625
192453 192453 68417 68417 16547 8 0.625
200615 200615 71285 71285 16547 1 0.0785340314136126
219794 219794 76122 76122 16547 1 0.0785340314136126
259727 259727 87951 87951 16547 8 0.628571428571429
277167 277167 93965 93965 16547 1 0.307692307692308
428970 428970 154566 154566 16547 1 0.0785340314136126
446655 446655 160025 160025 16547 7 0.620689655172414
516119 516119 206824 206824 16547 1 0.0785340314136126
516126 516126 206825 206825 16547 1 0.0785340314136126
516137 516137 206827 206827 16547 1 0.0785340314136126
523483 523483 208711 208711 16547 8 0.628571428571429
523485 523485 208712 208712 16547 8 0.628571428571429
575304 575304 225369 225369 16547 7 0.620689655172414
596488 596488 232209 232209 16547 1 0.0785340314136126
596905 596905 235263 235263 16547 1 0.0785340314136126
596912 596912 235264 235264 16547 1 0.0681329189576859
688210 688210 245431 245431 16547 8 0.625
702976 702976 250348 250348 16547 1 0.3125
738107 738107 260210 260210 16547 1 0.0785340314136126
925749 925749 329149 329149 16547 1 0.3
1636099 1636099 494653 494653 16547 8 0.625
1731526 1731526 530238 530238 16547 5 0.608695652173913 
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)
);