contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJEB64798" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1402202 | 1402202 | PRJEB64798_P_NODE_189422_length_170_cov_9.438017_g187656_i0 | PRJEB64798 | 189422 | 170 | 9.438017 | 16.0446289 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 233 | 4.7299999999999995e-57 | NTclustered | gi|2621704217|emb|OY761611.1| | 2447898 | g187656 | i0 | 92.593 | 146.435294117647 | 162 | 12 | 95 | 0 | 6 | 167 | 1419356 | 1419195 | MAG: Candidatus Kapabacteria bacterium isolate 963550f5-4d88-4eb0-99f7-25ebda648600 genome assembly, chromosome: 1 | blastn | 24894 | 233 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 6507011 | 6507011 | PRJEB64798_P_NODE_36426_length_327_cov_5.399281_g34667_i0 | PRJEB64798 | 36426 | 327 | 5.399281 | 17.65564887 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 128 | 4.97e-25 | NTclustered | gi|1869359902|gb|CP058732.1| | 2447898 | g34667 | i0 | 86.066 | 92.8960244648318 | 122 | 13 | 37 | 4 | 165 | 285 | 420569 | 420451 | MAG: Candidatus Kapaibacterium sp. isolate Ch6 chromosome, complete genome | blastn | 30377 | 128 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 9055904 | 9055904 | PRJEB64798_P_NODE_27368_length_376_cov_7.666667_g25613_i0 | PRJEB64798 | 27368 | 376 | 7.666667 | 28.82666792 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 425 | 1.83e-114 | NTclustered | gi|2556937695|gb|CP129493.1| | 2447898 | g25613 | i0 | 91.318 | 761.545212765957 | 311 | 27 | 83 | 0 | 6 | 316 | 1179030 | 1178720 | MAG: Candidatus Kapaibacterium sp. isolate cMAG.3 chromosome, complete genome | blastn | 286341 | 425 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 10330966 | 10330966 | PRJEB64798_P_NODE_20449_length_440_cov_17.442455_g18718_i0 | PRJEB64798 | 20449 | 440 | 17.442455 | 76.746802 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 52.8 | 0.043 | NTclustered | gi|1869359902|gb|CP058732.1| | 2447898 | g18718 | i0 | 100 | 0.0636363636363636 | 28 | 0 | 6 | 0 | 279 | 306 | 2394846 | 2394819 | MAG: Candidatus Kapaibacterium sp. isolate Ch6 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 11605620 | 11605620 | PRJEB64798_P_NODE_15270_length_510_cov_14.739696_g13586_i0 | PRJEB64798 | 15270 | 510 | 14.739696 | 75.1724496 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 287 | 1.26e-72 | NTclustered | gi|2621703255|emb|OY762428.1| | 2447898 | g13586 | i0 | 81.233 | 133.596078431373 | 373 | 54 | 72 | 12 | 137 | 503 | 3516279 | 3516641 | MAG: Candidatus Kapabacteria bacterium isolate a44c304e-2480-4604-92e3-6035b9b042d9 genome assembly, chromosome: 1 | blastn | 68134 | 287 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 11606979 | 11606979 | PRJEB64798_P_NODE_244990_length_153_cov_7.625000_g243224_i0 | PRJEB64798 | 244990 | 153 | 7.625 | 11.66625 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 209 | 7.03e-50 | NTclustered | gi|2621704217|emb|OY761611.1| | 2447898 | g243224 | i0 | 92 | 262.915032679739 | 150 | 10 | 97 | 2 | 2 | 149 | 1419433 | 1419582 | MAG: Candidatus Kapabacteria bacterium isolate 963550f5-4d88-4eb0-99f7-25ebda648600 genome assembly, chromosome: 1 | blastn | 40226 | 209 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 15430002 | 15430002 | PRJEB64798_P_NODE_184373_length_172_cov_9.796748_g182607_i0 | PRJEB64798 | 184373 | 172 | 9.796748 | 16.85040656 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 211 | 2.25e-50 | NTclustered | gi|2518551211|emb|OX638338.1| | 2447898 | g182607 | i0 | 90.566 | 478.726744186047 | 159 | 15 | 92 | 0 | 6 | 164 | 2782766 | 2782924 | MAG: Candidatus Kapabacteria bacterium isolate 9634bca7-0036-4470-acfa-8c32e30c46ef genome assembly, chromosome: 1 | blastn | 82341 | 211 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 16705003 | 16705003 | PRJEB64798_P_NODE_230694_length_158_cov_6.944954_g228928_i0 | PRJEB64798 | 230694 | 158 | 6.944954 | 10.97302732 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 185 | 1.23e-42 | NTclustered | gi|2907625638|emb|OZ223198.1| | 2447898 | g228928 | i0 | 90.278 | 138.075949367089 | 144 | 11 | 90 | 3 | 5 | 146 | 1118668 | 1118526 | MAG: Candidatus Kapaibacterium sp. isolate 09316a08-0405-4927-8c64-54324f316411 genome assembly, chromosome: 2 | blastn | 21816 | 185 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 16705577 | 16705577 | PRJEB64798_P_NODE_39054_length_316_cov_5.505618_g37291_i0 | PRJEB64798 | 39054 | 316 | 5.505618 | 17.39775288 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 243 | 1.64e-59 | NTclustered | gi|2621704217|emb|OY761611.1| | 2447898 | g37291 | i0 | 81.29 | 304.683544303797 | 310 | 49 | 97 | 9 | 6 | 312 | 1418733 | 1418430 | MAG: Candidatus Kapabacteria bacterium isolate 963550f5-4d88-4eb0-99f7-25ebda648600 genome assembly, chromosome: 1 | blastn | 96280 | 243 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 19254112 | 19254112 | PRJEB64798_P_NODE_24796_length_395_cov_13.627168_g23047_i0 | PRJEB64798 | 24796 | 395 | 13.627168 | 53.8273136 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 468 | 3.17e-127 | NTclustered | gi|2621703255|emb|OY762428.1| | 2447898 | g23047 | i0 | 88.265 | 297.111392405063 | 392 | 44 | 99 | 2 | 1 | 391 | 2680364 | 2679974 | MAG: Candidatus Kapabacteria bacterium isolate a44c304e-2480-4604-92e3-6035b9b042d9 genome assembly, chromosome: 1 | blastn | 117359 | 468 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 21803381 | 21803381 | PRJEB64798_P_NODE_122738_length_204_cov_6.877419_g120972_i0 | PRJEB64798 | 122738 | 204 | 6.877419 | 14.02993476 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 244 | 2.7399999999999997e-60 | NTclustered | gi|2621704217|emb|OY761611.1| | 2447898 | g120972 | i0 | 91.573 | 418.352941176471 | 178 | 13 | 87 | 2 | 1 | 178 | 1419469 | 1419644 | MAG: Candidatus Kapabacteria bacterium isolate 963550f5-4d88-4eb0-99f7-25ebda648600 genome assembly, chromosome: 1 | blastn | 85344 | 244 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 23079241 | 23079241 | PRJEB64798_P_NODE_161019_length_183_cov_2.186567_g159253_i0 | PRJEB64798 | 161019 | 183 | 2.186567 | 4.00141761 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 143 | 8.989999999999998e-30 | NTclustered | gi|1869359902|gb|CP058732.1| | 2447898 | g159253 | i0 | 90.654 | 213.595628415301 | 107 | 10 | 58 | 0 | 45 | 151 | 420986 | 420880 | MAG: Candidatus Kapaibacterium sp. isolate Ch6 chromosome, complete genome | blastn | 39088 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 23080439 | 23080439 | PRJEB64798_P_NODE_24359_length_399_cov_11.651429_g22611_i0 | PRJEB64798 | 24359 | 399 | 11.651429 | 46.48920171 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 296 | 1.6e-75 | NTclustered | gi|1869359902|gb|CP058732.1| | 2447898 | g22611 | i0 | 80.711 | 389.771929824561 | 394 | 64 | 97 | 9 | 12 | 398 | 422062 | 421674 | MAG: Candidatus Kapaibacterium sp. isolate Ch6 chromosome, complete genome | blastn | 155519 | 296 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 23080590 | 23080590 | PRJEB64798_P_NODE_27039_length_378_cov_39.069909_g25286_i0 | PRJEB64798 | 27039 | 378 | 39.069909 | 147.68425602 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 300 | 1.16e-76 | NTclustered | gi|2621703255|emb|OY762428.1| | 2447898 | g25286 | i0 | 81.316 | 272.772486772487 | 380 | 61 | 98 | 6 | 6 | 376 | 2680537 | 2680915 | MAG: Candidatus Kapabacteria bacterium isolate a44c304e-2480-4604-92e3-6035b9b042d9 genome assembly, chromosome: 1 | blastn | 103108 | 300 | 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);;