contig_metadata
22 rows where bioproject = "PRJNA914897" and tax_phylum = "Chlamydiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26612828 | 26612828 | PRJNA914897_P_NODE_28701_length_297_cov_1.272321_g28277_i0 | PRJNA914897 | 28701 | 297 | 1.272321 | 3.77879337 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 50.1 | 1.75e-4 | NR | NGX50374.1 | 2081524 | g28277 | i0 | 46.2 | 1.08080808080808 | 39 | 21 | 39.4 | 0 | 230 | 114 | 34 | 72 | NGX50374.1 Ribosomal RNA small subunit methyltransferase B [Chlamydiota bacterium] | diamond | 321 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 26968545 | 26968545 | PRJNA914897_P_NODE_3902_length_1013_cov_42.043617_g3615_i0 | PRJNA914897 | 3902 | 1013 | 42.043617 | 425.90184021 | root | 1 | Root_unresolved | Root_unresolved | 257 | 2.5399999999999992e-81 | NR | MCB1084310.1 | 34094 | g3615 | i0 | 74.4 | 2.25370187561698 | 172 | 44 | 50.9 | 0 | 277 | 792 | 1 | 172 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 2283 | 257 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 28951138 | 28951138 | PRJNA914897_P_NODE_12408_length_519_cov_21.183857_g11988_i0 | PRJNA914897 | 12408 | 519 | 21.183857 | 109.94421783 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 219 | 3.5600000000000004e-70 | NR | MCP5470420.1 | 2047757 | g11988 | i0 | 81.6 | 0.84971098265896 | 147 | 26 | 85 | 1 | 511 | 71 | 1 | 146 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 441 | 219 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29077367 | 29077367 | PRJNA914897_P_NODE_19788_length_382_cov_0.854369_g19366_i0 | PRJNA914897 | 19788 | 382 | 0.854369 | 3.26368958 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 52 | 6.54e-5 | NR | HSW73303.1 | 2047757 | g19366 | i0 | 27.3 | 0.863874345549738 | 110 | 70 | 78.5 | 2 | 78 | 377 | 97 | 206 | HSW73303.1 thioredoxin [Chlamydiales bacterium] | diamond | 330 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29519250 | 29519250 | PRJNA914897_P_NODE_5370_length_860_cov_1.850064_g5017_i0 | PRJNA914897 | 5370 | 860 | 1.850064 | 15.9105504 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 91.7 | 4.79e-17 | NR | MCB1180650.1 | 2052156 | g5017 | i0 | 62.7 | 0.962790697674419 | 67 | 25 | 23.4 | 0 | 322 | 122 | 259 | 325 | MCB1180650.1 RsmB/NOP family class I SAM-dependent RNA methyltransferase [Chlamydiia bacterium] | diamond | 828 | 91.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 29550659 | 29550659 | PRJNA914897_P_NODE_38270_length_248_cov_1.085714_g37846_i0 | PRJNA914897 | 38270 | 248 | 1.085714 | 2.69257072 | Candidatus Amphrikana amoebophyrae | 3076870 | Bacteria | Bacteria | 59.3 | 3.96e-8 | NR | MDN3504671.1 | 3076870 | g37846 | i0 | 50.9 | 1.39112903225806 | 57 | 27 | 67.7 | 1 | 58 | 225 | 91 | 147 | MDN3504671.1 glycosyltransferase family 2 protein [Candidatus Amphrikana amoebophyrae] | diamond | 345 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Candidatus Amphrikana | Candidatus Amphrikana amoebophyrae | |
| 29582096 | 29582096 | PRJNA914897_P_NODE_8130_length_677_cov_8.374172_g7727_i0 | PRJNA914897 | 8130 | 677 | 8.374172 | 56.69314444 | Simkania sp. | 34094 | Bacteria | Bacteria | 56.2 | 9.08e-7 | NR | MCB1084365.1 | 34094 | g7727 | i0 | 50 | 0.221565731166913 | 50 | 25 | 22.2 | 0 | 110 | 259 | 26 | 75 | MCB1084365.1 hypothetical protein [Simkania sp.] | diamond | 150 | 56.2 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 29613616 | 29613616 | PRJNA914897_P_NODE_29750_length_289_cov_4.453704_g29326_i0 | PRJNA914897 | 29750 | 289 | 4.453704 | 12.87120456 | Simkania sp. | 34094 | Bacteria | Bacteria | 46.2 | 0.00169 | NR | MCB1084323.1 | 34094 | g29326 | i0 | 73.9 | 0.487889273356401 | 23 | 6 | 23.9 | 0 | 131 | 63 | 91 | 113 | MCB1084323.1 AMP-binding protein [Simkania sp.] | diamond | 141 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 29708296 | 29708296 | PRJNA914897_P_NODE_14230_length_475_cov_25.594527_g13808_i0 | PRJNA914897 | 14230 | 475 | 25.594527 | 121.57400325 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 223 | 8.78e-72 | NR | MCP5470420.1 | 2047757 | g13808 | i0 | 78.8 | 0.985263157894737 | 156 | 33 | 98.5 | 0 | 5 | 472 | 1 | 156 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 468 | 223 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29779189 | 29779189 | PRJNA914897_P_NODE_41991_length_242_cov_0.911243_g41567_i0 | PRJNA914897 | 41991 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 85.9 | 1.86e-17 | NR | OGN59706.1 | 1797601 | g41567 | i0 | 56.2 | 1.82231404958678 | 73 | 32 | 90.5 | 0 | 2 | 220 | 324 | 396 | OGN59706.1 MAG: hypothetical protein A3F40_04550 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8] | diamond | 441 | 85.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8 | |||||
| 30150685 | 30150685 | PRJNA914897_P_NODE_22872_length_347_cov_1.105839_g22448_i0 | PRJNA914897 | 22872 | 347 | 1.105839 | 3.83726133 | Parachlamydia sp. | 2052048 | Bacteria | Bacteria | 72.4 | 9.98e-13 | NR | MCE2982696.1 | 2052048 | g22448 | i0 | 50.7 | 4.90201729106628 | 71 | 25 | 57.1 | 3 | 149 | 346 | 156 | 221 | MCE2982696.1 DNA alkylation repair protein [Parachlamydia sp.] | diamond | 1701 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 30341044 | 30341044 | PRJNA914897_P_NODE_4172_length_980_cov_9.647189_g3870_i0 | PRJNA914897 | 4172 | 980 | 9.647189 | 94.5424522 | Simkania sp. | 34094 | Bacteria | Bacteria | 256 | 7.03e-81 | NR | MCB1084310.1 | 34094 | g3870 | i0 | 73.3 | 0.52653061224489806 | 172 | 46 | 52.7 | 0 | 699 | 184 | 1 | 172 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 516 | 256 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 31035919 | 31035919 | PRJNA914897_P_NODE_22695_length_348_cov_2.767273_g22271_i0 | PRJNA914897 | 22695 | 348 | 2.767273 | 9.63011004 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 72 | 7.77e-14 | NR | MCP5470423.1 | 2047757 | g22271 | i0 | 81 | 0.362068965517241 | 42 | 8 | 36.2 | 0 | 329 | 204 | 1 | 42 | MCP5470423.1 DUF2039 domain-containing protein [Chlamydiales bacterium] | diamond | 126 | 72 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 31067379 | 31067379 | PRJNA914897_P_NODE_14675_length_466_cov_1.582697_g14253_i0 | PRJNA914897 | 14675 | 466 | 1.582697 | 7.37536802 | Candidatus Amphrikana amoebophyrae | 3076870 | Bacteria | Bacteria | 50.4 | 5.99e-4 | NR | MDN3504659.1 | 3076870 | g14253 | i0 | 55.3 | 1.15236051502146 | 47 | 18 | 29.6 | 2 | 277 | 414 | 50 | 94 | MDN3504659.1 glycosyltransferase family A protein [Candidatus Amphrikana amoebophyrae] | diamond | 537 | 50.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Candidatus Amphrikana | Candidatus Amphrikana amoebophyrae | |
| 31699693 | 31699693 | PRJNA914897_P_NODE_17277_length_417_cov_1.912791_g16855_i0 | PRJNA914897 | 17277 | 417 | 1.912791 | 7.97633847 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 77.4 | 1.84e-13 | NR | HSX03456.1 | 2047756 | g16855 | i0 | 51.2 | 1.26618705035971 | 84 | 36 | 59.7 | 3 | 275 | 27 | 44 | 123 | HSX03456.1 glycosyltransferase family A protein [Rhabdochlamydiaceae bacterium] | diamond | 528 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 31699709 | 31699709 | PRJNA914897_P_NODE_3117_length_1118_cov_9.470813_g2863_i0 | PRJNA914897 | 3117 | 1118 | 9.470813 | 105.88368934 | Chlamydiales bacterium SCGC AG-11 | 2047757 | Bacteria | Bacteria | 48.9 | 0.0288 | NR | SCA63082.1 | 1871324 | g2863 | i0 | 30.3 | 0.238819320214669 | 89 | 54 | 21.7 | 1 | 628 | 870 | 259 | 347 | SCA63082.1 Uncharacterized protein SCG7109_AH_00380 [Chlamydiales bacterium SCGC AG-110-M15] | diamond | 267 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium SCGC AG-110-M15 | |||
| 32015988 | 32015988 | PRJNA914897_P_NODE_7338_length_720_cov_3.996909_g6947_i0 | PRJNA914897 | 7338 | 720 | 3.996909 | 28.7777448 | Parachlamydia sp. | 2052048 | Bacteria | Bacteria | 47 | 0.0441 | NR | MCE5316929.1 | 2052048 | g6947 | i0 | 57.6 | 0.1375 | 33 | 14 | 13.8 | 0 | 518 | 420 | 220 | 252 | MCE5316929.1 C78 family peptidase [Parachlamydia sp.] | diamond | 99 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 32174435 | 32174435 | PRJNA914897_P_NODE_36218_length_252_cov_1.625698_g35794_i0 | PRJNA914897 | 36218 | 252 | 1.625698 | 4.09675896 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 43.5 | 0.0215 | NR | MDF2577682.1 | 2047757 | g35794 | i0 | 36.9 | 0.773809523809524 | 65 | 36 | 75 | 2 | 17 | 205 | 144 | 205 | MDF2577682.1 hypothetical protein [Chlamydiales bacterium] | diamond | 195 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 32237798 | 32237798 | PRJNA914897_P_NODE_10538_length_577_cov_2.190476_g10120_i0 | PRJNA914897 | 10538 | 577 | 2.190476 | 12.63904652 | Simkania sp. | 34094 | Bacteria | Bacteria | 68.6 | 1.88e-10 | NR | MCB1084431.1 | 34094 | g10120 | i0 | 45.1 | 0.369150779896014 | 71 | 39 | 36.9 | 0 | 413 | 201 | 55 | 125 | MCB1084431.1 hypothetical protein [Simkania sp.] | diamond | 213 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 32237808 | 32237808 | PRJNA914897_P_NODE_22158_length_354_cov_1.099644_g21734_i0 | PRJNA914897 | 22158 | 354 | 1.099644 | 3.89273976 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 69.7 | 6.2e-13 | NR | MCP5470428.1 | 2047757 | g21734 | i0 | 47.9 | 0.601694915254237 | 71 | 36 | 59.3 | 1 | 349 | 140 | 1 | 71 | MCP5470428.1 hypothetical protein [Chlamydiales bacterium] | diamond | 213 | 69.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 32743003 | 32743003 | PRJNA914897_P_NODE_15000_length_459_cov_6.971503_g14578_i0 | PRJNA914897 | 15000 | 459 | 6.971503 | 31.99919877 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 111 | 7.58e-28 | NR | MCP5470420.1 | 2047757 | g14578 | i0 | 49.2 | 1.59477124183007 | 124 | 62 | 80.4 | 1 | 459 | 91 | 1 | 124 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 732 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 32743020 | 32743020 | PRJNA914897_P_NODE_34400_length_263_cov_1.115789_g33976_i0 | PRJNA914897 | 34400 | 263 | 1.115789 | 2.93452507 | Simkania sp. | 34094 | Bacteria | Bacteria | 70.5 | 6.49e-13 | NR | MCB1084323.1 | 34094 | g33976 | i0 | 69 | 1.6425855513308 | 42 | 13 | 47.9 | 0 | 131 | 256 | 81 | 122 | MCB1084323.1 AMP-binding protein [Simkania sp.] | diamond | 432 | 70.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania 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);;