consensus_index

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

12 rows where inventory_id = 252816

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
714010 714010 252816 252816 30288 1 0.047541732819222
714011 714011 252816 252816 40240 1 0.047541732819222
714012 714012 252816 252816 53420 9 0.190166931276888
714013 714013 252816 252816 92418 3 0.095083465638444
714014 714014 252816 252816 110132 1 0.190166931276888
714015 714015 252816 252816 119803 1 0.0271667044681268
714016 714016 252816 252816 128763 3 0.150935593379248
714017 714017 252816 252816 167538 1 0.0380333862553776
714018 714018 252816 252816 176116 1 0.063388977092296
714019 714019 252816 252816 215275 2 0.0347195726506287
714020 714020 252816 252816 253130 1 0.063388977092296
714021 714021 252816 252816 327223 2 0.0448227755544412 
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)
);