consensus_index

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

15 rows where inventory_id = 20126

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
62479 62479 20126 20126 49167 10 0.145785151136878
62480 62480 20126 20126 65004 2 0.119480243582552
62481 62481 20126 20126 173801 2 0.087256032781834
62482 62482 20126 20126 174264 1 0.0422426452275215
62483 62483 20126 20126 177752 2 0.0325184034578552
62484 62484 20126 20126 186649 2 0.168970580910086
62485 62485 20126 20126 211530 2 0.0616993324794705
62486 62486 20126 20126 216556 3 0.0460195849558958
62487 62487 20126 20126 239027 2 0.087256032781834
62488 62488 20126 20126 241986 1 0.0241386544157265
62489 62489 20126 20126 261485 2 0.0689819507952284
62490 62490 20126 20126 287579 2 0.0354258595640274
62491 62491 20126 20126 295058 1 0.0281617634850143
62492 62492 20126 20126 320897 1 0.0225294107880114
62493 62493 20126 20126 326525 1 0.0198788918717748 
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)
);