consensus_index

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

26 rows where inventory_id = 87304

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
257876 257876 87304 87304 13150 6 0.0691134390670587
257877 257877 87304 87304 53041 3 0.072757555696376
257878 257878 87304 87304 103570 14 0.149295761208547
257879 257879 87304 87304 106602 1 0.029641459585967
257880 257880 87304 87304 140089 1 0.0203785034653523
257881 257881 87304 87304 274619 1 0.0155264788307446
257882 257882 87304 87304 284818 2 0.0199917794471011
257883 257883 87304 87304 313847 3 0.0630956242427835
257884 257884 87304 87304 314160 4 0.0696597579243653
257885 257885 87304 87304 314544 2 0.0262743457037626
257886 257886 87304 87304 315061 2 0.0435710731557336
257887 257887 87304 87304 315125 1 0.0130422422178255
257888 257888 87304 87304 315178 2 0.0283795369210687
257889 257889 87304 87304 315367 1 0.0163028027722818
257890 257890 87304 87304 315626 1 0.0326056055445636
257891 257891 87304 87304 315866 2 0.0245773999212839
257892 257892 87304 87304 315867 2 0.031374758563741
257893 257893 87304 87304 316308 2 0.0225000054278055
257894 257894 87304 87304 317291 2 0.0213149511441332
257895 257895 87304 87304 317399 2 0.0815140138614091
257896 257896 87304 87304 317401 2 0.0228284900358629
257897 257897 87304 87304 317478 3 0.0370785406483113
257898 257898 87304 87304 317664 2 0.0171846630016393
257899 257899 87304 87304 317898 1 0.0135856689769015
257900 257900 87304 87304 318033 1 0.0171608450234545
257901 257901 87304 87304 332568 1 0.0362284506050707 
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)
);