home / zeropm-v0-0-4

consensus_index

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

20 rows where inventory_id = 29

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
98 98 29 29 61698 1 0.123470793877599
99 99 29 29 136677 1 0.0154338492346999
100 100 29 29 139938 1 0.0189955067503999
101 101 29 29 189187 1 0.041156931292533
102 102 29 29 192009 1 0.035277369679314
103 103 29 29 192762 1 0.0823138625850661
104 104 29 29 195880 1 0.013718977097511
105 105 29 29 200272 1 0.0617353969387995
106 106 29 29 237240 1 0.0493883175510396
107 107 29 29 238995 1 0.0129969256713262
108 108 29 29 258403 1 0.0123470793877599
109 109 29 29 259333 1 0.0308676984693998
110 110 29 29 259505 1 0.0246941587755198
111 111 29 29 260006 1 0.0224492352504726
112 112 29 29 260045 1 0.0205784656462665
113 113 29 29 262283 1 0.246941587755198
114 114 29 29 267124 1 0.0164627725170132
115 115 29 29 294499 1 0.0145259757503058
116 116 29 29 320272 1 0.027437954195022
117 117 29 29 333227 1 0.017638684839657
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 474.68ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website