consensus_index

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

26 rows where inchi_id = 2

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
8151 8151 2464 2464 2 12 0.378947368421053
21145 21145 6242 6242 2 8 0.461538461538462
96721 96721 34291 34291 2 8 0.461538461538462
135475 135475 48016 48016 2 16 0.289572526395478
219654 219654 76089 76089 2 8 0.332880435763922
268245 268245 90926 90926 2 1 0.239130434782609
381867 381867 130684 130684 2 1 0.304347826086957
428871 428871 154542 154542 2 8 0.376681614349776
516019 516019 206801 206801 2 7 0.45993031358885
516023 516023 206802 206802 2 8 0.376681614349776
516028 516028 206803 206803 2 8 0.376681614349776
596549 596549 232225 232225 2 8 0.332880435763922
596867 596867 235255 235255 2 12 0.288987332046967
668773 668773 239614 239614 2 12 0.334271340633088
737174 737174 259958 259958 2 8 0.332880435763922
737181 737181 259959 259959 2 8 0.461538461538462
737185 737185 259960 259960 2 8 0.461538461538462
737189 737189 259961 259961 2 5 0.225289584269187
901061 901061 317135 317135 2 1 0.150943396226415
955198 955198 342969 342969 2 4 0.452830188679245
967513 967513 351188 351188 2 8 0.461538461538462
1177400 1177400 395083 395083 2 8 0.461538461538462
1433107 1433107 446770 446770 2 8 0.461538461538462
1589233 1589233 479741 479741 2 8 0.461538461538462
1614479 1614479 487449 487449 2 8 0.461538461538462
1696899 1696899 517284 517284 2 3 0.314285714285714 
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)
);