contig_metadata
20 rows where bioproject = "PRJNA421571", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4250240 | 4250240 | PRJNA421571_P_NODE_47604_length_406_cov_1.156156_g45056_i0 | PRJNA421571 | 47604 | 406 | 1.156156 | 4.69399336 | Bacteria | 2 | Bacteria | Bacteria | 174 | 6.08e-52 | NR | MBM3126526.1 | 2026724 | g45056 | i0 | 64.8 | 24.7019704433498 | 128 | 45 | 94.6 | 0 | 2 | 385 | 117 | 244 | MBM3126526.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Chloroflexota bacterium] | diamond | 10029 | 174 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 6802147 | 6802147 | PRJNA421571_P_NODE_93926_length_250_cov_0.870056_g91377_i0 | PRJNA421571 | 93926 | 250 | 0.870056 | 2.17514 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 108 | 4.76e-19 | NTclustered | gi|2621702714|emb|OY759598.1| | 2026734 | g91377 | i0 | 86.598 | 22.012 | 97 | 13 | 39 | 0 | 6 | 102 | 2944742 | 2944646 | MAG: Dehalococcoidia bacterium isolate 9e3974e8-1b76-4a2a-ace1-a6b9f67a3735 genome assembly, chromosome: 1 | blastn | 5503 | 108 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 15725828 | 15725828 | PRJNA421571_P_NODE_47313_length_408_cov_0.919403_g44765_i0 | PRJNA421571 | 47313 | 408 | 0.919403 | 3.75116424 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 279 | 1.65e-70 | NTclustered | gi|2874253741|emb|OY969584.1| | 1672391 | g44765 | i0 | 79.327 | 55.2990196078431 | 416 | 72 | 100 | 11 | 1 | 408 | 1350495 | 1350086 | MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1 | blastn | 22562 | 279 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 26775892 | 26775892 | PRJNA421571_P_NODE_89161_length_256_cov_1.628415_g86612_i0 | PRJNA421571 | 89161 | 256 | 1.628415 | 4.1687424 | Bacteria | 2 | Bacteria | Bacteria | 47 | 0.00144 | NR | MEO8469375.1 | 2026724 | g86612 | i0 | 42.9 | 2.19140625 | 77 | 37 | 89.1 | 3 | 5 | 232 | 102 | 172 | MEO8469375.1 adenylate/guanylate cyclase domain-containing protein [Chloroflexota bacterium] | diamond | 561 | 47 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27170252 | 27170252 | PRJNA421571_P_NODE_73742_length_292_cov_1.945205_g71193_i0 | PRJNA421571 | 73742 | 292 | 1.945205 | 5.6799986 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 47.4 | 0.00154 | NR | MBN1430334.1 | 2052143 | g71193 | i0 | 28.7 | 0.893835616438356 | 87 | 57 | 89.4 | 1 | 19 | 279 | 252 | 333 | MBN1430334.1 hypothetical protein [Anaerolineae bacterium] | diamond | 261 | 47.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 27233713 | 27233713 | PRJNA421571_P_NODE_57383_length_350_cov_4.714801_g54834_i0 | PRJNA421571 | 57383 | 350 | 4.714801 | 16.5018035 | Chloroflexi bacterium RBG_16_69_14 | 1797661 | Bacteria | Bacteria | 45.1 | 0.0167 | NR | OGO55017.1 | 1797661 | g54834 | i0 | 37.8 | 0.84 | 98 | 46 | 73.7 | 5 | 332 | 75 | 79 | 173 | OGO55017.1 MAG: hypothetical protein A2Z32_13675 [Chloroflexi bacterium RBG_16_69_14] | diamond | 294 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium RBG_16_69_14 | ||||||
| 27265393 | 27265393 | PRJNA421571_P_NODE_83983_length_268_cov_1.061538_g81434_i0 | PRJNA421571 | 83983 | 268 | 1.061538 | 2.84492184 | Bellilinea caldifistulae | 360411 | Bacteria | Bacteria | 47.8 | 8.66e-4 | NR | WP_061919062.1 | 360411 | g81434 | i0 | 33.8 | 1.62313432835821 | 74 | 43 | 82.8 | 1 | 20 | 241 | 492 | 559 | WP_061919062.1 NERD domain-containing protein/DEAD/DEAH box helicase [Bellilinea caldifistulae] | diamond | 435 | 47.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Bellilinea | Bellilinea caldifistulae | ||
| 27360261 | 27360261 | PRJNA421571_P_NODE_103343_length_243_cov_0.905882_g100794_i0 | PRJNA421571 | 103343 | 243 | 0.905882 | 2.20129326 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 79 | 3.73e-15 | NR | HRJ41445.1 | 2614250 | g100794 | i0 | 46.2 | 1.92592592592593 | 78 | 42 | 96.3 | 0 | 3 | 236 | 259 | 336 | HRJ41445.1 sodium/proton-translocating pyrophosphatase [Caldilineaceae bacterium] | diamond | 468 | 79 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 28450413 | 28450413 | PRJNA421571_P_NODE_105926_length_241_cov_1.595238_g103377_i0 | PRJNA421571 | 105926 | 241 | 1.595238 | 3.84452358 | Bacillati | 1783272 | Bacteria | Bacteria | 47 | 5.13e-4 | NR | HLZ60111.1 | 2692419 | g103377 | i0 | 37.3 | 3.74688796680498 | 75 | 43 | 93.4 | 2 | 2 | 226 | 71 | 141 | HLZ60111.1 protease inhibitor I42 family protein [Ktedonosporobacter sp.] | diamond | 903 | 47.4 | 0.991561181434599 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonosporobacteraceae | Ktedonosporobacter | Ktedonosporobacter sp. | ||
| 28623282 | 28623282 | PRJNA421571_P_NODE_87747_length_259_cov_1.655914_g85198_i0 | PRJNA421571 | 87747 | 259 | 1.655914 | 4.28881726 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.1 | 0.0324 | NR | MDQ6793338.1 | 2026724 | g85198 | i0 | 31.3 | 0.776061776061776 | 67 | 40 | 77.6 | 1 | 202 | 2 | 263 | 323 | MDQ6793338.1 molybdopterin-binding protein [Chloroflexota bacterium] | diamond | 201 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28717956 | 28717956 | PRJNA421571_P_NODE_99047_length_246_cov_0.890173_g96498_i0 | PRJNA421571 | 99047 | 246 | 0.890173 | 2.18982558 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 58.9 | 6.71e-8 | NR | NMB90080.1 | 2026724 | g96498 | i0 | 55.8 | 1.90243902439024 | 52 | 23 | 63.4 | 0 | 2 | 157 | 256 | 307 | NMB90080.1 alpha/beta hydrolase [Chloroflexota bacterium] | diamond | 468 | 58.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28875677 | 28875677 | PRJNA421571_P_NODE_53208_length_371_cov_11.231544_g50659_i0 | PRJNA421571 | 53208 | 371 | 11.231544 | 41.66902824 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 66.6 | 6.01e-12 | NR | MEX2237236.1 | 2026734 | g50659 | i0 | 58.9 | 0.905660377358491 | 56 | 23 | 45.3 | 0 | 353 | 186 | 1 | 56 | MEX2237236.1 CsbD family protein [Dehalococcoidia bacterium] | diamond | 336 | 66.6 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29096820 | 29096820 | PRJNA421571_P_NODE_48948_length_397_cov_1.401235_g46400_i0 | PRJNA421571 | 48948 | 397 | 1.401235 | 5.56290295 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 47.8 | 7.16e-4 | NR | MCW5848612.1 | 2052143 | g46400 | i0 | 58.7 | 0.347607052896725 | 46 | 19 | 34.8 | 0 | 395 | 258 | 79 | 124 | MCW5848612.1 profilin [Anaerolineae bacterium] | diamond | 138 | 47.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29254352 | 29254352 | PRJNA421571_P_NODE_30989_length_575_cov_1.328685_g28463_i0 | PRJNA421571 | 30989 | 575 | 1.328685 | 7.63993875 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 50.8 | 0.00112 | NR | MCH2527746.1 | 2026734 | g28463 | i0 | 47.6 | 0.43304347826087 | 42 | 22 | 21.9 | 0 | 148 | 273 | 85 | 126 | MCH2527746.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 249 | 50.8 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29822709 | 29822709 | PRJNA421571_P_NODE_91991_length_251_cov_0.865169_g89442_i0 | PRJNA421571 | 91991 | 251 | 0.865169 | 2.17157419 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 62.4 | 6.11e-10 | NR | MFN2299444.1 | 2073117 | g89442 | i0 | 50 | 0.693227091633466 | 58 | 29 | 69.3 | 0 | 250 | 77 | 91 | 148 | MFN2299444.1 peroxiredoxin [Anaerolineales bacterium] | diamond | 174 | 62.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29917816 | 29917816 | PRJNA421571_P_NODE_101291_length_245_cov_0.877907_g98742_i0 | PRJNA421571 | 101291 | 245 | 0.877907 | 2.15087215 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 66.2 | 2.37e-12 | NR | MDO9333808.1 | 2026733 | g98742 | i0 | 71.4 | 0.514285714285714 | 42 | 12 | 51.4 | 0 | 7 | 132 | 20 | 61 | MDO9333808.1 hypothetical protein [Dehalococcoidales bacterium] | diamond | 126 | 66.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 30282172 | 30282172 | PRJNA421571_P_NODE_106632_length_241_cov_0.916667_g104083_i0 | PRJNA421571 | 106632 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 58.2 | 1.36e-7 | NR | MCB0030369.1 | 2073117 | g104083 | i0 | 48.7 | 3.89626556016598 | 78 | 38 | 97.1 | 1 | 8 | 241 | 704 | 779 | MCB0030369.1 hypothetical protein [Anaerolineales bacterium] | diamond | 939 | 58.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31592821 | 31592821 | PRJNA421571_P_NODE_40736_length_460_cov_1.142119_g38188_i0 | PRJNA421571 | 40736 | 460 | 1.142119 | 5.2537474 | Thermoflexales bacterium | 2497639 | Bacteria | Bacteria | 63.5 | 2.18e-8 | NR | MBN1888829.1 | 2497639 | g38188 | i0 | 34.7 | 1.10869565217391 | 170 | 87 | 95.2 | 8 | 1 | 438 | 970 | 1139 | MBN1888829.1 TIGR03663 family protein [Thermoflexales bacterium] | diamond | 510 | 63.5 | 1 | Bacteria | Bacillati | Chloroflexota | Thermoflexia | Thermoflexales | Thermoflexales bacterium | ||||
| 32590055 | 32590055 | PRJNA421571_P_NODE_22899_length_726_cov_2.497703_g20493_i0 | PRJNA421571 | 22899 | 726 | 2.497703 | 18.13332378 | Candidatus Leptovillus | 3140597 | Bacteria | Bacteria | 59.3 | 3.68e-6 | NR | MFO7539015.1 | 2026724 | g20493 | i0 | 25.7 | 2.57851239669421 | 210 | 137 | 85.1 | 7 | 660 | 43 | 239 | 433 | MFO7539015.1 DUF4397 domain-containing protein [Chloroflexota bacterium] | diamond | 1872 | 59.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32888052 | 32888052 | PRJNA421571_P_NODE_107940_length_229_cov_2.961538_g105391_i0 | PRJNA421571 | 107940 | 229 | 2.961538 | 6.78192202 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 42 | 0.0499 | NR | MEZ4830889.1 | 2614250 | g105391 | i0 | 34.2 | 0.956331877729258 | 73 | 48 | 95.6 | 0 | 6 | 224 | 36 | 108 | MEZ4830889.1 hypothetical protein [Caldilineaceae bacterium] | diamond | 219 | 42 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae 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);;