consensus_index

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

19 rows where inventory_id = 53248

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
147852 147852 53248 53248 63365 6 0.269543913195333
147853 147853 53248 53248 115556 4 0.124458298370303
147854 147854 53248 53248 137508 2 0.0898479710651112
147855 147855 53248 53248 139962 2 0.0673859782988334
147856 147856 53248 53248 168840 1 0.0224619927662778
147857 147857 53248 53248 186406 2 0.0720386409905195
147858 147858 53248 53248 186918 2 0.0169796705172865
147859 147859 53248 53248 188180 2 0.0492117604984328
147860 147860 53248 53248 188635 2 0.0401812341884046
147861 147861 53248 53248 194722 1 0.0207341471688718
147862 147862 53248 53248 217787 2 0.0263047924550159
147863 147863 53248 53248 232251 1 0.0269543913195333
147864 147864 53248 53248 240057 2 0.0389053127104377
147865 147865 53248 53248 241447 2 0.0181314857193804
147866 147866 53248 53248 291243 2 0.0317660548079964
147867 147867 53248 53248 295070 2 0.022780618507321
147868 147868 53248 53248 309216 2 0.0209839651827732
147869 147869 53248 53248 309726 2 0.0194526563552189
147870 147870 53248 53248 334427 2 0.0154594036640126 
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)
);