consensus_index

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

20 rows where inventory_id = 78762

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
229837 229837 78762 78762 11532 1 0.0127184073957216
229838 229838 78762 78762 14236 4 0.216212925727268
229839 229839 78762 78762 93651 1 0.0120118292070704
229840 229840 78762 78762 120271 2 0.0268179128573379
229841 229841 78762 78762 135569 1 0.0113796276698562
229842 229842 78762 78762 136951 1 0.0154437804090906
229843 229843 78762 78762 137529 3 0.171608312874294
229844 229844 78762 78762 138654 4 0.152885625961934
229845 229845 78762 78762 139149 3 0.054053231431817
229846 229846 78762 78762 145325 1 0.0180177438106056
229847 229847 78762 78762 169163 3 0.0720709752424226
229848 229848 78762 78762 169195 1 0.0270266157159085
229849 229849 78762 78762 188645 1 0.0308875608181811
229850 229850 78762 78762 189159 1 0.0216212925727268
229851 229851 78762 78762 195416 1 0.0196557205206607
229852 229852 78762 78762 196711 1 0.0240236584141409
229853 229853 78762 78762 207186 1 0.0360354876212113
229854 229854 78762 78762 263431 1 0.0135133078579542
229855 229855 78762 78762 267247 1 0.0432425851454536
229856 229856 78762 78762 290792 1 0.0144141950484845 
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)
);