RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA879314" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA879314 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27308356 27308356 PRJNA879314_P_NODE_663_length_516_cov_1.948081_g613_i0 PRJNA879314 663 516 1.948081 10.05209796 Schistosoma haematobium 6185 Platyhelminthes Platyhelminthes 94.4 3.11e-21   NR XP_051073430.1 6185 g613 i0 37.5 2.34302325581395 136 78 75.6 3 27 416 1 135 XP_051073430.1 Cofilin-2, variant 2 [Schistosoma haematobium] diamond 1209 94.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium
27474147 27474147 PRJNA879314_P_NODE_7443_length_248_cov_0.891429_g7393_i0 PRJNA879314 7443 248 0.891429 2.21074392 Trematoda 6178 Platyhelminthes Platyhelminthes 99.8 3.5700000000000003e-22   NR CAH8434418.1 39320 g7393 i0 59.8 16.8629032258065 82 32 98 1 245 3 861 942 CAH8434418.1 unnamed protein product [Heterobilharzia americana] diamond 4182 99.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Heterobilharzia Heterobilharzia americana
31105818 31105818 PRJNA879314_P_NODE_975_length_428_cov_1.583099_g925_i0 PRJNA879314 975 428 1.583099 6.77566372 Schistosoma 6181 Platyhelminthes Platyhelminthes 137 9.31e-37   NR TNN11975.1 6182 g925 i0 49.6 4.85046728971963 133 66 92.5 1 31 426 155 287 TNN11975.1 DM9 domain-containing protein [Schistosoma japonicum] diamond 2076 138 0.992753623188406 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31327192 31327192 PRJNA879314_P_NODE_2055_length_325_cov_1.547619_g2005_i0 PRJNA879314 2055 325 1.547619 5.02976175 Fasciola 6191 Platyhelminthes Platyhelminthes 105 7.19e-26   NR THD27201.1 6192 g2005 i0 46.3 1.99384615384615 108 58 99.7 0 325 2 88 195 THD27201.1 DM9 domain-containing protein [Fasciola hepatica] diamond 648 105 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciola Fasciola hepatica
31359011 31359011 PRJNA879314_P_NODE_3016_length_286_cov_2.197183_g2966_i0 PRJNA879314 3016 286 2.197183 6.28394338 root 1 Root_unresolved Root_unresolved 111 9.51e-27   NR BAA08663.1 6161 g2966 i0 52.1 2.93706293706294 94 45 98.6 0 1 282 149 242 BAA08663.1 elongation factor-1alpha, partial [Dugesia japonica] diamond 840 112 0.991071428571429 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
31825142 31825142 PRJNA879314_P_NODE_8077_length_247_cov_0.896552_g8027_i0 PRJNA879314 8077 247 0.896552 2.21448344 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 104 4.52e-24   NR AKG62128.1 79327 g8027 i0 61.5 0.947368421052632 78 30 94.7 0 6 239 230 307 AKG62128.1 serrate RNA effector molecule, partial [Schmidtea mediterranea] diamond 234 104 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
32844399 32844399 PRJNA879314_P_NODE_11500_length_230_cov_2.050955_g11450_i0 PRJNA879314 11500 230 2.050955 4.7171965 Trematoda 6178 Platyhelminthes Platyhelminthes 118 1.9099999999999997e-30   NR VDP98910.1 157069 g11450 i0 78.2 6.10434782608696 78 15 99.1 1 2 229 196 273 VDP98910.1 unnamed protein product [Trichobilharzia regenti] diamond 1404 118 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Trichobilharzia Trichobilharzia regenti

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);;