consensus_index

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

23 rows where inventory_id = 156859

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
437515 437515 156859 156859 47211 8 0.24968907824283
437516 437516 156859 156859 137203 2 0.124844539121415
437517 437517 156859 156859 138605 1 0.0312111347803537
437518 437518 156859 156859 161112 1 0.0356698683204042
437519 437519 156859 156859 178422 1 0.0131415304338331
437520 437520 156859 156859 192258 1 0.0277432309158699
437521 437521 156859 156859 192260 1 0.024968907824283
437522 437522 156859 156859 192435 1 0.0624222695607074
437523 437523 156859 156859 206780 1 0.0226990071129845
437524 437524 156859 156859 206781 1 0.0208074231869025
437525 437525 156859 156859 206782 2 0.0261745274617031
437526 437526 156859 156859 206783 1 0.0178349341602021
437527 437527 156859 156859 206881 1 0.016645938549522
437528 437528 156859 156859 206882 1 0.0156055673901768
437529 437529 156859 156859 206883 1 0.0146875928378135
437530 437530 156859 156859 206884 1 0.013871615457935
437531 437531 156859 156859 233640 2 0.0197396548528834
437532 437532 156859 156859 235202 2 0.0644694427842906
437533 437533 156859 156859 238975 2 0.0720790282686036
437534 437534 156859 156859 253071 2 0.0243671589671629
437535 437535 156859 156859 284030 1 0.0416148463738049
437536 437536 156859 156859 287217 1 0.0416148463738049
437537 437537 156859 156859 287325 1 0.0113495035564923 
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)
);