consensus_index

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

27 rows where inventory_id = 72501

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
204520 204520 72501 72501 7337 2 0.0997808369128592
204521 204521 72501 72501 28097 1 0.00977648546177479
204522 204522 72501 72501 35682 1 0.00940046679016807
204523 204523 72501 72501 45515 1 0.01437718450261
204524 204524 72501 72501 45518 1 0.0152757585340231
204525 204525 72501 72501 54569 1 0.122206068272185
204526 204526 72501 72501 57796 1 0.048882427308874
204527 204527 72501 72501 59784 1 0.0162941424362913
204528 204528 72501 72501 60356 1 0.0116386731687795
204529 204529 72501 72501 60357 1 0.0101838390226821
204530 204530 72501 72501 75466 9 0.216326286277894
204531 204531 72501 72501 118596 1 0.0106266146323639
204532 204532 72501 72501 124774 1 0.0611030341360925
204533 204533 72501 72501 128634 1 0.0174580097531693
204534 204534 72501 72501 169699 1 0.0611030341360925
204535 204535 72501 72501 176643 1 0.0407353560907283
204536 204536 72501 72501 194194 1 0.0111096425701986
204537 204537 72501 72501 195937 1 0.024441213654437
204538 204538 72501 72501 214162 1 0.0203676780453642
204539 204539 72501 72501 220316 1 0.0271569040604855
204540 204540 72501 72501 232088 1 0.0349160195063385
204541 204541 72501 72501 232089 1 0.0305515170680462
204542 204542 72501 72501 241202 1 0.0222192851403973
204543 204543 72501 72501 249156 1 0.0188009335803361
204544 204544 72501 72501 255149 1 0.0122206068272185
204545 204545 72501 72501 270307 1 0.0135784520302428
204546 204546 72501 72501 275620 1 0.01286379666023 
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)
);