RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA1192965" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1192965 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
14349578 14349578 PRJNA1192965_P_NODE_4932_length_242_cov_0.911243_g4913_i0 PRJNA1192965 4932 242 0.911243 2.20520806 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 114 1.49e-28   NR CAH8509495.1 57078 g4913 i0 72.5 6.86776859504132 80 22 99.2 0 242 3 11 90 CAH8509495.1 unnamed protein product [Dicrocoelium dendriticum] diamond 1662 115 0.991304347826087 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
16897638 16897638 PRJNA1192965_P_NODE_4214_length_246_cov_0.890173_g4195_i0 PRJNA1192965 4214 246 0.890173 2.18982558 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 120 8.810000000000001e-33   NR VDN19669.1 60516 g4195 i0 67.1 24.2560975609756 79 26 96.3 0 246 10 12 90 VDN19669.1 unnamed protein product [Dibothriocephalus latus] diamond 5967 120 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Dibothriocephalus Dibothriocephalus latus
27072327 27072327 PRJNA1192965_P_NODE_1662_length_321_cov_1.233871_g1643_i0 PRJNA1192965 1662 321 1.233871 3.96072591 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 77 2.03e-15   NR ADW66116.1 79327 g1643 i0 49.3 1.29906542056075 67 34 62.6 0 255 55 66 132 ADW66116.1 lectin-like protein, partial [Schmidtea mediterranea] diamond 417 77 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
27660227 27660227 PRJNA1192965_P_NODE_4564_length_244_cov_0.900585_g4545_i0 PRJNA1192965 4564 244 0.900585 2.1974274 Schistosomatidae 31245 Platyhelminthes Platyhelminthes 132 4.3299999999999995e-37   NR KAH8857159.1 6182 g4545 i0 81 5.7172131147541 79 14 97.1 1 238 2 9 86 KAH8857159.1 Ras-related protein Rab-27A [Schistosoma japonicum] diamond 1395 132 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28051471 28051471 PRJNA1192965_P_NODE_945_length_398_cov_3.821538_g926_i0 PRJNA1192965 945 398 3.821538 15.20972124 Girardia tigrina 6162 Platyhelminthes Platyhelminthes 110 3.07e-25   NR AAL29940.1 6162 g926 i0 42.5 0.798994974874372 106 60 79.1 1 72 386 153 258 AAL29940.1 lectin 1, partial [Girardia tigrina] diamond 318 110 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Girardia Girardia tigrina
29346107 29346107 PRJNA1192965_P_NODE_349_length_612_cov_2.369202_g331_i0 PRJNA1192965 349 612 2.369202 14.49951624 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 99.8 1.53e-20   NR PAA86220.1 282301 g331 i0 31.7 0.78921568627451 161 109 78.4 1 544 65 76 236 PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] diamond 483 99.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
29914590 29914590 PRJNA1192965_P_NODE_4931_length_242_cov_0.911243_g4912_i0 PRJNA1192965 4931 242 0.911243 2.20520806 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 59.3 5.32e-8   NR XP_018651842.1 6183 g4912 i0 41.3 1.98347107438017 80 47 99.2 0 242 3 104 183 XP_018651842.1 hypothetical protein Smp_008710 [Schistosoma mansoni] diamond 480 59.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
30420279 30420279 PRJNA1192965_P_NODE_3373_length_251_cov_0.865169_g3354_i0 PRJNA1192965 3373 251 0.865169 2.17157419 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 170 1.64e-49   NR BAE78814.1 6161 g3354 i0 100 0.99203187250996006 83 0 99.2 0 251 3 105 187 BAE78814.1 innexin5 [Dugesia japonica] diamond 249 170 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica

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