consensus_index

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

22 rows where inventory_id = 537194

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1753378 1753378 537194 537194 34650 5 0.233318910573373
1753379 1753379 537194 537194 136914 1 0.0167508155478334
1753380 1753380 537194 537194 136990 2 0.189513844228449
1753381 1753381 537194 537194 168993 2 0.0547079344902279
1753382 1753382 537194 537194 185943 2 0.0547079344902279
1753383 1753383 537194 537194 192031 2 0.0536026097530669
1753384 1753384 537194 537194 195563 2 0.025789567641833
1753385 1753385 537194 537194 195628 2 0.0337664702453953
1753386 1753386 537194 537194 200242 2 0.0473784610571122
1753387 1753387 537194 537194 204092 1 0.0243648226150304
1753388 1753388 537194 537194 206281 2 0.0337664702453953
1753389 1753389 537194 537194 206857 1 0.0121824113075152
1753390 1753390 537194 537194 218034 2 0.0268013048765334
1753391 1753391 537194 537194 233496 1 0.0178675365843556
1753392 1753392 537194 537194 238946 2 0.0466550832946095
1753393 1753393 537194 537194 241682 1 0.0157654734567844
1753394 1753394 537194 537194 246712 1 0.0223344207304445
1753395 1753395 537194 537194 253113 2 0.0177495977602668
1753396 1753396 537194 537194 264331 1 0.0127625261316826
1753397 1753397 537194 537194 278990 1 0.0206163883665642
1753398 1753398 537194 537194 309941 1 0.0134006524382667
1753399 1753399 537194 537194 320431 1 0.0191437891975239 
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)
);