consensus_index

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

9 rows where inventory_id = 542127

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1763646 1763646 542127 542127 73029 1 0.039051650796998
1763647 1763647 542127 542127 90356 4 0.136680777789493
1763648 1763648 542127 542127 98477 2 0.273361555578986
1763649 1763649 542127 542127 203488 4 0.157825367699623
1763650 1763650 542127 542127 225981 2 0.04075033471398
1763651 1763651 542127 542127 229927 2 0.136680777789493
1763652 1763652 542127 542127 243522 2 0.12225100414194
1763653 1763653 542127 542127 289539 1 0.0341701944473733
1763654 1763654 542127 542127 333122 1 0.0455602592631644 
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)
);