contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA951810" and tax_phylum = "Vulcanimicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6039633 | 6039633 | PRJNA951810_P_NODE_169165_length_243_cov_2.100000_g168820_i0 | PRJNA951810 | 169165 | 243 | 2.1 | 5.103 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 71.2 | 2.83e-12 | NR | HTX52529.1 | 2952909 | g168820 | i0 | 45.7 | 1.72839506172839 | 70 | 38 | 86.4 | 0 | 15 | 224 | 307 | 376 | HTX52529.1 ABC transporter substrate-binding protein [Candidatus Baltobacteraceae bacterium] | diamond | 420 | 71.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 13690176 | 13690176 | PRJNA951810_P_NODE_17211_length_473_cov_4.627500_g16876_i0 | PRJNA951810 | 17211 | 473 | 4.6275 | 21.888075 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 259 | 9.47e-82 | NR | HVO04734.1 | 2952917 | g16876 | i0 | 86.4 | 0.887949260042283 | 140 | 19 | 88.8 | 0 | 54 | 473 | 1 | 140 | HVO04734.1 IS21 family transposase [Candidatus Cybelea sp.] | diamond | 420 | 259 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 22614150 | 22614150 | PRJNA951810_P_NODE_24958_length_402_cov_6.045593_g24617_i0 | PRJNA951810 | 24958 | 402 | 6.045593 | 24.30328386 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 183 | 1.8599999999999995e-55 | NR | HVO04733.1 | 2952917 | g24617 | i0 | 89.8 | 0.73134328358209 | 98 | 10 | 73.1 | 0 | 93 | 386 | 150 | 247 | HVO04733.1 IS21-like element helper ATPase IstB [Candidatus Cybelea sp.] | diamond | 294 | 183 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 25163298 | 25163298 | PRJNA951810_P_NODE_31580_length_356_cov_3.374558_g31238_i0 | PRJNA951810 | 31580 | 356 | 3.374558 | 12.01342648 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 108 | 1.5999999999999998e-25 | NR | HEY5258269.1 | 2952909 | g31238 | i0 | 87.7 | 1.09550561797753 | 65 | 8 | 54.8 | 0 | 2 | 196 | 141 | 205 | HEY5258269.1 type III polyketide synthase [Candidatus Baltobacteraceae bacterium] | diamond | 390 | 108 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 26899300 | 26899300 | PRJNA951810_P_NODE_99521_length_293_cov_3.804545_g99177_i0 | PRJNA951810 | 99521 | 293 | 3.804545 | 11.14731685 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 63.5 | 3.75e-10 | NR | HEY4002982.1 | 3036772 | g99177 | i0 | 54.2 | 0.491467576791809 | 48 | 22 | 49.1 | 0 | 146 | 3 | 57 | 104 | HEY4002982.1 hypothetical protein [Candidatus Xenobia bacterium] | diamond | 144 | 63.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Candidatus Xenobia | Candidatus Xenobia bacterium | |||||
| 27025744 | 27025744 | PRJNA951810_P_NODE_83522_length_299_cov_2.871681_g83178_i0 | PRJNA951810 | 83522 | 299 | 2.871681 | 8.58632619 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 45.8 | 0.00566 | NR | GMU57996.1 | 3036772 | g83178 | i0 | 53.1 | 0.983277591973244 | 49 | 23 | 49.2 | 0 | 150 | 4 | 120 | 168 | GMU57996.1 MAG: hypothetical protein AMXMBFR33_71420 [Candidatus Xenobia bacterium] | diamond | 294 | 45.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Candidatus Xenobia | Candidatus Xenobia bacterium | |||||
| 27278618 | 27278618 | PRJNA951810_P_NODE_170643_length_242_cov_0.911243_g170298_i0 | PRJNA951810 | 170643 | 242 | 0.911243 | 2.20520806 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 111 | 6.190000000000001e-27 | NR | GMU51501.1 | 3036772 | g170298 | i0 | 63.8 | 0.991735537190083 | 80 | 29 | 99.2 | 0 | 2 | 241 | 63 | 142 | GMU51501.1 MAG: hypothetical protein AMXMBFR33_06470 [Candidatus Xenobia bacterium] | diamond | 240 | 111 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Candidatus Xenobia | Candidatus Xenobia bacterium | |||||
| 28005180 | 28005180 | PRJNA951810_P_NODE_88965_length_298_cov_2.804444_g88621_i0 | PRJNA951810 | 88965 | 298 | 2.804444 | 8.35724312 | Candidatus Tumulicola sp. | 3069698 | Bacteria | Bacteria | 79.7 | 5.86e-15 | NR | HEY1682137.1 | 3069698 | g88621 | i0 | 71.7 | 0.463087248322148 | 46 | 13 | 46.3 | 0 | 143 | 6 | 186 | 231 | HEY1682137.1 Fic family protein [Candidatus Tumulicola sp.] | diamond | 138 | 79.7 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Tumulicola | Candidatus Tumulicola sp. | ||
| 28067900 | 28067900 | PRJNA951810_P_NODE_105445_length_289_cov_9.314815_g105101_i0 | PRJNA951810 | 105445 | 289 | 9.314815 | 26.91981535 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 46.2 | 0.00343 | NR | HXC86885.1 | 2952917 | g105101 | i0 | 36.7 | 1.00692041522491 | 49 | 31 | 50.9 | 0 | 288 | 142 | 41 | 89 | HXC86885.1 helix-turn-helix transcriptional regulator [Candidatus Cybelea sp.] | diamond | 291 | 46.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 30057165 | 30057165 | PRJNA951810_P_NODE_27591_length_383_cov_3.112903_g27249_i0 | PRJNA951810 | 27591 | 383 | 3.112903 | 11.92241849 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 56.2 | 3.18e-6 | NR | HTA60658.1 | 2952909 | g27249 | i0 | 50 | 0.908616187989556 | 70 | 30 | 50.9 | 1 | 188 | 382 | 9 | 78 | HTA60658.1 di-heme oxidoredictase family protein [Candidatus Baltobacteraceae bacterium] | diamond | 348 | 56.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 30531185 | 30531185 | PRJNA951810_P_NODE_48353_length_310_cov_6.012658_g48010_i0 | PRJNA951810 | 48353 | 310 | 6.012658 | 18.6392398 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 99 | 1.0100000000000002e-21 | NR | MFA7482372.1 | 3107663 | g48010 | i0 | 90 | 0.483870967741935 | 50 | 5 | 48.4 | 0 | 309 | 160 | 357 | 406 | MFA7482372.1 TIGR00366 family protein [Vulcanimicrobiota bacterium] | diamond | 150 | 99 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 31637359 | 31637359 | PRJNA951810_P_NODE_11896_length_550_cov_14.121593_g11574_i0 | PRJNA951810 | 11896 | 550 | 14.121593 | 77.6687615 | Candidatus Eremiobacteraceae bacterium | 3069296 | Bacteria | Bacteria | 61.2 | 2.28e-7 | NR | HXX16674.1 | 3069296 | g11574 | i0 | 71.4 | 0.229090909090909 | 42 | 12 | 22.9 | 0 | 419 | 544 | 36 | 77 | HXX16674.1 hypothetical protein [Candidatus Eremiobacteraceae bacterium] | diamond | 126 | 61.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Candidatus Eremiobacterales | Candidatus Eremiobacteraceae | Candidatus Eremiobacteraceae bacterium | |||
| 32491895 | 32491895 | PRJNA951810_P_NODE_150439_length_257_cov_8.331522_g150094_i0 | PRJNA951810 | 150439 | 257 | 8.331522 | 21.41201154 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 85.5 | 2.62e-18 | NR | HEY4003029.1 | 3036772 | g150094 | i0 | 55.3 | 0.992217898832685 | 85 | 38 | 99.2 | 0 | 1 | 255 | 26 | 110 | HEY4003029.1 MFS transporter [Candidatus Xenobia bacterium] | diamond | 255 | 85.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Candidatus Xenobia | Candidatus Xenobia bacterium | |||||
| 32744134 | 32744134 | PRJNA951810_P_NODE_162860_length_248_cov_0.880000_g162515_i0 | PRJNA951810 | 162860 | 248 | 0.88 | 2.1824 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 42.7 | 0.039 | NR | HET9096538.1 | 2952909 | g162515 | i0 | 42.3 | 0.629032258064516 | 52 | 29 | 61.7 | 1 | 73 | 225 | 116 | 167 | HET9096538.1 NAD(P)H-hydrate dehydratase [Candidatus Baltobacteraceae bacterium] | diamond | 156 | 42.7 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 32775468 | 32775468 | PRJNA951810_P_NODE_78940_length_299_cov_4.588496_g78596_i0 | PRJNA951810 | 78940 | 299 | 4.588496 | 13.71960304 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 84.3 | 1.71e-16 | NR | HUD46744.1 | 2952909 | g78596 | i0 | 76.5 | 0.511705685618729 | 51 | 11 | 50.2 | 1 | 2 | 151 | 432 | 482 | HUD46744.1 sodium:solute symporter [Candidatus Baltobacteraceae bacterium] | diamond | 153 | 84.3 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 32838315 | 32838315 | PRJNA951810_P_NODE_108520_length_288_cov_1.195349_g108176_i0 | PRJNA951810 | 108520 | 288 | 1.195349 | 3.44260512 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 45.4 | 0.00688 | NR | HLX25562.1 | 2952917 | g108176 | i0 | 47.8 | 0.479166666666667 | 46 | 23 | 46.9 | 1 | 200 | 66 | 360 | 405 | HLX25562.1 peptide ABC transporter substrate-binding protein [Candidatus Cybelea sp.] | diamond | 138 | 45.4 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. |
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);;