consensus_index

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

26 rows where inchi_id = 20142

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
54482 54482 17010 17010 20142 5 0.608695652173913
93961 93961 33402 33402 20142 6 0.615384615384615
176909 176909 63057 63057 20142 6 0.615384615384615
325951 325951 109850 109850 20142 6 0.615384615384615
472486 472486 171417 171417 20142 4 0.6
573029 573029 224543 224543 20142 6 0.615384615384615
690475 690475 246290 246290 20142 8 0.625
776285 776285 271521 271521 20142 4 0.6
776287 776287 271522 271522 20142 4 0.6
776289 776289 271523 271523 20142 6 0.615384615384615
937692 937692 334993 334993 20142 4 0.6
1039606 1039606 368353 368353 20142 5 0.608695652173913
1039608 1039608 368354 368354 20142 5 0.608695652173913
1039610 1039610 368355 368355 20142 5 0.608695652173913
1039612 1039612 368356 368356 20142 5 0.608695652173913
1259585 1259585 414953 414953 20142 5 0.608695652173913
1259587 1259587 414954 414954 20142 5 0.608695652173913
1259589 1259589 414955 414955 20142 5 0.608695652173913
1259591 1259591 414956 414956 20142 5 0.608695652173913
1259593 1259593 414957 414957 20142 5 0.608695652173913
1484231 1484231 459281 459281 20142 5 0.608695652173913
1484233 1484233 459282 459282 20142 5 0.608695652173913
1484235 1484235 459283 459283 20142 5 0.608695652173913
1596217 1596217 481872 481872 20142 5 0.608695652173913
1668144 1668144 505913 505913 20142 5 0.608695652173913
1748917 1748917 535690 535690 20142 6 0.615384615384615 
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)
);