home / zeropm-v0-0-4

consensus_index

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

31 rows where inventory_id = 442731

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1421615 1421615 442731 442731 657 1 0.0230490939152559
1421616 1421616 442731 442731 2254 1 0.0414883690474607
1421617 1421617 442731 442731 4766 1 0.0518604613093258
1421618 1421618 442731 442731 21841 1 0.0148172746598074
1421619 1421619 442731 442731 25029 1 0.0129651153273315
1421620 1421620 442731 442731 26332 1 0.0207441845237303
1421621 1421621 442731 442731 28000 1 0.00864341021822097
1421622 1421622 442731 442731 29741 1 0.0103720922618652
1421623 1421623 442731 442731 35792 1 0.0159570650182541
1421624 1421624 442731 442731 47222 1 0.0296345493196148
1421625 1421625 442731 442731 54354 1 0.0122024614845473
1421626 1421626 442731 442731 54894 1 0.0138294563491536
1421627 1421627 442731 442731 56546 1 0.00740863732990369
1421628 1421628 442731 442731 58604 1 0.0259302306546629
1421629 1421629 442731 442731 76691 8 0.207441845237303
1421630 1421630 442731 442731 84076 1 0.0172868204364419
1421631 1421631 442731 442731 90492 1 0.0691472817457678
1421632 1421632 442731 442731 90493 1 0.103720922618652
1421633 1421633 442731 442731 90494 1 0.0188583495670276
1421634 1421634 442731 442731 138217 1 0.0345736408728839
1421635 1421635 442731 442731 139924 1 0.011524546957628
1421636 1421636 442731 442731 140000 1 0.00829767380949213
1421637 1421637 442731 442731 149065 1 0.0109179918545949
1421638 1421638 442731 442731 164396 1 0.00942917478351379
1421639 1421639 442731 442731 164744 1 0.00901921066249145
1421640 1421640 442731 442731 167350 1 0.103720922618652
1421641 1421641 442731 442731 167732 1 0.00987818310653825
1421642 1421642 442731 442731 167902 1 0.00768303130508531
1421643 1421643 442731 442731 172126 1 0.0691472817457678
1421644 1421644 442731 442731 187780 1 0.00797853250912705
1421645 1421645 442731 442731 188572 1 0.00715316707714839
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)
);
Powered by Datasette · Queries took 1447.925ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website