consensus_index

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

28 rows where inventory_id = 66788

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
187552 187552 66788 66788 12804 15 0.138242609884958
187553 187553 66788 66788 31999 15 0.0600871643007782
187554 187554 66788 66788 42510 1 0.067911494520241
187555 187555 66788 66788 132800 46 0.0963727186830863
187556 187556 66788 66788 138695 11 0.0356841779229815
187557 187557 66788 66788 149689 1 0.0226371648400803
187558 187558 66788 66788 163679 1 0.0185213166873385
187559 187559 66788 66788 164434 2 0.026302008729295
187560 187560 66788 66788 215435 4 0.0342776386677428
187561 187561 66788 66788 230019 1 0.0135822989040482
187562 187562 66788 66788 230293 1 0.0156718833508248
187563 187563 66788 66788 230347 1 0.0145524631114802
187564 187564 66788 66788 230661 24 0.0535840208987509
187565 187565 66788 66788 230798 1 0.0127334052225452
187566 187566 66788 66788 230799 1 0.0119843813859249
187567 187567 66788 66788 248826 22 0.109131211411827
187568 187568 66788 66788 248933 13 0.0306469949073536
187569 187569 66788 66788 249014 12 0.0239266816376991
187570 187570 66788 66788 249064 12 0.0270314662182318
187571 187571 66788 66788 261724 1 0.0185213166873385
187572 187572 66788 66788 266405 2 0.0322132502985008
187573 187573 66788 66788 270301 2 0.00954074133164485
187574 187574 66788 66788 271113 2 0.0243509283459744
187575 187575 66788 66788 279126 2 0.0137357760795659
187576 187576 66788 66788 281630 12 0.0180612298738137
187577 187577 66788 66788 290047 2 0.012834066118806
187578 187578 66788 66788 309769 5 0.0329949879413197
187579 187579 66788 66788 331521 5 0.0239320401866528 
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)
);