consensus_index

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

27 rows where inchi_id = 29287

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
62499 62499 20129 20129 29287 3 0.320338184482712
87854 87854 31425 31425 29287 3 0.320338184482712
142805 142805 50906 50906 29287 7 0.312267161241712
362144 362144 122991 122991 29287 4 0.331329067133496
477644 477644 174217 174217 29287 8 0.625
486389 486389 180352 180352 29287 4 0.331329067133496
555551 555551 218977 218977 29287 4 0.331329067133496
599800 599800 236289 236289 29287 1 1.02118201755693e-05
663004 663004 237723 237723 29287 2 0.32867691749743
709915 709915 251884 251884 29287 3 0.320338184482712
808858 808858 281611 281611 29287 3 0.320338184482712
808865 808865 281612 281612 29287 2 0.32867691749743
808872 808872 281613 281613 29287 2 0.32867691749743
1061840 1061840 374933 374933 29287 3 0.320338184482712
1061847 1061847 374934 374934 29287 3 0.320338184482712
1061854 1061854 374935 374935 29287 3 0.320338184482712
1285692 1285692 422637 422637 29287 3 0.320338184482712
1285699 1285699 422638 422638 29287 3 0.320338184482712
1285706 1285706 422639 422639 29287 3 0.320338184482712
1285713 1285713 422640 422640 29287 3 0.320338184482712
1500412 1500412 464155 464155 29287 3 0.320338184482712
1500419 1500419 464156 464156 29287 3 0.320338184482712
1500426 1500426 464157 464157 29287 3 0.320338184482712
1600542 1600542 483502 483502 29287 3 0.320338184482712
1673799 1673799 507972 507972 29287 8 0.625
1683252 1683252 511694 511694 29287 3 0.320338184482712
1756070 1756070 538259 538259 29287 3 0.320338184482712 
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)
);