contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax_phylum = "Candidatus Cloacimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27886045 | 27886045 | PRJEB28062_P_NODE_35345_length_617_cov_1.579044_g33024_i0 | PRJEB28062 | 35345 | 617 | 1.579044 | 9.74270148 | Candidatus Cloacimonadaceae bacterium | 3064664 | Bacteria | Bacteria | 181 | 1.82e-49 | NR | MFA5667393.1 | 3064664 | g33024 | i0 | 50 | 1.9837925445705 | 204 | 92 | 95.8 | 7 | 592 | 2 | 239 | 439 | MFA5667393.1 T9SS type A sorting domain-containing protein [Candidatus Cloacimonadaceae bacterium] | diamond | 1224 | 181 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadaceae | Candidatus Cloacimonadaceae bacterium | ||
| 28106999 | 28106999 | PRJEB28062_P_NODE_63145_length_438_cov_11.616438_g60784_i0 | PRJEB28062 | 63145 | 438 | 11.616438 | 50.87999844 | Candidatus Cloacimonas sp. 4484_2 | 2053534 | Bacteria | Bacteria | 176 | 1.65e-50 | NR | OQX56517.1 | 1968525 | g60784 | i0 | 82.5 | 0.664383561643836 | 97 | 17 | 66.4 | 0 | 15 | 305 | 275 | 371 | OQX56517.1 MAG: phosphoadenosine phosphosulfate reductase [Candidatus Cloacimonas sp. 4484_209] | diamond | 291 | 176 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadaceae | Candidatus Cloacimonas | Candidatus Cloacimonas sp. 4484_209 | |
| 28391262 | 28391262 | PRJEB28062_P_NODE_73906_length_397_cov_29.709877_g71544_i0 | PRJEB28062 | 73906 | 397 | 29.709877 | 117.94821169 | Candidatus Cloacimonadaceae bacterium | 3064664 | Bacteria | Bacteria | 177 | 1.5e-51 | NR | MFA7030151.1 | 3064664 | g71544 | i0 | 75.8 | 0.906801007556675 | 120 | 27 | 89.2 | 1 | 20 | 373 | 237 | 356 | MFA7030151.1 hypothetical protein [Candidatus Cloacimonadaceae bacterium] | diamond | 360 | 177 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadaceae | Candidatus Cloacimonadaceae bacterium | ||
| 28580832 | 28580832 | PRJEB28062_P_NODE_66167_length_426_cov_2.991501_g63806_i0 | PRJEB28062 | 66167 | 426 | 2.991501 | 12.74379426 | Candidatus Cloacimonadaceae bacterium | 3064664 | Bacteria | Bacteria | 99.8 | 3.13e-21 | NR | MFA6721506.1 | 3064664 | g63806 | i0 | 41.4 | 0.901408450704225 | 128 | 60 | 84.5 | 2 | 18 | 377 | 59 | 179 | MFA6721506.1 hypothetical protein [Candidatus Cloacimonadaceae bacterium] | diamond | 384 | 99.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadaceae | Candidatus Cloacimonadaceae bacterium | ||
| 30981308 | 30981308 | PRJEB28062_P_NODE_98574_length_319_cov_2.500000_g96212_i0 | PRJEB28062 | 98574 | 319 | 2.5 | 7.975 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 72.8 | 2.22e-12 | NR | MBC8525337.1 | 2030808 | g96212 | i0 | 58.2 | 2.63322884012539 | 55 | 23 | 51.7 | 0 | 319 | 155 | 226 | 280 | MBC8525337.1 restriction endonuclease subunit S [Candidatus Cloacimonadota bacterium] | diamond | 840 | 72.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 32278024 | 32278024 | PRJEB28062_P_NODE_62479_length_441_cov_3.831522_g60119_i0 | PRJEB28062 | 62479 | 441 | 3.831522 | 16.89701202 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 256 | 8.79e-78 | NR | HOH98041.1 | 2030808 | g60119 | i0 | 94.6 | 0.877551020408163 | 129 | 7 | 87.8 | 0 | 403 | 17 | 602 | 730 | HOH98041.1 T9SS type A sorting domain-containing protein [Candidatus Cloacimonadota bacterium] | diamond | 387 | 256 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 32782823 | 32782823 | PRJEB28062_P_NODE_37560_length_596_cov_7.078394_g35233_i0 | PRJEB28062 | 37560 | 596 | 7.078394 | 42.18722824 | Candidatus Cloacimonadaceae bacterium | 3064664 | Bacteria | Bacteria | 229 | 2.99e-73 | NR | MFA6721509.1 | 3064664 | g35233 | i0 | 87.3 | 0.674496644295302 | 134 | 17 | 67.4 | 0 | 18 | 419 | 10 | 143 | MFA6721509.1 IS607 family transposase [Candidatus Cloacimonadaceae bacterium] | diamond | 402 | 229 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadaceae | Candidatus Cloacimonadaceae 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);;