consensus_index

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

12 rows where inventory_id = 533659

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1742321 1742321 533659 533659 215 1 0.116862913769095
1742322 1742322 533659 533659 755 2 0.165269117590692
1742323 1742323 533659 533659 756 4 0.23372582753819
1742324 1742324 533659 533659 2438 1 0.0467451655076381
1742325 1742325 533659 533659 2439 1 0.0389543045896984
1742326 1742326 533659 533659 75973 1 0.0779086091793968
1742327 1742327 533659 533659 76425 1 0.0333894039340272
1742328 1742328 533659 533659 136452 1 0.0779086091793968
1742329 1742329 533659 533659 139912 1 0.0292157284422738
1742330 1742330 533659 533659 142231 1 0.0259695363931322
1742331 1742331 533659 533659 182948 2 0.0826345587953459
1742332 1742332 533659 533659 253861 1 0.0584314568845476 
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)
);