consensus_index

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

12 rows where inventory_id = 4708

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15133 15133 4708 4708 48081 6 0.317395726729541
15134 15134 4708 4708 136284 2 0.129576262837871
15135 15135 4708 4708 144340 1 0.0528992877882568
15136 15136 4708 4708 179834 3 0.0961243851861953
15137 15137 4708 4708 186336 1 0.0288541569754128
15138 15138 4708 4708 197263 1 0.0264496438941284
15139 15139 4708 4708 202583 1 0.0317395726729541
15140 15140 4708 4708 204326 2 0.0793489316823853
15141 15141 4708 4708 207146 2 0.0819512242520608
15142 15142 4708 4708 208623 2 0.0579482663951717
15143 15143 4708 4708 249668 2 0.0453422466756487
15144 15144 4708 4708 291098 1 0.0396744658411926 
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)
);