consensus_index

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

18 rows where inchi_id = 97946

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
463 463 71 71 97946 1 0.382978723404255
77284 77284 27768 27768 97946 2 0.384615384615385
195370 195370 69269 69269 97946 2 0.384615384615385
206570 206570 73211 73211 97946 1 0.382978723404255
509900 509900 204256 204256 97946 1 0.375
593236 593236 231210 231210 97946 1 0.375
597739 597739 235486 235486 97946 1 0.382978723404255
672558 672558 240610 240610 97946 2 0.384615384615385
744499 744499 262019 262019 97946 2 0.384615384615385
744502 744502 262020 262020 97946 1 0.375
744505 744505 262021 262021 97946 1 0.375
872600 872600 301282 301282 97946 1 0.375
979914 979914 354019 354019 97946 2 0.384615384615385
1187830 1187830 397870 397870 97946 2 0.384615384615385
1440179 1440179 448656 448656 97946 2 0.384615384615385
1590492 1590492 480098 480098 97946 2 0.384615384615385
1711325 1711325 523776 523776 97946 2 0.384615384615385
1764202 1764202 542479 542479 97946 2 0.384615384615385 
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)
);