contig_metadata
20 rows where bioproject = "PRJNA934332", tax_phylum = "Acidobacteriota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10184099 | 10184099 | PRJNA934332_P_NODE_10848_length_242_cov_0.911243_g10761_i0 | PRJNA934332 | 10848 | 242 | 0.911243 | 2.20520806 | Terriglobia | 204432 | Bacteria | Bacteria | 145 | 2.86e-39 | NR | MDX1984977.1 | 2212468 | g10761 | i0 | 83.5 | 8.81404958677686 | 79 | 13 | 97.9 | 0 | 237 | 1 | 286 | 364 | MDX1984977.1 alpha-L-fucosidase [Bryobacteraceae bacterium] | diamond | 2133 | 145 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 11114222 | 11114222 | PRJNA934332_P_NODE_10989_length_242_cov_0.911243_g10902_i0 | PRJNA934332 | 10989 | 242 | 0.911243 | 2.20520806 | Candidatus Solibacter usitatus | 332163 | Bacteria | Bacteria | 291 | 4.24e-74 | NTclustered | gi|470468228|ref|NR_076103.1| | 332163 | g10902 | i0 | 88.571 | 109.995867768595 | 245 | 21 | 100 | 7 | 1 | 242 | 2275 | 2035 | Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence | blastn | 26619 | 291 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Solibacter | Candidatus Solibacter usitatus | ||
| 14938513 | 14938513 | PRJNA934332_P_NODE_3172_length_358_cov_1.322807_g3085_i0 | PRJNA934332 | 3172 | 358 | 1.322807 | 4.73564906 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 121 | 1.87e-31 | NR | WP_263414003.1 | 940139 | g3085 | i0 | 72.1 | 6.15921787709497 | 86 | 23 | 72.1 | 1 | 3 | 260 | 157 | 241 | WP_263414003.1 SDR family NAD(P)-dependent oxidoreductase [Terriglobus aquaticus] | diamond | 2205 | 122 | 0.991803278688525 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus aquaticus | ||
| 17832989 | 17832989 | PRJNA934332_P_NODE_9214_length_247_cov_0.885057_g9127_i0 | PRJNA934332 | 9214 | 247 | 0.885057 | 2.18609079 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 138 | 5.38e-36 | NR | MEO5923947.1 | 2212468 | g9127 | i0 | 84 | 1.96761133603239 | 81 | 13 | 98.4 | 0 | 3 | 245 | 224 | 304 | MEO5923947.1 ferrous iron transporter B [Bryobacteraceae bacterium] | diamond | 486 | 138 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 26676440 | 26676440 | PRJNA934332_P_NODE_11061_length_241_cov_1.833333_g10974_i0 | PRJNA934332 | 11061 | 241 | 1.833333 | 4.41833253 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 71.2 | 2.69e-12 | NR | MEO8037012.1 | 1978231 | g10974 | i0 | 63.2 | 0.70954356846473 | 57 | 21 | 71 | 0 | 233 | 63 | 318 | 374 | MEO8037012.1 metallophosphoesterase [Acidobacteriota bacterium] | diamond | 171 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27150953 | 27150953 | PRJNA934332_P_NODE_7662_length_251_cov_0.865169_g7575_i0 | PRJNA934332 | 7662 | 251 | 0.865169 | 2.17157419 | Candidatus Geothrix skivensis | 2954439 | Bacteria | Bacteria | 109 | 1.83e-26 | NR | MBK9796358.1 | 2954439 | g7575 | i0 | 66.3 | 0.956175298804781 | 80 | 27 | 95.6 | 0 | 3 | 242 | 5 | 84 | MBK9796358.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Candidatus Geothrix skivensis] | diamond | 240 | 109 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Candidatus Geothrix skivensis | ||
| 27309644 | 27309644 | PRJNA934332_P_NODE_5823_length_280_cov_1.371981_g5736_i0 | PRJNA934332 | 5823 | 280 | 1.371981 | 3.8415468 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 136 | 1.52e-36 | NR | MCX6622778.1 | 1978231 | g5736 | i0 | 66.3 | 0.985714285714286 | 92 | 31 | 98.6 | 0 | 276 | 1 | 212 | 303 | MCX6622778.1 PfkB family carbohydrate kinase [Acidobacteriota bacterium] | diamond | 276 | 136 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28098784 | 28098784 | PRJNA934332_P_NODE_8485_length_248_cov_2.622857_g8398_i0 | PRJNA934332 | 8485 | 248 | 2.622857 | 6.50468536 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 153 | 3.989999999999999e-41 | NR | MFM2125432.1 | 1978231 | g8398 | i0 | 85.4 | 0.991935483870968 | 82 | 12 | 99.2 | 0 | 2 | 247 | 142 | 223 | MFM2125432.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 246 | 153 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29614086 | 29614086 | PRJNA934332_P_NODE_10770_length_242_cov_0.911243_g10683_i0 | PRJNA934332 | 10770 | 242 | 0.911243 | 2.20520806 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 163 | 3.39e-45 | NR | MBM3793666.1 | 1978231 | g10683 | i0 | 95 | 0.991735537190083 | 80 | 4 | 99.2 | 0 | 241 | 2 | 525 | 604 | MBM3793666.1 DUF1592 domain-containing protein [Acidobacteriota bacterium] | diamond | 240 | 163 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29645569 | 29645569 | PRJNA934332_P_NODE_7750_length_251_cov_0.865169_g7663_i0 | PRJNA934332 | 7750 | 251 | 0.865169 | 2.17157419 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 56.2 | 6.96e-7 | NR | BDC48658.1 | 2802972 | g7663 | i0 | 85.2 | 1.31474103585657 | 27 | 4 | 32.3 | 0 | 251 | 171 | 373 | 399 | BDC48658.1 alpha/beta hydrolase [Bryobacterales bacterium F-183] | diamond | 330 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 30025152 | 30025152 | PRJNA934332_P_NODE_7651_length_251_cov_0.865169_g7564_i0 | PRJNA934332 | 7651 | 251 | 0.865169 | 2.17157419 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 176 | 1.41e-52 | NR | MEI9813295.1 | 1978231 | g7564 | i0 | 91.6 | 0.99203187250996006 | 83 | 7 | 99.2 | 0 | 1 | 249 | 226 | 308 | MEI9813295.1 PQQ-dependent sugar dehydrogenase [Acidobacteriota bacterium] | diamond | 249 | 176 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30158153 | 30158153 | PRJNA934332_P_NODE_10992_length_242_cov_0.911243_g10905_i0 | PRJNA934332 | 10992 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 120 | 5.27e-30 | NR | HZY61483.1 | 1934404 | g10905 | i0 | 65.8 | 17.1074380165289 | 79 | 27 | 97.9 | 0 | 6 | 242 | 161 | 239 | HZY61483.1 glycosyl hydrolase family 39 [Edaphobacter sp.] | diamond | 4140 | 121 | 0.991735537190083 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter sp. | ||
| 30498953 | 30498953 | PRJNA934332_P_NODE_8993_length_247_cov_0.885057_g8906_i0 | PRJNA934332 | 8993 | 247 | 0.885057 | 2.18609079 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 68.6 | 3.23e-11 | NR | MFN7919901.1 | 2212468 | g8906 | i0 | 45.9 | 0.898785425101215 | 74 | 40 | 89.9 | 0 | 222 | 1 | 590 | 663 | MFN7919901.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 222 | 68.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30530407 | 30530407 | PRJNA934332_P_NODE_6473_length_269_cov_1.408163_g6386_i0 | PRJNA934332 | 6473 | 269 | 1.408163 | 3.78795847 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 127 | 6.45e-32 | NR | MCU1329754.1 | 2026791 | g6386 | i0 | 77.5 | 0.992565055762082 | 89 | 20 | 99.3 | 0 | 267 | 1 | 373 | 461 | MCU1329754.1 hypothetical protein [Bryobacterales bacterium] | diamond | 267 | 127 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 30593587 | 30593587 | PRJNA934332_P_NODE_5493_length_286_cov_1.267606_g5406_i0 | PRJNA934332 | 5493 | 286 | 1.267606 | 3.62535316 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 102 | 1.2e-23 | NR | HKQ76392.1 | 2052146 | g5406 | i0 | 54.4 | 0.944055944055944 | 90 | 36 | 94.4 | 1 | 285 | 16 | 47 | 131 | HKQ76392.1 STELLO glycosyltransferase family protein [Blastocatellia bacterium] | diamond | 270 | 102 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 30688348 | 30688348 | PRJNA934332_P_NODE_11453_length_235_cov_2.166667_g11366_i0 | PRJNA934332 | 11453 | 235 | 2.166667 | 5.09166745 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 124 | 4.92e-31 | NR | HUR35195.1 | 2910147 | g11366 | i0 | 81.6 | 1.9531914893617 | 76 | 14 | 97 | 0 | 6 | 233 | 148 | 223 | HUR35195.1 glycosyltransferase family 39 protein [Vicinamibacterales bacterium] | diamond | 459 | 124 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30751761 | 30751761 | PRJNA934332_P_NODE_7954_length_250_cov_0.870056_g7867_i0 | PRJNA934332 | 7954 | 250 | 0.870056 | 2.17514 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 100 | 3.84e-24 | NR | MBI4903934.1 | 1978231 | g7867 | i0 | 68.6 | 1.68 | 70 | 22 | 84 | 0 | 1 | 210 | 142 | 211 | MBI4903934.1 16S rRNA (guanine(527)-N(7))-methyltransferase RsmG [Acidobacteriota bacterium] | diamond | 420 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31700087 | 31700087 | PRJNA934332_P_NODE_5597_length_284_cov_1.440758_g5510_i0 | PRJNA934332 | 5597 | 284 | 1.440758 | 4.09175272 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 68.2 | 6.99e-11 | NR | HEY3161421.1 | 2910147 | g5510 | i0 | 47 | 0.876760563380282 | 83 | 42 | 87.7 | 1 | 255 | 7 | 684 | 764 | HEY3161421.1 Ig-like domain repeat protein [Vicinamibacterales bacterium] | diamond | 249 | 68.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31763312 | 31763312 | PRJNA934332_P_NODE_7557_length_251_cov_0.865169_g7470_i0 | PRJNA934332 | 7557 | 251 | 0.865169 | 2.17157419 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 132 | 6.91e-35 | NR | NDJ14590.1 | 2081523 | g7470 | i0 | 80.7 | 0.99203187250996006 | 83 | 16 | 99.2 | 0 | 250 | 2 | 167 | 249 | NDJ14590.1 arsenical pump-driving ATPase [Terriglobia bacterium] | diamond | 249 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 32522976 | 32522976 | PRJNA934332_P_NODE_9259_length_246_cov_1.456647_g9172_i0 | PRJNA934332 | 9259 | 246 | 1.456647 | 3.58335162 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 60.1 | 2.83e-8 | NR | MBP7678692.1 | 2651171 | g9172 | i0 | 45.8 | 1.01219512195122 | 83 | 34 | 98.8 | 2 | 244 | 2 | 81 | 154 | MBP7678692.1 AAA family ATPase [Thermoanaerobaculia bacterium] | diamond | 249 | 60.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia 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);;