consensus_index

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

12 rows where inventory_id = 280074

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
803214 803214 280074 280074 8928 2 0.0371326152144148
803215 803215 280074 280074 38789 1 0.0364384864350087
803216 803216 280074 280074 43760 1 0.0655892755830157
803217 803217 280074 280074 45094 4 0.117832482088287
803218 803218 280074 280074 97453 8 0.262140384614287
803219 803219 280074 280074 99486 1 0.0468494825592969
803220 803220 280074 280074 102682 1 0.109315459305026
803221 803221 280074 280074 110453 2 0.0403674086188387
803222 803222 280074 280074 188501 1 0.0327946377915079
803223 803223 280074 280074 223483 2 0.115946553844659
803224 803224 280074 280074 232089 1 0.0409932972393848
803225 803225 280074 280074 259839 1 0.0819865944787696 
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)
);