consensus_index

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

16 rows where inventory_id = 364142

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1023883 1023883 364142 364142 4082 1 0.0181600739178219
1023884 1023884 364142 364142 119555 6 0.254241034849507
1023885 1023885 364142 364142 167912 1 0.0508482069699013
1023886 1023886 364142 364142 188050 1 0.0211867529041255
1023887 1023887 364142 364142 192603 3 0.0769977699946653
1023888 1023888 364142 364142 193513 1 0.0254241034849507
1023889 1023889 364142 364142 199455 2 0.0293572259818823
1023890 1023890 364142 364142 201331 1 0.0847470116165022
1023891 1023891 364142 364142 212213 2 0.0480470393771072
1023892 1023892 364142 364142 212214 1 0.0317801293561883
1023893 1023893 364142 364142 218318 1 0.0158900646780942
1023894 1023894 364142 364142 230866 2 0.0312949080477542
1023895 1023895 364142 364142 247521 1 0.127120517424753
1023896 1023896 364142 364142 256712 1 0.0282490038721674
1023897 1023897 364142 364142 258451 2 0.0898877798989857
1023898 1023898 364142 364142 267222 1 0.0195570026807313 
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)
);