contig_metadata
16 rows where bioproject = "PRJNA615175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6973313 | 6973313 | PRJNA615175_P_NODE_20926_length_302_cov_5.427948_g20758_i0 | PRJNA615175 | 20926 | 302 | 5.427948 | 16.39240296 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 147 | 1.25e-30 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g20758 | i0 | 96.591 | 27.1953642384106 | 88 | 3 | 29 | 0 | 206 | 293 | 658956 | 659043 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 8213 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 6973325 | 6973325 | PRJNA615175_P_NODE_2146_length_1046_cov_1.410072_g2029_i0 | PRJNA615175 | 2146 | 1046 | 1.410072 | 14.74935312 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 248 | 3.87e-73 | NR | HYD18620.1 | 2052139 | g2029 | i0 | 61.2 | 1.04971319311663 | 183 | 70 | 52.5 | 1 | 496 | 1044 | 1 | 182 | HYD18620.1 malto-oligosyltrehalose trehalohydrolase [Patescibacteria group bacterium] | diamond | 1098 | 248 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 15897789 | 15897789 | PRJNA615175_P_NODE_21533_length_297_cov_2.669643_g21365_i0 | PRJNA615175 | 21533 | 297 | 2.669643 | 7.92883971 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 179 | 5.939999999999999e-55 | NR | MBI3889290.1 | 2026720 | g21365 | i0 | 90.6 | 0.96969696969697 | 96 | 9 | 97 | 0 | 288 | 1 | 1 | 96 | MBI3889290.1 50S ribosomal protein L4 [Candidatus Saccharibacteria bacterium] | diamond | 288 | 179 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 22827189 | 22827189 | PRJNA615175_P_NODE_26458_length_260_cov_1.647059_g26290_i0 | PRJNA615175 | 26458 | 260 | 1.647059 | 4.2823534 | Bacteria | 2 | Bacteria | Bacteria | 414 | 2.62e-111 | NTclustered | gi|1958075319|gb|CP064995.1| | 2026720 | g26290 | i0 | 95.385 | 284.646153846154 | 260 | 12 | 100 | 0 | 1 | 260 | 692980 | 692721 | Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome | blastn | 74008 | 414 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 23547373 | 23547373 | PRJNA615175_P_NODE_18919_length_320_cov_4.020243_g18751_i0 | PRJNA615175 | 18919 | 320 | 4.020243 | 12.8647776 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 198 | 8.82e-59 | NR | OYX53424.1 | 1970481 | g18751 | i0 | 98.1 | 5.9625 | 106 | 2 | 99.4 | 0 | 320 | 3 | 315 | 420 | OYX53424.1 MAG: F0F1 ATP synthase subunit alpha [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 1908 | 198 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 23547737 | 23547737 | PRJNA615175_P_NODE_6199_length_613_cov_2.251852_g6034_i0 | PRJNA615175 | 6199 | 613 | 2.251852 | 13.80385276 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 85.9 | 4.66e-17 | NR | MCX7778977.1 | 2052139 | g6034 | i0 | 44.4 | 1.30668841761827 | 117 | 62 | 57.3 | 1 | 214 | 564 | 63 | 176 | MCX7778977.1 50S ribosomal protein L6 [Patescibacteria group bacterium] | diamond | 801 | 85.9 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27143127 | 27143127 | PRJNA615175_P_NODE_5202_length_675_cov_4.300664_g5039_i0 | PRJNA615175 | 5202 | 675 | 4.300664 | 29.029482 | Candidatus Muiribacterium halophilum | 2053465 | Bacteria | Bacteria | 94 | 4.79e-18 | NR | MCK9476368.1 | 2053465 | g5039 | i0 | 49.5 | 0.422222222222222 | 95 | 45 | 42.2 | 1 | 84 | 368 | 889 | 980 | MCK9476368.1 hypothetical protein [Candidatus Muiribacterium halophilum] | diamond | 285 | 94 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Muiribacteriota | Candidatus Muiribacteriia | Candidatus Muiribacteriaceae | Candidatus Muiribacterium | Candidatus Muiribacterium halophilum | |||
| 27396557 | 27396557 | PRJNA615175_P_NODE_3103_length_883_cov_2.201235_g2966_i0 | PRJNA615175 | 3103 | 883 | 2.201235 | 19.43690505 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 437 | 2.709999999999999e-150 | NR | OYX53317.1 | 1970481 | g2966 | i0 | 86.3 | 0.845979614949037 | 249 | 34 | 84.6 | 0 | 136 | 882 | 33 | 281 | OYX53317.1 MAG: UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 747 | 437 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 28154357 | 28154357 | PRJNA615175_P_NODE_12805_length_399_cov_1.754601_g12637_i0 | PRJNA615175 | 12805 | 399 | 1.754601 | 7.00085799 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 45.8 | 0.00634 | NR | MFA6536845.1 | 2052139 | g12637 | i0 | 42.4 | 1.01503759398496 | 59 | 33 | 44.4 | 1 | 82 | 258 | 76 | 133 | MFA6536845.1 GNAT family N-acetyltransferase [Patescibacteria group bacterium] | diamond | 405 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28154364 | 28154364 | PRJNA615175_P_NODE_3565_length_822_cov_4.384513_g3417_i0 | PRJNA615175 | 3565 | 822 | 4.384513 | 36.04069686 | Candidatus Muiribacterium halophilum | 2053465 | Bacteria | Bacteria | 252 | 1.55e-76 | NR | MCK9477009.1 | 2053465 | g3417 | i0 | 53.3 | 1.77372262773723 | 227 | 104 | 82.1 | 2 | 694 | 20 | 246 | 472 | MCK9477009.1 hypothetical protein [Candidatus Muiribacterium halophilum] | diamond | 1458 | 252 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Muiribacteriota | Candidatus Muiribacteriia | Candidatus Muiribacteriaceae | Candidatus Muiribacterium | Candidatus Muiribacterium halophilum | |||
| 29133119 | 29133119 | PRJNA615175_P_NODE_12169_length_412_cov_1.539823_g12001_i0 | PRJNA615175 | 12169 | 412 | 1.539823 | 6.34407076 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 208 | 7.099999999999999e-62 | NR | NCU37721.1 | 2026720 | g12001 | i0 | 70.6 | 0.990291262135922 | 136 | 39 | 99 | 1 | 3 | 410 | 220 | 354 | NCU37721.1 DUF3459 domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 408 | 208 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29606176 | 29606176 | PRJNA615175_P_NODE_14510_length_372_cov_2.575251_g14342_i0 | PRJNA615175 | 14510 | 372 | 2.575251 | 9.57993372 | Candidatus Spechtbacterales bacterium | 3085100 | Bacteria | Bacteria | 72.8 | 4.96e-13 | NR | MDX1608196.1 | 3085100 | g14342 | i0 | 44.4 | 0.580645161290323 | 72 | 39 | 58.1 | 1 | 3 | 218 | 115 | 185 | MDX1608196.1 thymidine kinase [Candidatus Spechtbacterales bacterium] | diamond | 216 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Candidatus Spechtbacterales | Candidatus Spechtbacterales bacterium | |||||
| 30491102 | 30491102 | PRJNA615175_P_NODE_4673_length_716_cov_2.581649_g4513_i0 | PRJNA615175 | 4673 | 716 | 2.581649 | 18.48460684 | candidate division TM6 bacterium GW2 | 95901 | Bacteria | Bacteria | 186 | 1.65e-54 | NR | KKP52874.1 | 1619080 | g4513 | i0 | 71.1 | 0.536312849162011 | 128 | 37 | 53.6 | 0 | 5 | 388 | 153 | 280 | KKP52874.1 MAG: hypothetical protein UR43_C0009G0006 [candidate division TM6 bacterium GW2011_GWF2_33_332] | diamond | 384 | 186 | 1 | Bacteria | Bacteria candidate phyla | candidate division TM6 bacterium GW2011_GWF2_33_332 | |||||||
| 30598697 | 30598697 | PRJNA615175_P_NODE_35533_length_241_cov_0.916667_g35365_i0 | PRJNA615175 | 35533 | 241 | 0.916667 | 2.20916747 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 90.1 | 7.03e-19 | NR | PKO16528.1 | 2013722 | g35365 | i0 | 57.4 | 1.70539419087137 | 68 | 29 | 84.6 | 0 | 240 | 37 | 226 | 293 | PKO16528.1 MAG: insulinase family protein [candidate division BRC1 bacterium HGW-BRC1-1] | diamond | 411 | 90.5 | 0.995580110497237 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | candidate division BRC1 bacterium HGW-BRC1-1 | ||||||
| 30965131 | 30965131 | PRJNA615175_P_NODE_19154_length_318_cov_2.889796_g18986_i0 | PRJNA615175 | 19154 | 318 | 2.889796 | 9.18955128 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 85.1 | 1.24e-17 | NR | MFO0882336.1 | 2973664 | g18986 | i0 | 54.4 | 0.641509433962264 | 68 | 31 | 64.2 | 0 | 209 | 6 | 54 | 121 | MFO0882336.1 NUDIX domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 204 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 31881864 | 31881864 | PRJNA615175_P_NODE_13197_length_392_cov_2.686520_g13029_i0 | PRJNA615175 | 13197 | 392 | 2.68652 | 10.5311584 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 59.7 | 1.67e-7 | NR | MFA5025123.1 | 2053613 | g13029 | i0 | 36.2 | 2.70918367346939 | 127 | 65 | 87.2 | 5 | 365 | 24 | 60 | 183 | MFA5025123.1 PcfJ domain-containing protein [Candidatus Shapirobacteria bacterium] | diamond | 1062 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria 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);;