RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA446034" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA446034 · 6 ✖

analysis 1

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
27107434 27107434 PRJNA446034_S_NODE_113702_length_150_cov_7.672566_g113665_i0 PRJNA446034 113702 150 7.672566 11.508849 Candidatus Brocadiales bacterium 2760054 Bacteria Bacteria 50.1 2.04e-5   NR MBC8555558.1 2760054 g113665 i0 51 0.98 49 24 98 0 147 1 1 49 MBC8555558.1 hypothetical protein [Candidatus Brocadiales bacterium] diamond 147 50.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales     Candidatus Brocadiales bacterium
29428898 29428898 PRJNA446034_S_NODE_69269_length_170_cov_1.654135_g69232_i0 PRJNA446034 69269 170 1.654135 2.8120295 Roseimaritima 1579506 Bacteria Bacteria 42.4 0.0195   NR WP_068140707.1 980254 g69232 i0 48.6 1.23529411764706 35 18 61.8 0 6 110 992 1026 WP_068140707.1 S1 RNA-binding domain-containing protein [Roseimaritima ulvae] diamond 210 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Roseimaritima Roseimaritima ulvae
29791568 29791568 PRJNA446034_S_NODE_91991_length_158_cov_5.917355_g91954_i0 PRJNA446034 91991 158 5.917355 9.3494209 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0212   NR MDP6761505.1 2026780 g91954 i0 47.7 1.59493670886076 44 22 81.6 1 22 150 100 143 MDP6761505.1 UDP-2,3-diacylglucosamine diphosphatase [Planctomycetota bacterium] diamond 252 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30345616 30345616 PRJNA446034_S_NODE_43172_length_190_cov_1.882353_g43135_i0 PRJNA446034 43172 190 1.882353 3.5764707 Anatilimnocola 2807414 Bacteria Bacteria 68.6 1.92e-12   NR MBI2477508.1 2052181 g43135 i0 68.2 6.25263157894737 44 14 69.5 0 190 59 131 174 MBI2477508.1 RNA polymerase sigma factor [Planctomycetia bacterium] diamond 1188 68.9 0.995645863570392 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
30992397 30992397 PRJNA446034_S_NODE_37834_length_196_cov_1.352201_g37797_i0 PRJNA446034 37834 196 1.352201 2.65031396 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 77 1.66e-14   NR MBQ1456580.1 2691551 g37797 i0 54.8 0.948979591836735 62 28 94.9 0 4 189 41 102 MBQ1456580.1 DNA adenine methylase [Thermoguttaceae bacterium] diamond 186 77 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
32162605 32162605 PRJNA446034_S_NODE_47018_length_186_cov_3.241611_g46981_i0 PRJNA446034 47018 186 3.241611 6.02939646 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0333   NR MEL7089525.1 2026780 g46981 i0 41.7 0.774193548387097 48 26 74.2 1 7 144 68 115 MEL7089525.1 DNA-processing protein DprA [Planctomycetota bacterium] diamond 144 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium

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