consensus_index

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

11 rows where inchi_id = 38727

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
60384 60384 19220 19220 38727 1 0.304272260026875
106893 106893 37642 37642 38727 1 0.282217906268466
155329 155329 55863 55863 38727 1 0.311688311688312
243140 243140 82694 82694 38727 1 0.19702852664608
440026 440026 157742 157742 38727 1 0.19702852664608
474463 474463 172524 172524 38727 1 0.380952380952381
482351 482351 177227 177227 38727 1 0.311688311688312
797297 797297 278187 278187 38727 1 0.304272260026875
797302 797302 278188 278188 38727 2 0.286824828486996
862682 862682 298136 298136 38727 1 0.311688311688312
1678937 1678937 509924 509924 38727 2 0.286824828486996 
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)
);