consensus_index

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

15 rows where inchi_id = 5233

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
24586 24586 7210 7210 5233 8 0.625
89113 89113 31836 31836 5233 8 0.625
126945 126945 45378 45378 5233 1 0.0591270603766543
166860 166860 59684 59684 5233 2 0.352403028196169
166864 166864 59685 59685 5233 14 0.327586206896552
224455 224455 77425 77425 5233 6 0.615384615384615
227235 227235 78155 78155 5233 1 0.172413793103448
432427 432427 155518 155518 5233 7 0.476190476190476
433770 433770 155889 155889 5233 1 0.063741106689325
434015 434015 155960 155960 5233 2 0.204210180883054
585174 585174 228558 228558 5233 1 0.063741106689325
589905 589905 230257 230257 5233 12 0.636363636363636
676435 676435 241743 241743 5233 8 0.625
913242 913242 322780 322780 5233 4 0.6
1618678 1618678 488753 488753 5233 8 0.625 
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)
);