contig_metadata
6 rows where bioproject = "PRJNA884104", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27149807 | 27149807 | PRJNA884104_S_NODE_54942_length_282_cov_1.473684_g54199_i0 | PRJNA884104 | 54942 | 282 | 1.473684 | 4.15578888 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 44.7 | 0.0121 | NR | MFC1898309.1 | 2030808 | g54199 | i0 | 39.3 | 0.595744680851064 | 56 | 34 | 59.6 | 0 | 196 | 29 | 380 | 435 | MFC1898309.1 Na/Pi cotransporter family protein [Candidatus Cloacimonadota bacterium] | diamond | 168 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 27497881 | 27497881 | PRJNA884104_S_NODE_27503_length_388_cov_0.977778_g26760_i0 | PRJNA884104 | 27503 | 388 | 0.977778 | 3.79377864 | Candidatus Cloacimonadales bacterium | 3060593 | Bacteria | Bacteria | 65.9 | 1.54e-9 | NR | MFO7895620.1 | 3060593 | g26760 | i0 | 40 | 0.811855670103093 | 105 | 59 | 80.4 | 4 | 358 | 47 | 193 | 294 | MFO7895620.1 FlgD immunoglobulin-like domain containing protein [Candidatus Cloacimonadales bacterium] | diamond | 315 | 65.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadales bacterium | |||
| 30474225 | 30474225 | PRJNA884104_S_NODE_38013_length_335_cov_0.881679_g37270_i0 | PRJNA884104 | 38013 | 335 | 0.881679 | 2.95362465 | FCB group | 1783270 | Bacteria | Bacteria | 176 | 8.62e-54 | NR | PKN80893.1 | 2013733 | g37270 | i0 | 79.3 | 25.844776119403 | 111 | 23 | 99.4 | 0 | 333 | 1 | 40 | 150 | PKN80893.1 MAG: NAD(P)H:quinone oxidoreductase, partial [Candidatus Cloacimonetes bacterium HGW-Cloacimonetes-1] | diamond | 8658 | 177 | 0.994350282485876 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonetes bacterium HGW-Cloacimonetes-1 | |||||
| 30940233 | 30940233 | PRJNA884104_S_NODE_33394_length_355_cov_1.000000_g32651_i0 | PRJNA884104 | 33394 | 355 | 1 | 3.55 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 45.8 | 0.0105 | NR | MCK5051353.1 | 2030808 | g32651 | i0 | 33.7 | 1.47042253521127 | 92 | 58 | 77.7 | 2 | 67 | 342 | 3 | 91 | MCK5051353.1 T9SS type A sorting domain-containing protein [Candidatus Cloacimonadota bacterium] | diamond | 522 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 31793588 | 31793588 | PRJNA884104_S_NODE_37457_length_337_cov_1.155303_g36714_i0 | PRJNA884104 | 37457 | 337 | 1.155303 | 3.89337111 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 63.2 | 6.55e-9 | NR | MDD3052503.1 | 2030808 | g36714 | i0 | 50.8 | 0.560830860534125 | 63 | 30 | 56.1 | 1 | 266 | 78 | 208 | 269 | MDD3052503.1 RNA ligase family protein [Candidatus Cloacimonadota bacterium] | diamond | 189 | 63.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 32395117 | 32395117 | PRJNA884104_S_NODE_85419_length_241_cov_1.375000_g84676_i0 | PRJNA884104 | 85419 | 241 | 1.375 | 3.31375 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 50.8 | 4.9e-5 | NR | HPV14487.1 | 2030808 | g84676 | i0 | 56.1 | 0.983402489626556 | 41 | 18 | 51 | 0 | 222 | 100 | 38 | 78 | HPV14487.1 SEL1-like repeat protein [Candidatus Cloacimonadota bacterium] | diamond | 237 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota 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);;