contig_metadata
16 rows where bioproject = "PRJNA283169" and tax_phylum = "Candidatus Woeseibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13125608 | 13125608 | PRJNA283169_P_NODE_3931_length_211_cov_1.271605_g3868_i0 | PRJNA283169 | 3931 | 211 | 1.271605 | 2.68308655 | Bacteria | 2 | Bacteria | Bacteria | 132 | 3.4399999999999993e-34 | NR | OGM17691.1 | 1802487 | g3868 | i0 | 97.1 | 2.94312796208531 | 69 | 2 | 98.1 | 0 | 3 | 209 | 449 | 517 | OGM17691.1 MAG: hypothetical protein A2V56_00630, partial [Candidatus Woesebacteria bacterium RBG_19FT_COMBO_42_9] | diamond | 621 | 132 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium RBG_19FT_COMBO_42_9 | ||||||
| 16949112 | 16949112 | PRJNA283169_P_NODE_1134_length_370_cov_1.227414_g1072_i0 | PRJNA283169 | 1134 | 370 | 1.227414 | 4.5414318 | Bacteria | 2 | Bacteria | Bacteria | 209 | 4.45e-64 | NR | OGM25730.1 | 1802496 | g1072 | i0 | 81.1 | 7.94594594594595 | 122 | 23 | 98.9 | 0 | 368 | 3 | 126 | 247 | OGM25730.1 MAG: hypothetical protein A2627_01510 [Candidatus Woesebacteria bacterium RIFCSPHIGHO2_01_FULL_39_28] | diamond | 2940 | 209 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium RIFCSPHIGHO2_01_FULL_39_28 | ||||||
| 23323810 | 23323810 | PRJNA283169_P_NODE_3459_length_223_cov_1.160920_g3396_i0 | PRJNA283169 | 3459 | 223 | 1.16092 | 2.5888516 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 145 | 3.18e-30 | NTclustered | gi|1950815156|gb|CP066686.1| | 2026804 | g3396 | i0 | 82.941 | 0.762331838565022 | 170 | 20 | 74 | 5 | 9 | 174 | 767875 | 768039 | MAG: Candidatus Woesebacteria bacterium isolate NC_groundwater_442_Ag_B-0.1um_40_41 chromosome | blastn | 170 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 26821125 | 26821125 | PRJNA283169_P_NODE_2341_length_269_cov_1.336364_g2279_i0 | PRJNA283169 | 2341 | 269 | 1.336364 | 3.59481916 | Candidatus Woesebacteria bacterium RIFCSPHIGHO2_ | 2026804 | Bacteria | Bacteria | 106 | 1.86e-24 | NR | OGM32771.1 | 1802504 | g2279 | i0 | 54.8 | 0.936802973977695 | 84 | 38 | 93.7 | 0 | 11 | 262 | 401 | 484 | OGM32771.1 MAG: hypothetical protein A3D00_02165 [Candidatus Woesebacteria bacterium RIFCSPHIGHO2_02_FULL_38_9] | diamond | 252 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium RIFCSPHIGHO2_02_FULL_38_9 | ||||||
| 27408090 | 27408090 | PRJNA283169_P_NODE_5763_length_178_cov_1.573643_g5700_i0 | PRJNA283169 | 5763 | 178 | 1.573643 | 2.80108454 | Bacteria | 2 | Bacteria | Bacteria | 90.1 | 5.78e-22 | NR | KKR43814.1 | 1618576 | g5700 | i0 | 72.4 | 3.89325842696629 | 58 | 16 | 97.8 | 0 | 177 | 4 | 16 | 73 | KKR43814.1 MAG: Phenylalanine-tRNA ligase beta subunit, partial [Candidatus Woesebacteria bacterium GW2011_GWB1_40_12] | diamond | 693 | 90.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWB1_40_12 | ||||||
| 27674572 | 27674572 | PRJNA283169_P_NODE_6664_length_168_cov_0.865546_g6601_i0 | PRJNA283169 | 6664 | 168 | 0.865546 | 1.45411728 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 52.4 | 5.67e-7 | NR | MBP7118634.1 | 2026804 | g6601 | i0 | 64.5 | 0.553571428571429 | 31 | 11 | 55.4 | 0 | 74 | 166 | 27 | 57 | MBP7118634.1 hypothetical protein [Candidatus Woesebacteria bacterium] | diamond | 93 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 28291762 | 28291762 | PRJNA283169_P_NODE_6486_length_169_cov_0.866667_g6423_i0 | PRJNA283169 | 6486 | 169 | 0.866667 | 1.46466723 | Bacteria | 2 | Bacteria | Bacteria | 89.4 | 5.26e-19 | NR | KKQ92080.1 | 1618572 | g6423 | i0 | 78.6 | 3.97633136094675 | 56 | 12 | 99.4 | 0 | 2 | 169 | 12 | 67 | KKQ92080.1 MAG: cell division FtsK/SpoIIIE [Candidatus Woesebacteria bacterium GW2011_GWB1_39_10] | diamond | 672 | 89.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWB1_39_10 | ||||||
| 28463860 | 28463860 | PRJNA283169_P_NODE_7246_length_165_cov_0.896552_g7183_i0 | PRJNA283169 | 7246 | 165 | 0.896552 | 1.4793108 | Candidatus Woesebacteria bacterium GW2 | 2026804 | Bacteria | Bacteria | 47.8 | 2.27e-4 | NR | KKP48300.1 | 1618561 | g7183 | i0 | 42.4 | 1.07272727272727 | 59 | 30 | 100 | 2 | 1 | 165 | 418 | 476 | KKP48300.1 MAG: hypothetical protein UR38_C0001G0096 [Candidatus Woesebacteria bacterium GW2011_GWA2_33_28] | diamond | 177 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWA2_33_28 | ||||||
| 29586159 | 29586159 | PRJNA283169_P_NODE_7970_length_162_cov_1.362832_g7907_i0 | PRJNA283169 | 7970 | 162 | 1.362832 | 2.20778784 | Bacteria | 2 | Bacteria | Bacteria | 107 | 1.54e-25 | NR | KKU03691.1 | 1618598 | g7907 | i0 | 98.1 | 3 | 54 | 1 | 100 | 0 | 162 | 1 | 386 | 439 | KKU03691.1 MAG: hypothetical protein UX03_C0013G0051 [Candidatus Woesebacteria bacterium GW2011_GWE1_45_18] | diamond | 486 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWE1_45_18 | ||||||
| 29744066 | 29744066 | PRJNA283169_P_NODE_3410_length_225_cov_1.107955_g3347_i0 | PRJNA283169 | 3410 | 225 | 1.107955 | 2.49289875 | Bacteria | 2 | Bacteria | Bacteria | 89.7 | 5.05e-19 | NR | MCX6704126.1 | 2026804 | g3347 | i0 | 52.9 | 2.72 | 68 | 32 | 90.7 | 0 | 11 | 214 | 314 | 381 | MCX6704126.1 MFS transporter [Candidatus Woesebacteria bacterium] | diamond | 612 | 89.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 30502564 | 30502564 | PRJNA283169_P_NODE_4213_length_205_cov_0.993590_g4150_i0 | PRJNA283169 | 4213 | 205 | 0.99359 | 2.0368595 | Bacillati | 1783272 | Bacteria | Bacteria | 46.2 | 0.00127 | NR | OGM25278.1 | 1802497 | g4150 | i0 | 29.7 | 3.83414634146341 | 64 | 45 | 93.7 | 0 | 192 | 1 | 208 | 271 | OGM25278.1 MAG: hypothetical protein A2715_04505 [Candidatus Woesebacteria bacterium RIFCSPHIGHO2_01_FULL_39_32] | diamond | 786 | 46.6 | 0.991416309012876 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium RIFCSPHIGHO2_01_FULL_39_32 | ||||||
| 30642691 | 30642691 | PRJNA283169_P_NODE_2573_length_257_cov_1.312500_g2511_i0 | PRJNA283169 | 2573 | 257 | 1.3125 | 3.373125 | Candidatus Woesebacteria bacterium GW2 | 2026804 | Bacteria | Bacteria | 87 | 2.34e-18 | NR | KKQ98365.1 | 1618574 | g2511 | i0 | 57.8 | 0.968871595330739 | 83 | 35 | 96.9 | 0 | 250 | 2 | 173 | 255 | KKQ98365.1 MAG: hypothetical protein UT24_C0038G0012 [Candidatus Woesebacteria bacterium GW2011_GWB1_39_12] | diamond | 249 | 87 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWB1_39_12 | ||||||
| 30705913 | 30705913 | PRJNA283169_P_NODE_5954_length_175_cov_1.642857_g5891_i0 | PRJNA283169 | 5954 | 175 | 1.642857 | 2.87499975 | Candidatus Woesebacteria bacterium GW2 | 2026804 | Bacteria | Bacteria | 86.7 | 1.22e-18 | NR | KKR87983.1 | 1618577 | g5891 | i0 | 71.9 | 3.90857142857143 | 57 | 16 | 97.7 | 0 | 171 | 1 | 82 | 138 | KKR87983.1 MAG: Topoisomerase [Candidatus Woesebacteria bacterium GW2011_GWB1_41_10] | diamond | 684 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWB1_41_10 | ||||||
| 31527967 | 31527967 | PRJNA283169_S_NODE_3416_length_162_cov_0.141593_g3402_i0 | PRJNA283169 | 3416 | 162 | 0.141593 | 0.22938066 | Candidatus Woesebacteria bacterium GW2 | 2026804 | Bacteria | Bacteria | 65.5 | 1.21e-10 | NR | KKR72163.1 | 1618562 | g3402 | i0 | 55.6 | 3 | 54 | 24 | 100 | 0 | 1 | 162 | 411 | 464 | KKR72163.1 MAG: Phenylalanyl-tRNA synthetase, beta subunit [Candidatus Woesebacteria bacterium GW2011_GWA2_40_7] | diamond | 486 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWA2_40_7 | ||||||
| 32287431 | 32287431 | PRJNA283169_P_NODE_2379_length_267_cov_1.394495_g2317_i0 | PRJNA283169 | 2379 | 267 | 1.394495 | 3.72330165 | Candidatus Woesebacteria bacterium GW2 | 2026804 | Bacteria | Bacteria | 68.2 | 1.11e-11 | NR | KKQ98808.1 | 1618574 | g2317 | i0 | 50.8 | 0.662921348314607 | 59 | 29 | 66.3 | 0 | 179 | 3 | 1 | 59 | KKQ98808.1 MAG: hypothetical protein UT24_C0036G0006 [Candidatus Woesebacteria bacterium GW2011_GWB1_39_12] | diamond | 177 | 68.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWB1_39_12 | ||||||
| 32508885 | 32508885 | PRJNA283169_P_NODE_7339_length_165_cov_0.879310_g7276_i0 | PRJNA283169 | 7339 | 165 | 0.87931 | 1.4508615 | Candidatus Woesebacteria bacterium GW2 | 2026804 | Bacteria | Bacteria | 94 | 1.91e-21 | NR | KKU09184.1 | 1618581 | g7276 | i0 | 87 | 0.981818181818182 | 54 | 7 | 98.2 | 0 | 1 | 162 | 181 | 234 | KKU09184.1 MAG: Succinyl-CoA synthetase (ADP-forming) alpha subunit [Candidatus Woesebacteria bacterium GW2011_GWB1_45_5] | diamond | 162 | 94 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWB1_45_5 |
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);;