home / zeropm-v0-0-4

consensus_index

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

15 rows where inventory_id = 240000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
670219 670219 240000 240000 705 8 0.246490872785237
670220 670220 240000 240000 5245 1 0.0308113590981546
670221 670221 240000 240000 15280 1 0.0616227181963093
670222 670222 240000 240000 26713 1 0.0246490872785237
670223 670223 240000 240000 43514 1 0.123245436392619
670224 670224 240000 240000 46139 1 0.0205409060654364
670225 670225 240000 240000 47282 1 0.0273878747539152
670226 670226 240000 240000 49851 1 0.0352129818264624
670227 670227 240000 240000 57687 1 0.0821636242617457
670228 670228 240000 240000 75709 1 0.0821636242617457
670229 670229 240000 240000 143835 1 0.0224082611622943
670230 670230 240000 240000 144527 1 0.0189608363680952
670231 670231 240000 240000 158359 1 0.0492981745570474
670232 670232 240000 240000 158539 1 0.0410818121308728
670233 670233 240000 240000 222107 1 0.123245436392619
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 1669.653ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website