contig_metadata
15 rows where bioproject = "PRJEB64798" 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 9055558 | 9055558 | PRJEB64798_P_NODE_230268_length_158_cov_11.238532_g228502_i0 | PRJEB64798 | 230268 | 158 | 11.238532 | 17.75688056 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 64.7 | 9.05e-12 | NR | MBI5620140.1 | 2282145 | g228502 | i0 | 58.8 | 1.93670886075949 | 51 | 21 | 96.8 | 0 | 3 | 155 | 52 | 102 | MBI5620140.1 MGMT family protein [Candidatus Gottesmanbacteria bacterium] | diamond | 306 | 64.7 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 27634106 | 27634106 | PRJEB64798_P_NODE_149404_length_189_cov_1.092857_g147638_i0 | PRJEB64798 | 149404 | 189 | 1.092857 | 2.06549973 | Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_ | 2282145 | Bacteria | Bacteria | 56.2 | 3.6e-8 | NR | OGG18593.1 | 1798385 | g147638 | i0 | 73 | 0.587301587301587 | 37 | 10 | 58.7 | 0 | 66 | 176 | 6 | 42 | OGG18593.1 MAG: hypothetical protein A3D05_01805 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_02_FULL_40_24] | diamond | 111 | 56.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_02_FULL_40_24 | ||||||
| 28960360 | 28960360 | PRJEB64798_P_NODE_158988_length_184_cov_1.918519_g157222_i0 | PRJEB64798 | 158988 | 184 | 1.918519 | 3.53007496 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 80.9 | 4.05e-16 | NR | MBI3577184.1 | 2282145 | g157222 | i0 | 81.4 | 0.96195652173913 | 59 | 10 | 96.2 | 1 | 178 | 2 | 120 | 177 | MBI3577184.1 hypothetical protein [Candidatus Gottesmanbacteria bacterium] | diamond | 177 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 32436954 | 32436954 | PRJEB64798_P_NODE_70379_length_230_cov_11.762431_g68614_i0 | PRJEB64798 | 70379 | 230 | 11.762431 | 27.0535913 | Candidatus Gottesmanbacteria bacterium GW2 | 2282145 | Bacteria | Bacteria | 52.4 | 4.26e-6 | NR | KKU87615.1 | 1618445 | g68614 | i0 | 54.2 | 0.626086956521739 | 48 | 22 | 62.6 | 0 | 70 | 213 | 48 | 95 | KKU87615.1 MAG: hypothetical protein UY16_C0022G0015 [Candidatus Gottesmanbacteria bacterium GW2011_GWA2_47_9] | diamond | 144 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium GW2011_GWA2_47_9 |
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);;