consensus_index

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

20 rows where inchi_id = 38144

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27581 27581 8003 8003 38144 8 0.413793103448276
47177 47177 14486 14486 38144 1 0.0176560370167997
104353 104353 36789 36789 38144 1 0.0176560370167997
159021 159021 57248 57248 38144 1 0.0176560370167997
187003 187003 66600 66600 38144 24 0.348837209302326
232521 232521 79532 79532 38144 8 0.413793103448276
297017 297017 100464 100464 38144 2 0.16796409360056
461627 461627 165860 165860 38144 1 0.0176560370167997
503703 503703 201547 201547 38144 8 0.413793103448276
533898 533898 211852 211852 38144 1 0.0176560370167997
562081 562081 221006 221006 38144 8 0.413793103448276
701580 701580 249912 249912 38144 12 0.418032786885246
734047 734047 258900 258900 38144 1 0.0176560370167997
796826 796826 278048 278048 38144 8 0.413793103448276
796830 796830 278049 278049 38144 7 0.517241379310345
854574 854574 295594 295594 38144 1 0.0176560370167997
877186 877186 304114 304114 38144 4 0.506024096385542
1652553 1652553 500520 500520 38144 2 0.168417965822302
1654348 1654348 501198 501198 38144 1 0.0176560370167997
1741673 1741673 533454 533454 38144 1 0.0176560370167997 
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)
);