consensus_index

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

18 rows where inchi_id = 195045

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
51757 51757 16045 16045 195045 3 0.22795274768709
97405 97405 34561 34561 195045 3 0.22795274768709
196058 196058 69539 69539 195045 4 0.229923108754661
314080 314080 105955 105955 195045 3 0.227383158502931
314674 314674 106140 106140 195045 1 0.307692307692308
468084 468084 169171 169171 195045 3 0.227383158502931
468251 468251 169245 169245 195045 1 0.307692307692308
684783 684783 244297 244297 195045 3 0.22795274768709
767371 767371 268651 268651 195045 2 0.225021644704267
767375 767375 268652 268652 195045 2 0.225021644704267
767379 767379 268653 268653 195045 2 0.225021644704267
767383 767383 268654 268654 195045 3 0.22795274768709
767387 767387 268655 268655 195045 2 0.225021644704267
767391 767391 268656 268656 195045 3 0.22795274768709
904912 904912 319204 319204 195045 2 0.225021644704267
1663073 1663073 504096 504096 195045 4 0.228884441209887
1663270 1663270 504168 504168 195045 1 0.3125
1746336 1746336 534869 534869 195045 3 0.228448704925121 
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)
);