consensus_index

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

19 rows where inventory_id = 79429

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
232137 232137 79429 79429 37114 6 0.131960588857068
232138 232138 79429 79429 77512 4 0.0631394773430079
232139 232139 79429 79429 133163 6 0.251565521186367
232140 232140 79429 79429 136304 1 0.0251565521186367
232141 232141 79429 79429 150458 1 0.027951724576263
232142 232142 79429 79429 159813 1 0.0228695928351243
232143 232143 79429 79429 184959 2 0.125782760593183
232144 232144 79429 79429 213385 1 0.0157228450741479
232145 232145 79429 79429 223231 1 0.0209637934321972
232146 232146 79429 79429 230295 2 0.0513505969819925
232147 232147 79429 79429 235151 1 0.0193511939374128
232148 232148 79429 79429 235219 2 0.0419275868643945
232149 232149 79429 79429 237495 1 0.0359379315980524
232150 232150 79429 79429 237600 2 0.0296472809906013
232151 232151 79429 79429 251506 2 0.0503131042372734
232152 232152 79429 79429 288683 2 0.0220637557737655
232153 232153 79429 79429 288692 2 0.0202717273928988
232154 232154 79429 79429 309063 1 0.0167710347457578
232155 232155 79429 79429 309498 1 0.0209637934321972 
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)
);