consensus_index

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

12 rows where inventory_id = 59594

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
166466 166466 59594 59594 17909 4 0.205609186649341
166467 166467 59594 59594 46336 1 0.0969251001026663
166468 166468 59594 59594 138072 1 0.0323083667008888
166469 166469 59594 59594 157358 1 0.0242312750256666
166470 166470 59594 59594 222493 1 0.0581550600615998
166471 166471 59594 59594 226562 2 0.0839395989532588
166472 166472 59594 59594 240129 2 0.290775300307999
166473 166473 59594 59594 261968 1 0.0363469125384999
166474 166474 59594 59594 264584 2 0.0593542596299285
166475 166475 59594 59594 289998 1 0.0415393286154284
166476 166476 59594 59594 294484 1 0.0290775300307999
166477 166477 59594 59594 308145 1 0.0264341182098181 
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)
);