contig_metadata
22 rows where bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25923215 | 25923215 | PRJEB20058_P_NODE_149340_length_314_cov_68.446640_g146518_i0 | PRJEB20058 | 149340 | 314 | 68.44664 | 214.9224496 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 79.3 | 1.9e-15 | NR | HRK60447.1 | 2447898 | g146518 | i0 | 86.9 | 1.09872611464968 | 61 | 8 | 58.3 | 0 | 213 | 31 | 31 | 91 | HRK60447.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 345 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 26194378 | 26194378 | PRJEB20058_P_NODE_124742_length_355_cov_8.074830_g121923_i0 | PRJEB20058 | 124742 | 355 | 8.07483 | 28.6656465 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 407 | 6.219999999999999e-109 | NTclustered | gi|2621703255|emb|OY762428.1| | 2447898 | g121923 | i0 | 88.427 | 173.371830985915 | 337 | 39 | 95 | 0 | 19 | 355 | 2679991 | 2680327 | MAG: Candidatus Kapabacteria bacterium isolate a44c304e-2480-4604-92e3-6035b9b042d9 genome assembly, chromosome: 1 | blastn | 61547 | 407 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 26199948 | 26199948 | PRJEB20058_P_NODE_34182_length_718_cov_15.663623_g31616_i0 | PRJEB20058 | 34182 | 718 | 15.663623 | 112.46481314 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 97.1 | 3.27e-15 | NTclustered | gi|2621703255|emb|OY762428.1| | 2447898 | g31616 | i0 | 85.714 | 5.95125348189415 | 91 | 13 | 13 | 0 | 160 | 250 | 4537318 | 4537408 | MAG: Candidatus Kapabacteria bacterium isolate a44c304e-2480-4604-92e3-6035b9b042d9 genome assembly, chromosome: 1 | blastn | 4273 | 97.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32911214 | 32911214 | PRJEB20058_P_NODE_30681_length_757_cov_9.741379_g28203_i0 | PRJEB20058 | 30681 | 757 | 9.741379 | 73.74223903 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 368 | 1.84e-123 | NR | GIV50125.1 | 2447898 | g28203 | i0 | 98.3 | 0.693527080581242 | 175 | 3 | 69.4 | 0 | 218 | 742 | 258 | 432 | GIV50125.1 MAG: hypothetical protein KatS3mg038_0646 [Candidatus Kapaibacterium sp.] | diamond | 525 | 368 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32945159 | 32945159 | PRJEB20058_P_NODE_189210_length_266_cov_1.804878_g186386_i0 | PRJEB20058 | 189210 | 266 | 1.804878 | 4.80097548 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 45.8 | 6.25e-4 | NR | MBL8000004.1 | 2447898 | g186386 | i0 | 48.8 | 0.462406015037594 | 41 | 21 | 46.2 | 0 | 104 | 226 | 1 | 41 | MBL8000004.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 123 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32945569 | 32945569 | PRJEB20058_P_NODE_42274_length_647_cov_2.969283_g39613_i0 | PRJEB20058 | 42274 | 647 | 2.969283 | 19.21126101 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 219 | 1.48e-66 | NR | GIV56876.1 | 2447898 | g39613 | i0 | 93 | 0.593508500772797 | 128 | 9 | 59.4 | 0 | 264 | 647 | 1 | 128 | GIV56876.1 MAG: NAD(P) transhydrogenase subunit alpha [Candidatus Kapaibacterium sp.] | diamond | 384 | 219 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32945796 | 32945796 | PRJEB20058_P_NODE_75266_length_479_cov_2.744019_g72488_i0 | PRJEB20058 | 75266 | 479 | 2.744019 | 13.14385101 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 140 | 8.09e-37 | NR | GIV56375.1 | 2447898 | g72488 | i0 | 96.3 | 1.03966597077244 | 81 | 3 | 50.7 | 0 | 54 | 296 | 1 | 81 | GIV56375.1 MAG: permease [Candidatus Kapaibacterium sp.] | diamond | 498 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32962402 | 32962402 | PRJEB20058_P_NODE_187090_length_268_cov_2.507246_g184267_i0 | PRJEB20058 | 187090 | 268 | 2.507246 | 6.71941928 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 75.5 | 9.21e-14 | NR | GIV54871.1 | 2447898 | g184267 | i0 | 94.6 | 0.414179104477612 | 37 | 2 | 41.4 | 0 | 156 | 266 | 1 | 37 | GIV54871.1 MAG: hypothetical protein KatS3mg039_1389 [Candidatus Kapaibacterium sp.] | diamond | 111 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32962795 | 32962795 | PRJEB20058_P_NODE_38386_length_679_cov_7.268608_g35762_i0 | PRJEB20058 | 38386 | 679 | 7.268608 | 49.35384832 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 315 | 3.1900000000000002e-103 | NR | MFA5511170.1 | 2447898 | g35762 | i0 | 86.8 | 2.31958762886598 | 174 | 23 | 76.9 | 0 | 19 | 540 | 28 | 201 | MFA5511170.1 beta-ketoacyl-ACP synthase II [Candidatus Kapaibacterium sp.] | diamond | 1575 | 315 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32979023 | 32979023 | PRJEB20058_P_NODE_105707_length_394_cov_3.357357_g102899_i0 | PRJEB20058 | 105707 | 394 | 3.357357 | 13.22798658 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 154 | 1.86e-40 | NR | GIV50538.1 | 2447898 | g102899 | i0 | 87.6 | 0.677664974619289 | 89 | 11 | 67.8 | 0 | 393 | 127 | 2056 | 2144 | GIV50538.1 MAG: hypothetical protein KatS3mg038_1059 [Candidatus Kapaibacterium sp.] | diamond | 267 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32979245 | 32979245 | PRJEB20058_P_NODE_143563_length_323_cov_5.167939_g140742_i0 | PRJEB20058 | 143563 | 323 | 5.167939 | 16.69244297 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 172 | 3.82e-50 | NR | HEY6170766.1 | 2447898 | g140742 | i0 | 87.3 | 0.947368421052632 | 102 | 13 | 94.7 | 0 | 316 | 11 | 185 | 286 | HEY6170766.1 ABC transporter transmembrane domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 306 | 172 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33030959 | 33030959 | PRJEB20058_P_NODE_37020_length_691_cov_6.557143_g34421_i0 | PRJEB20058 | 37020 | 691 | 6.557143 | 45.30985813 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 392 | 5.4099999999999996e-133 | NR | GIV56636.1 | 2447898 | g34421 | i0 | 89.9 | 0.942112879884226 | 217 | 22 | 94.2 | 0 | 19 | 669 | 149 | 365 | GIV56636.1 MAG: 23S rRNA (uracil-5-)-methyltransferase RumA [Candidatus Kapaibacterium sp.] | diamond | 651 | 392 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33047273 | 33047273 | PRJEB20058_P_NODE_145901_length_320_cov_1.374517_g143080_i0 | PRJEB20058 | 145901 | 320 | 1.374517 | 4.3984544 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 150 | 2.12e-43 | NR | HET9137271.1 | 2447898 | g143080 | i0 | 68.6 | 1.96875 | 105 | 33 | 98.4 | 0 | 317 | 3 | 40 | 144 | HET9137271.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 630 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33047377 | 33047377 | PRJEB20058_P_NODE_166069_length_292_cov_3.943723_g163246_i0 | PRJEB20058 | 166069 | 292 | 3.943723 | 11.51567116 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 173 | 8.05e-50 | NR | GIV55503.1 | 2447898 | g163246 | i0 | 86.6 | 2.98972602739726 | 97 | 13 | 99.7 | 0 | 1 | 291 | 336 | 432 | GIV55503.1 MAG: hypothetical protein KatS3mg040_0271 [Candidatus Kapaibacterium sp.] | diamond | 873 | 173 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33047393 | 33047393 | PRJEB20058_P_NODE_16805_length_1009_cov_43.400844_g14881_i0 | PRJEB20058 | 16805 | 1009 | 43.400844 | 437.91451596 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 191 | 3.68e-57 | NR | GIV56766.1 | 2447898 | g14881 | i0 | 92.6 | 0.564915758176412 | 95 | 7 | 28.2 | 0 | 767 | 483 | 1 | 95 | GIV56766.1 MAG: hypothetical protein KatS3mg040_1534 [Candidatus Kapaibacterium sp.] | diamond | 570 | 191 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33048192 | 33048192 | PRJEB20058_P_NODE_90677_length_431_cov_8.875676_g87879_i0 | PRJEB20058 | 90677 | 431 | 8.875676 | 38.25416356 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 196 | 3.0599999999999992e-55 | NR | GIV56392.1 | 2447898 | g87879 | i0 | 87.5 | 0.779582366589327 | 112 | 14 | 78 | 0 | 419 | 84 | 413 | 524 | GIV56392.1 MAG: UvrABC system protein A [Candidatus Kapaibacterium sp.] | diamond | 336 | 196 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33064374 | 33064374 | PRJEB20058_P_NODE_151045_length_312_cov_2.900398_g148223_i0 | PRJEB20058 | 151045 | 312 | 2.900398 | 9.04924176 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 163 | 5.69e-47 | NR | GIV54871.1 | 2447898 | g148223 | i0 | 96.3 | 3.15384615384615 | 82 | 3 | 78.8 | 0 | 2 | 247 | 42 | 123 | GIV54871.1 MAG: hypothetical protein KatS3mg039_1389 [Candidatus Kapaibacterium sp.] | diamond | 984 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33082383 | 33082383 | PRJEB20058_P_NODE_90790_length_431_cov_3.062162_g87992_i0 | PRJEB20058 | 90790 | 431 | 3.062162 | 13.19791822 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 145 | 9.779999999999999e-39 | NR | GIV55752.1 | 2447898 | g87992 | i0 | 89.5 | 0.59860788863109 | 86 | 9 | 59.9 | 0 | 9 | 266 | 189 | 274 | GIV55752.1 MAG: hypothetical protein KatS3mg040_0520 [Candidatus Kapaibacterium sp.] | diamond | 258 | 145 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33099311 | 33099311 | PRJEB20058_P_NODE_72926_length_487_cov_6.946009_g70150_i0 | PRJEB20058 | 72926 | 487 | 6.946009 | 33.82706383 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 260 | 2.1e-86 | NR | GIV55784.1 | 2447898 | g70150 | i0 | 93.2 | 0.819301848049281 | 133 | 9 | 81.9 | 0 | 18 | 416 | 32 | 164 | GIV55784.1 MAG: phenylacetate-CoA oxygenase subunit PaaJ [Candidatus Kapaibacterium sp.] | diamond | 399 | 260 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33099454 | 33099454 | PRJEB20058_P_NODE_93774_length_423_cov_2.900552_g90974_i0 | PRJEB20058 | 93774 | 423 | 2.900552 | 12.26933496 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 177 | 1.61e-48 | NR | GIV50346.1 | 2447898 | g90974 | i0 | 95.7 | 1.33333333333333 | 94 | 4 | 66.7 | 0 | 19 | 300 | 221 | 314 | GIV50346.1 MAG: hypothetical protein KatS3mg038_0867 [Candidatus Kapaibacterium sp.] | diamond | 564 | 177 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33116305 | 33116305 | PRJEB20058_P_NODE_65983_length_514_cov_7.225166_g63215_i0 | PRJEB20058 | 65983 | 514 | 7.225166 | 37.13735324 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 323 | 1.85e-109 | NR | GIV54749.1 | 2447898 | g63215 | i0 | 97.6 | 0.963035019455253 | 165 | 3 | 95.7 | 1 | 496 | 5 | 22 | 186 | GIV54749.1 MAG: hypothetical protein KatS3mg039_1267 [Candidatus Kapaibacterium sp.] | diamond | 495 | 323 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 33133268 | 33133268 | PRJEB20058_P_NODE_29327_length_774_cov_13.140252_g26887_i0 | PRJEB20058 | 29327 | 774 | 13.140252 | 101.70555048 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 281 | 9.11e-90 | NR | GIV49521.1 | 2447898 | g26887 | i0 | 98 | 0.581395348837209 | 150 | 3 | 58.1 | 0 | 467 | 18 | 1 | 150 | GIV49521.1 MAG: acetyl-CoA acetyltransferase [Candidatus Kapaibacterium sp.] | diamond | 450 | 281 | 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);;