contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4443347 | 4443347 | PRJNA641707_P_NODE_311264_length_161_cov_4.339286_g308601_i0 | PRJNA641707 | 311264 | 161 | 4.339286 | 6.98625046 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 154 | 3.5600000000000004e-33 | NTclustered | gi|2518551211|emb|OX638338.1| | 2447898 | g308601 | i0 | 85.333 | 10.0372670807453 | 150 | 20 | 93 | 2 | 8 | 156 | 2783473 | 2783621 | MAG: Candidatus Kapabacteria bacterium isolate 9634bca7-0036-4470-acfa-8c32e30c46ef genome assembly, chromosome: 1 | blastn | 1616 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 6995454 | 6995454 | PRJNA641707_P_NODE_62146_length_269_cov_6.231818_g59485_i0 | PRJNA641707 | 62146 | 269 | 6.231818 | 16.76359042 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 122 | 1.8499999999999998e-23 | NTclustered | gi|1869359902|gb|CP058732.1| | 2447898 | g59485 | i0 | 87.273 | 137.617100371747 | 110 | 11 | 40 | 3 | 162 | 269 | 420677 | 420785 | MAG: Candidatus Kapaibacterium sp. isolate Ch6 chromosome, complete genome | blastn | 37019 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 9543135 | 9543135 | PRJNA641707_P_NODE_268208_length_175_cov_2.912698_g265545_i0 | PRJNA641707 | 268208 | 175 | 2.912698 | 5.0972215 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 259 | 8.09e-65 | NTclustered | gi|2621703255|emb|OY762428.1| | 2447898 | g265545 | i0 | 94.643 | 147.194285714286 | 168 | 7 | 95 | 2 | 2 | 168 | 2680174 | 2680008 | MAG: Candidatus Kapabacteria bacterium isolate a44c304e-2480-4604-92e3-6035b9b042d9 genome assembly, chromosome: 1 | blastn | 25759 | 259 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 9543935 | 9543935 | PRJNA641707_P_NODE_300188_length_164_cov_4.513043_g297525_i0 | PRJNA641707 | 300188 | 164 | 4.513043 | 7.40139052 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 219 | 1.2799999999999999e-52 | NTclustered | gi|2518551211|emb|OX638338.1| | 2447898 | g297525 | i0 | 91.358 | 208.158536585366 | 162 | 11 | 98 | 3 | 5 | 164 | 2780267 | 2780427 | MAG: Candidatus Kapabacteria bacterium isolate 9634bca7-0036-4470-acfa-8c32e30c46ef genome assembly, chromosome: 1 | blastn | 34138 | 219 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 10815266 | 10815266 | PRJNA641707_P_NODE_110609_length_246_cov_2.791878_g107946_i0 | PRJNA641707 | 110609 | 246 | 2.791878 | 6.86801988 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 158 | 4.58e-34 | NTclustered | gi|2621703255|emb|OY762428.1| | 2447898 | g107946 | i0 | 96.809 | 427.520325203252 | 94 | 3 | 38 | 0 | 7 | 100 | 2680823 | 2680916 | MAG: Candidatus Kapabacteria bacterium isolate a44c304e-2480-4604-92e3-6035b9b042d9 genome assembly, chromosome: 1 | blastn | 105170 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 10821134 | 10821134 | PRJNA641707_P_NODE_63689_length_265_cov_8.768519_g61028_i0 | PRJNA641707 | 63689 | 265 | 8.768519 | 23.23657535 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 307 | 4.68e-79 | NTclustered | gi|2556937695|gb|CP129493.1| | 2447898 | g61028 | i0 | 88.031 | 0.977358490566038 | 259 | 31 | 98 | 0 | 5 | 263 | 1178984 | 1178726 | MAG: Candidatus Kapaibacterium sp. isolate cMAG.3 chromosome, complete genome | blastn | 259 | 307 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 13370459 | 13370459 | PRJNA641707_P_NODE_40291_length_343_cov_7.880952_g37650_i0 | PRJNA641707 | 40291 | 343 | 7.880952 | 27.03166536 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 259 | 1.7800000000000002e-64 | NTclustered | gi|2518551211|emb|OX638338.1| | 2447898 | g37650 | i0 | 93.22 | 30.3760932944606 | 177 | 10 | 79 | 1 | 118 | 292 | 2780582 | 2780758 | MAG: Candidatus Kapabacteria bacterium isolate 9634bca7-0036-4470-acfa-8c32e30c46ef genome assembly, chromosome: 1 | blastn | 10419 | 259 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 14641798 | 14641798 | PRJNA641707_P_NODE_194532_length_198_cov_6.791946_g191869_i0 | PRJNA641707 | 194532 | 198 | 6.791946 | 13.44805308 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 130 | 7.71e-26 | NTclustered | gi|2518551211|emb|OX638338.1| | 2447898 | g191869 | i0 | 90.099 | 83.8434343434343 | 101 | 9 | 51 | 1 | 95 | 194 | 2781138 | 2781038 | MAG: Candidatus Kapabacteria bacterium isolate 9634bca7-0036-4470-acfa-8c32e30c46ef genome assembly, chromosome: 1 | blastn | 16601 | 130 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 17194441 | 17194441 | PRJNA641707_P_NODE_46894_length_316_cov_7.850187_g44242_i0 | PRJNA641707 | 46894 | 316 | 7.850187 | 24.80659092 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 169 | 2.8199999999999997e-37 | NTclustered | gi|2907625638|emb|OZ223198.1| | 2447898 | g44242 | i0 | 91.736 | 70.4715189873418 | 121 | 10 | 79 | 0 | 1 | 121 | 1117861 | 1117981 | MAG: Candidatus Kapaibacterium sp. isolate 09316a08-0405-4927-8c64-54324f316411 genome assembly, chromosome: 2 | blastn | 22269 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 17194460 | 17194460 | PRJNA641707_P_NODE_47954_length_312_cov_9.958175_g45300_i0 | PRJNA641707 | 47954 | 312 | 9.958175 | 31.069506 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 357 | 5.52e-94 | NTclustered | gi|2556937695|gb|CP129493.1| | 2447898 | g45300 | i0 | 87.662 | 426.714743589744 | 308 | 36 | 98 | 2 | 1 | 307 | 1179333 | 1179639 | MAG: Candidatus Kapaibacterium sp. isolate cMAG.3 chromosome, complete genome | blastn | 133135 | 357 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 24843831 | 24843831 | PRJNA641707_P_NODE_9000_length_711_cov_3186.672205_g1375_i1 | PRJNA641707 | 9000 | 711 | 3186.672205 | 22657.23937755 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 660 | 0 | NTclustered | gi|1869359902|gb|CP058732.1| | 2447898 | g1375 | i1 | 83.926 | 344.864978902954 | 703 | 100 | 98 | 12 | 9 | 706 | 421489 | 420795 | MAG: Candidatus Kapaibacterium sp. isolate Ch6 chromosome, complete genome | blastn | 245199 | 660 | 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);;