RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA438687 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
1710246 1710246 PRJNA438687_S_NODE_7662_length_156_cov_2.446281_g7572_i0 PRJNA438687 7662 156 2.446281 3.81619836 Ephydatia fluviatilis 31330 Porifera other_Eukaryota 279 5.41e-71   NTclustered gi|2268710978|emb|OX176771.1| 31330 g7572 i0 99.351 2.96153846153846 154 1 99 0 1 154 658 811 Ephydatia fluviatilis partial 28S rRNA gene blastn 462 279 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
6194250 6194250 PRJNA438687_S_NODE_5625_length_186_cov_4.198675_g5535_i0 PRJNA438687 5625 186 4.198675 7.8095355 Ephydatia 6051 Porifera other_Eukaryota 344 2.34e-90   NTclustered gi|2169279564|gb|OL985643.1| 31330 g5535 i0 100 100.838709677419 186 0 100 0 1 186 192 7 Ephydatia fluviatilis voucher P059-170902-1 large subunit ribosomal RNA gene, partial sequence blastn 18756 344 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
8744224 8744224 PRJNA438687_S_NODE_7107_length_163_cov_2.539062_g7017_i0 PRJNA438687 7107 163 2.539062 4.13867106 Haliclona 6057 Porifera other_Eukaryota 99 1.72e-16   NTclustered gi|1731765159|gb|MN386036.1| 2606654 g7017 i0 93.846 52.2085889570552 65 4 40 0 59 123 570 506 Haliclona sp. 3 NW-2019 large subunit ribosomal RNA gene, partial sequence blastn 8510 99 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Chalinidae Haliclona Haliclona sp. 3 NW-2019
9363399 9363399 PRJNA438687_S_NODE_7928_length_153_cov_3.101695_g7838_i0 PRJNA438687 7928 153 3.101695 4.74559335 Leucettidae sp. Sp11 1936241 Porifera other_Eukaryota 58.4 2.69e-4   NTclustered gi|1353874599|gb|KY670632.1| 1936241 g7838 i0 86.792 32.2091503267974 53 6 35 1 1 53 6741 6690 Leucettidae sp. Sp11 voucher NHMUK:2017.1.19.1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 4928 58.4 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Clathrinida Leucettidae   Leucettidae sp. Sp11
10019347 10019347 PRJNA438687_S_NODE_5068_length_197_cov_3.802469_g4978_i0 PRJNA438687 5068 197 3.802469 7.49086393 Spongillidae 6050 Porifera other_Eukaryota 351 1.5e-92   NTclustered gi|2268710980|emb|OX176772.1| 6052 g4978 i0 100 92.497461928934 190 0 96 0 1 190 1922 2111 Ephydatia muelleri partial 28S rRNA gene blastn 18222 351 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia muelleri
11294377 11294377 PRJNA438687_S_NODE_7109_length_163_cov_2.460938_g7019_i0 PRJNA438687 7109 163 2.460938 4.01132894 Ephydatia 6051 Porifera other_Eukaryota 291 2.64e-74   NTclustered gi|527136323|gb|KC899055.1| 31330 g7019 i0 98.773 99.5766871165644 163 2 100 0 1 163 622 784 Ephydatia fluviatilis clone Ef05 18S ribosomal RNA gene, partial sequence blastn 16231 291 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
11914073 11914073 PRJNA438687_S_NODE_5390_length_190_cov_7.838710_g5300_i0 PRJNA438687 5390 190 7.83871 14.893549 Ephydatia fluviatilis 31330 Porifera other_Eukaryota 351 1.4399999999999997e-92   NTclustered gi|2268710978|emb|OX176771.1| 31330 g5300 i0 100 60.8 190 0 100 0 1 190 2401 2212 Ephydatia fluviatilis partial 28S rRNA gene blastn 11552 351 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
13844749 13844749 PRJNA438687_S_NODE_4971_length_199_cov_9.286585_g4881_i0 PRJNA438687 4971 199 9.286585 18.48030415 Spongillida 1779161 Porifera other_Eukaryota 361 2.5299999999999998e-95   NTclustered gi|77379379|gb|DQ167159.1| 6052 g4881 i0 99.495 99.6381909547739 198 1 99 0 2 199 956 759 Ephydatia muelleri voucher ZMB Por 12659 18S ribosomal RNA gene, partial sequence blastn 19828 361 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia muelleri
15118994 15118994 PRJNA438687_S_NODE_5192_length_194_cov_18.490566_g5102_i0 PRJNA438687 5192 194 18.490566 35.87169804 Spongillida 1779161 Porifera other_Eukaryota 318 1.5e-82   NTclustered gi|77379379|gb|DQ167159.1| 6052 g5102 i0 96.859 98.5 191 5 98 1 5 194 1470 1280 Ephydatia muelleri voucher ZMB Por 12659 18S ribosomal RNA gene, partial sequence blastn 19109 318 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia muelleri
15737937 15737937 PRJNA438687_S_NODE_2813_length_266_cov_10.649351_g2723_i0 PRJNA438687 2813 266 10.649351 28.32727366 Ephydatia fluviatilis 31330 Porifera other_Eukaryota 479 9.42e-131   NTclustered gi|2268710978|emb|OX176771.1| 31330 g2723 i0 99.618 38.609022556391 262 1 98 0 1 262 3398 3659 Ephydatia fluviatilis partial 28S rRNA gene blastn 10270 479 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
18942596 18942596 PRJNA438687_S_NODE_1995_length_305_cov_34.114815_g1905_i0 PRJNA438687 1995 305 34.114815 104.05018575 Spongillidae 6050 Porifera other_Eukaryota 346 1.16e-90   NTclustered gi|2268710983|emb|OX176773.1| 6055 g1905 i0 95 106.252459016393 220 11 72 0 86 305 1866 1647 Spongilla lacustris partial 28S rRNA gene blastn 32407 346 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Spongilla Spongilla lacustris
20836892 20836892 PRJNA438687_S_NODE_4377_length_212_cov_16.790960_g4287_i0 PRJNA438687 4377 212 16.79096 35.5968352 Ephydatia fluviatilis 31330 Porifera other_Eukaryota 340 3.55e-89   NTclustered gi|2268710978|emb|OX176771.1| 31330 g4287 i0 95.755 100.283018867925 212 8 100 1 1 212 2691 2901 Ephydatia fluviatilis partial 28S rRNA gene blastn 21260 340 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
21493016 21493016 PRJNA438687_S_NODE_3077_length_255_cov_6.386364_g2987_i0 PRJNA438687 3077 255 6.386364 16.2852282 Spongillida 1779161 Porifera other_Eukaryota 414 2.56e-111   NTclustered gi|2268710978|emb|OX176771.1| 31330 g2987 i0 96.414 54.4901960784314 251 9 98 0 1 251 82 332 Ephydatia fluviatilis partial 28S rRNA gene blastn 13895 414 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);;