RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Kapaibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Kapaibacteriota · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA630162 · 10 ✖

analysis 1

  • diamond · 10 ✖
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
26891050 26891050 PRJNA630162_P_NODE_108641_length_180_cov_2.587786_g107118_i0 PRJNA630162 108641 180 2.587786 4.6580148 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 42 0.0313   NR MER3329173.1 2447898 g107118 i0 55.3 0.633333333333333 38 17 63.3 0 177 64 258 295 MER3329173.1 GEVED domain-containing protein [Candidatus Kapaibacterium sp.] diamond 114 42 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
26891263 26891263 PRJNA630162_P_NODE_97941_length_187_cov_1.260870_g96418_i0 PRJNA630162 97941 187 1.26087 2.3578269 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 77.4 3.44e-16   NR MFN8361304.1 2447898 g96418 i0 67.9 0.850267379679144 53 17 85 0 161 3 1 53 MFN8361304.1 hypothetical protein [Candidatus Kapaibacterium sp.] diamond 159 77.4 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
27270349 27270349 PRJNA630162_P_NODE_44923_length_264_cov_1.939535_g43400_i0 PRJNA630162 44923 264 1.939535 5.1203724 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 50.1 1.1e-4   NR MCU0426220.1 2447898 g43400 i0 45.2 0.704545454545455 62 30 70.5 1 34 219 60 117 MCU0426220.1 BspA family leucine-rich repeat surface protein [Candidatus Kapaibacterium sp.] diamond 186 50.1 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
27617920 27617920 PRJNA630162_P_NODE_163664_length_160_cov_3.036036_g162141_i0 PRJNA630162 163664 160 3.036036 4.8576576 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 102 5.3e-25   NR MFN8360956.1 2447898 g162141 i0 94.2 0.975 52 3 97.5 0 3 158 189 240 MFN8360956.1 type I methionyl aminopeptidase [Candidatus Kapaibacterium sp.] diamond 156 102 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
28217375 28217375 PRJNA630162_P_NODE_128426_length_170_cov_1.685950_g126903_i0 PRJNA630162 128426 170 1.68595 2.866115 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 57.8 5.38e-8   NR HOK14998.1 2447898 g126903 i0 45.1 2.7 51 28 90 0 155 3 76 126 HOK14998.1 hypothetical protein [Candidatus Kapaibacterium sp.] diamond 459 57.8 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
29165105 29165105 PRJNA630162_P_NODE_118289_length_175_cov_1.992063_g116766_i0 PRJNA630162 118289 175 1.992063 3.48611025 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 113 2.2600000000000003e-27   NR MFN8360195.1 2447898 g116766 i0 96.4 1.92 56 2 96 0 170 3 347 402 MFN8360195.1 hypothetical protein [Candidatus Kapaibacterium sp.] diamond 336 113 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
29575287 29575287 PRJNA630162_P_NODE_9130_length_635_cov_3.665529_g7765_i0 PRJNA630162 9130 635 3.665529 23.27610915 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 68.9 3.38e-10   NR MBZ0193890.1 2447898 g7765 i0 74.5 1.50708661417323 47 12 22.2 0 42 182 53 99 MBZ0193890.1 hypothetical protein [Candidatus Kapaibacterium sp.] diamond 957 68.9 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
29859472 29859472 PRJNA630162_P_NODE_128691_length_170_cov_1.570248_g127168_i0 PRJNA630162 128691 170 1.570248 2.6694216 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 53.5 7.63e-7   NR MFN8361949.1 2447898 g127168 i0 53.7 4.62352941176471 54 13 95.3 1 162 1 58 99 MFN8361949.1 hypothetical protein [Candidatus Kapaibacterium sp.] diamond 786 53.5 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
31534640 31534640 PRJNA630162_P_NODE_150596_length_164_cov_1.678261_g149073_i0 PRJNA630162 150596 164 1.678261 2.75234804 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 49.7 4.51e-5   NR MFP4529148.1 2447898 g149073 i0 43.1 0.932926829268293 51 29 93.3 0 10 162 1 51 MFP4529148.1 TolC family protein [Candidatus Kapaibacterium sp.] diamond 153 49.7 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
32420304 32420304 PRJNA630162_P_NODE_124279_length_172_cov_1.682927_g122756_i0 PRJNA630162 124279 172 1.682927 2.89463444 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 72.8 8.45e-14   NR MCX6154931.1 2447898 g122756 i0 59.3 0.941860465116279 54 22 94.2 0 163 2 25 78 MCX6154931.1 hypothetical protein [Candidatus Kapaibacterium sp.] diamond 162 72.8 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.

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