consensus_index

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

14 rows where inventory_id = 4894

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
16570 16570 4894 4894 2801 2 0.0487629332756802
16571 16571 4894 4894 33352 1 0.0222571321043411
16572 16572 4894 4894 35529 1 0.0296761761391215
16573 16573 4894 4894 56807 2 0.133542792626047
16574 16574 4894 4894 68374 8 0.267085585252093
16575 16575 4894 4894 71040 1 0.0381550836074419
16576 16576 4894 4894 71042 1 0.0333856981565116
16577 16577 4894 4894 146038 1 0.0890285284173644
16578 16578 4894 4894 169799 1 0.0667713963130233
16579 16579 4894 4894 196804 1 0.0890285284173644
16580 16580 4894 4894 217744 1 0.0667713963130233
16581 16581 4894 4894 226276 1 0.0534171170504186
16582 16582 4894 4894 234440 1 0.0267085585252093
16583 16583 4894 4894 252411 1 0.0242805077501903 
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)
);