consensus_index

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

25 rows where inchi_id = 76731

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17693 17693 5182 5182 76731 8 0.376597175521184
48905 48905 15037 15037 76731 1 0.0509411972006775
120820 120820 42026 42026 76731 8 0.376597175521184
123851 123851 42987 42987 76731 1 0.0509411972006775
178733 178733 63716 63716 76731 8 0.330017260966875
184905 184905 65996 65996 76731 1 0.0509411972006775
215009 215009 74707 74707 76731 8 0.330017260966875
303521 303521 102670 102670 76731 1 0.0509411972006775
425716 425716 153613 153613 76731 8 0.330017260966875
463437 463437 166515 166515 76731 1 0.0509411972006775
480859 480859 176267 176267 76731 1 0.253012048192771
545404 545404 215860 215860 76731 1 0.0522538523803068
674238 674238 241024 241024 76731 1 0.0509411972006775
730195 730195 257586 257586 76731 12 0.328010114307077
747865 747865 262967 262967 76731 1 0.0509411972006775
830242 830242 288079 288079 76731 1 0.0524657224310189
846574 846574 293182 293182 76731 5 0.373665480427046
846582 846582 293183 293183 76731 8 0.344389663688932
846589 846589 293184 293184 76731 8 0.376597175521184
846597 846597 293185 293185 76731 8 0.323050765120233
950519 950519 340977 340977 76731 4 0.37261069441084
1611206 1611206 486358 486358 76731 8 0.376597175521184
1656381 1656381 501908 501908 76731 1 0.0509411972006775
1717179 1717179 525911 525911 76731 8 0.376597175521184
1743223 1743223 533904 533904 76731 1 0.0509411972006775 
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)
);