consensus_index

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

24 rows where inchi_id = 197534

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
43749 43749 13345 13345 197534 2 0.0927839338883277
79880 79880 28833 28833 197534 2 0.0927839338883277
151176 151176 54185 54185 197534 2 0.0927839338883277
289968 289968 98199 98199 197534 2 0.118982755846728
457536 457536 164436 164436 197534 2 0.0927839338883277
548026 548026 216689 216689 197534 1 0.0652544452307932
718935 718935 254204 254204 197534 2 0.0927839338883277
823381 823381 285822 285822 197534 2 0.0927839338883277
823388 823388 285823 285823 197534 1 0.0652544452307932
823395 823395 285824 285824 197534 1 0.0652544452307932
823402 823402 285825 285825 197534 1 0.0652544452307932
897440 897440 315364 315364 197534 1 0.0652544452307932
1076456 1076456 377836 377836 197534 2 0.0946672934851701
1076463 1076463 377837 377837 197534 2 0.0946672934851701
1076470 1076470 377838 377838 197534 2 0.0946672934851701
1303128 1303128 425908 425908 197534 2 0.0946672934851701
1303135 1303135 425909 425909 197534 2 0.0946672934851701
1303142 1303142 425910 425910 197534 2 0.0946672934851701
1511065 1511065 466255 466255 197534 2 0.0946672934851701
1511072 1511072 466256 466256 197534 2 0.0946672934851701
1511079 1511079 466257 466257 197534 2 0.0946672934851701
1602300 1602300 484001 484001 197534 2 0.0946672934851701
1649404 1649404 499481 499481 197534 2 0.0946672934851701
1737938 1737938 532362 532362 197534 2 0.0927839338883277 
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)
);