home / zeropm-v0-0-4

consensus_index

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

24 rows where inchi_id = 139770

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
13256 13256 4067 4067 139770 1 0.310344827586207
52020 52020 16136 16136 139770 1 0.310344827586207
57946 57946 18253 18253 139770 1 0.0550119027150059
115723 115723 40368 40368 139770 1 0.0552215111889159
139196 139196 49593 49593 139770 1 0.310344827586207
196822 196822 69857 69857 139770 1 0.0552215111889159
315255 315255 106327 106327 139770 1 0.307692307692308
340005 340005 114684 114684 139770 1 0.0554356852702019
468428 468428 169325 169325 139770 1 0.304347826086957
478163 478163 174502 174502 139770 1 0.0530454851124523
578241 578241 226497 226497 139770 1 0.3
696437 696437 248279 248279 139770 1 0.0552215111889159
768813 768813 268978 268978 139770 2 0.314285714285714
768815 768815 268979 268979 139770 1 0.3125
1048022 1048022 370919 370919 139770 1 0.0552215111889159
1048029 1048029 370920 370920 139770 1 0.0552215111889159
1269428 1269428 417860 417860 139770 1 0.0552215111889159
1269435 1269435 417861 417861 139770 1 0.0552215111889159
1490213 1490213 461154 461154 139770 1 0.0552215111889159
1490220 1490220 461155 461155 139770 1 0.0552215111889159
1597854 1597854 482600 482600 139770 1 0.0552215111889159
1663557 1663557 504263 504263 139770 2 0.314285714285714
1674306 1674306 508163 508163 139770 1 0.0552215111889159
1752114 1752114 536754 536754 139770 1 0.0550119027150059
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)
);
Powered by Datasette · Queries took 1594.839ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website