consensus_index

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

22 rows where inchi_id = 2147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
47293 47293 14562 14562 2147 2 0.0811723752001755
48508 48508 14919 14919 2147 8 0.412865521868252
122081 122081 42410 42410 2147 8 0.412865521868252
164706 164706 58945 58945 2147 10 0.395370178901232
164711 164711 58946 58946 2147 2 0.0924002832938847
302544 302544 102383 102383 2147 10 0.395370178901232
463065 463065 166335 166335 2147 10 0.395370178901232
468703 468703 169457 169457 2147 6 0.240842980932421
502476 502476 200810 200810 2147 6 0.388371021797955
527156 527156 209636 209636 2147 10 0.395370178901232
593978 593978 231449 231449 2147 10 0.395370178901232
668946 668946 239661 239661 2147 2 0.083408310741195
671549 671549 240364 240364 2147 14 0.408972974049514
737509 737509 260042 260042 2147 2 0.0811723752001755
737515 737515 260043 260043 2147 3 0.080729180465167
742585 742585 261472 261472 2147 10 0.395370178901232
742591 742591 261473 261473 2147 8 0.412865521868252
952337 952337 341677 341677 2147 4 0.404268484758723
952349 952349 341685 341685 2147 2 0.082252118054176
1655925 1655925 501759 501759 2147 8 0.412865521868252
1741844 1741844 533545 533545 2147 2 0.0761429962052145
1742922 1742922 533825 533825 2147 10 0.395370178901232 
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)
);