RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA556992 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
4360679 4360679 PRJNA556992_P_NODE_812684_length_245_cov_2.296512_g810494_i0 PRJNA556992 812684 245 2.296512 5.6264544 Aiolochroia crassa 261677 Porifera other_Eukaryota 141 4.59e-29   NTclustered gi|512765256|gb|KC869494.1| 261677 g810494 i0 90.566 43.3877551020408 106 10 43 0 140 245 1334 1229 Aiolochroia crassa voucher P04 28S ribosomal RNA gene, partial sequence blastn 10630 141 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Verongiida Aplysinidae Aiolochroia Aiolochroia crassa
6906237 6906237 PRJNA556992_P_NODE_405526_length_276_cov_1.546798_g403337_i0 PRJNA556992 405526 276 1.546798 4.26916248 Suberites sp. RT-2017 1973069 Porifera other_Eukaryota 86.1 2.5e-12   NTclustered gi|1172523174|gb|KX949575.1| 1973069 g403337 i0 100 27.8478260869565 46 0 17 0 1 46 51 6 Suberites sp. RT-2017 18S ribosomal RNA gene, partial sequence blastn 7686 86.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites sp. RT-2017
22208422 22208422 PRJNA556992_P_NODE_649478_length_255_cov_1.604396_g647289_i0 PRJNA556992 649478 255 1.604396 4.0912098 Dysidea avara 196820 Porifera other_Eukaryota 135 2.24e-27   NTclustered gi|2749568998|ref|XM_066051098.1| 196820 g647289 i0 80.328 15.1137254901961 183 33 71 3 38 219 931 1111 PREDICTED: Dysidea avara nuclear migration protein nudC-like (LOC136257786), mRNA blastn 3854 135 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
24749145 24749145 PRJNA556992_P_NODE_1093240_length_214_cov_5.730496_g1091049_i0 PRJNA556992 1093240 214 5.730496 12.26326144 Dysidea avara 196820 Porifera other_Eukaryota 52.8 0.019   NTclustered gi|2749516543|ref|XM_066027457.1| 196820 g1091049 i0 96.875 0.299065420560748 32 0 14 1 23 53 5411 5380 PREDICTED: Dysidea avara uncharacterized protein (LOC136237149), transcript variant X2, mRNA blastn 64 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
24749300 24749300 PRJNA556992_P_NODE_1104200_length_211_cov_13.152174_g1102009_i0 PRJNA556992 1104200 211 13.152174 27.75108714 Sycon ciliatum 27933 Porifera other_Eukaryota 56.5 0.001   NTclustered gi|2732903834|ref|XM_065339908.1| 27933 g1102009 i0 87.5 0.725118483412322 48 6 23 0 107 154 2648 2601 PREDICTED: Sycon ciliatum uncharacterized LOC135827419 (LOC135827419), transcript variant X2, mRNA blastn 153 56.5 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum

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