home / zeropm-v0-0-4

consensus_index

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

23 rows where inventory_id = 10070

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
34112 34112 10070 10070 1073 3 0.109467672854003
34113 34113 10070 10070 49220 2 0.0251136065029037
34114 34114 10070 10070 53081 1 0.109467672854003
34115 34115 10070 10070 54003 5 0.175748501338161
34116 34116 10070 10070 84323 1 0.0312764779582867
34117 34117 10070 10070 137046 1 0.0729784485693356
34118 34118 10070 10070 137627 1 0.0182446121423339
34119 34119 10070 10070 175623 1 0.0364892242846678
34120 34120 10070 10070 176824 1 0.0729784485693356
34121 34121 10070 10070 177231 1 0.0547338364270017
34122 34122 10070 10070 186533 1 0.0218935345708007
34123 34123 10070 10070 195195 1 0.0437870691416013
34124 34124 10070 10070 197883 1 0.0145956897138671
34125 34125 10070 10070 200002 1 0.0128785497475298
34126 34126 10070 10070 202593 1 0.0136834591067504
34127 34127 10070 10070 204708 1 0.0199032132461824
34128 34128 10070 10070 204867 1 0.0156382389791433
34129 34129 10070 10070 208893 1 0.0121630747615559
34130 34130 10070 10070 208894 1 0.0168411804390774
34131 34131 10070 10070 212779 1 0.0109467672854003
34132 34132 10070 10070 309510 2 0.0213659019847456
34133 34133 10070 10070 315681 1 0.0273669182135008
34134 34134 10070 10070 315682 1 0.0243261495231119
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 1884.358ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website