contig_metadata
19 rows where bioproject = "PRJNA1108009" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24439015 | 24439015 | PRJNA1108009_P_NODE_27440_length_247_cov_0.885057_g27122_i0 | PRJNA1108009 | 27440 | 247 | 0.885057 | 2.18609079 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 340 | 4.25e-89 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g27122 | i0 | 91.566 | 138.599190283401 | 249 | 17 | 100 | 4 | 1 | 247 | 220161 | 219915 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 34234 | 340 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 27573239 | 27573239 | PRJNA1108009_P_NODE_28224_length_246_cov_0.890173_g27906_i0 | PRJNA1108009 | 28224 | 246 | 0.890173 | 2.18982558 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 84 | 3e-19 | NR | MBR5938954.1 | 2026720 | g27906 | i0 | 95.6 | 1.64634146341463 | 45 | 2 | 54.9 | 0 | 246 | 112 | 27 | 71 | MBR5938954.1 50S ribosomal protein L20 [Candidatus Saccharibacteria bacterium] | diamond | 405 | 84 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27636520 | 27636520 | PRJNA1108009_P_NODE_27604_length_247_cov_0.885057_g27286_i0 | PRJNA1108009 | 27604 | 247 | 0.885057 | 2.18609079 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 125 | 7.2399999999999985e-34 | NR | MBQ3292955.1 | 2026720 | g27286 | i0 | 76.5 | 1.96761133603239 | 81 | 19 | 98.4 | 0 | 244 | 2 | 56 | 136 | MBQ3292955.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 486 | 125 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27754206 | 27754206 | PRJNA1108009_P_NODE_27664_length_247_cov_0.885057_g27346_i0 | PRJNA1108009 | 27664 | 247 | 0.885057 | 2.18609079 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 2.55e-22 | NR | OGL71986.1 | 1802389 | g27346 | i0 | 60.3 | 3.86234817813765 | 78 | 31 | 94.7 | 0 | 1 | 234 | 460 | 537 | OGL71986.1 MAG: hypothetical protein A3C17_01105 [Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_02_FULL_53_13] | diamond | 954 | 101 | 0.99009900990099 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_02_FULL_53_13 | ||||||
| 27857330 | 27857330 | PRJNA1108009_P_NODE_25825_length_250_cov_0.870056_g25507_i0 | PRJNA1108009 | 25825 | 250 | 0.870056 | 2.17514 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 73.9 | 2.35e-13 | NR | MBR3052036.1 | 2026720 | g25507 | i0 | 72.7 | 1.056 | 44 | 12 | 52.8 | 0 | 133 | 2 | 139 | 182 | MBR3052036.1 thioredoxin-disulfide reductase [Candidatus Saccharibacteria bacterium] | diamond | 264 | 73.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28173041 | 28173041 | PRJNA1108009_P_NODE_28726_length_245_cov_0.895349_g28408_i0 | PRJNA1108009 | 28726 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 130 | 7.28e-33 | NR | MBR2725846.1 | 2026720 | g28408 | i0 | 79 | 0.991836734693878 | 81 | 17 | 99.2 | 0 | 245 | 3 | 750 | 830 | MBR2725846.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 243 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28638228 | 28638228 | PRJNA1108009_P_NODE_23527_length_259_cov_1.586022_g23209_i0 | PRJNA1108009 | 23527 | 259 | 1.586022 | 4.10779698 | Bacteria | 2 | Bacteria | Bacteria | 42.7 | 0.0448 | NR | MBU4360837.1 | 2052139 | g23209 | i0 | 36.5 | 1.45945945945946 | 63 | 40 | 73 | 0 | 30 | 218 | 404 | 466 | MBU4360837.1 preprotein translocase subunit SecA [Patescibacteria group bacterium] | diamond | 378 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30510009 | 30510009 | PRJNA1108009_P_NODE_20433_length_284_cov_1.364929_g20115_i0 | PRJNA1108009 | 20433 | 284 | 1.364929 | 3.87639836 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 147 | 2.73e-41 | NR | MBR2855556.1 | 2026720 | g20115 | i0 | 83.8 | 1.61619718309859 | 80 | 13 | 84.5 | 0 | 284 | 45 | 212 | 291 | MBR2855556.1 NTP transferase domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 459 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30699508 | 30699508 | PRJNA1108009_P_NODE_26314_length_249_cov_0.875000_g25996_i0 | PRJNA1108009 | 26314 | 249 | 0.875 | 2.17875 | Candidatus Nanosyncoccus alces | 2171997 | Bacteria | Bacteria | 159 | 9.59e-49 | NR | WP_129734361.1 | 2171997 | g25996 | i0 | 97.6 | 0.987951807228916 | 82 | 2 | 98.8 | 0 | 1 | 246 | 8 | 89 | WP_129734361.1 30S ribosomal protein S14 [Candidatus Nanosyncoccus alces] | diamond | 246 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanosyncoccales | Candidatus Nanosyncoccaceae | Candidatus Nanosyncoccus | Candidatus Nanosyncoccus alces | ||
| 30699513 | 30699513 | PRJNA1108009_P_NODE_29234_length_245_cov_0.866279_g28916_i0 | PRJNA1108009 | 29234 | 245 | 0.866279 | 2.12238355 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 130 | 4.74e-33 | NR | MBQ8156403.1 | 2026720 | g28916 | i0 | 80.2 | 3.96734693877551 | 81 | 15 | 99.2 | 1 | 1 | 243 | 566 | 645 | MBQ8156403.1 sodium/proton-translocating pyrophosphatase [Candidatus Saccharibacteria bacterium] | diamond | 972 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30794317 | 30794317 | PRJNA1108009_P_NODE_28494_length_246_cov_0.890173_g28176_i0 | PRJNA1108009 | 28494 | 246 | 0.890173 | 2.18982558 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 134 | 2.73e-35 | NR | MBQ3433220.1 | 2026720 | g28176 | i0 | 79 | 11.8536585365854 | 81 | 17 | 98.8 | 0 | 2 | 244 | 161 | 241 | MBQ3433220.1 sugar transferase [Candidatus Saccharibacteria bacterium] | diamond | 2916 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30975387 | 30975387 | PRJNA1108009_P_NODE_13154_length_366_cov_1.139932_g12836_i0 | PRJNA1108009 | 13154 | 366 | 1.139932 | 4.17215112 | Bacteria | 2 | Bacteria | Bacteria | 89.7 | 1.3e-18 | NR | HEU67631.1 | 2053493 | g12836 | i0 | 46.9 | 1.87704918032787 | 113 | 56 | 91.8 | 3 | 30 | 365 | 12 | 121 | HEU67631.1 HYR domain-containing protein [Candidatus Acetothermia bacterium] | diamond | 687 | 89.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Acetothermia bacterium | ||||||
| 30984139 | 30984139 | PRJNA1108009_P_NODE_24834_length_251_cov_0.865169_g24516_i0 | PRJNA1108009 | 24834 | 251 | 0.865169 | 2.17157419 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 126 | 1.97e-32 | NR | MBQ9180838.1 | 2026720 | g24516 | i0 | 71.1 | 2.96414342629482 | 83 | 24 | 99.2 | 0 | 2 | 250 | 333 | 415 | MBQ9180838.1 ATP-binding protein [Candidatus Saccharibacteria bacterium] | diamond | 744 | 126 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31173236 | 31173236 | PRJNA1108009_P_NODE_30415_length_243_cov_0.905882_g30097_i0 | PRJNA1108009 | 30415 | 243 | 0.905882 | 2.20129326 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 112 | 3.16e-28 | NR | MBR2710061.1 | 2026720 | g30097 | i0 | 72.5 | 0.987654320987654 | 80 | 22 | 98.8 | 0 | 241 | 2 | 16 | 95 | MBR2710061.1 glycosyltransferase family 2 protein [Candidatus Saccharibacteria bacterium] | diamond | 240 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31458333 | 31458333 | PRJNA1108009_P_NODE_30736_length_242_cov_0.911243_g30418_i0 | PRJNA1108009 | 30736 | 242 | 0.911243 | 2.20520806 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 163 | 3.47e-46 | NR | MBQ1373367.1 | 2026720 | g30418 | i0 | 98.7 | 2.93801652892562 | 79 | 1 | 97.9 | 0 | 5 | 241 | 380 | 458 | MBQ1373367.1 threonine--tRNA ligase [Candidatus Saccharibacteria bacterium] | diamond | 711 | 163 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31774385 | 31774385 | PRJNA1108009_P_NODE_28057_length_246_cov_0.890173_g27739_i0 | PRJNA1108009 | 28057 | 246 | 0.890173 | 2.18982558 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 142 | 6.62e-41 | NR | MBR3322130.1 | 2026720 | g27739 | i0 | 86.6 | 3 | 82 | 11 | 100 | 0 | 1 | 246 | 73 | 154 | MBR3322130.1 elongation factor Ts [Candidatus Saccharibacteria bacterium] | diamond | 738 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32597081 | 32597081 | PRJNA1108009_P_NODE_21460_length_276_cov_1.192118_g21142_i0 | PRJNA1108009 | 21460 | 276 | 1.192118 | 3.29024568 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 179 | 2.78e-51 | NR | MBQ3474530.1 | 2026720 | g21142 | i0 | 93.4 | 6.92391304347826 | 91 | 6 | 98.9 | 0 | 3 | 275 | 419 | 509 | MBQ3474530.1 threonine--tRNA ligase [Candidatus Saccharibacteria bacterium] | diamond | 1911 | 179 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32597089 | 32597089 | PRJNA1108009_P_NODE_26300_length_249_cov_0.875000_g25982_i0 | PRJNA1108009 | 26300 | 249 | 0.875 | 2.17875 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 118 | 1.0799999999999999e-32 | NR | MBO7720108.1 | 2026720 | g25982 | i0 | 90.5 | 0.759036144578313 | 63 | 6 | 75.9 | 0 | 190 | 2 | 1 | 63 | MBO7720108.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 189 | 118 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32745811 | 32745811 | PRJNA1108009_P_NODE_31380_length_241_cov_0.916667_g31062_i0 | PRJNA1108009 | 31380 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 63.5 | 3.89e-11 | NR | PIX17685.1 | 1974545 | g31062 | i0 | 67.4 | 2.67634854771784 | 43 | 14 | 53.5 | 0 | 239 | 111 | 33 | 75 | PIX17685.1 MAG: hypothetical protein COZ71_01995, partial [Candidatus Desantisbacteria bacterium CG_4_8_14_3_um_filter_40_12] | diamond | 645 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Desantisiibacteriota | Candidatus Desantisbacteria bacterium CG_4_8_14_3_um_filter_40_12 |
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);;