RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA743294 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
5026543 5026543 PRJNA743294_P_NODE_13584_length_433_cov_6.772222_g13128_i0 PRJNA743294 13584 433 6.772222 29.32372126 Haplosclerida 6049 Porifera other_Eukaryota 108 8.8e-19   NTclustered gi|1284883228|gb|KY825184.1| 178514 g13128 i0 81.159 5.46882217090069 138 22 32 3 27 163 3340 3474 Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence blastn 2368 108 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon compressa
12677970 12677970 PRJNA743294_P_NODE_60470_length_208_cov_4.355556_g60014_i0 PRJNA743294 60470 208 4.355556 9.05955648 Metazoa 33208 Porifera other_Eukaryota 132 2.27e-26   NTclustered gi|2268710980|emb|OX176772.1| 6052 g60014 i0 96.25 38.7163461538462 80 3 38 0 4 83 2446 2367 Ephydatia muelleri partial 28S rRNA gene blastn 8053 132 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia muelleri
21600532 21600532 PRJNA743294_P_NODE_51877_length_247_cov_0.896552_g51421_i0 PRJNA743294 51877 247 0.896552 2.21448344 Metazoa 33208 Porifera other_Eukaryota 54.7 0.006   NTclustered gi|2732931298|ref|XM_065332720.1| 27933 g51421 i0 100 0.465587044534413 29 0 12 0 158 186 6187 6159 PREDICTED: Sycon ciliatum uncharacterized LOC135819503 (LOC135819503), mRNA blastn 115 54.7 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);;