contig_metadata
18 rows where bioproject = "PRJNA725806" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8365141 | 8365141 | PRJNA725806_P_NODE_192247_length_151_cov_3.026316_g191945_i0 | PRJNA725806 | 192247 | 151 | 3.026316 | 4.56973716 | Candidatus Phycocordibacter aenigmaticus | 1948796 | Bacteria | Bacteria | 52.8 | 0.012 | NTclustered | gi|2862534145|gb|CP174359.1| | 1948796 | g191945 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 106 | 133 | 338988 | 339015 | MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Candidatus Phycocordibacterales | Candidatus Phycocordibacteraceae | Candidatus Phycocordibacter | Candidatus Phycocordibacter aenigmaticus | ||
| 8365236 | 8365236 | PRJNA725806_P_NODE_59327_length_236_cov_1.216080_g59030_i0 | PRJNA725806 | 59327 | 236 | 1.21608 | 2.8699488 | Candidatus Nealsonbacteria bacterium DGGOD1a | 3043262 | Bacteria | Bacteria | 52.8 | 0.021 | NTclustered | gi|2205901313|gb|CP092821.1| | 3043262 | g59030 | i0 | 100 | 0.11864406779661 | 28 | 0 | 12 | 0 | 88 | 115 | 492038 | 492065 | MAG: Candidatus Nealsonbacteria bacterium DGGOD1a chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nealsoniibacteriota | Candidatus Nealsonbacteria bacterium DGGOD1a | ||||||
| 11398116 | 11398116 | PRJNA725806_P_NODE_54449_length_242_cov_3.741463_g54152_i0 | PRJNA725806 | 54449 | 242 | 3.741463 | 9.05434046 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.006 | NTclustered | gi|2314743697|dbj|AP026679.1| | 2099670 | g54152 | i0 | 100 | 0.239669421487603 | 29 | 0 | 12 | 0 | 98 | 126 | 262706 | 262678 | MAG: Candidatus Dojkabacteria bacterium KatS3mg084 DNA, complete genome | blastn | 58 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 23664771 | 23664771 | PRJNA725806_P_NODE_13179_length_351_cov_6.216561_g12889_i0 | PRJNA725806 | 13179 | 351 | 6.216561 | 21.82012911 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 52.8 | 0.033 | NTclustered | gi|2108435138|gb|CP070627.1| | 2052149 | g12889 | i0 | 100 | 0.0797720797720798 | 28 | 0 | 8 | 0 | 94 | 121 | 2876108 | 2876135 | MAG: Candidatus Aminicenantes bacterium isolate bin99 chromosome | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 26894317 | 26894317 | PRJNA725806_P_NODE_75541_length_217_cov_12.600000_g75240_i0 | PRJNA725806 | 75541 | 217 | 12.6 | 27.342 | Candidatus Giovannonibacteria bacterium | 2053557 | Bacteria | Bacteria | 42.4 | 0.0374 | NR | MBI2020948.1 | 2053557 | g75240 | i0 | 35.6 | 0.622119815668203 | 45 | 29 | 62.2 | 0 | 37 | 171 | 71 | 115 | MBI2020948.1 tetratricopeptide repeat protein [Candidatus Giovannonibacteria bacterium] | diamond | 135 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Giovannoniibacteriota | Candidatus Giovannonibacteria bacterium | ||||||
| 27115256 | 27115256 | PRJNA725806_P_NODE_130422_length_178_cov_5.936170_g130120_i0 | PRJNA725806 | 130422 | 178 | 5.93617 | 10.5663826 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 41.6 | 0.0391 | NR | HHZ89897.1 | 2026781 | g130120 | i0 | 43.8 | 0.808988764044944 | 48 | 24 | 75.8 | 1 | 137 | 3 | 21 | 68 | HHZ89897.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 144 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 27146659 | 27146659 | PRJNA725806_P_NODE_86522_length_208_cov_1.350877_g86221_i0 | PRJNA725806 | 86522 | 208 | 1.350877 | 2.80982416 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 130 | 3.65e-33 | NR | OJU87461.1 | 1895829 | g86221 | i0 | 100 | 0.980769230769231 | 68 | 0 | 98.1 | 0 | 3 | 206 | 437 | 504 | OJU87461.1 MAG: ATP-dependent DNA helicase PcrA [Candidatus Saccharibacteria bacterium 49-20] | diamond | 204 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 27273524 | 27273524 | PRJNA725806_P_NODE_145923_length_170_cov_9.135338_g145621_i0 | PRJNA725806 | 145923 | 170 | 9.135338 | 15.5300746 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 42 | 0.0265 | NR | MBD3300581.1 | 2045217 | g145621 | i0 | 52.4 | 0.741176470588235 | 42 | 18 | 70.6 | 1 | 45 | 164 | 428 | 469 | MBD3300581.1 glycosyltransferase [Candidatus Moraniibacteriota bacterium] | diamond | 126 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 27947045 | 27947045 | PRJNA725806_P_NODE_93805_length_202_cov_1.854545_g93503_i0 | PRJNA725806 | 93805 | 202 | 1.854545 | 3.7461809 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 4.15e-5 | NR | HLK86067.1 | 2785449 | g93503 | i0 | 41.5 | 2.58415841584158 | 53 | 31 | 78.7 | 0 | 34 | 192 | 5 | 57 | HLK86067.1 DEAD/DEAH box helicase [Candidatus Binataceae bacterium] | diamond | 522 | 50.8 | 0.992125984251969 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 29168294 | 29168294 | PRJNA725806_P_NODE_75629_length_217_cov_9.055556_g75328_i0 | PRJNA725806 | 75629 | 217 | 9.055556 | 19.65055652 | Candidatus Shapirobacteria bacterium CG | 2053613 | Bacteria | Bacteria | 41.2 | 0.0426 | NR | PIS14228.1 | 1974481 | g75328 | i0 | 32.7 | 0.76036866359447 | 55 | 32 | 76 | 1 | 173 | 9 | 6 | 55 | PIS14228.1 MAG: hypothetical protein COT65_00010 [Candidatus Shapirobacteria bacterium CG09_land_8_20_14_0_10_47_13] | diamond | 165 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium CG09_land_8_20_14_0_10_47_13 | ||||||
| 29736133 | 29736133 | PRJNA725806_P_NODE_103530_length_195_cov_1.303797_g103228_i0 | PRJNA725806 | 103530 | 195 | 1.303797 | 2.54240415 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 46.6 | 8.57e-4 | NR | MBN9398373.1 | 2026720 | g103228 | i0 | 41.1 | 0.861538461538462 | 56 | 29 | 83.1 | 3 | 33 | 194 | 378 | 431 | MBN9398373.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 168 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30052101 | 30052101 | PRJNA725806_P_NODE_18551_length_324_cov_1.177700_g18257_i0 | PRJNA725806 | 18551 | 324 | 1.1777 | 3.815748 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 63.2 | 6.58e-9 | NR | HVX24508.1 | 2973664 | g18257 | i0 | 43.2 | 0.75 | 81 | 45 | 75 | 1 | 279 | 37 | 101 | 180 | HVX24508.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 243 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30400296 | 30400296 | PRJNA725806_P_NODE_66933_length_226_cov_9.523810_g66633_i0 | PRJNA725806 | 66933 | 226 | 9.52381 | 21.5238106 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 43.5 | 0.0155 | NR | HET6924576.1 | 2973664 | g66633 | i0 | 32.4 | 0.902654867256637 | 68 | 45 | 88.9 | 1 | 214 | 14 | 71 | 138 | HET6924576.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 204 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 31189322 | 31189322 | PRJNA725806_P_NODE_102635_length_195_cov_6.037975_g102333_i0 | PRJNA725806 | 102635 | 195 | 6.037975 | 11.77405125 | Candidatus Rifleibacteriota bacterium | 2053586 | Bacteria | Bacteria | 42.7 | 0.0198 | NR | MDD3146703.1 | 2053586 | g102333 | i0 | 35.6 | 0.692307692307692 | 45 | 29 | 69.2 | 0 | 189 | 55 | 34 | 78 | MDD3146703.1 hypothetical protein [Candidatus Rifleibacteriota bacterium] | diamond | 135 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rifleibacteriota | Candidatus Rifleibacteriota bacterium | ||||||
| 31189334 | 31189334 | PRJNA725806_P_NODE_142855_length_172_cov_2.570370_g142553_i0 | PRJNA725806 | 142855 | 172 | 2.57037 | 4.4210364 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 42.7 | 0.0146 | NR | MFQ6040197.1 | 2026781 | g142553 | i0 | 41.3 | 0.802325581395349 | 46 | 25 | 76.7 | 1 | 29 | 160 | 180 | 225 | MFQ6040197.1 aldehyde dehydrogenase family protein [Candidatus Poribacteria bacterium] | diamond | 138 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 31506149 | 31506149 | PRJNA725806_P_NODE_113036_length_188_cov_6.231788_g112734_i0 | PRJNA725806 | 113036 | 188 | 6.231788 | 11.71576144 | Candidatus Nomurabacteria bacterium RIFCSPLOWO2_ | 2052152 | Bacteria | Bacteria | 43.1 | 0.0133 | NR | OGI90090.1 | 1801772 | g112734 | i0 | 32.1 | 0.845744680851064 | 53 | 33 | 79.8 | 1 | 164 | 15 | 682 | 734 | OGI90090.1 MAG: hypothetical protein A2911_00275 [Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_40_15] | diamond | 159 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_40_15 | ||||||
| 31601027 | 31601027 | PRJNA725806_P_NODE_152136_length_168_cov_0.984733_g151834_i0 | PRJNA725806 | 152136 | 168 | 0.984733 | 1.65435144 | Candidatus Wolfebacteria bacterium GW2 | 2030812 | Bacteria | Bacteria | 40.4 | 0.0396 | NR | KKR12499.1 | 1619013 | g151834 | i0 | 32.1 | 0.946428571428571 | 53 | 35 | 92.9 | 1 | 161 | 6 | 36 | 88 | KKR12499.1 MAG: hypothetical protein UT41_C0001G0043 [Candidatus Wolfebacteria bacterium GW2011_GWC2_39_22] | diamond | 159 | 40.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWC2_39_22 | ||||||
| 32360481 | 32360481 | PRJNA725806_P_NODE_86539_length_208_cov_1.239766_g86238_i0 | PRJNA725806 | 86539 | 208 | 1.239766 | 2.57871328 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 40.8 | 0.0269 | NR | MEO0292599.1 | 2052148 | g86238 | i0 | 37.5 | 0.576923076923077 | 40 | 25 | 57.7 | 0 | 87 | 206 | 18 | 57 | MEO0292599.1 4Fe-4S dicluster domain-containing protein [candidate division WOR-3 bacterium] | diamond | 120 | 40.8 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 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);;