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 = 15001

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
48751 48751 15001 15001 137567 1 0.0577803491178917
48752 48752 15001 15001 147684 1 0.115560698235783
48753 48753 15001 15001 186926 1 0.0770404654905222
48754 48754 15001 15001 207566 4 0.231121396471567
48755 48755 15001 15001 231994 1 0.0462242792943133
48756 48756 15001 15001 262020 1 0.0330173423530809
48757 48757 15001 15001 263138 4 0.0878071423783632
48758 48758 15001 15001 277821 4 0.0377570779009811
48759 48759 15001 15001 288773 3 0.0468575672946358
48760 48760 15001 15001 288886 2 0.0308848957267624
48761 48761 15001 15001 291370 4 0.0630989346325478
48762 48762 15001 15001 292110 2 0.0246376236464235
48763 48763 15001 15001 294795 2 0.029837643982886
48764 48764 15001 15001 297633 2 0.0291185589395108
48765 48765 15001 15001 308467 1 0.0192601163726306
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 1456.828ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website