consensus_index

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

17 rows where inventory_id = 497434

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1643612 1643612 497434 497434 38771 2 0.0796443380540901
1643613 1643613 497434 497434 52227 2 0.0762536482322956
1643614 1643614 497434 497434 132949 3 0.264150386001641
1643615 1643615 497434 497434 171056 3 0.0484558531858252
1643616 1643616 497434 497434 189155 1 0.0330187982502052
1643617 1643617 497434 497434 192043 2 0.132075193000821
1643618 1643618 497434 497434 237510 1 0.0660375965004103
1643619 1643619 497434 497434 237608 1 0.0220125321668034
1643620 1643620 497434 497434 238500 1 0.0293500428890712
1643621 1643621 497434 497434 241346 1 0.0176100257334427
1643622 1643622 497434 497434 243292 2 0.0499197307201471
1643623 1643623 497434 497434 243349 1 0.0203192604616647
1643624 1643624 497434 497434 274721 2 0.0373565058389609
1643625 1643625 497434 497434 290048 1 0.0188678847144029
1643626 1643626 497434 497434 320634 1 0.0528300772003282
1643627 1643627 497434 497434 322069 1 0.0165093991251026
1643628 1643628 497434 497434 326460 2 0.0261547855675865 
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)
);