home / zeropm-v0-0-4

consensus_index

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

18 rows where inventory_id = 50020

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
140394 140394 50020 50020 8150 1 0.0185804240814103
140395 140395 50020 50020 45278 1 0.0222965088976924
140396 140396 50020 50020 88233 4 0.222965088976923
140397 140397 50020 50020 127988 1 0.0247738987752137
140398 140398 50020 50020 160363 1 0.0318521555681319
140399 140399 50020 50020 178931 1 0.0278706361221154
140400 140400 50020 50020 182665 1 0.0371608481628206
140401 140401 50020 50020 182666 1 0.0557412722442309
140402 140402 50020 50020 183864 1 0.0171511606905326
140403 140403 50020 50020 190318 1 0.222965088976923
140404 140404 50020 50020 192104 1 0.111482544488462
140405 140405 50020 50020 205015 1 0.0139353180610577
140406 140406 50020 50020 206188 1 0.0131155934692308
140407 140407 50020 50020 218600 1 0.0148643392651282
140408 140408 50020 50020 233551 1 0.0743216963256412
140409 140409 50020 50020 253834 1 0.0445930177953847
140410 140410 50020 50020 262180 1 0.015926077784066
140411 140411 50020 50020 293174 1 0.0202695535433567
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 648.818ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website