contig_metadata
22 rows where analysis = "blastn" and tax_phylum = "Candidatus Gottesmaniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1401225 | 1401225 | PRJEB64798_P_NODE_124142_length_203_cov_2.844156_g122376_i0 | PRJEB64798 | 124142 | 203 | 2.844156 | 5.77363668 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 159 | 1.01e-34 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g122376 | i0 | 82.778 | 6.66009852216749 | 180 | 30 | 88 | 1 | 2 | 180 | 736891 | 737070 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 1352 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 2168901 | 2168901 | PRJNA911178_P_NODE_84422_length_388_cov_1.546032_g81955_i0 | PRJNA911178 | 84422 | 388 | 1.546032 | 5.99860416 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 132 | 4.63e-26 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g81955 | i0 | 78.027 | 2.5979381443299 | 223 | 40 | 56 | 8 | 53 | 268 | 737497 | 737277 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 1008 | 132 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 2678285 | 2678285 | PRJEB64798_P_NODE_220103_length_162_cov_2.504425_g218337_i0 | PRJEB64798 | 220103 | 162 | 2.504425 | 4.0571685 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 161 | 2.15e-35 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g218337 | i0 | 95.96 | 105.395061728395 | 99 | 4 | 61 | 0 | 8 | 106 | 754006 | 754104 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 17074 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 6959556 | 6959556 | PRJNA605033_P_NODE_106206_length_222_cov_1.850267_g104637_i0 | PRJNA605033 | 106206 | 222 | 1.850267 | 4.10759274 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 63.9 | 9.1e-6 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g104637 | i0 | 95 | 0.337837837837838 | 40 | 2 | 18 | 0 | 183 | 222 | 537307 | 537346 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 75 | 63.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 7780907 | 7780907 | PRJEB64798_P_NODE_245027_length_153_cov_7.403846_g243261_i0 | PRJEB64798 | 245027 | 153 | 7.403846 | 11.32788438 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 113 | 5.670000000000001e-21 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g243261 | i0 | 80.952 | 0.96078431372549 | 147 | 24 | 95 | 4 | 8 | 152 | 737827 | 737683 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 147 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 9305587 | 9305587 | PRJNA312107_P_NODE_14068_length_195_cov_1.027397_g13902_i0 | PRJNA312107 | 14068 | 195 | 1.027397 | 2.00342415 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 178 | 2.66e-40 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g13902 | i0 | 90.37 | 11.4461538461538 | 135 | 13 | 69 | 0 | 61 | 195 | 754807 | 754673 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 2232 | 178 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 10330698 | 10330698 | PRJEB64798_P_NODE_185669_length_172_cov_2.788618_g183903_i0 | PRJEB64798 | 185669 | 172 | 2.788618 | 4.79642296 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 159 | 8.26e-35 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g183903 | i0 | 89.062 | 6.23837209302326 | 128 | 14 | 74 | 0 | 6 | 133 | 753986 | 754113 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 1073 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 11605709 | 11605709 | PRJEB64798_P_NODE_158050_length_184_cov_5.822222_g156284_i0 | PRJEB64798 | 158050 | 184 | 5.822222 | 10.71288848 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 228 | 2.4299999999999996e-55 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g156284 | i0 | 90 | 6.60869565217391 | 180 | 12 | 97 | 4 | 6 | 183 | 737421 | 737246 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 1216 | 228 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 11607576 | 11607576 | PRJEB64798_P_NODE_49310_length_279_cov_6.413043_g47545_i0 | PRJEB64798 | 49310 | 279 | 6.413043 | 17.89238997 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 363 | 1.0499999999999999e-95 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g47545 | i0 | 90.614 | 106.358422939068 | 277 | 21 | 98 | 5 | 1 | 274 | 737552 | 737826 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 29674 | 363 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 12081401 | 12081401 | PRJNA630162_P_NODE_172350_length_152_cov_2.504854_g170827_i0 | PRJNA630162 | 172350 | 152 | 2.504854 | 3.80737808 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 63.9 | 5.74e-6 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g170827 | i0 | 95 | 0.263157894736842 | 40 | 2 | 26 | 0 | 67 | 106 | 753539 | 753500 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 40 | 63.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 12880812 | 12880812 | PRJEB64798_P_NODE_154971_length_186_cov_1.897810_g153205_i0 | PRJEB64798 | 154971 | 186 | 1.89781 | 3.5299266 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 78.7 | 2.6200000000000003e-10 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g153205 | i0 | 90.164 | 0.327956989247312 | 61 | 4 | 32 | 2 | 1 | 60 | 753402 | 753343 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 61 | 78.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 13356018 | 13356018 | PRJNA630162_P_NODE_154291_length_163_cov_2.078947_g152768_i0 | PRJNA630162 | 154291 | 163 | 2.078947 | 3.38868361 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 132 | 1.7e-26 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g152768 | i0 | 87.069 | 23.8220858895706 | 116 | 15 | 71 | 0 | 5 | 120 | 736243 | 736128 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 3883 | 132 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 13356186 | 13356186 | PRJNA630162_P_NODE_172111_length_152_cov_2.893204_g170588_i0 | PRJNA630162 | 172111 | 152 | 2.893204 | 4.39767008 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 95.3 | 2.04e-15 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g170588 | i0 | 79.699 | 5.48026315789474 | 133 | 25 | 87 | 2 | 19 | 150 | 755097 | 754966 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 833 | 95.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 14594032 | 14594032 | PRJNA591127_P_NODE_9812_length_235_cov_2.222222_g9644_i0 | PRJNA591127 | 9812 | 235 | 2.222222 | 5.2222217 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 106 | 1.59e-18 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g9644 | i0 | 89.412 | 36.6468085106383 | 85 | 7 | 36 | 2 | 151 | 235 | 753343 | 753425 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 8612 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 15905690 | 15905690 | PRJNA630162_P_NODE_97533_length_187_cov_1.500000_g96010_i0 | PRJNA630162 | 97533 | 187 | 1.5 | 2.805 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 261 | 2.44e-65 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g96010 | i0 | 96.226 | 5.27807486631016 | 159 | 6 | 85 | 0 | 5 | 163 | 754219 | 754377 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 987 | 261 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 17180692 | 17180692 | PRJNA630162_P_NODE_80974_length_200_cov_2.238411_g79451_i0 | PRJNA630162 | 80974 | 200 | 2.238411 | 4.476822 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 171 | 4.599999999999999e-38 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g79451 | i0 | 88.889 | 525.645 | 144 | 8 | 69 | 6 | 55 | 192 | 753542 | 753401 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 105129 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 21805840 | 21805840 | PRJEB64798_P_NODE_49938_length_277_cov_7.565789_g48173_i0 | PRJEB64798 | 49938 | 277 | 7.565789 | 20.95723553 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 132 | 3.18e-26 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g48173 | i0 | 75.972 | 2.48736462093863 | 283 | 53 | 99 | 11 | 1 | 273 | 737896 | 738173 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 689 | 132 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 21806135 | 21806135 | PRJEB64798_P_NODE_65578_length_240_cov_1.801047_g63813_i0 | PRJEB64798 | 65578 | 240 | 1.801047 | 4.3225128 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 152 | 2.0699999999999998e-32 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g63813 | i0 | 78.926 | 7.21666666666667 | 242 | 37 | 98 | 14 | 2 | 235 | 753659 | 753424 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 1732 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 22012263 | 22012263 | PRJNA1227535_P_NODE_8918_length_299_cov_1.969027_g8795_i0 | PRJNA1227535 | 8918 | 299 | 1.969027 | 5.88739073 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 241 | 5.53e-59 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g8795 | i0 | 81.667 | 126.491638795987 | 300 | 45 | 99 | 9 | 5 | 299 | 737919 | 737625 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 37821 | 241 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 23080315 | 23080315 | PRJEB64798_P_NODE_232939_length_157_cov_12.601852_g231173_i0 | PRJEB64798 | 232939 | 157 | 12.601852 | 19.78490764 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 252 | 1.19e-62 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g231173 | i0 | 96.689 | 75.5605095541401 | 151 | 5 | 96 | 0 | 6 | 156 | 736128 | 736278 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 11863 | 252 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 24354206 | 24354206 | PRJEB64798_P_NODE_237660_length_156_cov_2.897196_g235894_i0 | PRJEB64798 | 237660 | 156 | 2.897196 | 4.51962576 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 111 | 2.09e-20 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g235894 | i0 | 80.667 | 89.224358974359 | 150 | 23 | 94 | 6 | 9 | 154 | 738185 | 738038 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 13919 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 24828017 | 24828017 | PRJNA630162_P_NODE_150840_length_164_cov_1.521739_g149317_i0 | PRJNA630162 | 150840 | 164 | 1.521739 | 2.49565196 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 165 | 1.69e-36 | NTclustered | gi|2874253905|emb|OY970230.1| | 2282145 | g149317 | i0 | 92.241 | 1.42682926829268 | 116 | 9 | 71 | 0 | 36 | 151 | 754692 | 754577 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD01689.bin.c.3 genome assembly, chromosome: 1 | blastn | 234 | 165 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria 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);;