contig_metadata
13 rows where bioproject = "PRJNA498309", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18332565 | 18332565 | PRJNA498309_P_NODE_51975_length_366_cov_3.565350_g49827_i0 | PRJNA498309 | 51975 | 366 | 3.56535 | 13.049181 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 166 | 1.03e-47 | NR | GIV56181.1 | 2447898 | g49827 | i0 | 96.5 | 0.69672131147541 | 85 | 3 | 69.7 | 0 | 256 | 2 | 1 | 85 | GIV56181.1 MAG: ribosome-binding ATPase YchF [Candidatus Kapaibacterium sp.] | diamond | 255 | 166 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 19606971 | 19606971 | PRJNA498309_P_NODE_57496_length_339_cov_2.274834_g55348_i0 | PRJNA498309 | 57496 | 339 | 2.274834 | 7.71168726 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 274 | 6.28e-69 | NTclustered | gi|1869359902|gb|CP058732.1| | 2447898 | g55348 | i0 | 84.452 | 0.834808259587021 | 283 | 38 | 82 | 3 | 43 | 321 | 268848 | 269128 | MAG: Candidatus Kapaibacterium sp. isolate Ch6 chromosome, complete genome | blastn | 283 | 274 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 27077053 | 27077053 | PRJNA498309_P_NODE_69442_length_288_cov_1.545817_g67293_i0 | PRJNA498309 | 69442 | 288 | 1.545817 | 4.45195296 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 103 | 9.459999999999999e-24 | NR | GIV50123.1 | 2447898 | g67293 | i0 | 92.7 | 0.572916666666667 | 55 | 3 | 56.3 | 1 | 70 | 231 | 382 | 436 | GIV50123.1 MAG: hypothetical protein KatS3mg038_0644 [Candidatus Kapaibacterium sp.] | diamond | 165 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 27171628 | 27171628 | PRJNA498309_P_NODE_116282_length_161_cov_1.653226_g114133_i0 | PRJNA498309 | 116282 | 161 | 1.653226 | 2.66169386 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 101 | 2.96e-23 | NR | GIV50346.1 | 2447898 | g114133 | i0 | 94.2 | 0.968944099378882 | 52 | 3 | 96.9 | 0 | 156 | 1 | 221 | 272 | GIV50346.1 MAG: hypothetical protein KatS3mg038_0867 [Candidatus Kapaibacterium sp.] | diamond | 156 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 28561458 | 28561458 | PRJNA498309_P_NODE_32247_length_498_cov_9.494577_g30228_i0 | PRJNA498309 | 32247 | 498 | 9.494577 | 47.28299346 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 140 | 4.159999999999999e-35 | NR | GIV55916.1 | 2447898 | g30228 | i0 | 88.5 | 0.469879518072289 | 78 | 9 | 47 | 0 | 251 | 18 | 1 | 78 | GIV55916.1 MAG: hypothetical protein KatS3mg040_0684 [Candidatus Kapaibacterium sp.] | diamond | 234 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 28593019 | 28593019 | PRJNA498309_P_NODE_41987_length_423_cov_26.321244_g39872_i0 | PRJNA498309 | 41987 | 423 | 26.321244 | 111.33886212 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 203 | 3.99e-62 | NR | GIV56245.1 | 2447898 | g39872 | i0 | 95.1 | 0.723404255319149 | 102 | 5 | 72.3 | 0 | 420 | 115 | 231 | 332 | GIV56245.1 MAG: 3-oxoacyl-[acyl-carrier-protein] synthase 3 [Candidatus Kapaibacterium sp.] | diamond | 306 | 203 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 28845321 | 28845321 | PRJNA498309_P_NODE_119488_length_156_cov_1.268908_g117339_i0 | PRJNA498309 | 119488 | 156 | 1.268908 | 1.97949648 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 86.7 | 3.33e-18 | NR | GIV55503.1 | 2447898 | g117339 | i0 | 78.4 | 1.96153846153846 | 51 | 11 | 98.1 | 0 | 155 | 3 | 344 | 394 | GIV55503.1 MAG: hypothetical protein KatS3mg040_0271 [Candidatus Kapaibacterium sp.] | diamond | 306 | 86.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30487797 | 30487797 | PRJNA498309_P_NODE_30153_length_517_cov_10.612500_g28156_i0 | PRJNA498309 | 30153 | 517 | 10.6125 | 54.866625 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 236 | 1.5699999999999999e-68 | NR | GIV53065.1 | 2447898 | g28156 | i0 | 75.5 | 0.922630560928433 | 159 | 33 | 89.9 | 2 | 12 | 476 | 201 | 357 | GIV53065.1 MAG: hypothetical protein KatS3mg038_3586 [Candidatus Kapaibacterium sp.] | diamond | 477 | 236 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 31024982 | 31024982 | PRJNA498309_P_NODE_39255_length_442_cov_10.960494_g37160_i0 | PRJNA498309 | 39255 | 442 | 10.960494 | 48.44538348 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 244 | 2.92e-77 | NR | GIV50340.1 | 2447898 | g37160 | i0 | 98.4 | 0.84841628959276 | 125 | 2 | 84.8 | 0 | 48 | 422 | 109 | 233 | GIV50340.1 MAG: 8-amino-7-oxononanoate synthase [Candidatus Kapaibacterium sp.] | diamond | 375 | 244 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 31277660 | 31277660 | PRJNA498309_P_NODE_83135_length_240_cov_5.748768_g80986_i0 | PRJNA498309 | 83135 | 240 | 5.748768 | 13.7970432 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 134 | 1.4799999999999998e-37 | NR | GIV55014.1 | 2447898 | g80986 | i0 | 91.3 | 0.8625 | 69 | 6 | 86.3 | 0 | 22 | 228 | 14 | 82 | GIV55014.1 MAG: bb3-type cytochrome oxidase subunit IV [Candidatus Kapaibacterium sp.] | diamond | 207 | 134 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 31846979 | 31846979 | PRJNA498309_P_NODE_84717_length_235_cov_6.106061_g82568_i0 | PRJNA498309 | 84717 | 235 | 6.106061 | 14.34924335 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 122 | 4.76e-31 | NR | GIV56161.1 | 2447898 | g82568 | i0 | 92.2 | 0.817021276595745 | 64 | 5 | 81.7 | 0 | 22 | 213 | 289 | 352 | GIV56161.1 MAG: cysteine desulfurase IscS [Candidatus Kapaibacterium sp.] | diamond | 192 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32226920 | 32226920 | PRJNA498309_P_NODE_72758_length_275_cov_4.802521_g70609_i0 | PRJNA498309 | 72758 | 275 | 4.802521 | 13.20693275 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 97.1 | 4.31e-21 | NR | GIV56760.1 | 2447898 | g70609 | i0 | 87.8 | 0.534545454545455 | 49 | 6 | 53.5 | 0 | 258 | 112 | 540 | 588 | GIV56760.1 MAG: hypothetical protein KatS3mg040_1528 [Candidatus Kapaibacterium sp.] | diamond | 147 | 97.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32511821 | 32511821 | PRJNA498309_P_NODE_29139_length_528_cov_3.690428_g27157_i0 | PRJNA498309 | 29139 | 528 | 3.690428 | 19.48545984 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 255 | 7.26e-84 | NR | GIV56541.1 | 2447898 | g27157 | i0 | 97.7 | 0.75 | 132 | 3 | 75 | 0 | 119 | 514 | 1 | 132 | GIV56541.1 MAG: hypothetical protein KatS3mg040_1309 [Candidatus Kapaibacterium sp.] | diamond | 396 | 255 | 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);;