consensus_index

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

18 rows where inventory_id = 4007

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
13026 13026 4007 4007 7814 7 0.22757432405429
13027 13027 4007 4007 52391 2 0.0384707063045212
13028 13028 4007 4007 136466 3 0.22018539049862
13029 13029 4007 4007 137782 2 0.0800831612895692
13030 13030 4007 4007 169143 1 0.0308240231520593
13031 13031 4007 4007 173351 2 0.0392325764296901
13032 13032 4007 4007 177859 2 0.046236034728089
13033 13033 4007 4007 189480 2 0.0605371797074499
13034 13034 4007 4007 190639 1 0.0154120115760297
13035 13035 4007 4007 195505 2 0.0295726671764143
13036 13036 4007 4007 213929 1 0.0231180173640445
13037 13037 4007 4007 237760 2 0.0349511570000769
13038 13038 4007 4007 239250 1 0.0346770260460667
13039 13039 4007 4007 257204 1 0.0173385130230334
13040 13040 4007 4007 277345 1 0.0198154434548953
13041 13041 4007 4007 277406 2 0.0392325764296901
13042 13042 4007 4007 291836 1 0.0184944138912356
13043 13043 4007 4007 309772 1 0.0163186004922667 
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)
);