RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJEB3181" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB3181 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
5158267 5158267 PRJEB3181_P_NODE_1805_length_500_cov_2.494670_g1633_i0 PRJEB3181 1805 500 2.49467 12.47335 Bresslauilla relicta 1311963 Platyhelminthes Platyhelminthes 86.1 4.82e-12   NTclustered gi|588313927|gb|KC869885.1| 1311963 g1633 i0 81.081 0.336 111 17 22 2 154 264 1606 1712 Bresslauilla relicta 28S ribosomal RNA genes, partial sequence blastn 168 86.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Rhabdocoela Graffillidae Bresslauilla Bresslauilla relicta
6434334 6434334 PRJEB3181_S_NODE_5326_length_262_cov_118.850220_g5033_i0 PRJEB3181 5326 262 118.85022 311.3875764 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 185 2.26e-42   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g5033 i0 87.5 14.0190839694656 160 20 61 0 17 176 1379 1538 Stenostomum sthenum mitochondrion, complete genome blastn 3673 185 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
7708493 7708493 PRJEB3181_S_NODE_7067_length_234_cov_2046.301508_g6774_i0 PRJEB3181 7067 234 2046.301508 4788.34552872 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 95.3 3.43e-15   NTclustered gi|687789777|emb|LK829830.1| 57078 g6774 i0 91.304 28.6367521367521 69 6 29 0 166 234 533 601 Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 blastn 6701 95.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
10258639 10258639 PRJEB3181_P_NODE_10649_length_260_cov_7.777293_g10385_i0 PRJEB3181 10649 260 7.777293 20.2209618 Diplorchis hangzhouensis 1131906 Platyhelminthes Platyhelminthes 54.7 0.007   NTclustered gi|379771686|gb|JQ038227.1| 1131906 g10385 i0 100 0.111538461538462 29 0 11 0 205 233 5389 5361 Diplorchis hangzhouensis mitochondrion sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Polystomatidea Polystomatidae Diplorchis Diplorchis hangzhouensis
12467967 12467967 PRJEB3181_S_NODE_17730_length_154_cov_3.705882_g17437_i0 PRJEB3181 17730 154 3.705882 5.70705828 Stenostomum 39238 Platyhelminthes Platyhelminthes 279 5.33e-71   NTclustered gi|209968707|gb|FJ384870.1| 52061 g17437 i0 99.351 42.6623376623377 154 1 100 0 1 154 190 37 Stenostomum leucops isolate K05_55 28S ribosomal RNA gene, partial sequence blastn 6570 279 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum leucops
12809539 12809539 PRJEB3181_P_NODE_7471_length_308_cov_1.722022_g7210_i0 PRJEB3181 7471 308 1.722022 5.30382776 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 361 4.21e-95   NTclustered gi|68479954|gb|DQ076149.1| 6182 g7210 i0 93.416 0.788961038961039 243 16 79 0 66 308 356 114 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 243 361 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
14084428 14084428 PRJEB3181_S_NODE_472_length_631_cov_209.206376_g251_i0 PRJEB3181 472 631 209.206376 1320.09223256 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1014 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g251 i0 98.438 33.2963549920761 576 9 91 0 53 628 8984 8409 Stenostomum sthenum mitochondrion, complete genome blastn 21010 1014 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
16633043 16633043 PRJEB3181_S_NODE_8814_length_212_cov_2483.146893_g8521_i0 PRJEB3181 8814 212 2483.146893 5264.27141316 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 93.5 1.1e-14   NTclustered gi|687789777|emb|LK829830.1| 57078 g8521 i0 92.308 31.7594339622642 65 5 31 0 148 212 537 601 Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 blastn 6733 93.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
17566712 17566712 PRJEB3181_S_NODE_5234_length_264_cov_17.209607_g4941_i0 PRJEB3181 5234 264 17.209607 45.43336248 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 483 7.219999999999998e-132   NTclustered gi|2866376384|gb|PQ722296.1| 39377 g4941 i0 99.621 99.5227272727273 264 1 100 0 1 264 292 29 Stenostomum sp. (in: flatworms) isolate F8 small subunit ribosomal RNA gene, partial sequence blastn 26274 483 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sp. (in: flatworms)
19181373 19181373 PRJEB3181_P_NODE_13636_length_228_cov_52.177665_g13372_i0 PRJEB3181 13636 228 52.177665 118.9650762 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 56.5 0.002   NTclustered gi|687789777|emb|LK829830.1| 57078 g13372 i0 100 1 30 0 13 0 1 30 564 535 Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 blastn 228 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
20456882 20456882 PRJEB3181_S_NODE_2197_length_359_cov_587.246914_g1904_i0 PRJEB3181 2197 359 587.246914 2108.21642126 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 298 3.96e-76   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g1904 i0 88.306 20.1448467966574 248 29 69 0 112 359 14090 13843 Stenostomum sthenum mitochondrion, complete genome blastn 7232 298 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum

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