RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA796753" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 4 ✖

bioproject 1

  • PRJNA796753 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_kingdom 0

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
780799 780799 PRJNA796753_P_NODE_50461_length_243_cov_1.811765_g50149_i0 PRJNA796753 50461 243 1.811765 4.40258895 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 233 7.289999999999999e-57   NTclustered gi|2258833497|gb|CP060226.1| 2053688 g50149 i0 85.586 2.62139917695473 222 32 91 0 1 222 813880 813659 MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome blastn 637 233 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria bacterium
7159074 7159074 PRJNA796753_P_NODE_31266_length_276_cov_1.068966_g30954_i0 PRJNA796753 31266 276 1.068966 2.95034616 Candidatus Saccharibacteria bacterium oral taxon 488 713059 Bacteria Bacteria 499 7.54e-137   NTclustered gi|1842065531|gb|CP040002.1| 713059 g30954 i0 99.275 302.811594202899 276 2 100 0 1 276 150922 151197 Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome blastn 83576 499 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488
15245184 15245184 PRJNA796753_P_NODE_51912_length_242_cov_2.059172_g51600_i0 PRJNA796753 51912 242 2.059172 4.98319624 Candidatus Nanosynbacteraceae 2093822 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|1842053267|gb|CP039998.1| 713059 g51600 i0 100 65.5123966942149 242 0 100 0 1 242 147114 146873 Candidatus Saccharibacteria bacterium oral taxon 488 strain CM002 chromosome, complete genome blastn 15854 448 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488
16519663 16519663 PRJNA796753_P_NODE_7913_length_486_cov_1.382567_g7602_i0 PRJNA796753 7913 486 1.382567 6.71927562 Candidatus Nanosynbacter 2093823 Bacteria Bacteria 876 0   NTclustered gi|1842065531|gb|CP040002.1| 713059 g7602 i0 99.379 137.954732510288 483 3 99 0 4 486 152302 151820 Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome blastn 67046 876 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488

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