home / zeropm-v0-0-4

consensus_index

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

17 rows where inchi_id = 1997

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
48459 48459 14905 14905 1997 8 0.625
48461 48461 14906 14906 1997 1 0.0942798288702266
94377 94377 33505 33505 1997 8 0.625
173318 173318 61916 61916 1997 1 0.0942798288702266
302308 302308 102313 102313 1997 8 0.625
302310 302310 102314 102314 1997 1 0.0867597272919348
505840 505840 202308 202308 1997 1 0.0867597272919348
594071 594071 231482 231482 1997 1 0.0809503784693019
671280 671280 240284 240284 1997 8 0.625
671282 671282 240285 240285 1997 1 0.0888315439222924
741872 741872 261315 261315 1997 1 0.0931526736027099
741879 741879 261316 261316 1997 1 0.0942798288702266
741886 741886 261317 261317 1997 1 0.0931526736027099
920679 920679 326696 326696 1997 1 0.0931526736027099
1655814 1655814 501720 501720 1997 8 0.625
1655816 1655816 501721 501721 1997 1 0.0942798288702266
1742877 1742877 533813 533813 1997 1 0.0942798288702266
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 1942.233ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website