contig_metadata
13 rows where bioproject = "PRJNA340009", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27485560 | 27485560 | PRJNA340009_P_NODE_69203_length_164_cov_0.886957_g68896_i0 | PRJNA340009 | 69203 | 164 | 0.886957 | 1.45460948 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 101 | 1.06e-25 | NR | MCU0428230.1 | 2447898 | g68896 | i0 | 94.3 | 0.969512195121951 | 53 | 3 | 97 | 0 | 160 | 2 | 74 | 126 | MCU0428230.1 D-aminoacyl-tRNA deacylase [Candidatus Kapaibacterium sp.] | diamond | 159 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 28211505 | 28211505 | PRJNA340009_P_NODE_46106_length_189_cov_3.628571_g45799_i0 | PRJNA340009 | 46106 | 189 | 3.628571 | 6.85799919 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 82.4 | 1.78e-16 | NR | MCU0427524.1 | 2447898 | g45799 | i0 | 69.5 | 0.936507936507937 | 59 | 18 | 93.7 | 0 | 188 | 12 | 165 | 223 | MCU0427524.1 leucyl aminopeptidase [Candidatus Kapaibacterium sp.] | diamond | 177 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 28622310 | 28622310 | PRJNA340009_P_NODE_49267_length_184_cov_7.088889_g48960_i0 | PRJNA340009 | 49267 | 184 | 7.088889 | 13.04355576 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 94.7 | 4.83e-22 | NR | TAE20511.1 | 2447898 | g48960 | i0 | 73.3 | 1.94021739130435 | 60 | 13 | 92.9 | 1 | 184 | 14 | 161 | 220 | TAE20511.1 MAG: hypothetical protein EAZ92_17950 [Candidatus Kapaibacterium sp.] | diamond | 357 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 29190630 | 29190630 | PRJNA340009_P_NODE_65189_length_166_cov_0.871795_g64882_i0 | PRJNA340009 | 65189 | 166 | 0.871795 | 1.4471797 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 85.1 | 1.02e-17 | NR | MCU0425645.1 | 2447898 | g64882 | i0 | 84 | 0.903614457831325 | 50 | 8 | 90.4 | 0 | 16 | 165 | 23 | 72 | MCU0425645.1 leucine-rich repeat domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 150 | 85.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 29253418 | 29253418 | PRJNA340009_P_NODE_61769_length_167_cov_1.338983_g61462_i0 | PRJNA340009 | 61769 | 167 | 1.338983 | 2.23610161 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 75.5 | 3.79e-14 | NR | MFN8360340.1 | 2447898 | g61462 | i0 | 68.8 | 0.862275449101796 | 48 | 15 | 86.2 | 0 | 22 | 165 | 674 | 721 | MFN8360340.1 T9SS type A sorting domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 144 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 29411467 | 29411467 | PRJNA340009_P_NODE_71909_length_163_cov_0.894737_g71602_i0 | PRJNA340009 | 71909 | 163 | 0.894737 | 1.45842131 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 84.7 | 2.03e-17 | NR | MBL7993224.1 | 2447898 | g71602 | i0 | 70.4 | 0.993865030674847 | 54 | 16 | 99.4 | 0 | 1 | 162 | 498 | 551 | MBL7993224.1 ABC transporter permease [Candidatus Kapaibacterium sp.] | diamond | 162 | 84.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30137521 | 30137521 | PRJNA340009_P_NODE_40932_length_199_cov_2.620000_g40625_i0 | PRJNA340009 | 40932 | 199 | 2.62 | 5.2138 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 120 | 1.88e-30 | NR | MBL7993485.1 | 2447898 | g40625 | i0 | 98.4 | 0.964824120603015 | 64 | 1 | 96.5 | 0 | 1 | 192 | 223 | 286 | MBL7993485.1 histidine kinase [Candidatus Kapaibacterium sp.] | diamond | 192 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30232690 | 30232690 | PRJNA340009_P_NODE_64452_length_166_cov_0.871795_g64145_i0 | PRJNA340009 | 64452 | 166 | 0.871795 | 1.4471797 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 51.2 | 1.33e-5 | NR | MBE2190107.1 | 2447898 | g64145 | i0 | 56.3 | 1.73493975903614 | 48 | 21 | 86.7 | 0 | 147 | 4 | 65 | 112 | MBE2190107.1 DUF3560 domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 288 | 51.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30264583 | 30264583 | PRJNA340009_P_NODE_24972_length_246_cov_1.035533_g24665_i0 | PRJNA340009 | 24972 | 246 | 1.035533 | 2.54741118 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 106 | 5.31e-25 | NR | MBL7989973.1 | 2447898 | g24665 | i0 | 58.5 | 3.07317073170732 | 82 | 33 | 100 | 1 | 1 | 246 | 335 | 415 | MBL7989973.1 S-adenosylmethionine:tRNA ribosyltransferase-isomerase [Candidatus Kapaibacterium sp.] | diamond | 756 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30485483 | 30485483 | PRJNA340009_P_NODE_31333_length_223_cov_1.505747_g31026_i0 | PRJNA340009 | 31333 | 223 | 1.505747 | 3.35781581 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 129 | 2.17e-34 | NR | MCU0424145.1 | 2447898 | g31026 | i0 | 83.6 | 0.982062780269058 | 73 | 12 | 98.2 | 0 | 221 | 3 | 232 | 304 | MCU0424145.1 sigma-70 family RNA polymerase sigma factor [Candidatus Kapaibacterium sp.] | diamond | 219 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30959456 | 30959456 | PRJNA340009_P_NODE_57034_length_173_cov_1.645161_g56727_i0 | PRJNA340009 | 57034 | 173 | 1.645161 | 2.84612853 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 58.9 | 5.99e-10 | NR | MBL8000120.1 | 2447898 | g56727 | i0 | 64.1 | 2.02890173410405 | 39 | 14 | 67.6 | 0 | 119 | 3 | 7 | 45 | MBL8000120.1 glycosyltransferase [Candidatus Kapaibacterium sp.] | diamond | 351 | 58.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 31022629 | 31022629 | PRJNA340009_P_NODE_27515_length_235_cov_4.715054_g27208_i0 | PRJNA340009 | 27515 | 235 | 4.715054 | 11.0803769 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 111 | 2.01e-26 | NR | MCU0425345.1 | 2447898 | g27208 | i0 | 66.7 | 2.87234042553191 | 75 | 25 | 95.7 | 0 | 227 | 3 | 332 | 406 | MCU0425345.1 tetratricopeptide repeat protein [Candidatus Kapaibacterium sp.] | diamond | 675 | 111 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 31148522 | 31148522 | PRJNA340009_P_NODE_47675_length_187_cov_1.478261_g47368_i0 | PRJNA340009 | 47675 | 187 | 1.478261 | 2.76434807 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 132 | 9.26e-37 | NR | MFN8359439.1 | 2447898 | g47368 | i0 | 100 | 0.994652406417112 | 62 | 0 | 99.5 | 0 | 187 | 2 | 94 | 155 | MFN8359439.1 DUF2071 domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 186 | 132 | 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);;