consensus_index

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

23 rows where inventory_id = 271983

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
777699 777699 271983 271983 21885 6 0.166928472475275
777700 777700 271983 271983 52192 1 0.0378546332586708
777701 777701 271983 271983 97503 3 0.0636951333100396
777702 777702 271983 271983 129063 8 0.139550451188312
777703 777703 271983 271983 136946 1 0.0220818694008913
777704 777704 271983 271983 190455 1 0.017665495520713
777705 777705 271983 271983 199658 4 0.0450216877452602
777706 777706 271983 271983 207196 4 0.0415763248378277
777707 777707 271983 271983 207197 1 0.0294424925345217
777708 777708 271983 271983 224669 4 0.0883274776035652
777709 777709 271983 271983 238499 2 0.0301975507947842
777710 777710 271983 271983 238968 4 0.0662456082026739
777711 777711 271983 271983 258848 4 0.0309458394491718
777712 777712 271983 271983 262017 2 0.0316714584666372
777713 777713 271983 271983 273973 4 0.0214225599884634
777714 777714 271983 271983 276458 2 0.0189273166293354
777715 777715 271983 271983 288174 1 0.017665495520713
777716 777716 271983 271983 289332 2 0.0312284791892919
777717 777717 271983 271983 291044 1 0.0264982432810696
777718 777718 271983 271983 291915 2 0.0165614020506685
777719 777719 271983 271983 296095 2 0.0147212462672609
777720 777720 271983 271983 320735 2 0.0192238461700532
777721 777721 271983 271983 339857 4 0.0185320307691842 
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)
);