consensus_index

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

22 rows where inchi_id = 29879

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
24 24 5 5 29879 4 0.6
132936 132936 47207 47207 29879 7 0.620689655172414
202185 202185 71694 71694 29879 6 0.615384615384615
418958 418958 149676 149676 29879 2 0.630993034743972
529066 529066 210100 210100 29879 6 0.615384615384615
529068 529068 210101 210101 29879 7 0.476190476190476
566770 566770 222503 222503 29879 6 0.615384615384615
787631 787631 275075 275075 29879 4 0.6
787633 787633 275076 275076 29879 7 0.620689655172414
901913 901913 317611 317611 29879 4 0.6
1047956 1047956 370897 370897 29879 7 0.620689655172414
1047958 1047958 370898 370898 29879 7 0.620689655172414
1047960 1047960 370899 370899 29879 7 0.620689655172414
1269347 1269347 417831 417831 29879 7 0.620689655172414
1269349 1269349 417832 417832 29879 7 0.620689655172414
1269351 1269351 417833 417833 29879 7 0.620689655172414
1490174 1490174 461141 461141 29879 7 0.620689655172414
1490176 1490176 461142 461142 29879 7 0.620689655172414
1490178 1490178 461143 461143 29879 7 0.620689655172414
1597842 1597842 482596 482596 29879 7 0.620689655172414
1674252 1674252 508143 508143 29879 7 0.620689655172414
1752098 1752098 536744 536744 29879 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)
);