home / zeropm-v0-0-4

consensus_index

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

12 rows where inchi_id = 36360

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
52906 52906 16457 16457 36360 1 0.113636363636364
122712 122712 42652 42652 36360 1 0.113636363636364
178405 178405 63579 63579 36360 1 0.113636363636364
273709 273709 92830 92830 36360 7 0.620689655172414
318985 318985 107485 107485 36360 1 0.171428571428571
319511 319511 107669 107669 36360 1 0.113207547169811
469883 469883 170013 170013 36360 1 0.113636363636364
687601 687601 245212 245212 36360 1 0.113636363636364
931916 931916 331898 331898 36360 1 0.112
1664998 1664998 504765 504765 36360 1 0.172413793103448
1665222 1665222 504853 504853 36360 1 0.113989637305699
1747559 1747559 535259 535259 36360 1 0.113636363636364
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 555.399ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website