consensus_index

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

11 rows where inventory_id = 531073

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1733780 1733780 531073 531073 30971 5 0.225628128630441
1733781 1733781 531073 531073 101713 1 0.0647946650497119
1733782 1733782 531073 531073 136601 1 0.129589330099424
1733783 1733783 531073 531073 242164 1 0.0518357320397695
1733784 1733784 531073 531073 275015 2 0.259178660198848
1733785 1733785 531073 531073 289310 1 0.0863928867329492
1733786 1733786 531073 531073 307685 1 0.0431964433664746
1733787 1733787 531073 531073 309836 1 0.0370255228855496
1733788 1733788 531073 531073 320490 1 0.0287976289109831
1733789 1733789 531073 531073 320709 1 0.0323973325248559
1733790 1733790 531073 531073 329478 1 0.0259178660198848 
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)
);