contig_metadata
22 rows where bioproject = "PRJNA700095", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1959149 | 1959149 | PRJNA700095_P_NODE_25882_length_337_cov_2.159091_g24618_i0 | PRJNA700095 | 25882 | 337 | 2.159091 | 7.27613667 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 154 | 8.47e-33 | NTclustered | gi|76574292|gb|DQ139440.1| | 171953 | g24618 | i0 | 76.689 | 135.237388724036 | 296 | 58 | 86 | 11 | 47 | 337 | 304 | 15 | Uncultured Acidobacteria bacterium clone CAL7 23S ribosomal RNA gene, partial sequence | blastn | 45575 | 154 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 3234335 | 3234335 | PRJNA700095_P_NODE_69123_length_227_cov_2.532468_g67858_i0 | PRJNA700095 | 69123 | 227 | 2.532468 | 5.74870236 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 398 | 2.25e-106 | NTclustered | gi|112980866|gb|DQ829670.1| | 171953 | g67858 | i0 | 98.238 | 100.969162995595 | 227 | 4 | 100 | 0 | 1 | 227 | 549 | 323 | Uncultured Acidobacteria bacterium clone DON12 23S ribosomal RNA gene, partial sequence | blastn | 22920 | 398 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 4511263 | 4511263 | PRJNA700095_P_NODE_43724_length_266_cov_4.720207_g42460_i0 | PRJNA700095 | 43724 | 266 | 4.720207 | 12.55575062 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 291 | 4.74e-74 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g42460 | i0 | 86.415 | 170.214285714286 | 265 | 36 | 99 | 0 | 2 | 266 | 3559018 | 3559282 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 45277 | 291 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 8336453 | 8336453 | PRJNA700095_P_NODE_51207_length_251_cov_1.370787_g49943_i0 | PRJNA700095 | 51207 | 251 | 1.370787 | 3.44067537 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 433 | 6.95e-117 | NTclustered | gi|389545423|gb|JQ400351.1| | 171953 | g49943 | i0 | 98.374 | 98.2350597609562 | 246 | 4 | 98 | 0 | 3 | 248 | 212 | 457 | Uncultured Acidobacteria bacterium clone CNY_00167 16S ribosomal RNA gene, partial sequence | blastn | 24657 | 433 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 14712209 | 14712209 | PRJNA700095_P_NODE_40352_length_275_cov_1.366337_g39088_i0 | PRJNA700095 | 40352 | 275 | 1.366337 | 3.75742675 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 412 | 1.0099999999999997e-110 | NTclustered | gi|341941922|gb|JN225540.1| | 171953 | g39088 | i0 | 93.818 | 100.887272727273 | 275 | 16 | 100 | 1 | 1 | 275 | 315 | 588 | Uncultured Acidobacteria bacterium clone GSY-XJ5 16S ribosomal RNA gene, partial sequence | blastn | 27744 | 412 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 25410720 | 25410720 | PRJNA700095_P_NODE_26240_length_334_cov_4.114943_g24976_i0 | PRJNA700095 | 26240 | 334 | 4.114943 | 13.74390962 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 157 | 7.14e-46 | NR | HEX8853696.1 | 2283092 | g24976 | i0 | 62.2 | 12.9251497005988 | 111 | 42 | 99.7 | 0 | 2 | 334 | 70 | 180 | HEX8853696.1 uridine kinase [Pyrinomonadaceae bacterium] | diamond | 4317 | 157 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27051219 | 27051219 | PRJNA700095_P_NODE_43202_length_268_cov_1.328205_g41938_i0 | PRJNA700095 | 43202 | 268 | 1.328205 | 3.5595894 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 50.4 | 9.7e-5 | NR | HEV2494198.1 | 2081523 | g41938 | i0 | 38 | 4.89179104477612 | 92 | 49 | 97.4 | 3 | 3 | 263 | 482 | 570 | HEV2494198.1 hypothetical protein [Terriglobia bacterium] | diamond | 1311 | 50.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 28440912 | 28440912 | PRJNA700095_P_NODE_32446_length_299_cov_5.632743_g31182_i0 | PRJNA700095 | 32446 | 299 | 5.632743 | 16.84190157 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 99.4 | 7.71e-24 | NR | HKD78720.1 | 2976921 | g31182 | i0 | 47.3 | 3.77257525083612 | 93 | 47 | 93.3 | 1 | 289 | 11 | 54 | 144 | HKD78720.1 nuclear transport factor 2 family protein [Candidatus Angelobacter sp.] | diamond | 1128 | 99.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 28472458 | 28472458 | PRJNA700095_P_NODE_22586_length_366_cov_2.194539_g21322_i0 | PRJNA700095 | 22586 | 366 | 2.194539 | 8.03201274 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 53.9 | 1.65e-5 | NR | MEZ5292908.1 | 2910147 | g21322 | i0 | 61.8 | 0.278688524590164 | 34 | 13 | 27.9 | 0 | 4 | 105 | 160 | 193 | MEZ5292908.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 102 | 53.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28503904 | 28503904 | PRJNA700095_P_NODE_2987_length_1125_cov_3.514259_g2252_i0 | PRJNA700095 | 2987 | 1125 | 3.514259 | 39.53541375 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 95.9 | 1.1e-19 | NR | MEZ5292909.1 | 2910147 | g2252 | i0 | 37.7 | 0.368 | 138 | 84 | 36.8 | 2 | 910 | 497 | 22 | 157 | MEZ5292909.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 414 | 95.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28724932 | 28724932 | PRJNA700095_P_NODE_19467_length_402_cov_1.647416_g18204_i0 | PRJNA700095 | 19467 | 402 | 1.647416 | 6.62261232 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 64.3 | 3.34e-9 | NR | MCX6550006.1 | 1978231 | g18204 | i0 | 30.4 | 1.86567164179104 | 125 | 82 | 90.3 | 2 | 402 | 40 | 44 | 167 | MCX6550006.1 GDSL-type esterase/lipase family protein [Acidobacteriota bacterium] | diamond | 750 | 64.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29009481 | 29009481 | PRJNA700095_P_NODE_38308_length_280_cov_1.487923_g37044_i0 | PRJNA700095 | 38308 | 280 | 1.487923 | 4.1661844 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 79 | 9.15e-17 | NR | MCY7346640.1 | 2283092 | g37044 | i0 | 92.3 | 1.67142857142857 | 39 | 3 | 41.8 | 0 | 117 | 1 | 1 | 39 | MCY7346640.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 468 | 79 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29419420 | 29419420 | PRJNA700095_P_NODE_66909_length_237_cov_2.091463_g65645_i0 | PRJNA700095 | 66909 | 237 | 2.091463 | 4.95676731 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 90.1 | 7.07e-19 | NR | NOT25580.1 | 1978231 | g65645 | i0 | 58.4 | 1.94936708860759 | 77 | 29 | 97.5 | 2 | 3 | 233 | 45 | 118 | NOT25580.1 PAS domain S-box protein [Acidobacteriota bacterium] | diamond | 462 | 90.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29482459 | 29482459 | PRJNA700095_P_NODE_25230_length_342_cov_1.940520_g23966_i0 | PRJNA700095 | 25230 | 342 | 1.94052 | 6.6365784 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 49.7 | 4.04e-4 | NR | HEY7339111.1 | 2212468 | g23966 | i0 | 55 | 0.350877192982456 | 40 | 18 | 35.1 | 0 | 159 | 278 | 400 | 439 | HEY7339111.1 ankyrin repeat domain-containing protein [Bryobacteraceae bacterium] | diamond | 120 | 49.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30177462 | 30177462 | PRJNA700095_P_NODE_53332_length_249_cov_1.488636_g52068_i0 | PRJNA700095 | 53332 | 249 | 1.488636 | 3.70670364 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 43.9 | 0.0144 | NR | MCZ2156184.1 | 2026791 | g52068 | i0 | 35.5 | 0.746987951807229 | 62 | 40 | 74.7 | 0 | 15 | 200 | 230 | 291 | MCZ2156184.1 AAA family ATPase [Bryobacterales bacterium] | diamond | 186 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 30272623 | 30272623 | PRJNA700095_P_NODE_53512_length_249_cov_0.875000_g52248_i0 | PRJNA700095 | 53512 | 249 | 0.875 | 2.17875 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 43.5 | 0.0223 | NR | HUD98818.1 | 2212468 | g52248 | i0 | 42.9 | 0.674698795180723 | 56 | 26 | 67.5 | 1 | 231 | 64 | 209 | 258 | HUD98818.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 168 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30619802 | 30619802 | PRJNA700095_P_NODE_30993_length_307_cov_2.739316_g29729_i0 | PRJNA700095 | 30993 | 307 | 2.739316 | 8.40970012 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 59.7 | 3.11e-8 | NR | HTA80186.1 | 1964191 | g29729 | i0 | 42.9 | 0.684039087947883 | 70 | 37 | 68.4 | 1 | 210 | 1 | 6 | 72 | HTA80186.1 hypothetical protein [Terracidiphilus sp.] | diamond | 210 | 59.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 31410022 | 31410022 | PRJNA700095_P_NODE_33476_length_295_cov_1.346847_g32212_i0 | PRJNA700095 | 33476 | 295 | 1.346847 | 3.97319865 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 43.9 | 0.0262 | NR | HET6959490.1 | 2910147 | g32212 | i0 | 37.5 | 0.732203389830508 | 72 | 39 | 73.2 | 2 | 239 | 24 | 67 | 132 | HET6959490.1 type VI secretion system baseplate subunit TssF [Vicinamibacterales bacterium] | diamond | 216 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31789289 | 31789289 | PRJNA700095_P_NODE_28617_length_318_cov_1.461224_g27353_i0 | PRJNA700095 | 28617 | 318 | 1.461224 | 4.64669232 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 50.8 | 1.02e-4 | NR | MCX6550006.1 | 1978231 | g27353 | i0 | 31.1 | 0.971698113207547 | 103 | 65 | 92.5 | 2 | 316 | 23 | 51 | 152 | MCX6550006.1 GDSL-type esterase/lipase family protein [Acidobacteriota bacterium] | diamond | 309 | 50.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31916052 | 31916052 | PRJNA700095_P_NODE_7557_length_722_cov_3.964561_g6412_i0 | PRJNA700095 | 7557 | 722 | 3.964561 | 28.62413042 | Holophaga sp. | 2582906 | Bacteria | Bacteria | 95.9 | 8.050000000000001e-21 | NR | HPS68479.1 | 2582906 | g6412 | i0 | 45.9 | 2.7382271468144 | 111 | 58 | 45.7 | 2 | 350 | 679 | 42 | 151 | HPS68479.1 Hsp20/alpha crystallin family protein [Holophaga sp.] | diamond | 1977 | 95.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophaga | Holophaga sp. | ||
| 31947533 | 31947533 | PRJNA700095_P_NODE_15797_length_462_cov_1.185090_g14535_i0 | PRJNA700095 | 15797 | 462 | 1.18509 | 5.4751158 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 50.8 | 5.6e-4 | NR | HEX4961659.1 | 2651171 | g14535 | i0 | 48.8 | 0.279220779220779 | 43 | 22 | 27.9 | 0 | 456 | 328 | 586 | 628 | HEX4961659.1 serine/threonine-protein kinase [Thermoanaerobaculia bacterium] | diamond | 129 | 50.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 32454220 | 32454220 | PRJNA700095_P_NODE_48239_length_257_cov_1.516304_g46975_i0 | PRJNA700095 | 48239 | 257 | 1.516304 | 3.89690128 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 48.5 | 4.16e-4 | NR | MBI4752540.1 | 1978231 | g46975 | i0 | 39.1 | 4.24902723735409 | 64 | 38 | 73.5 | 1 | 9 | 197 | 543 | 606 | MBI4752540.1 IPT/TIG domain-containing protein [Acidobacteriota bacterium] | diamond | 1092 | 48.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;