consensus_index

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

15 rows where inventory_id = 527431

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1722072 1722072 527431 527431 1639 5 0.220846782408003
1722073 1722073 527431 527431 7040 1 0.220846782408003
1722074 1722074 527431 527431 16464 2 0.0220846782408003
1722075 1722075 527431 527431 43799 2 0.0736155941360009
1722076 1722076 527431 527431 137983 2 0.0216558087117805
1722077 1722077 527431 527431 140143 3 0.0645759909188237
1722078 1722078 527431 527431 140401 3 0.0964637174057496
1722079 1722079 527431 527431 159132 2 0.0315495403440004
1722080 1722080 527431 527431 169008 1 0.0552116956020007
1722081 1722081 527431 527431 169009 2 0.0493828418076399
1722082 1722082 527431 527431 170702 2 0.0349189423164447
1722083 1722083 527431 527431 195795 2 0.0221959367698366
1722084 1722084 527431 527431 208656 1 0.0184038985340002
1722085 1722085 527431 527431 218754 2 0.0368077970680004
1722086 1722086 527431 527431 290984 1 0.024538531378667 
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)
);