consensus_index

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

13 rows where inventory_id = 6857

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
23410 23410 6857 6857 3518 8 0.268558739558629
23411 23411 6857 6857 33467 1 0.0895195798528764
23412 23412 6857 6857 72107 1 0.0671396848896573
23413 23413 6857 6857 170648 1 0.0383655342226613
23414 23414 6857 6857 178740 1 0.0298398599509588
23415 23415 6857 6857 207931 1 0.0268558739558629
23416 23416 6857 6857 208103 1 0.134279369779315
23417 23417 6857 6857 220822 2 0.10963864631394
23418 23418 6857 6857 223930 1 0.0671396848896573
23419 23419 6857 6857 232261 1 0.0447597899264382
23420 23420 6857 6857 247348 1 0.0537117479117258
23421 23421 6857 6857 257247 1 0.0335698424448286
23422 23422 6857 6857 282466 1 0.0244144308689663 
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)
);