consensus_index

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

16 rows where inventory_id = 364139

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1023835 1023835 364139 364139 4082 1 0.0181600739178219
1023836 1023836 364139 364139 119555 6 0.254241034849507
1023837 1023837 364139 364139 167912 1 0.0508482069699013
1023838 1023838 364139 364139 188050 1 0.0211867529041255
1023839 1023839 364139 364139 192603 3 0.0769977699946653
1023840 1023840 364139 364139 193513 1 0.0254241034849507
1023841 1023841 364139 364139 199455 2 0.0293572259818823
1023842 1023842 364139 364139 201331 1 0.0847470116165022
1023843 1023843 364139 364139 212213 2 0.0480470393771072
1023844 1023844 364139 364139 212214 1 0.0317801293561883
1023845 1023845 364139 364139 218318 1 0.0158900646780942
1023846 1023846 364139 364139 230866 2 0.0312949080477542
1023847 1023847 364139 364139 247521 1 0.127120517424753
1023848 1023848 364139 364139 256712 1 0.0282490038721674
1023849 1023849 364139 364139 258451 2 0.0898877798989857
1023850 1023850 364139 364139 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)
);