consensus_index

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

31 rows where inchi_id = 870

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
33933 33933 10040 10040 870 2 0.0823923351203211
47867 47867 14733 14733 870 9 0.443823833642027
105950 105950 37266 37266 870 2 0.0823923351203211
144156 144156 51400 51400 870 6 0.356073228699856
164733 164733 58954 58954 870 2 0.0858356407735085
164741 164741 58956 58956 870 17 0.37707662595707
256434 256434 86986 86986 870 2 0.0823923351203211
445445 445445 159610 159610 870 2 0.0823923351203211
582856 582856 227866 227866 870 2 0.0823923351203211
669928 669928 239918 239918 870 10 0.446898779756052
681612 681612 243446 243446 870 2 0.0823923351203211
683038 683038 243922 243922 870 5 0.367529555320203
726318 726318 256550 256550 870 2 0.209789710142509
739376 739376 260541 260541 870 6 0.561959542366711
739379 739379 260542 260542 870 9 0.443823833642027
739383 739383 260543 260543 870 11 0.441458130670272
761835 761835 267221 267221 870 2 0.0823923351203211
764414 764414 267951 267951 870 4 0.378378378378378
764417 764417 267952 267952 870 5 0.367529555320203
838816 838816 290964 290964 870 2 0.205613947414223
928814 928814 330417 330417 870 5 0.551370854534993
928831 928831 330425 330425 870 3 0.375
951225 951225 341256 341256 870 2 0.0709527770478832
971986 971986 352288 352288 870 9 0.443823833642027
1182154 1182154 396347 396347 870 9 0.443823833642027
1436401 1436401 447648 447648 870 9 0.443823833642027
1589635 1589635 479851 479851 870 9 0.443823833642027
1634848 1634848 494213 494213 870 2 0.0823923351203211
1730650 1730650 530010 530010 870 2 0.0709527770478832
1742421 1742421 533686 533686 870 9 0.443823833642027
1745918 1745918 534763 534763 870 5 0.367529555320203 
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)
);