RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA572587", tax_clade = "Opisthokonta" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 15 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 15 ✖

bioproject 1

  • PRJNA572587 · 15 ✖
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
559096 559096 PRJNA572587_P_NODE_38501_length_177_cov_0.929688_g38173_i0 PRJNA572587 38501 177 0.929688 1.64554776 Marionfyfea adventor 3040208 Platyhelminthes Platyhelminthes 261 2.28e-65   NTclustered gi|2893358306|gb|PV014941.1| 3040208 g38173 i0 93.258 100.655367231638 178 10 100 2 1 177 656 832 Marionfyfea adventor isolate MarionAdv_2022-07 large subunit ribosomal RNA gene, partial sequence blastn 17816 261 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Geoplanidae Marionfyfea Marionfyfea adventor
1834176 1834176 PRJNA572587_P_NODE_1862_length_941_cov_14.707399_g1692_i0 PRJNA572587 1862 941 14.707399 138.39662459 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 1687 0   NTclustered gi|753176482|gb|KM821047.2| 79327 g1692 i0 100 25.2263549415515 913 0 97 0 23 935 12590 13502 Schmidtea mediterranea mitochondrion, complete genome blastn 23738 1687 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
1834512 1834512 PRJNA572587_P_NODE_43702_length_165_cov_50.155172_g43374_i0 PRJNA572587 43702 165 50.155172 82.7560338 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 281 1.62e-71   NTclustered gi|56757963|gb|AY815390.1| 6182 g43374 i0 97.576 103.624242424242 165 3 100 1 1 165 1375 1212 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 17098 281 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
1834531 1834531 PRJNA572587_P_NODE_45642_length_163_cov_0.894737_g45314_i0 PRJNA572587 45642 163 0.894737 1.45842131 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 167 4.649999999999999e-37   NTclustered gi|21309546|gb|AY068917.1| 79327 g45314 i0 92.308 0.717791411042945 117 9 72 0 1 117 390 506 Schmidtea mediterranea clone H.25.10e unknown mRNA sequence blastn 117 167 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
3109576 3109576 PRJNA572587_P_NODE_14083_length_308_cov_15.046332_g13755_i0 PRJNA572587 14083 308 15.046332 46.34270256 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 289 2.0099999999999996e-73   NTclustered gi|1124902734|gb|AY812498.2| 6182 g13755 i0 92.647 65.801948051948 204 10 65 4 105 303 1322 1119 Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds blastn 20267 291 0.993127147766323 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
4386475 4386475 PRJNA572587_P_NODE_35184_length_186_cov_2.160584_g34856_i0 PRJNA572587 35184 186 2.160584 4.01868624 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 52.8 0.016   NTclustered gi|1240504568|gb|MF667538.1| 6161 g34856 i0 100 0.150537634408602 28 0 15 0 157 184 28 1 Dugesia japonica 14-3-3 epsilon mRNA, complete cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
5662700 5662700 PRJNA572587_P_NODE_30645_length_200_cov_34.158940_g30317_i0 PRJNA572587 30645 200 34.15894 68.31788 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 56.5 0.001   NTclustered gi|687564855|emb|LK603690.1| 57078 g30317 i0 96.97 0.165 33 1 17 0 47 79 897 865 Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0192986 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
8212040 8212040 PRJNA572587_P_NODE_33367_length_191_cov_21.690141_g33039_i0 PRJNA572587 33367 191 21.690141 41.42816931 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 294 2.47e-75   NTclustered gi|1124902734|gb|AY812498.2| 6182 g33039 i0 98.788 86.3717277486911 165 2 86 0 7 171 1158 1322 Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds blastn 16497 296 0.993243243243243 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
12037846 12037846 PRJNA572587_P_NODE_20450_length_250_cov_8.651741_g20122_i0 PRJNA572587 20450 250 8.651741 21.6293525 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 357 4.28e-94   NTclustered gi|56757963|gb|AY815390.1| 6182 g20122 i0 92.308 119.36 260 7 99 3 1 248 1786 2044 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 29840 357 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
12037935 12037935 PRJNA572587_P_NODE_25350_length_222_cov_65.815029_g25022_i0 PRJNA572587 25350 222 65.815029 146.10936438 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 353 4.82e-93   NTclustered gi|1124902734|gb|AY812498.2| 6182 g25022 i0 98.985 88.6531531531532 197 2 89 0 25 221 1006 810 Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds blastn 19681 353 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
22235937 22235937 PRJNA572587_P_NODE_25938_length_220_cov_2.380117_g25610_i0 PRJNA572587 25938 220 2.380117 5.2362574 Marionfyfea adventor 3040208 Platyhelminthes Platyhelminthes 320 4.84e-83   NTclustered gi|2893358306|gb|PV014941.1| 3040208 g25610 i0 92.793 40.0363636363636 222 14 100 2 1 220 341 120 Marionfyfea adventor isolate MarionAdv_2022-07 large subunit ribosomal RNA gene, partial sequence blastn 8808 320 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Geoplanidae Marionfyfea Marionfyfea adventor
27269098 27269098 PRJNA572587_P_NODE_39163_length_175_cov_3.492063_g38835_i0 PRJNA572587 39163 175 3.492063 6.11111025 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 100 7.689999999999999e-23   NR AAX28387.3 6182 g38835 i0 94.1 1.74857142857143 51 3 87.4 0 22 174 445 495 AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] diamond 306 100 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29510904 29510904 PRJNA572587_P_NODE_15950_length_287_cov_14.521008_g15622_i0 PRJNA572587 15950 287 14.521008 41.67529296 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 43.5 0.0354   NR CAH8664748.1 57078 g15622 i0 36.9 0.878048780487805 84 46 83.6 4 240 1 2665 2745 CAH8664748.1 unnamed protein product [Dicrocoelium dendriticum] diamond 252 43.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
31533473 31533473 PRJNA572587_P_NODE_7696_length_438_cov_29.372751_g7371_i0 PRJNA572587 7696 438 29.372751 128.65264938 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 130 3.75e-35   NR AAX25032.2 6182 g7371 i0 78.2 0.534246575342466 78 17 53.4 0 24 257 102 179 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 234 130 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32229425 32229425 PRJNA572587_P_NODE_31458_length_198_cov_2.006711_g31130_i0 PRJNA572587 31458 198 2.006711 3.97328778 Clonorchis sinensis 79923 Platyhelminthes Platyhelminthes 40.4 0.031   NR GAA50846.1 79923 g31130 i0 59.3 0.409090909090909 27 11 40.9 0 14 94 59 85 GAA50846.1 U6 snRNA-associated Sm-like protein LSm8 [Clonorchis sinensis] diamond 81 40.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Opisthorchiidae Clonorchis Clonorchis sinensis

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