contig_metadata
16 rows where bioproject = "PRJNA704949", tax_clade = "FCB group" and tax_phylum = "Candidatus Kapaibacteriota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17278884 | 17278884 | PRJNA704949_P_NODE_793654_length_299_cov_2.216000_g778322_i0 | PRJNA704949 | 793654 | 299 | 2.216 | 6.62584 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 52.8 | 0.028 | NTclustered | gi|2907625638|emb|OZ223198.1| | 2447898 | g778322 | i0 | 96.875 | 0.107023411371237 | 32 | 0 | 10 | 1 | 47 | 77 | 13129 | 13098 | MAG: Candidatus Kapaibacterium sp. isolate 09316a08-0405-4927-8c64-54324f316411 genome assembly, chromosome: 2 | blastn | 32 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 26734379 | 26734379 | PRJNA704949_P_NODE_1322581_length_218_cov_1.538462_g1307244_i0 | PRJNA704949 | 1322581 | 218 | 1.538462 | 3.35384716 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 83.2 | 1.48e-16 | NR | HVK37164.1 | 2447898 | g1307244 | i0 | 54.4 | 0.935779816513762 | 68 | 31 | 93.6 | 0 | 13 | 216 | 1 | 68 | HVK37164.1 IgGFc-binding protein [Candidatus Kapaibacterium sp.] | diamond | 204 | 83.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 27494244 | 27494244 | PRJNA704949_P_NODE_732443_length_314_cov_0.981132_g717114_i0 | PRJNA704949 | 732443 | 314 | 0.981132 | 3.08075448 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 74.3 | 7.03e-13 | NR | HVK39029.1 | 2447898 | g717114 | i0 | 44.8 | 0.831210191082803 | 87 | 45 | 82.2 | 2 | 23 | 280 | 717 | 801 | HVK39029.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 261 | 74.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 27556766 | 27556766 | PRJNA704949_P_NODE_1585024_length_194_cov_1.075862_g1569685_i0 | PRJNA704949 | 1585024 | 194 | 1.075862 | 2.08717228 | Candidatus Kapaibacterium thiocyanatum | 1895771 | Bacteria | Bacteria | 127 | 4.06e-32 | NR | MBN9399278.1 | 1895771 | g1569685 | i0 | 92.2 | 0.989690721649485 | 64 | 5 | 99 | 0 | 192 | 1 | 406 | 469 | MBN9399278.1 hypothetical protein [Candidatus Kapaibacterium thiocyanatum] | diamond | 192 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium thiocyanatum | |
| 28472663 | 28472663 | PRJNA704949_P_NODE_1313506_length_219_cov_1.529412_g1298169_i0 | PRJNA704949 | 1313506 | 219 | 1.529412 | 3.34941228 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 49.3 | 1.31e-4 | NR | MFP4529338.1 | 2447898 | g1298169 | i0 | 51.2 | 1.71232876712329 | 43 | 21 | 58.9 | 0 | 218 | 90 | 547 | 589 | MFP4529338.1 tetratricopeptide repeat protein [Candidatus Kapaibacterium sp.] | diamond | 375 | 49.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 28914355 | 28914355 | PRJNA704949_P_NODE_1442508_length_206_cov_1.401274_g1427170_i0 | PRJNA704949 | 1442508 | 206 | 1.401274 | 2.88662444 | Candidatus Kapaibacterium thiocyanatum | 1895771 | Bacteria | Bacteria | 127 | 2.5699999999999997e-32 | NR | MBN9399278.1 | 1895771 | g1427170 | i0 | 88.2 | 0.990291262135922 | 68 | 8 | 99 | 0 | 1 | 204 | 277 | 344 | MBN9399278.1 hypothetical protein [Candidatus Kapaibacterium thiocyanatum] | diamond | 204 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium thiocyanatum | |
| 29199224 | 29199224 | PRJNA704949_P_NODE_249049_length_533_cov_2.134298_g234505_i0 | PRJNA704949 | 249049 | 533 | 2.134298 | 11.37580834 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 182 | 1.16e-49 | NR | HVK39420.1 | 2447898 | g234505 | i0 | 54.9 | 0.973733583489681 | 173 | 78 | 97.4 | 0 | 2 | 520 | 137 | 309 | HVK39420.1 translocation/assembly module TamB domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 519 | 182 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 29640514 | 29640514 | PRJNA704949_P_NODE_1579690_length_194_cov_1.434483_g1564351_i0 | PRJNA704949 | 1579690 | 194 | 1.434483 | 2.78289702 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 43.1 | 0.0142 | NR | HVK39454.1 | 2447898 | g1564351 | i0 | 38.8 | 1.0360824742268 | 67 | 23 | 75.8 | 1 | 46 | 192 | 24 | 90 | HVK39454.1 glycosyl hydrolase family 18 protein [Candidatus Kapaibacterium sp.] | diamond | 201 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30241021 | 30241021 | PRJNA704949_P_NODE_1394252_length_211_cov_0.969136_g1378914_i0 | PRJNA704949 | 1394252 | 211 | 0.969136 | 2.04487696 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 94.4 | 1.03e-21 | NR | MBC8146130.1 | 2447898 | g1378914 | i0 | 77.8 | 0.767772511848341 | 54 | 12 | 76.8 | 0 | 3 | 164 | 180 | 233 | MBC8146130.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 162 | 94.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30304816 | 30304816 | PRJNA704949_P_NODE_2024032_length_166_cov_1.333333_g2008693_i0 | PRJNA704949 | 2024032 | 166 | 1.333333 | 2.21333278 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 82.4 | 1.35e-16 | NR | HVK37164.1 | 2447898 | g2008693 | i0 | 76.9 | 0.939759036144578 | 52 | 12 | 94 | 0 | 1 | 156 | 184 | 235 | HVK37164.1 IgGFc-binding protein [Candidatus Kapaibacterium sp.] | diamond | 156 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30619951 | 30619951 | PRJNA704949_P_NODE_1117933_length_243_cov_1.242268_g1102597_i0 | PRJNA704949 | 1117933 | 243 | 1.242268 | 3.01871124 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 65.1 | 4.71e-10 | NR | MFA5512123.1 | 2447898 | g1102597 | i0 | 44.3 | 4.67901234567901 | 79 | 40 | 92.6 | 1 | 18 | 242 | 339 | 417 | MFA5512123.1 adenylosuccinate lyase [Candidatus Kapaibacterium sp.] | diamond | 1137 | 65.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30778538 | 30778538 | PRJNA704949_P_NODE_717614_length_317_cov_2.328358_g702285_i0 | PRJNA704949 | 717614 | 317 | 2.328358 | 7.38089486 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 107 | 9.97e-25 | NR | MBC8144236.1 | 2447898 | g702285 | i0 | 56.3 | 0.908517350157729 | 96 | 42 | 90.9 | 0 | 25 | 312 | 37 | 132 | MBC8144236.1 DUF1800 domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 288 | 107 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32053844 | 32053844 | PRJNA704949_P_NODE_178398_length_615_cov_1.832155_g164536_i0 | PRJNA704949 | 178398 | 615 | 1.832155 | 11.26775325 | FCB group | 1783270 | Bacteria | Bacteria | 48.5 | 0.00977 | NR | HZV12048.1 | 2447898 | g164536 | i0 | 60.5 | 0.960975609756098 | 38 | 15 | 18.5 | 0 | 214 | 327 | 18 | 55 | HZV12048.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 591 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32137821 | 32137821 | PRJNA704949_P_NODE_1351678_length_215_cov_1.409639_g1336340_i0 | PRJNA704949 | 1351678 | 215 | 1.409639 | 3.03072385 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 79.7 | 2.23e-15 | NR | MBC8145432.1 | 2447898 | g1336340 | i0 | 52.9 | 0.976744186046512 | 70 | 33 | 97.7 | 0 | 212 | 3 | 19 | 88 | MBC8145432.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 210 | 79.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32201049 | 32201049 | PRJNA704949_P_NODE_1230998_length_228_cov_2.251397_g1215661_i0 | PRJNA704949 | 1230998 | 228 | 2.251397 | 5.13318516 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 100 | 1e-22 | NR | HYM20707.1 | 2447898 | g1215661 | i0 | 64.8 | 1.86842105263158 | 71 | 25 | 93.4 | 0 | 14 | 226 | 141 | 211 | HYM20707.1 DNA repair protein RecN [Candidatus Kapaibacterium sp.] | diamond | 426 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32328184 | 32328184 | PRJNA704949_P_NODE_1860099_length_173_cov_1.677419_g1844760_i0 | PRJNA704949 | 1860099 | 173 | 1.677419 | 2.90193487 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 42 | 0.0278 | NR | MEO5928358.1 | 2447898 | g1844760 | i0 | 51 | 0.84971098265896 | 49 | 19 | 85 | 1 | 2 | 148 | 189 | 232 | MEO5928358.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 147 | 42 | 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
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);;