contig_metadata
13 rows where analysis = "diamond" and tax_phylum = "Candidatus Niyogiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17793 | 17793 | PRJEB11748_P_NODE_300061_length_219_cov_6.841772_g297878_i0 | PRJEB11748 | 300061 | 219 | 6.841772 | 14.98348068 | Candidatus Niyogibacteria bacterium CG1 | 2750078 | Bacteria | Bacteria | 93.2 | 2.44e-22 | NR | PIR70272.1 | 1974725 | g297878 | i0 | 63.9 | 1.67123287671233 | 61 | 22 | 83.6 | 0 | 35 | 217 | 45 | 105 | PIR70272.1 MAG: very short patch repair endonuclease [Candidatus Niyogibacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_19] | diamond | 366 | 93.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_19 | ||||||
| 27187546 | 27187546 | PRJNA556992_P_NODE_736282_length_249_cov_2.193182_g734093_i0 | PRJNA556992 | 736282 | 249 | 2.193182 | 5.46102318 | Bacteria | 2 | Bacteria | Bacteria | 80.9 | 1.52e-15 | NR | QQG46606.1 | 2750078 | g734093 | i0 | 48.8 | 2.02409638554217 | 84 | 42 | 100 | 1 | 1 | 249 | 309 | 392 | QQG46606.1 MAG: hypothetical protein HYY55_02050 [Candidatus Niyogibacteria bacterium] | diamond | 504 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium | ||||||
| 28154457 | 28154457 | PRJNA615351_P_NODE_177765_length_158_cov_1.292683_g163665_i0 | PRJNA615351 | 177765 | 158 | 1.292683 | 2.04243914 | Candidatus Niyogibacteria bacterium RIFCSPHIGHO2_ | 2750078 | Bacteria | Bacteria | 66.6 | 4.15e-11 | NR | OGZ28590.1 | 1801723 | g163665 | i0 | 57.4 | 0.892405063291139 | 47 | 20 | 89.2 | 0 | 3 | 143 | 192 | 238 | OGZ28590.1 MAG: hypothetical protein A2835_03935 [Candidatus Niyogibacteria bacterium RIFCSPHIGHO2_01_FULL_45_28] | diamond | 141 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium RIFCSPHIGHO2_01_FULL_45_28 | ||||||
| 28179888 | 28179888 | PRJNA340009_P_NODE_36546_length_209_cov_1.275000_g36239_i0 | PRJNA340009 | 36546 | 209 | 1.275 | 2.66475 | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_ | 2750078 | Bacteria | Bacteria | 78.2 | 7.01e-15 | NR | OGZ29909.1 | 1801724 | g36239 | i0 | 89.5 | 0.545454545454545 | 38 | 4 | 54.5 | 0 | 53 | 166 | 177 | 214 | OGZ29909.1 MAG: hypothetical protein A2931_00885 [Candidatus Niyogibacteria bacterium RIFCSPLOWO2_01_FULL_45_48] | diamond | 114 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_01_FULL_45_48 | ||||||
| 28457116 | 28457116 | PRJNA1073005_P_NODE_9086_length_250_cov_0.870056_g8967_i0 | PRJNA1073005 | 9086 | 250 | 0.870056 | 2.17514 | Candidatus Niyogibacteria bacterium | 2750078 | Bacteria | Bacteria | 44.7 | 0.00759 | NR | MBI5742705.1 | 2750078 | g8967 | i0 | 39.1 | 0.768 | 64 | 33 | 72 | 3 | 66 | 245 | 188 | 249 | MBI5742705.1 TPM domain-containing protein [Candidatus Niyogibacteria bacterium] | diamond | 192 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium | ||||||
| 29145013 | 29145013 | PRJNA382357_P_NODE_40489_length_360_cov_5.561873_g39750_i0 | PRJNA382357 | 40489 | 360 | 5.561873 | 20.0227428 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.1 | 2.09e-9 | NR | MBI1957008.1 | 2750078 | g39750 | i0 | 62.8 | 1.38333333333333 | 43 | 16 | 35.8 | 0 | 39 | 167 | 236 | 278 | MBI1957008.1 hypothetical protein [Candidatus Niyogibacteria bacterium] | diamond | 498 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium | ||||||
| 29527297 | 29527297 | PRJDB4941_P_NODE_39110_length_164_cov_0.904348_g38342_i0 | PRJDB4941 | 39110 | 164 | 0.904348 | 1.48313072 | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_12_FULL_41_13 | 1801726 | Bacteria | Bacteria | 68.2 | 1.34e-11 | NR | OGZ31573.1 | 1801726 | g38342 | i0 | 83.3 | 0.658536585365854 | 36 | 6 | 65.9 | 0 | 57 | 164 | 1 | 36 | OGZ31573.1 MAG: UDP-glucose 6-dehydrogenase [Candidatus Niyogibacteria bacterium RIFCSPLOWO2_12_FULL_41_13] | diamond | 108 | 68.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_12_FULL_41_13 | ||||||
| 29660835 | 29660835 | PRJNA1148190_P_NODE_85910_length_585_cov_1.632812_g74777_i0 | PRJNA1148190 | 85910 | 585 | 1.632812 | 9.5519502 | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_12_FULL_41_13 | 1801726 | Bacteria | Bacteria | 246 | 3.08e-78 | NR | OGZ31570.1 | 1801726 | g74777 | i0 | 63.2 | 0.98974358974359 | 193 | 71 | 99 | 0 | 580 | 2 | 61 | 253 | OGZ31570.1 MAG: hypothetical protein A3H02_02580 [Candidatus Niyogibacteria bacterium RIFCSPLOWO2_12_FULL_41_13] | diamond | 579 | 246 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_12_FULL_41_13 | ||||||
| 30580747 | 30580747 | PRJNA404067_P_NODE_31653_length_208_cov_2.571429_g31266_i0 | PRJNA404067 | 31653 | 208 | 2.571429 | 5.34857232 | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_12_FULL_41_13 | 1801726 | Bacteria | Bacteria | 58.9 | 4.74e-8 | NR | OGZ31561.1 | 1801726 | g31266 | i0 | 45.3 | 0.923076923076923 | 64 | 32 | 92.3 | 1 | 207 | 16 | 1596 | 1656 | OGZ31561.1 MAG: hypothetical protein A3H02_02535 [Candidatus Niyogibacteria bacterium RIFCSPLOWO2_12_FULL_41_13] | diamond | 192 | 58.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_12_FULL_41_13 | ||||||
| 30737278 | 30737278 | PRJNA168635_P_NODE_15094_length_207_cov_1.189873_g14678_i0 | PRJNA168635 | 15094 | 207 | 1.189873 | 2.46303711 | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_ | 2750078 | Bacteria | Bacteria | 40.8 | 0.0208 | NR | OGZ31266.1 | 1801725 | g14678 | i0 | 38.2 | 0.797101449275362 | 55 | 33 | 79.7 | 1 | 14 | 178 | 24 | 77 | OGZ31266.1 MAG: hypothetical protein A3J00_01855 [Candidatus Niyogibacteria bacterium RIFCSPLOWO2_02_FULL_45_13] | diamond | 165 | 40.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium RIFCSPLOWO2_02_FULL_45_13 | ||||||
| 31243740 | 31243740 | PRJNA340009_P_NODE_63075_length_167_cov_0.864407_g62768_i0 | PRJNA340009 | 63075 | 167 | 0.864407 | 1.44355969 | Candidatus Niyogibacteria bacterium | 2750078 | Bacteria | Bacteria | 72.8 | 3.35e-13 | NR | MBI1956949.1 | 2750078 | g62768 | i0 | 73.8 | 2.26347305389222 | 42 | 11 | 75.4 | 0 | 1 | 126 | 536 | 577 | MBI1956949.1 DNA polymerase/3'-5' exonuclease PolX [Candidatus Niyogibacteria bacterium] | diamond | 378 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium | ||||||
| 32697996 | 32697996 | PRJNA315399_P_NODE_469960_length_154_cov_3.239316_g469512_i0 | PRJNA315399 | 469960 | 154 | 3.239316 | 4.98854664 | Candidatus Niyogibacteria bacterium | 2750078 | Bacteria | Bacteria | 59.3 | 1.51e-8 | NR | MBI4114666.1 | 2750078 | g469512 | i0 | 61.4 | 0.857142857142857 | 44 | 17 | 85.7 | 0 | 137 | 6 | 178 | 221 | MBI4114666.1 HD domain-containing protein [Candidatus Niyogibacteria bacterium] | diamond | 132 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria bacterium | ||||||
| 32700680 | 32700680 | PRJNA513467_S_NODE_7000_length_160_cov_1.585366_g6977_i0 | PRJNA513467 | 7000 | 160 | 1.585366 | 2.5365856 | Candidatus Niyogibacteria bacterium | 2750078 | Bacteria | Bacteria | 43.9 | 0.00206 | NR | MBI2038746.1 | 2750078 | g6977 | i0 | 69.4 | 0.675 | 36 | 10 | 67.5 | 1 | 3 | 110 | 104 | 138 | MBI2038746.1 30S ribosomal protein S6 [Candidatus Niyogibacteria bacterium] | diamond | 108 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Niyogiibacteriota | Candidatus Niyogibacteria 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);;