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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1316986 1316986 427875 427875 50 1 0.0434081346911564
1316987 1316987 427875 427875 5026 1 0.0144693782303855
1316988 1316988 427875 427875 13102 1 0.0325561010183673
1316989 1316989 427875 427875 19292 1 0.0236771643769944
1316990 1316990 427875 427875 31986 1 0.0118385821884972
1316991 1316991 427875 427875 43529 1 0.0162780505091837
1316992 1316992 427875 427875 50396 1 0.0124023241974733
1316993 1316993 427875 427875 56841 1 0.00898099338437719
1316994 1316994 427875 427875 57219 1 0.0137078320077336
1316995 1316995 427875 427875 61367 10 0.167831653177846
1316996 1316996 427875 427875 75145 2 0.130224404073469
1316997 1316997 427875 427875 91291 2 0.0492201982585695
1316998 1316998 427875 427875 91427 1 0.0173632538764626
1316999 1316999 427875 427875 91431 1 0.0113238612237799
1317000 1317000 427875 427875 97057 1 0.0217040673455782
1317001 1317001 427875 427875 97370 1 0.0153205181262905
1317002 1317002 427875 427875 138664 1 0.0868162693823128
1317003 1317003 427875 427875 153141 1 0.0200345237036107
1317004 1317004 427875 427875 175261 1 0.0289387564607709
1317005 1317005 427875 427875 178281 1 0.00930174314810494
1317006 1317006 427875 427875 180035 1 0.0520897616293877
1317007 1317007 427875 427875 203079 1 0.0104179523258775
1317008 1317008 427875 427875 203382 1 0.0651122020367346
1317009 1317009 427875 427875 207203 1 0.0130224404073469
1317010 1317010 427875 427875 210591 1 0.0108520336727891
1317011 1317011 427875 427875 219653 1 0.0260448808146938
1317012 1317012 427875 427875 232687 1 0.0100172618518053
1317013 1317013 427875 427875 234514 1 0.0186034862962099
1317014 1317014 427875 427875 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 1617.095ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website