contig_metadata
25 rows where analysis = "blastn" and tax_phylum = "Candidatus Zixiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 349068 | 349068 | PRJNA1240804_P_NODE_89321_length_180_cov_1.488550_g88955_i0 | PRJNA1240804 | 89321 | 180 | 1.48855 | 2.67939 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 132 | 1.91e-26 | NTclustered | gi|2621704311|emb|OY760907.1| | 1664345 | g88955 | i0 | 81.176 | 37.9 | 170 | 26 | 93 | 6 | 13 | 180 | 3469508 | 3469343 | MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1 | blastn | 6822 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 1716727 | 1716727 | PRJNA453567_P_NODE_28682_length_164_cov_0.889764_g28445_i0 | PRJNA453567 | 28682 | 164 | 0.889764 | 1.45921296 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 52.8 | 0.014 | NTclustered | gi|2621704311|emb|OY760907.1| | 1664345 | g28445 | i0 | 96.774 | 0.189024390243902 | 31 | 1 | 19 | 0 | 115 | 145 | 2676565 | 2676535 | MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1 | blastn | 31 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 2662693 | 2662693 | PRJEB49404_P_NODE_541023_length_172_cov_1.097744_g527222_i0 | PRJEB49404 | 541023 | 172 | 1.097744 | 1.88811968 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 84.2 | 5.12e-12 | NTclustered | gi|2874254123|emb|OY970208.1| | 1664345 | g527222 | i0 | 94.444 | 5.99418604651163 | 54 | 3 | 31 | 0 | 21 | 74 | 1313585 | 1313532 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD04408.bin.1.44 genome assembly, chromosome: 1 | blastn | 1031 | 84.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 2993780 | 2993780 | PRJNA470927_P_NODE_2223_length_301_cov_2.572519_g2162_i0 | PRJNA470927 | 2223 | 301 | 2.5725189999999998 | 7.74328219 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 344 | 4.1299999999999985e-90 | NTclustered | gi|2874254123|emb|OY970208.1| | 1664345 | g2162 | i0 | 87.5 | 271.794019933555 | 304 | 31 | 99 | 7 | 1 | 300 | 1314246 | 1313946 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD04408.bin.1.44 genome assembly, chromosome: 1 | blastn | 81810 | 344 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 4310072 | 4310072 | PRJNA505329_P_NODE_11264_length_233_cov_3.554348_g10793_i0 | PRJNA505329 | 11264 | 233 | 3.554348 | 8.28163084 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 86.1 | 2.06e-12 | NTclustered | gi|2621704311|emb|OY760907.1| | 1664345 | g10793 | i0 | 85.366 | 0.351931330472103 | 82 | 12 | 35 | 0 | 6 | 87 | 1865109 | 1865028 | MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1 | blastn | 82 | 86.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 5636146 | 5636146 | PRJNA556992_P_NODE_725085_length_250_cov_0.870056_g722896_i0 | PRJNA556992 | 725085 | 250 | 0.870056 | 2.17514 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 69.4 | 2.25e-7 | NTclustered | gi|2108097368|gb|CP070742.1| | 2053527 | g722896 | i0 | 100 | 6.068 | 37 | 0 | 15 | 0 | 195 | 231 | 3460027 | 3459991 | MAG: Candidatus Zixiibacteriota bacterium isolate bin38 chromosome | blastn | 1517 | 69.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 5963690 | 5963690 | PRJNA884104_S_NODE_24145_length_412_cov_1.589971_g23402_i0 | PRJNA884104 | 24145 | 412 | 1.589971 | 6.55068052 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|2107809231|gb|CP070824.1| | 2053527 | g23402 | i0 | 94.444 | 0.087378640776699 | 36 | 2 | 9 | 0 | 118 | 153 | 66648 | 66613 | MAG: Candidatus Zixiibacteriota bacterium isolate bin1124 chromosome | blastn | 36 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 6873689 | 6873689 | PRJNA526367_P_NODE_36786_length_188_cov_8.064748_g36576_i0 | PRJNA526367 | 36786 | 188 | 8.064748 | 15.16172624 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 86.1 | 1.59e-12 | NTclustered | gi|2621704311|emb|OY760907.1| | 1664345 | g36576 | i0 | 78.906 | 27.9574468085106 | 128 | 26 | 68 | 1 | 58 | 184 | 3469819 | 3469692 | MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1 | blastn | 5256 | 86.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 7807346 | 7807346 | PRJNA1009807_S_NODE_2067_length_216_cov_4.502825_g2039_i0 | PRJNA1009807 | 2067 | 216 | 4.502825 | 9.726102 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 254 | 4.87e-63 | NTclustered | gi|2874254123|emb|OY970208.1| | 1664345 | g2039 | i0 | 88.018 | 195.527777777778 | 217 | 23 | 100 | 3 | 1 | 216 | 1314237 | 1314023 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD04408.bin.1.44 genome assembly, chromosome: 1 | blastn | 42234 | 254 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 10163161 | 10163161 | PRJNA853203_P_NODE_2508_length_405_cov_2.162651_g2361_i0 | PRJNA853203 | 2508 | 405 | 2.162651 | 8.75873655 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 448 | 4.24e-121 | NTclustered | gi|2874254123|emb|OY970208.1| | 1664345 | g2361 | i0 | 86.585 | 427.528395061728 | 410 | 49 | 100 | 5 | 1 | 405 | 1315306 | 1315714 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD04408.bin.1.44 genome assembly, chromosome: 1 | blastn | 173149 | 449 | 0.997772828507795 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 12381264 | 12381264 | PRJNA928559_P_NODE_115590_length_331_cov_3.833333_g114021_i0 | PRJNA928559 | 115590 | 331 | 3.833333 | 12.68833223 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 115 | 3.9200000000000006e-21 | NTclustered | gi|2107993783|gb|CP070777.1| | 2053527 | g114021 | i0 | 92.5 | 3.31117824773414 | 80 | 6 | 24 | 0 | 215 | 294 | 1209133 | 1209054 | MAG: Candidatus Zixiibacteriota bacterium isolate bin19 chromosome | blastn | 1096 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 12809448 | 12809448 | PRJEB3181_P_NODE_14591_length_220_cov_54.121693_g14327_i0 | PRJEB3181 | 14591 | 220 | 54.121693 | 119.0677246 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 150 | 6.72e-32 | NTclustered | gi|2874254123|emb|OY970208.1| | 1664345 | g14327 | i0 | 81.579 | 122.4 | 190 | 28 | 84 | 5 | 1 | 184 | 1313107 | 1313295 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD04408.bin.1.44 genome assembly, chromosome: 1 | blastn | 26928 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 16337245 | 16337245 | PRJNA1148190_P_NODE_331193_length_307_cov_1.970085_g320020_i0 | PRJNA1148190 | 331193 | 307 | 1.970085 | 6.04816095 | Bacteria | 2 | Bacteria | Bacteria | 58.4 | 6.16e-4 | NTclustered | gi|2108055441|gb|CP070756.1| | 2053527 | g320020 | i0 | 86.538 | 0.765472312703583 | 52 | 7 | 17 | 0 | 32 | 83 | 713463 | 713514 | MAG: Candidatus Zixiibacteriota bacterium isolate bin295 chromosome | blastn | 235 | 58.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 16703644 | 16703644 | PRJEB64798_P_NODE_14034_length_533_cov_12.884298_g12375_i0 | PRJEB64798 | 14034 | 533 | 12.884298 | 68.67330834 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 237 | 1.3499999999999998e-57 | NTclustered | gi|2874254123|emb|OY970208.1| | 1664345 | g12375 | i0 | 80.921 | 600.437148217636 | 304 | 54 | 56 | 4 | 12 | 311 | 1313068 | 1313371 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD04408.bin.1.44 genome assembly, chromosome: 1 | blastn | 320033 | 237 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 16704431 | 16704431 | PRJEB64798_P_NODE_191794_length_169_cov_16.975000_g190028_i0 | PRJEB64798 | 191794 | 169 | 16.975 | 28.68775 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 100 | 4.97e-17 | NTclustered | gi|2621704311|emb|OY760907.1| | 1664345 | g190028 | i0 | 84.762 | 14.6449704142012 | 105 | 11 | 61 | 5 | 3 | 105 | 3469319 | 3469420 | MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1 | blastn | 2475 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 17080314 | 17080314 | PRJNA529645_P_NODE_9274_length_200_cov_5.735099_g9174_i0 | PRJNA529645 | 9274 | 200 | 5.735099 | 11.470198 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 86.1 | 1.71e-12 | NTclustered | gi|2621704311|emb|OY760907.1| | 1664345 | g9174 | i0 | 85.366 | 0.41 | 82 | 12 | 41 | 0 | 6 | 87 | 1865109 | 1865028 | MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1 | blastn | 82 | 86.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 17279322 | 17279322 | PRJNA704949_P_NODE_845754_length_288_cov_1.899582_g830420_i0 | PRJNA704949 | 845754 | 288 | 1.899582 | 5.47079616 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 202 | 2.5e-47 | NTclustered | gi|2621704311|emb|OY760907.1| | 1664345 | g830420 | i0 | 79.928 | 54.8194444444444 | 279 | 52 | 96 | 4 | 1 | 277 | 1828176 | 1827900 | MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1 | blastn | 15788 | 202 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 17424519 | 17424519 | PRJNA861969_P_NODE_28894_length_258_cov_1.286486_g28663_i0 | PRJNA861969 | 28894 | 258 | 1.286486 | 3.31913388 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 58.4 | 5.05e-4 | NTclustered | gi|2107809231|gb|CP070824.1| | 2053527 | g28663 | i0 | 94.595 | 0.143410852713178 | 37 | 2 | 14 | 0 | 177 | 213 | 1884073 | 1884037 | MAG: Candidatus Zixiibacteriota bacterium isolate bin1124 chromosome | blastn | 37 | 58.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 17504351 | 17504351 | PRJNA946307_P_NODE_134754_length_169_cov_1.333333_g133880_i0 | PRJNA946307 | 134754 | 169 | 1.333333 | 2.25333277 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 167 | 4.83e-37 | NTclustered | gi|2874253775|emb|OY969724.1| | 1664345 | g133880 | i0 | 93.75 | 1.11242603550296 | 112 | 6 | 66 | 1 | 1 | 111 | 228746 | 228635 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD02416.bin.2.48 genome assembly, chromosome: 1 | blastn | 188 | 167 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 18120602 | 18120602 | PRJNA1120060_P_NODE_621275_length_345_cov_2.694853_g603523_i0 | PRJNA1120060 | 621275 | 345 | 2.694853 | 9.29724285 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 52.8 | 0.033 | NTclustered | gi|2108097368|gb|CP070742.1| | 2053527 | g603523 | i0 | 100 | 0.0811594202898551 | 28 | 0 | 8 | 0 | 132 | 159 | 1943989 | 1944016 | MAG: Candidatus Zixiibacteriota bacterium isolate bin38 chromosome | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 18796408 | 18796408 | PRJNA971676_P_NODE_18575_length_246_cov_0.890173_g18486_i0 | PRJNA971676 | 18575 | 246 | 0.890173 | 2.18982558 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 165 | 2.74e-36 | NTclustered | gi|2874254123|emb|OY970208.1| | 1664345 | g18486 | i0 | 80.645 | 0.882113821138211 | 217 | 39 | 88 | 3 | 6 | 221 | 277702 | 277916 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD04408.bin.1.44 genome assembly, chromosome: 1 | blastn | 217 | 165 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 23171563 | 23171563 | PRJNA1112809_P_NODE_137999_length_276_cov_1.064039_g134724_i0 | PRJNA1112809 | 137999 | 276 | 1.064039 | 2.93674764 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 206 | 1.84e-48 | NTclustered | gi|2874253775|emb|OY969724.1| | 1664345 | g134724 | i0 | 84.541 | 26.6594202898551 | 207 | 32 | 75 | 0 | 43 | 249 | 2916140 | 2915934 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD02416.bin.2.48 genome assembly, chromosome: 1 | blastn | 7358 | 206 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 23316529 | 23316529 | PRJNA168635_P_NODE_18879_length_186_cov_2.102190_g18463_i0 | PRJNA168635 | 18879 | 186 | 2.10219 | 3.9100734 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 204 | 4.15e-48 | NTclustered | gi|2621704311|emb|OY760907.1| | 1664345 | g18463 | i0 | 89.873 | 313.833333333333 | 158 | 16 | 85 | 0 | 29 | 186 | 3468975 | 3469132 | MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1 | blastn | 58373 | 204 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 23491602 | 23491602 | PRJNA558770_P_NODE_200799_length_234_cov_3.748744_g198794_i0 | PRJNA558770 | 200799 | 234 | 3.748744 | 8.77206096 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2874253775|emb|OY969724.1| | 1664345 | g198794 | i0 | 96.97 | 0.141025641025641 | 33 | 0 | 14 | 1 | 5 | 36 | 2878246 | 2878278 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD02416.bin.2.48 genome assembly, chromosome: 1 | blastn | 33 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 24827815 | 24827815 | PRJNA630162_P_NODE_128560_length_170_cov_1.644628_g127037_i0 | PRJNA630162 | 128560 | 170 | 1.644628 | 2.7958676 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 134 | 4.94e-27 | NTclustered | gi|2874253775|emb|OY969724.1| | 1664345 | g127037 | i0 | 85.714 | 2.96470588235294 | 126 | 18 | 74 | 0 | 39 | 164 | 2878480 | 2878605 | MAG: uncultured candidate division Zixibacteria bacterium isolate MFD02416.bin.2.48 genome assembly, chromosome: 1 | blastn | 504 | 134 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium |
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);;