RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax_phylum = "Bryozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bryozoa · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA315314 · 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
1655792 1655792 PRJNA315314_S_NODE_4342_length_383_cov_123.937853_g4021_i0 PRJNA315314 4342 383 123.937853 474.68197699 Plumatella emarginata 56620 Bryozoa other_Eukaryota 497 3.9e-136   NTclustered gi|359292663|gb|JN681030.1| 56620 g4021 i0 100 101.76501305483 269 0 70 0 1 269 2086 1818 Plumatella emarginata 28S ribosomal RNA gene, partial sequence blastn 38976 497 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella emarginata
13134537 13134537 PRJNA315314_S_NODE_21751_length_178_cov_2.073826_g21430_i0 PRJNA315314 21751 178 2.073826 3.69141028 Plumatella vaihiriae 480603 Bryozoa other_Eukaryota 324 2.89e-84   NTclustered gi|359292693|gb|JN681060.1| 480603 g21430 i0 99.438 35.7191011235955 178 1 100 0 1 178 541 718 Plumatella vaihiriae 12S ribosomal RNA (rrnS) gene, partial sequence; tRNA-Glu, tRNA-Trp, tRNA-Tyr, and tRNA-Arg genes, complete sequence; and 16S ribosomal RNA (rrnL) gene, partial sequence; mitochondrial blastn 6358 324 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella vaihiriae
16958411 16958411 PRJNA315314_S_NODE_5094_length_355_cov_65.098160_g4773_i0 PRJNA315314 5094 355 65.09816 231.098468 Plumatella emarginata 56620 Bryozoa other_Eukaryota 497 3.59e-136   NTclustered gi|359292663|gb|JN681030.1| 56620 g4773 i0 100 75.543661971831 269 0 76 0 1 269 2086 1818 Plumatella emarginata 28S ribosomal RNA gene, partial sequence blastn 26818 497 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella emarginata
19506786 19506786 PRJNA315314_S_NODE_21116_length_180_cov_3.483444_g20795_i0 PRJNA315314 21116 180 3.483444 6.2701992 Plumatella vaihiriae 480603 Bryozoa other_Eukaryota 322 1.05e-83   NTclustered gi|359292664|gb|JN681031.1| 480603 g20795 i0 100 99.2611111111111 174 0 97 0 1 174 997 824 Plumatella vaihiriae 28S ribosomal RNA gene, partial sequence blastn 17867 322 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella vaihiriae
19506851 19506851 PRJNA315314_S_NODE_25676_length_165_cov_6.919118_g25355_i0 PRJNA315314 25676 165 6.919118 11.4165447 Plumatella vaihiriae 480603 Bryozoa other_Eukaryota 305 9.59e-79   NTclustered gi|359292664|gb|JN681031.1| 480603 g25355 i0 100 24.9454545454545 165 0 100 0 1 165 730 566 Plumatella vaihiriae 28S ribosomal RNA gene, partial sequence blastn 4116 305 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella vaihiriae

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