RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA400391", tax_clade = "Opisthokonta" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 6 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 6 ✖

bioproject 1

  • PRJNA400391 · 6 ✖

analysis 1

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
4909053 4909053 PRJNA400391_S_NODE_5504_length_168_cov_15.240602_g5443_i0 PRJNA400391 5504 168 15.240602 25.60421136 Spongillida 1779161 Porifera other_Eukaryota 294 2.12e-75   NTclustered gi|77379379|gb|DQ167159.1| 6052 g5443 i0 98.225 100.64880952381 169 1 100 2 1 168 1460 1293 Ephydatia muelleri voucher ZMB Por 12659 18S ribosomal RNA gene, partial sequence blastn 16909 294 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia muelleri
8067459 8067459 PRJNA400391_S_NODE_827_length_377_cov_101.769006_g766_i0 PRJNA400391 827 377 101.769006 383.66915262 Ephydatia fluviatilis 31330 Porifera other_Eukaryota 516 1.06e-141   NTclustered gi|2268710978|emb|OX176771.1| 31330 g766 i0 96.474 87.0238726790451 312 11 91 0 3 314 2738 3049 Ephydatia fluviatilis partial 28S rRNA gene blastn 32808 516 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
9342273 9342273 PRJNA400391_S_NODE_4988_length_177_cov_7.830986_g4927_i0 PRJNA400391 4988 177 7.830986 13.86084522 Ephydatia fluviatilis 31330 Porifera other_Eukaryota 322 1.03e-83   NTclustered gi|2268710978|emb|OX176771.1| 31330 g4927 i0 100 49.7683615819209 174 0 98 0 1 174 2231 2404 Ephydatia fluviatilis partial 28S rRNA gene blastn 8809 322 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
17658594 17658594 PRJNA400391_S_NODE_3974_length_202_cov_4.131737_g3913_i0 PRJNA400391 3974 202 4.131737 8.34610874 Spongillida 1779161 Porifera other_Eukaryota 368 1.54e-97   NTclustered gi|77379379|gb|DQ167159.1| 6052 g3913 i0 99.505 100.094059405941 202 1 100 0 1 202 760 961 Ephydatia muelleri voucher ZMB Por 12659 18S ribosomal RNA gene, partial sequence blastn 20219 368 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia muelleri
19539908 19539908 PRJNA400391_S_NODE_6396_length_154_cov_1.638655_g6335_i0 PRJNA400391 6396 154 1.638655 2.5235287 Ephydatia fluviatilis 31330 Porifera other_Eukaryota 274 2.48e-69   NTclustered gi|2268710978|emb|OX176771.1| 31330 g6335 i0 98.701 33.1493506493507 154 2 100 0 1 154 720 873 Ephydatia fluviatilis partial 28S rRNA gene blastn 5105 274 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
22090510 22090510 PRJNA400391_S_NODE_3158_length_226_cov_9.581152_g3097_i0 PRJNA400391 3158 226 9.581152 21.65340352 Ephydatia fluviatilis 31330 Porifera other_Eukaryota 418 1.7199999999999998e-112   NTclustered gi|2268710978|emb|OX176771.1| 31330 g3097 i0 100 24.5221238938053 226 0 100 0 1 226 3616 3391 Ephydatia fluviatilis partial 28S rRNA gene blastn 5542 418 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis

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