consensus_index

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

18 rows where inventory_id = 242982

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
679982 679982 242982 242982 7814 7 0.22757432405429
679983 679983 242982 242982 52391 2 0.0384707063045212
679984 679984 242982 242982 136466 3 0.22018539049862
679985 679985 242982 242982 137782 2 0.0800831612895692
679986 679986 242982 242982 169143 1 0.0308240231520593
679987 679987 242982 242982 173351 2 0.0392325764296901
679988 679988 242982 242982 177859 2 0.046236034728089
679989 679989 242982 242982 189480 2 0.0605371797074499
679990 679990 242982 242982 190639 1 0.0154120115760297
679991 679991 242982 242982 195505 2 0.0295726671764143
679992 679992 242982 242982 213929 1 0.0231180173640445
679993 679993 242982 242982 237760 2 0.0349511570000769
679994 679994 242982 242982 239250 1 0.0346770260460667
679995 679995 242982 242982 257204 1 0.0173385130230334
679996 679996 242982 242982 277345 1 0.0198154434548953
679997 679997 242982 242982 277406 2 0.0392325764296901
679998 679998 242982 242982 291836 1 0.0184944138912356
679999 679999 242982 242982 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)
);