contig_metadata
6 rows where bioproject = "PRJNA994052", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Binatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3526831 | 3526831 | PRJNA994052_P_NODE_24543_length_296_cov_11.834081_g23308_i0 | PRJNA994052 | 24543 | 296 | 11.834081 | 35.02887976 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 131 | 8.999999999999999e-34 | NR | MFI5367169.1 | 2838779 | g23308 | i0 | 60.9 | 3.89189189189189 | 128 | 19 | 98.3 | 1 | 293 | 3 | 176 | 303 | MFI5367169.1 DNA repair protein RadA [Candidatus Binatia bacterium] | diamond | 1152 | 131 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 12455846 | 12455846 | PRJNA994052_P_NODE_61670_length_223_cov_81.486667_g60414_i0 | PRJNA994052 | 61670 | 223 | 81.486667 | 181.71526741 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 263 | 8.4e-66 | NTclustered | gi|2621703606|emb|OY761465.1| | 2838779 | g60414 | i0 | 89.151 | 174.134529147982 | 212 | 22 | 95 | 1 | 12 | 223 | 3394370 | 3394160 | MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1 | blastn | 38832 | 263 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 20103247 | 20103247 | PRJNA994052_P_NODE_68636_length_214_cov_27.432624_g67380_i0 | PRJNA994052 | 68636 | 214 | 27.432624 | 58.70581536 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 94.7 | 8.89e-22 | NR | MCK6553501.1 | 2838779 | g67380 | i0 | 65.6 | 0.897196261682243 | 64 | 22 | 89.7 | 0 | 17 | 208 | 84 | 147 | MCK6553501.1 glycosyltransferase family 2 protein [Candidatus Binatia bacterium] | diamond | 192 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30311355 | 30311355 | PRJNA994052_P_NODE_20772_length_307_cov_22.316239_g19545_i0 | PRJNA994052 | 20772 | 307 | 22.316239 | 68.51085373 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 42.7 | 0.0321 | NR | MCK6557059.1 | 2838779 | g19545 | i0 | 63 | 0.263843648208469 | 27 | 10 | 26.4 | 0 | 151 | 71 | 112 | 138 | MCK6557059.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 81 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30753221 | 30753221 | PRJNA994052_P_NODE_36014_length_267_cov_15.860825_g34768_i0 | PRJNA994052 | 36014 | 267 | 15.860825 | 42.34840275 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 114 | 3.8299999999999997e-28 | NR | HYV32137.1 | 2838779 | g34768 | i0 | 83.1 | 1.48314606741573 | 65 | 11 | 73 | 0 | 263 | 69 | 296 | 360 | HYV32137.1 IS21 family transposase [Candidatus Binatia bacterium] | diamond | 396 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32366223 | 32366223 | PRJNA994052_P_NODE_77659_length_203_cov_42.930769_g76402_i0 | PRJNA994052 | 77659 | 203 | 42.930769 | 87.14946107 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 70.1 | 4.45e-14 | NR | MEO6025980.1 | 2838779 | g76402 | i0 | 68 | 0.738916256157635 | 50 | 13 | 73.9 | 2 | 159 | 10 | 20 | 66 | MEO6025980.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 150 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia 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);;