consensus_index

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

27 rows where inchi_id = 29751

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31453 31453 9235 9235 29751 1 0.0128379674306898
34338 34338 10149 10149 29751 8 0.625
117800 117800 41118 41118 29751 8 0.625
117903 117903 41144 41144 29751 1 0.0128379674306898
160658 160658 57735 57735 29751 1 0.0128379674306898
179875 179875 64221 64221 29751 5 0.608695652173913
268676 268676 91069 91069 29751 6 0.615384615384615
450054 450054 161421 161421 29751 4 0.6
566876 566876 222531 222531 29751 4 0.6
667777 667777 239301 239301 29751 6 0.615384615384615
727397 727397 256847 256847 29751 1 0.0128379674306898
787382 787382 275005 275005 29751 4 0.6
787384 787384 275006 275006 29751 8 0.625
840789 840789 291549 291549 29751 1 0.0128379674306898
1047806 1047806 370849 370849 29751 6 0.615384615384615
1047808 1047808 370850 370850 29751 6 0.615384615384615
1138549 1138549 386648 386648 29751 1 0.0128379674306898
1269158 1269158 417780 417780 29751 6 0.615384615384615
1380778 1380778 436334 436334 29751 1 0.0128379674306898
1490077 1490077 461114 461114 29751 6 0.615384615384615
1559993 1559993 473303 473303 29751 1 0.0128379674306898
1597803 1597803 482586 482586 29751 6 0.615384615384615
1604795 1604795 484819 484819 29751 1 0.0128379674306898
1630156 1630156 492610 492610 29751 1 0.0128379674306898
1640279 1640279 496224 496224 29751 6 0.615384615384615
1727813 1727813 529130 529130 29751 1 0.0128379674306898
1733586 1733586 530998 530998 29751 6 0.615384615384615 
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)
);