home / zeropm-v0-0-4

consensus_index

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

10 rows where inventory_id = 392517

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1168753 1168753 392517 392517 46528 3 0.211204802174614
1168754 1168754 392517 392517 81277 5 0.185313883588293
1168755 1168755 392517 392517 142861 3 0.12088457257247
1168756 1168756 392517 392517 182554 1 0.152305017591599
1168757 1168757 392517 392517 183469 1 0.0380762543978998
1168758 1168758 392517 392517 189605 1 0.0338455594647998
1168759 1168759 392517 392517 195229 1 0.0609220070366396
1168760 1168760 392517 392517 231209 2 0.0879333429054404
1168761 1168761 392517 392517 290463 1 0.0507683391971997
1168762 1168762 392517 392517 308242 1 0.0435157193118854
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 795.149ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website