home / zeropm-v0-0-4

consensus_index

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

29 rows where inventory_id = 427868

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1316783 1316783 427868 427868 50 1 0.0434081346911564
1316784 1316784 427868 427868 5026 1 0.0144693782303855
1316785 1316785 427868 427868 13102 1 0.0325561010183673
1316786 1316786 427868 427868 19292 1 0.0236771643769944
1316787 1316787 427868 427868 31986 1 0.0118385821884972
1316788 1316788 427868 427868 43529 1 0.0162780505091837
1316789 1316789 427868 427868 50396 1 0.0124023241974733
1316790 1316790 427868 427868 56841 1 0.00898099338437719
1316791 1316791 427868 427868 57219 1 0.0137078320077336
1316792 1316792 427868 427868 61367 10 0.167831653177846
1316793 1316793 427868 427868 75145 2 0.130224404073469
1316794 1316794 427868 427868 91291 2 0.0492201982585695
1316795 1316795 427868 427868 91427 1 0.0173632538764626
1316796 1316796 427868 427868 91431 1 0.0113238612237799
1316797 1316797 427868 427868 97057 1 0.0217040673455782
1316798 1316798 427868 427868 97370 1 0.0153205181262905
1316799 1316799 427868 427868 138664 1 0.0868162693823128
1316800 1316800 427868 427868 153141 1 0.0200345237036107
1316801 1316801 427868 427868 175261 1 0.0289387564607709
1316802 1316802 427868 427868 178281 1 0.00930174314810494
1316803 1316803 427868 427868 180035 1 0.0520897616293877
1316804 1316804 427868 427868 203079 1 0.0104179523258775
1316805 1316805 427868 427868 203382 1 0.0651122020367346
1316806 1316806 427868 427868 207203 1 0.0130224404073469
1316807 1316807 427868 427868 210591 1 0.0108520336727891
1316808 1316808 427868 427868 219653 1 0.0260448808146938
1316809 1316809 427868 427868 232687 1 0.0100172618518053
1316810 1316810 427868 427868 234514 1 0.0186034862962099
1316811 1316811 427868 427868 259706 1 0.0520897616293877
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 1897.475ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website