RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB2368 · 20 ✖

analysis 1

  • diamond · 20 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
1297110 1297110 PRJEB2368_P_NODE_2882_length_492_cov_1.707692_g2585_i0 PRJEB2368 2882 492 1.707692 8.40184464 Opisthorchis viverrini 6198 Platyhelminthes Platyhelminthes 287 4.9e-93   NR XP_009170841.1 6198 g2585 i0 77.8 1.09756097560976 180 23 99.4 1 3 491 66 245 XP_009170841.1 hypothetical protein T265_07133 [Opisthorchis viverrini] diamond 540 287 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Opisthorchiidae Opisthorchis Opisthorchis viverrini
3849151 3849151 PRJEB2368_P_NODE_924_length_903_cov_2.983834_g736_i0 PRJEB2368 924 903 2.983834 26.94402102 Plagiorchiida 27871 Platyhelminthes Platyhelminthes 449 1.37e-150   NR VDP90003.1 27848 g736 i0 93.1 4.06976744186047 245 16 81.4 1 167 901 320 563 VDP90003.1 unnamed protein product [Echinostoma caproni] diamond 3675 451 0.995565410199557 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Echinostomatidae Echinostoma Echinostoma caproni
8949903 8949903 PRJEB2368_P_NODE_13768_length_174_cov_1.927007_g13449_i0 PRJEB2368 13768 174 1.927007 3.35299218 Metazoa 33208 Platyhelminthes Platyhelminthes 115 6.67e-29   NR THD21498.1 6192 g13449 i0 94.7 2.94827586206897 57 3 98.3 0 3 173 267 323 THD21498.1 Elongation FacTor [Fasciola hepatica] diamond 513 115 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciola Fasciola hepatica
24248724 24248724 PRJEB2368_P_NODE_360_length_1381_cov_2.383185_g265_i0 PRJEB2368 360 1381 2.383185 32.91178485 Heterophyidae 84526 Platyhelminthes Platyhelminthes 285 4.12e-88   NR YP_008994157.1 84529 g265 i0 56.7 1.18826937002172 277 73 50 3 697 8 129 405 YP_008994157.1 NADH dehydrogenase subunit 4 [Metagonimus yokogawai] diamond 1641 285 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Heterophyidae Metagonimus Metagonimus yokogawai
26811686 26811686 PRJEB2368_P_NODE_8081_length_287_cov_1.744000_g7763_i0 PRJEB2368 8081 287 1.744 5.00528 Schistosoma margrebowiei 48269 Platyhelminthes Platyhelminthes 45.8 0.00213   NR VDO91441.1 48269 g7763 i0 82.6 1.85017421602787 23 4 24 0 6 74 41 63 VDO91441.1 unnamed protein product [Schistosoma margrebowiei] diamond 531 45.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma margrebowiei
26868721 26868721 PRJEB2368_P_NODE_10221_length_287_cov_1.280000_g9903_i0 PRJEB2368 10221 287 1.28 3.6736 Schistosoma 6181 Platyhelminthes Platyhelminthes 47 0.0017   NR XP_012797820.2 6185 g9903 i0 87.5 0.501742160278746 24 3 25.1 0 214 285 120 143 XP_012797820.2 hypothetical protein MS3_00009259 [Schistosoma haematobium] diamond 144 47 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium
26875267 26875267 PRJEB2368_P_NODE_12521_length_203_cov_2.168675_g12202_i0 PRJEB2368 12521 203 2.168675 4.40241025 Haplorchis taichui 235153 Platyhelminthes Platyhelminthes 87.4 2.48e-19   NR AYV63033.1 235153 g12202 i0 77.8 0.798029556650246 54 12 79.8 0 2 163 90 143 AYV63033.1 cytochrome c oxidase subunit III [Haplorchis taichui] diamond 162 87.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Heterophyidae Haplorchis Haplorchis taichui
27121233 27121233 PRJEB2368_P_NODE_14682_length_162_cov_0.888000_g14363_i0 PRJEB2368 14682 162 0.888 1.43856 Trematoda 6178 Platyhelminthes Platyhelminthes 111 8.260000000000001e-27   NR KAA0200534.1 27845 g14363 i0 94.3 4.90740740740741 53 3 98.1 0 161 3 184 236 KAA0200534.1 Phosphoenolpyruvate carboxykinase [Fasciolopsis buskii] diamond 795 111 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciolopsis Fasciolopsis buskii
27248004 27248004 PRJEB2368_P_NODE_12023_length_226_cov_1.238095_g11704_i0 PRJEB2368 12023 226 1.238095 2.7980947 Opisthorchis 6197 Platyhelminthes Platyhelminthes 125 4.55e-33   NR OON21665.1 6198 g11704 i0 86.5 1.9646017699115 74 9 98.2 1 3 224 23 95 OON21665.1 malate dehydrogenase, NAD-dependent [Opisthorchis viverrini] diamond 444 126 0.992063492063492 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Opisthorchiidae Opisthorchis Opisthorchis viverrini
27791440 27791440 PRJEB2368_P_NODE_2984_length_479_cov_2.443439_g2685_i0 PRJEB2368 2984 479 2.443439 11.70407281 Haplorchis taichui 235153 Platyhelminthes Platyhelminthes 169 4.46e-49   NR AYV63038.1 235153 g2685 i0 72.8 0.713987473903967 114 31 71.4 0 476 135 52 165 AYV63038.1 NADH dehydrogenase subunit 2 [Haplorchis taichui] diamond 342 169 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Heterophyidae Haplorchis Haplorchis taichui
27974326 27974326 PRJEB2368_P_NODE_15945_length_151_cov_1.026316_g15626_i0 PRJEB2368 15945 151 1.026316 1.54973716 Opisthorchiidae 6196 Platyhelminthes Platyhelminthes 99.4 1.5999999999999999e-24   NR XP_009174389.1 6198 g15626 i0 95.9 2.9205298013245 49 2 97.4 0 149 3 1 49 XP_009174389.1 hypothetical protein T265_09909 [Opisthorchis viverrini] diamond 441 99.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Opisthorchiidae Opisthorchis Opisthorchis viverrini
28170222 28170222 PRJEB2368_P_NODE_10306_length_287_cov_1.256000_g9988_i0 PRJEB2368 10306 287 1.256 3.60472 Schistosoma rodhaini 6188 Platyhelminthes Platyhelminthes 73.6 9.56e-13   NR CAH8538603.1 6188 g9988 i0 49.5 1.98606271777003 95 0 99.3 1 285 1 645 691 CAH8538603.1 unnamed protein product [Schistosoma rodhaini] diamond 570 73.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma rodhaini
28170223 28170223 PRJEB2368_P_NODE_11446_length_267_cov_1.347826_g11127_i0 PRJEB2368 11446 267 1.347826 3.59869542 Haplorchis taichui 235153 Platyhelminthes Platyhelminthes 134 1.3499999999999999e-34   NR AYV63044.1 235153 g11127 i0 76.4 1 89 21 100 0 1 267 293 381 AYV63044.1 NADH dehydrogenase subunit 5 [Haplorchis taichui] diamond 267 134 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Heterophyidae Haplorchis Haplorchis taichui
29300457 29300457 PRJEB2368_P_NODE_8469_length_287_cov_1.616000_g8151_i0 PRJEB2368 8469 287 1.616 4.63792 Schistosoma 6181 Platyhelminthes Platyhelminthes 45.8 0.00392   NR CAH8614820.1 6187 g8151 i0 87.5 0.491289198606272 24 3 25.1 0 3 74 105 128 CAH8614820.1 unnamed protein product [Schistosoma intercalatum] diamond 141 46.2 0.991341991341991 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma intercalatum
29622163 29622163 PRJEB2368_P_NODE_10630_length_287_cov_1.020000_g10312_i0 PRJEB2368 10630 287 1.02 2.9274 Schistosoma mattheei 31246 Platyhelminthes Platyhelminthes 44.7 0.0129   NR VDP41783.1 31246 g10312 i0 84 1.02439024390244 25 4 26.1 0 76 2 40 64 VDP41783.1 unnamed protein product [Schistosoma mattheei] diamond 294 44.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mattheei
29647354 29647354 PRJEB2368_P_NODE_12670_length_199_cov_1.444444_g12351_i0 PRJEB2368 12670 199 1.444444 2.87444356 Trematoda 6178 Platyhelminthes Platyhelminthes 82.8 4.79e-17   NR ACB31854.1 6198 g12351 i0 63.3 6.25628140703518 60 22 90.5 0 19 198 220 279 ACB31854.1 NADH dehydrogenase subunit 2 [Opisthorchis viverrini] diamond 1245 83.2 0.995192307692308 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Opisthorchiidae Opisthorchis Opisthorchis viverrini
30318077 30318077 PRJEB2368_P_NODE_872_length_933_cov_2.660714_g687_i0 PRJEB2368 872 933 2.660714 24.82446162 Haplorchis taichui 235153 Platyhelminthes Platyhelminthes 308 1.89e-102   NR YP_008578695.1 235153 g687 i0 73.6 1.2475884244373 193 50 62.1 1 7 585 11 202 YP_008578695.1 cytochrome c oxidase subunit II [Haplorchis taichui] diamond 1164 308 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Heterophyidae Haplorchis Haplorchis taichui
30570046 30570046 PRJEB2368_P_NODE_14293_length_166_cov_1.759690_g13974_i0 PRJEB2368 14293 166 1.75969 2.9210854 Echinostoma caproni 27848 Platyhelminthes Platyhelminthes 105 1.36e-24   NR VDP88956.1 27848 g13974 i0 92.6 3.90361445783133 54 4 97.6 0 3 164 158 211 VDP88956.1 unnamed protein product [Echinostoma caproni] diamond 648 105 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Echinostomatidae Echinostoma Echinostoma caproni
30854609 30854609 PRJEB2368_P_NODE_13154_length_185_cov_1.912162_g12835_i0 PRJEB2368 13154 185 1.912162 3.5374997 Haplorchis taichui 235153 Platyhelminthes Platyhelminthes 85.5 1.43e-17   NR AYV63044.1 235153 g12835 i0 84.6 2.56216216216216 52 8 84.3 0 184 29 99 150 AYV63044.1 NADH dehydrogenase subunit 5 [Haplorchis taichui] diamond 474 85.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Heterophyidae Haplorchis Haplorchis taichui
30943151 30943151 PRJEB2368_P_NODE_15614_length_153_cov_1.439655_g15295_i0 PRJEB2368 15614 153 1.439655 2.20267215 Trematoda 6178 Platyhelminthes Platyhelminthes 85.9 6.68e-18   NR KAA3673627.1 34504 g15295 i0 74 2.94117647058824 50 13 98 0 152 3 527 576 KAA3673627.1 phosphoenolpyruvate carboxykinase (GTP) [Paragonimus westermani] diamond 450 85.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Troglotrematidae Paragonimus Paragonimus westermani

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;