consensus_index

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

19 rows where inchi_id = 250000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14247 14247 4386 4386 250000 1 0.0722666682166877
44226 44226 13499 13499 250000 1 0.0722666682166877
115914 115914 40440 40440 250000 1 0.0722666682166877
187242 187242 66692 66692 250000 1 0.0722666682166877
291465 291465 98720 98720 250000 3 0.363016492906601
291471 291471 98721 98721 250000 1 0.0722666682166877
458029 458029 164631 164631 250000 1 0.0722666682166877
546880 546880 216312 216312 250000 1 0.073841021198156
546882 546882 216313 216313 250000 3 0.363016492906601
720197 720197 254599 254599 250000 1 0.0722666682166877
825689 825689 286587 286587 250000 2 0.421270193625418
825692 825692 286588 286588 250000 2 0.431621031764604
825702 825702 286591 286591 250000 1 0.073841021198156
825708 825708 286592 286592 250000 1 0.0607412374842052
825714 825714 286593 286593 250000 1 0.0727402501396315
825719 825719 286594 286594 250000 1 0.0722666682166877
873451 873451 301675 301675 250000 2 0.431621031764604
940808 940808 336558 336558 250000 1 0.0727402501396315
1738336 1738336 532477 532477 250000 1 0.0722666682166877 
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)
);