contig_metadata
17 rows where bioproject = "PRJNA667863" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10838196 | 10838196 | PRJNA667863_P_NODE_5249_length_298_cov_2.608889_g5215_i0 | PRJNA667863 | 5249 | 298 | 2.608889 | 7.77448922 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 315 | 3.2000000000000003e-81 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g5215 | i0 | 91.342 | 677.385906040268 | 231 | 19 | 77 | 1 | 69 | 298 | 220797 | 221027 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 201861 | 315 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 12113385 | 12113385 | PRJNA667863_P_NODE_9650_length_260_cov_1.106952_g9616_i0 | PRJNA667863 | 9650 | 260 | 1.106952 | 2.8780752 | Candidatus Harrisonbacteria bacterium | 2528272 | Bacteria | Bacteria | 62.4 | 5.15e-9 | NR | MBI4991891.1 | 2528272 | g9616 | i0 | 41 | 1.86923076923077 | 78 | 45 | 90 | 1 | 260 | 27 | 164 | 240 | MBI4991891.1 AAA family ATPase [Candidatus Harrisonbacteria bacterium] | diamond | 486 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium | ||||||
| 19760978 | 19760978 | PRJNA667863_P_NODE_6356_length_284_cov_3.440758_g6322_i0 | PRJNA667863 | 6356 | 284 | 3.440758 | 9.77175272 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 139 | 1.5899999999999999e-40 | NR | MDR3570670.1 | 2053589 | g6322 | i0 | 91.8 | 0.77112676056338 | 73 | 6 | 77.1 | 0 | 226 | 8 | 6 | 78 | MDR3570670.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 219 | 139 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26638330 | 26638330 | PRJNA667863_P_NODE_4601_length_310_cov_2.556962_g4567_i0 | PRJNA667863 | 4601 | 310 | 2.556962 | 7.9265822 | Candidatus Saccharibacteria bacterium 32-49-12 | 1970479 | Bacteria | Bacteria | 79 | 7.89e-15 | NR | OYX42407.1 | 1970479 | g4567 | i0 | 48.9 | 0.890322580645161 | 92 | 40 | 86.1 | 3 | 270 | 4 | 35 | 122 | OYX42407.1 MAG: hypothetical protein B7Y94_03435 [Candidatus Saccharibacteria bacterium 32-49-12] | diamond | 276 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-49-12 | ||||||
| 27366349 | 27366349 | PRJNA667863_P_NODE_19643_length_197_cov_4.258065_g19609_i0 | PRJNA667863 | 19643 | 197 | 4.258065 | 8.38838805 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 46.2 | 0.0012 | NR | UPA22765.1 | 2053688 | g19609 | i0 | 46.3 | 0.624365482233503 | 41 | 22 | 62.4 | 0 | 15 | 137 | 308 | 348 | UPA22765.1 MAG: DUF4215 domain-containing protein [Candidatus Peribacteria bacterium] | diamond | 123 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 27776724 | 27776724 | PRJNA667863_P_NODE_5904_length_289_cov_1.236111_g5870_i0 | PRJNA667863 | 5904 | 289 | 1.236111 | 3.57236079 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 42.4 | 0.0425 | NR | MEO7904955.1 | 2973664 | g5870 | i0 | 32.4 | 0.737024221453287 | 71 | 48 | 73.7 | 0 | 220 | 8 | 39 | 109 | MEO7904955.1 transcriptional regulator NrdR [Candidatus Saccharimonadales bacterium] | diamond | 213 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28092267 | 28092267 | PRJNA667863_P_NODE_8245_length_269_cov_1.372449_g8211_i0 | PRJNA667863 | 8245 | 269 | 1.372449 | 3.69188781 | Candidatus Moranbacteria bacterium RIFOXYC1_FULL_44_13 | 1801652 | Bacteria | Bacteria | 81.6 | 1.07e-15 | NR | OGI34104.1 | 1801652 | g8211 | i0 | 55.7 | 0.981412639405205 | 88 | 37 | 98.1 | 2 | 6 | 269 | 204 | 289 | OGI34104.1 MAG: hypothetical protein A2420_00945 [Candidatus Moranbacteria bacterium RIFOXYC1_FULL_44_13] | diamond | 264 | 81.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moranbacteria bacterium RIFOXYC1_FULL_44_13 | ||||||
| 28344862 | 28344862 | PRJNA667863_P_NODE_13566_length_247_cov_0.885057_g13532_i0 | PRJNA667863 | 13566 | 247 | 0.885057 | 2.18609079 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 48.1 | 5.06e-4 | NR | TXH00892.1 | 2045217 | g13532 | i0 | 37.7 | 0.740890688259109 | 61 | 37 | 72.9 | 1 | 14 | 193 | 409 | 469 | TXH00892.1 MAG: hypothetical protein E6R05_06395, partial [Candidatus Moraniibacteriota bacterium] | diamond | 183 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 28692409 | 28692409 | PRJNA667863_P_NODE_13747_length_246_cov_4.445087_g13713_i0 | PRJNA667863 | 13747 | 246 | 4.445087 | 10.93491402 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 120 | 2.26e-33 | NR | MDR3570671.1 | 2053589 | g13713 | i0 | 75.6 | 1 | 82 | 19 | 98.8 | 1 | 245 | 3 | 13 | 94 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 246 | 120 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28881561 | 28881561 | PRJNA667863_P_NODE_7088_length_277_cov_2.931373_g7054_i0 | PRJNA667863 | 7088 | 277 | 2.931373 | 8.11990321 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 69.7 | 1.83e-11 | NR | MDD4318729.1 | 2735830 | g7054 | i0 | 57.4 | 0.584837545126354 | 54 | 23 | 58.5 | 0 | 277 | 116 | 472 | 525 | MDD4318729.1 DUF4215 domain-containing protein [Candidatus Peribacteraceae bacterium] | diamond | 162 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 29418249 | 29418249 | PRJNA667863_P_NODE_10309_length_256_cov_1.437158_g10275_i0 | PRJNA667863 | 10309 | 256 | 1.437158 | 3.67912448 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 42.7 | 0.0193 | NR | HEY2004433.1 | 2890869 | g10275 | i0 | 44.4 | 0.52734375 | 45 | 25 | 52.7 | 0 | 174 | 40 | 17 | 61 | HEY2004433.1 VOC family protein [Candidatus Saccharimonadia bacterium] | diamond | 135 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 29449742 | 29449742 | PRJNA667863_P_NODE_4350_length_315_cov_1.933884_g4316_i0 | PRJNA667863 | 4350 | 315 | 1.933884 | 6.0917346 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 100 | 2.74e-25 | NR | MCD6142244.1 | 2306012 | g4316 | i0 | 69.8 | 2 | 63 | 19 | 60 | 0 | 102 | 290 | 4 | 66 | MCD6142244.1 cold-shock protein [Candidatus Bipolaricaulota bacterium] | diamond | 630 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 29702180 | 29702180 | PRJNA667863_P_NODE_7930_length_271_cov_1.404040_g7896_i0 | PRJNA667863 | 7930 | 271 | 1.40404 | 3.8049484 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 79.3 | 7.28e-15 | NR | MBI4280962.1 | 2053634 | g7896 | i0 | 45.7 | 4.85977859778598 | 94 | 44 | 98.5 | 3 | 4 | 270 | 681 | 772 | MBI4280962.1 DNA polymerase III subunit alpha [Candidatus Uhrbacteria bacterium] | diamond | 1317 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 31029700 | 31029700 | PRJNA667863_P_NODE_5275_length_298_cov_1.368889_g5241_i0 | PRJNA667863 | 5275 | 298 | 1.368889 | 4.07928922 | Candidatus Peribacterales bacterium | 2711152 | Bacteria | Bacteria | 72.4 | 2.84e-12 | NR | HLC75740.1 | 2711152 | g5241 | i0 | 46.4 | 0.845637583892617 | 84 | 40 | 79.5 | 1 | 5 | 241 | 1859 | 1942 | HLC75740.1 DUF4215 domain-containing protein [Candidatus Peribacterales bacterium] | diamond | 252 | 72.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacterales bacterium | ||||
| 31187121 | 31187121 | PRJNA667863_P_NODE_10115_length_257_cov_1.603261_g10081_i0 | PRJNA667863 | 10115 | 257 | 1.603261 | 4.12038077 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 45.1 | 0.00595 | NR | MCA9324640.1 | 2026720 | g10081 | i0 | 48.8 | 0.501945525291829 | 43 | 21 | 49 | 1 | 252 | 127 | 73 | 115 | MCA9324640.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 129 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31472248 | 31472248 | PRJNA667863_P_NODE_13316_length_247_cov_1.488506_g13282_i0 | PRJNA667863 | 13316 | 247 | 1.488506 | 3.67660982 | Candidatus Aerophobetes bacterium | 2030807 | Bacteria | Bacteria | 59.7 | 4.16e-8 | NR | PCI95492.1 | 2030807 | g13282 | i0 | 47.8 | 0.838056680161943 | 69 | 31 | 83.8 | 1 | 41 | 247 | 136 | 199 | PCI95492.1 MAG: hypothetical protein COB11_02075 [Candidatus Aerophobetes bacterium] | diamond | 207 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 32294967 | 32294967 | PRJNA667863_P_NODE_14619_length_245_cov_0.895349_g14585_i0 | PRJNA667863 | 14619 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 149 | 8.719999999999999e-43 | NR | HMR72891.1 | 2026720 | g14585 | i0 | 81.5 | 0.991836734693878 | 81 | 15 | 99.2 | 0 | 1 | 243 | 33 | 113 | HMR72891.1 lysine--tRNA ligase [Candidatus Saccharibacteria bacterium] | diamond | 243 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;