consensus_index

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

26 rows where inchi_id = 81207

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
12304 12304 3767 3767 81207 4 0.473684210526316
18187 18187 5315 5315 81207 8 0.9
89161 89161 31861 31861 81207 8 0.9
198107 198107 70452 70452 81207 13 0.933333333333333
216163 216163 75057 75057 81207 7 0.888888888888889
217564 217564 75464 75464 81207 2 0.158943953012576
426479 426479 153828 153828 81207 7 0.888888888888889
535413 535413 212474 212474 81207 5 0.857142857142857
732706 732706 258399 258399 81207 8 0.9
851684 851684 294693 294693 81207 4 0.833333333333333
851685 851685 294694 294694 81207 8 0.9
851686 851686 294695 294695 81207 4 0.833333333333333
851687 851687 294696 294696 81207 8 0.9
851688 851688 294697 294697 81207 8 0.9
855689 855689 295980 295980 81207 1 0.153846153846154
855693 855693 295981 295981 81207 1 0.150943396226415
1170657 1170657 393198 393198 81207 8 0.625
1170659 1170659 393199 393199 81207 8 0.625
1426467 1426467 444858 444858 81207 8 0.625
1426469 1426469 444859 444859 81207 8 0.625
1584631 1584631 478430 478430 81207 8 0.625
1584633 1584633 478431 478431 81207 8 0.625
1606337 1606337 485299 485299 81207 8 0.625
1611940 1611940 486609 486609 81207 8 0.625
1612842 1612842 486919 486919 81207 1 0.153846153846154
1717591 1717591 526025 526025 81207 6 0.875 
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)
);