consensus_index

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

25 rows where inchi_id = 63042

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
16305 16305 4869 4869 63042 8 0.413793103448276
84894 84894 30545 30545 63042 8 0.413793103448276
128219 128219 45825 45825 63042 16 0.311512415349887
212399 212399 74207 74207 63042 8 0.521739130434783
278688 278688 94489 94489 63042 1 0.125960542697603
374579 374579 127791 127791 63042 1 0.104583251628628
423890 423890 153271 153271 63042 8 0.521739130434783
546350 546350 216117 216117 63042 7 0.620689655172414
576013 576013 225737 225737 63042 3 0.690983005625053
721119 721119 254913 254913 63042 8 0.413793103448276
827224 827224 287115 287115 63042 8 0.413793103448276
827228 827228 287116 287116 63042 8 0.521739130434783
827230 827230 287117 287117 63042 5 0.608695652173913
901298 901298 317264 317264 63042 1 0.103500806539223
935251 935251 333777 333777 63042 4 0.6
1090178 1090178 380877 380877 63042 8 0.413793103448276
1090182 1090182 380878 380878 63042 8 0.413793103448276
1319070 1319070 429456 429456 63042 8 0.413793103448276
1319074 1319074 429457 429457 63042 8 0.413793103448276
1521130 1521130 468689 468689 63042 8 0.413793103448276
1521134 1521134 468690 468690 63042 8 0.413793103448276
1602809 1602809 484191 484191 63042 8 0.413793103448276
1609649 1609649 485996 485996 63042 8 0.413793103448276
1690302 1690302 514529 514529 63042 1 0.101610849285733
1716010 1716010 525606 525606 63042 8 0.413793103448276 
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)
);