consensus_index

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

17 rows where inventory_id = 214690

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
542625 542625 214690 214690 70925 4 0.137104530228541
542626 542626 214690 214690 115988 1 0.0715267287062936
542627 542627 214690 214690 120402 3 0.214580186118881
542628 542628 214690 214690 142925 1 0.0134112616324301
542629 542629 214690 214690 223594 2 0.075865552356466
542630 542630 214690 214690 229307 4 0.214580186118881
542631 542631 214690 214690 229308 1 0.0143053457412587
542632 542632 214690 214690 230506 1 0.0153271561513486
542633 542633 214690 214690 232064 1 0.0429160372237762
542634 542634 214690 214690 232066 1 0.0357633643531468
542635 542635 214690 214690 232070 1 0.0306543123026973
542636 542636 214690 214690 232071 1 0.0268225232648601
542637 542637 214690 214690 232074 1 0.0238422429020979
542638 542638 214690 214690 232078 1 0.0214580186118881
542639 542639 214690 214690 232181 1 0.019507289647171
542640 542640 214690 214690 232182 1 0.0178816821765734
542641 542641 214690 214690 232183 1 0.0165061681629908 
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)
);