consensus_index

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

20 rows where inchi_id = 51327

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
8542 8542 2578 2578 51327 7 0.620689655172414
10468 10468 3186 3186 51327 3 0.200917693242684
70155 70155 23644 23644 51327 1 0.192307692307692
106821 106821 37621 37621 51327 1 0.192307692307692
155080 155080 55785 55785 51327 1 0.192307692307692
198991 198991 70752 70752 51327 7 0.620689655172414
204985 204985 72647 72647 51327 3 0.201254698503602
209523 209523 73873 73873 51327 8 0.625
389888 389888 134180 134180 51327 1 0.19047619047619
511442 511442 205906 205906 51327 8 0.625
511444 511444 205907 205907 51327 8 0.625
553855 553855 218495 218495 51327 8 0.625
576711 576711 226027 226027 51327 1 0.192307692307692
663246 663246 237792 237792 51327 8 0.625
812778 812778 282694 282694 51327 8 0.625
812780 812780 282695 282695 51327 8 0.625
836056 836056 290064 290064 51327 1 0.19047619047619
926805 926805 329619 329619 51327 1 0.1875
1705460 1705460 521187 521187 51327 1 0.192307692307692
1714816 1714816 525422 525422 51327 4 0.6 
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)
);