consensus_index

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

15 rows where inventory_id = 287705

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
829358 829358 287705 287705 11222 2 0.213006370504455
829359 829359 287705 287705 47433 1 0.106503185252227
829360 829360 287705 287705 57970 1 0.071002123501485
829361 829361 287705 287705 65096 2 0.150618249019634
829362 829362 287705 287705 69975 1 0.042601274100891
829363 829363 287705 287705 112985 4 0.16184984158041
829364 829364 287705 287705 149319 1 0.023667374500495
829365 829365 287705 287705 182660 1 0.0266257963130569
829366 829366 287705 287705 182664 1 0.0532515926261137
829367 829367 287705 287705 182667 1 0.0355010617507425
829368 829368 287705 287705 194689 1 0.0177505308753712
829369 829369 287705 287705 220621 1 0.019364215500405
829370 829370 287705 287705 252399 1 0.0163851054234196
829371 829371 287705 287705 255746 1 0.0304294815006364
829372 829372 287705 287705 334416 1 0.0213006370504455 
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)
);