contig_metadata
16 rows where tax_clade = "Candidatus Halobeggiatoa", tax_phylum = "Pseudomonadota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6676117 | 6676117 | PRJNA1148190_P_NODE_625246_length_249_cov_0.875000_g614073_i0 | PRJNA1148190 | 625246 | 249 | 0.875 | 2.17875 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 133 | 9.08e-36 | NR | MDM8566148.1 | 3055495 | g614073 | i0 | 68.7 | 1.98795180722892 | 83 | 26 | 100 | 0 | 1 | 249 | 89 | 171 | MDM8566148.1 electron transport complex subunit RsxD [Candidatus Halobeggiatoa sp. HSG11] | diamond | 495 | 133 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 18392507 | 18392507 | PRJNA558770_P_NODE_290655_length_234_cov_1.557789_g288650_i0 | PRJNA558770 | 290655 | 234 | 1.557789 | 3.64522626 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 84 | 6.51e-17 | NR | MDM8565179.1 | 3055495 | g288650 | i0 | 57.1 | 17.7692307692308 | 77 | 4 | 98.7 | 1 | 1 | 231 | 220 | 267 | MDM8565179.1 GDP-mannose 4,6-dehydratase [Candidatus Halobeggiatoa sp. HSG11] | diamond | 4158 | 84 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 21149508 | 21149508 | PRJNA770826_P_NODE_32677_length_166_cov_0.888889_g32506_i0 | PRJNA770826 | 32677 | 166 | 0.888889 | 1.47555574 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 89 | 3.34e-19 | NR | MDM8566288.1 | 3055495 | g32506 | i0 | 79.6 | 12.6686746987952 | 54 | 11 | 97.6 | 0 | 3 | 164 | 177 | 230 | MDM8566288.1 S-(hydroxymethyl)glutathione dehydrogenase/class III alcohol dehydrogenase [Candidatus Halobeggiatoa sp. HSG11] | diamond | 2103 | 89 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 26597970 | 26597970 | PRJNA1237347_P_NODE_352641_length_302_cov_1.008734_g346068_i0 | PRJNA1237347 | 352641 | 302 | 1.008734 | 3.04637668 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 86.7 | 1.65e-17 | NR | MDM8565238.1 | 3055495 | g346068 | i0 | 45.9 | 0.973509933774834 | 98 | 53 | 97.4 | 0 | 295 | 2 | 197 | 294 | MDM8565238.1 ATP-binding protein [Candidatus Halobeggiatoa sp. HSG11] | diamond | 294 | 86.7 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 26947940 | 26947940 | PRJNA330616_P_NODE_30422_length_163_cov_0.894737_g30013_i0 | PRJNA330616 | 30422 | 163 | 0.894737 | 1.45842131 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 48.1 | 1.53e-4 | NR | MDM8565756.1 | 3055495 | g30013 | i0 | 40 | 0.920245398773006 | 50 | 30 | 92 | 0 | 152 | 3 | 59 | 108 | MDM8565756.1 PKD domain-containing protein [Candidatus Halobeggiatoa sp. HSG11] | diamond | 150 | 48.1 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 27027956 | 27027956 | PRJNA1148190_P_NODE_569902_length_253_cov_1.566667_g558729_i0 | PRJNA1148190 | 569902 | 253 | 1.566667 | 3.96366751 | Bacteria | 2 | Bacteria | Bacteria | 104 | 6.74e-24 | NR | MDM8564118.1 | 3055495 | g558729 | i0 | 63.5 | 3.02371541501976 | 85 | 30 | 99.6 | 1 | 1 | 252 | 255 | 339 | MDM8564118.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Candidatus Halobeggiatoa sp. HSG11] | diamond | 765 | 104 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 27450734 | 27450734 | PRJNA1148190_P_NODE_491983_length_268_cov_1.492308_g480810_i0 | PRJNA1148190 | 491983 | 268 | 1.492308 | 3.99938544 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 97.1 | 3.53e-24 | NR | MDM8564847.1 | 3055495 | g480810 | i0 | 58 | 0.906716417910448 | 81 | 34 | 90.7 | 0 | 26 | 268 | 1 | 81 | MDM8564847.1 hypothetical protein [Candidatus Halobeggiatoa sp. HSG11] | diamond | 243 | 97.1 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 28296402 | 28296402 | PRJEB20058_S_NODE_6286_length_233_cov_9.034884_g6248_i0 | PRJEB20058 | 6286 | 233 | 9.034884 | 21.05127972 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 60.5 | 1.16e-8 | NR | MDM8566662.1 | 3055495 | g6248 | i0 | 55.4 | 0.721030042918455 | 56 | 25 | 72.1 | 0 | 170 | 3 | 1 | 56 | MDM8566662.1 ApaLI family restriction endonuclease [Candidatus Halobeggiatoa sp. HSG11] | diamond | 168 | 60.5 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 28918367 | 28918367 | PRJNA881716_P_NODE_55208_length_243_cov_0.917647_g55033_i0 | PRJNA881716 | 55208 | 243 | 0.917647 | 2.22988221 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 47.4 | 8.85e-4 | NR | MDM8565298.1 | 3055495 | g55033 | i0 | 35.1 | 1.82716049382716 | 74 | 46 | 91.4 | 1 | 11 | 232 | 1453 | 1524 | MDM8565298.1 PAS domain S-box protein [Candidatus Halobeggiatoa sp. HSG11] | diamond | 444 | 47.4 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 29020433 | 29020433 | PRJNA688655_P_NODE_16488_length_241_cov_0.916667_g16423_i0 | PRJNA688655 | 16488 | 241 | 0.916667 | 2.20916747 | Candidatus Parabeggiatoa | 1034941 | Bacteria | Bacteria | 82.4 | 1.92e-16 | NR | MDM8565081.1 | 3055495 | g16423 | i0 | 53.1 | 4.03319502074689 | 81 | 33 | 98.3 | 2 | 238 | 2 | 153 | 230 | MDM8565081.1 VWA domain-containing protein [Candidatus Halobeggiatoa sp. HSG11] | diamond | 972 | 82.4 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 29054362 | 29054362 | PRJEB14803_P_NODE_28848_length_203_cov_1.357143_g28382_i0 | PRJEB14803 | 28848 | 203 | 1.357143 | 2.75500029 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 47.8 | 3.74e-4 | NR | MDM8566588.1 | 3055495 | g28382 | i0 | 54.1 | 0.54679802955665 | 37 | 17 | 54.7 | 0 | 3 | 113 | 26 | 62 | MDM8566588.1 hypothetical protein [Candidatus Halobeggiatoa sp. HSG11] | diamond | 111 | 47.8 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 29720134 | 29720134 | PRJNA1111146_P_NODE_71610_length_263_cov_3.490476_g70472_i0 | PRJNA1111146 | 71610 | 263 | 3.490476 | 9.17995188 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 114 | 2.35e-27 | NR | MDM8567186.1 | 3055495 | g70472 | i0 | 60 | 2.11026615969582 | 90 | 33 | 99.2 | 1 | 3 | 263 | 792 | 881 | MDM8567186.1 N-6 DNA methylase [Candidatus Halobeggiatoa sp. HSG11] | diamond | 555 | 114 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 30012219 | 30012219 | PRJNA390533_P_NODE_31711_length_235_cov_1.193878_g30684_i0 | PRJNA390533 | 31711 | 235 | 1.193878 | 2.8056133 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 131 | 1.77e-33 | NR | MDM8567414.1 | 3055495 | g30684 | i0 | 76.4 | 2.78297872340426 | 72 | 17 | 91.9 | 0 | 6 | 221 | 811 | 882 | MDM8567414.1 N-6 DNA methylase [Candidatus Halobeggiatoa sp. HSG11] | diamond | 654 | 131 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 32003219 | 32003219 | PRJNA379145_P_NODE_43738_length_273_cov_1.791667_g41586_i0 | PRJNA379145 | 43738 | 273 | 1.791667 | 4.89125091 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 67 | 1.47e-10 | NR | MDM8567715.1 | 3055495 | g41586 | i0 | 46 | 0.956043956043956 | 87 | 42 | 92.3 | 3 | 256 | 5 | 207 | 291 | MDM8567715.1 DUF642 domain-containing protein [Candidatus Halobeggiatoa sp. HSG11] | diamond | 261 | 67 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 33028310 | 33028310 | PRJEB14175_P_NODE_152924_length_273_cov_4.000000_g150657_i0 | PRJEB14175 | 152924 | 273 | 4 | 10.92 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 57 | 3.5e-7 | NR | MDM8566662.1 | 3055495 | g150657 | i0 | 54.9 | 0.56043956043956 | 51 | 23 | 56 | 0 | 119 | 271 | 1 | 51 | MDM8566662.1 ApaLI family restriction endonuclease [Candidatus Halobeggiatoa sp. HSG11] | diamond | 153 | 57 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 | ||
| 33123717 | 33123717 | PRJNA737474d_S_NODE_17423_length_367_cov_4.357143_g16829_i0 | PRJNA737474 | 17423 | 367 | 4.357143 | 15.99071481 | Candidatus Halobeggiatoa sp. HSG11 | 3055495 | Bacteria | Bacteria | 50.1 | 1.22e-4 | NR | MDM8566630.1 | 3055495 | g16829 | i0 | 72.4 | 0.237057220708447 | 29 | 8 | 23.7 | 0 | 213 | 127 | 118 | 146 | MDM8566630.1 hypothetical protein [Candidatus Halobeggiatoa sp. HSG11] | diamond | 87 | 50.1 | 1 | Bacteria | Candidatus Halobeggiatoa | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Thiotrichales | Thiotrichaceae | Candidatus Halobeggiatoa sp. HSG11 |
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);;