consensus_index

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

21 rows where inchi_id = 49227

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15185 15185 4715 4715 49227 8 0.461538461538462
46987 46987 14390 14390 49227 1 0.0600450334332226
61035 61035 19505 19505 49227 1 0.211267605633803
92329 92329 32923 32923 49227 8 0.461538461538462
123903 123903 42989 42989 49227 1 0.0600450334332226
209249 209249 73818 73818 49227 7 0.45993031358885
299499 299499 101219 101219 49227 1 0.0600450334332226
422109 422109 153079 153079 49227 8 0.375903614457831
536716 536716 213002 213002 49227 1 0.0600450334332226
703126 703126 250388 250388 49227 1 0.211267605633803
730709 730709 257771 257771 49227 1 0.0600450334332226
799450 799450 278898 278898 49227 1 0.148181409968568
799456 799456 278899 278899 49227 1 0.211267605633803
809882 809882 281939 281939 49227 8 0.461538461538462
809887 809887 281940 281940 49227 8 0.390166220119898
848752 848752 293613 293613 49227 1 0.0600450334332226
868021 868021 299474 299474 49227 4 0.452830188679245
926384 926384 329432 329432 49227 1 0.208816705336427
1608127 1608127 485764 485764 49227 8 0.461538461538462
1741469 1741469 533350 533350 49227 1 0.0600450334332226
1754952 1754952 537800 537800 49227 1 0.211267605633803 
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)
);