consensus_index

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

19 rows where inchi_id = 9345

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
50508 50508 15681 15681 9345 8 0.625
162898 162898 58348 58348 9345 12 0.417391304347826
309488 309488 104546 104546 9345 8 0.413793103448276
310472 310472 104828 104828 9345 1 0.108815330410518
466875 466875 168628 168628 9345 1 0.108815330410518
506000 506000 202359 202359 9345 8 0.413793103448276
581796 581796 227552 227552 9345 1 0.108815330410518
582473 582473 227749 227749 9345 8 0.413793103448276
762081 762081 267297 267297 9345 8 0.625
936199 936199 334266 334266 9345 4 0.6
1027224 1027224 364991 364991 9345 8 0.625
1027226 1027226 364992 364992 9345 8 0.625
1245133 1245133 411080 411080 9345 8 0.625
1245135 1245135 411081 411081 9345 8 0.625
1474775 1474775 456705 456705 9345 8 0.625
1474777 1474777 456706 456706 9345 8 0.625
1594034 1594034 481140 481140 9345 8 0.625
1660644 1660644 503334 503334 9345 8 0.625
1661227 1661227 503516 503516 9345 1 0.111040793835332 
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)
);