consensus_index

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

18 rows where inchi_id = 172166

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18602 18602 5449 5449 172166 1 0.191489361702128
33876 33876 10029 10029 172166 3 0.381329036154734
89178 89178 31867 31867 172166 1 0.192307692307692
98393 98393 34875 34875 172166 3 0.381329036154734
127979 127979 45758 45758 172166 1 0.192307692307692
193878 193878 68893 68893 172166 3 0.381329036154734
245160 245160 83413 83413 172166 1 0.191489361702128
256024 256024 86875 86875 172166 3 0.317421850901532
445155 445155 159536 159536 172166 2 0.30381200648493
481366 481366 176588 176588 172166 3 0.373148985150052
583440 583440 228029 228029 172166 3 0.317421850901532
760468 760468 266859 266859 172166 3 0.381329036154734
760472 760472 266860 266860 172166 2 0.387096774193548
824809 824809 286225 286225 172166 1 0.192307692307692
824812 824812 286226 286226 172166 1 0.1875
928377 928377 330206 330206 172166 2 0.387096774193548
1629375 1629375 492302 492302 172166 1 0.192307692307692
1634513 1634513 494124 494124 172166 3 0.302895351153522 
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)
);