RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA330616" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA330616 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27422465 27422465 PRJNA330616_P_NODE_24563_length_170_cov_1.685950_g24154_i0 PRJNA330616 24563 170 1.68595 2.866115 Planctomycetota bacterium 2026780 Bacteria Bacteria 71.2 1.98e-14   NR MCX5658594.1 2026780 g24154 i0 70.7 0.723529411764706 41 12 72.4 0 1 123 19 59 MCX5658594.1 hypothetical protein [Planctomycetota bacterium] diamond 123 71.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27611826 27611826 PRJNA330616_P_NODE_28344_length_165_cov_0.879310_g27935_i0 PRJNA330616 28344 165 0.87931 1.4508615 Gemmataceae bacterium 2052164 Bacteria Bacteria 48.5 1.07e-4   NR MCI0681538.1 2052164 g27935 i0 55.6 1.72727272727273 45 20 81.8 0 25 159 178 222 MCI0681538.1 hypothetical protein [Gemmataceae bacterium] diamond 285 48.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28242986 28242986 PRJNA330616_P_NODE_12586_length_233_cov_1.592391_g12177_i0 PRJNA330616 12586 233 1.592391 3.71027103 Planctomycetia bacterium 2052181 Bacteria Bacteria 62.4 3.31e-9   NR MDZ4778905.1 2052181 g12177 i0 46.2 1.00429184549356 78 41 99.1 1 231 1 142 219 MDZ4778905.1 hypothetical protein [Planctomycetia bacterium] diamond 234 62.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
28432663 28432663 PRJNA330616_P_NODE_14626_length_218_cov_1.207101_g14217_i0 PRJNA330616 14626 218 1.207101 2.63148018 Phycisphaerales bacterium 2052180 Bacteria Bacteria 83.2 1.54e-16   NR MFN7020731.1 2052180 g14217 i0 73.6 1.52752293577982 53 14 72.9 0 1 159 952 1004 MFN7020731.1 tandem-95 repeat protein [Phycisphaerales bacterium] diamond 333 83.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28432668 28432668 PRJNA330616_P_NODE_19086_length_193_cov_1.062500_g18677_i0 PRJNA330616 19086 193 1.0625 2.050625 Rubripirellula amarantea 2527999 Bacteria Bacteria 46.6 8.38e-4   NR WP_146513878.1 2527999 g18677 i0 53.3 0.699481865284974 45 21 69.9 0 11 145 369 413 WP_146513878.1 Glu/Leu/Phe/Val family dehydrogenase [Rubripirellula amarantea] diamond 135 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula amarantea
29253301 29253301 PRJNA330616_P_NODE_32589_length_161_cov_0.910714_g32180_i0 PRJNA330616 32589 161 0.910714 1.46624954 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 64.3 9.74e-12   NR MBC7816662.1 2026779 g32180 i0 73.2 1.54658385093168 41 11 76.4 0 157 35 1 41 MBC7816662.1 GntR family transcriptional regulator [Planctomycetaceae bacterium] diamond 249 64.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32635057 32635057 PRJNA330616_P_NODE_26200_length_167_cov_0.864407_g25791_i0 PRJNA330616 26200 167 0.864407 1.44355969 Planctomycetota bacterium 2026780 Bacteria Bacteria 51.6 9.53e-6   NR TXT28242.1 2026780 g25791 i0 48.1 2.55089820359281 52 27 93.4 0 162 7 271 322 TXT28242.1 MAG: hypothetical protein FD138_2632 [Planctomycetota bacterium] diamond 426 51.6 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);;