contig_metadata
24 rows where bioproject = "PRJNA929522", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 905378 | 905378 | PRJNA929522_S_NODE_881_length_672_cov_1.878130_g819_i0 | PRJNA929522 | 881 | 672 | 1.87813 | 12.6210336 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 177 | 6.29e-51 | NR | MEM7116960.1 | 2026724 | g819 | i0 | 48.2 | 1.78125 | 199 | 94 | 85.3 | 3 | 671 | 99 | 63 | 260 | MEM7116960.1 serine protease [Chloroflexota bacterium] | diamond | 1197 | 177 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 8906229 | 8906229 | PRJNA929522_S_NODE_1607_length_520_cov_1.684564_g1537_i0 | PRJNA929522 | 1607 | 520 | 1.684564 | 8.7597328 | Bacteria | 2 | Bacteria | Bacteria | 159 | 1.4199999999999999e-42 | NR | MEP7200188.1 | 2026724 | g1537 | i0 | 48.8 | 3 | 168 | 83 | 95.2 | 2 | 507 | 13 | 320 | 487 | MEP7200188.1 S8 family serine peptidase [Chloroflexota bacterium] | diamond | 1560 | 160 | 0.99375 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 14933247 | 14933247 | PRJNA929522_S_NODE_132_length_1376_cov_3.653108_g110_i0 | PRJNA929522 | 132 | 1376 | 3.653108 | 50.26676608 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 328 | 2.47e-100 | NR | MEO8289065.1 | 2026724 | g110 | i0 | 44.3 | 4.90334302325581 | 454 | 221 | 95.3 | 13 | 1374 | 64 | 65 | 503 | MEO8289065.1 S8 family serine peptidase [Chloroflexota bacterium] | diamond | 6747 | 328 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 23857714 | 23857714 | PRJNA929522_S_NODE_579_length_823_cov_2.494667_g526_i0 | PRJNA929522 | 579 | 823 | 2.494667 | 20.53110941 | Bacillati | 1783272 | Bacteria | Bacteria | 294 | 2.14e-93 | NR | MBM3129803.1 | 2026724 | g526 | i0 | 55.3 | 4.77885783718104 | 273 | 108 | 98.1 | 5 | 814 | 8 | 124 | 386 | MBM3129803.1 peptidase S8 [Chloroflexota bacterium] | diamond | 3933 | 294 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 25131509 | 25131509 | PRJNA929522_S_NODE_7820_length_259_cov_2.069892_g7750_i0 | PRJNA929522 | 7820 | 259 | 2.069892 | 5.36102028 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 125 | 2.2299999999999996e-31 | NR | PZC49461.1 | 2026724 | g7750 | i0 | 68.2 | 0.984555984555985 | 85 | 27 | 98.5 | 0 | 4 | 258 | 232 | 316 | PZC49461.1 MAG: acetyl-CoA synthetase [Chloroflexota bacterium] | diamond | 255 | 125 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26676374 | 26676374 | PRJNA929522_S_NODE_9921_length_242_cov_0.911243_g9851_i0 | PRJNA929522 | 9921 | 242 | 0.911243 | 2.20520806 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 46.6 | 2.11e-4 | NR | MCX6067226.1 | 2026724 | g9851 | i0 | 41.7 | 1.16528925619835 | 48 | 26 | 57 | 1 | 68 | 205 | 22 | 69 | MCX6067226.1 hypothetical protein [Chloroflexota bacterium] | diamond | 282 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27150859 | 27150859 | PRJNA929522_S_NODE_1722_length_504_cov_1.315545_g1652_i0 | PRJNA929522 | 1722 | 504 | 1.315545 | 6.6303468 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 68.6 | 5.8e-10 | NR | MAT98625.1 | 2024896 | g1652 | i0 | 52.2 | 0.773809523809524 | 69 | 30 | 41.1 | 1 | 286 | 492 | 182 | 247 | MAT98625.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 390 | 68.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 27498974 | 27498974 | PRJNA929522_S_NODE_7543_length_263_cov_2.021053_g7473_i0 | PRJNA929522 | 7543 | 263 | 2.021053 | 5.31536939 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 55.5 | 1.6e-6 | NR | HND47414.1 | 2073117 | g7473 | i0 | 65.2 | 0.524714828897338 | 46 | 14 | 50.2 | 2 | 133 | 2 | 379 | 424 | HND47414.1 hypothetical protein [Anaerolineales bacterium] | diamond | 138 | 55.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 27972473 | 27972473 | PRJNA929522_S_NODE_4965_length_311_cov_1.617647_g4895_i0 | PRJNA929522 | 4965 | 311 | 1.617647 | 5.03088217 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 68.6 | 1.04e-11 | NR | HZR97695.1 | 2026724 | g4895 | i0 | 61.8 | 1.61093247588424 | 55 | 21 | 53.1 | 0 | 298 | 134 | 103 | 157 | HZR97695.1 carboxypeptidase regulatory-like domain-containing protein [Chloroflexota bacterium] | diamond | 501 | 68.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28067159 | 28067159 | PRJNA929522_S_NODE_3805_length_346_cov_1.985348_g3735_i0 | PRJNA929522 | 3805 | 346 | 1.985348 | 6.86930408 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 148 | 9.25e-39 | NR | HND47414.1 | 2073117 | g3735 | i0 | 57.9 | 1.21387283236994 | 140 | 32 | 98 | 2 | 341 | 3 | 611 | 750 | HND47414.1 hypothetical protein [Anaerolineales bacterium] | diamond | 420 | 148 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28098691 | 28098691 | PRJNA929522_S_NODE_125_length_1405_cov_4.733483_g104_i0 | PRJNA929522 | 125 | 1405 | 4.733483 | 66.50543615 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 284 | 7.06e-82 | NR | HEY85254.1 | 2026724 | g104 | i0 | 38.9 | 4.0932384341637 | 470 | 250 | 94.4 | 13 | 1349 | 24 | 33 | 493 | HEY85254.1 S8 family serine peptidase [Chloroflexota bacterium] | diamond | 5751 | 284 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28130477 | 28130477 | PRJNA929522_S_NODE_6165_length_286_cov_1.009390_g6095_i0 | PRJNA929522 | 6165 | 286 | 1.00939 | 2.8868554 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 105 | 4.54e-24 | NR | HZQ10529.1 | 2052143 | g6095 | i0 | 56.5 | 0.891608391608392 | 85 | 37 | 89.2 | 0 | 284 | 30 | 469 | 553 | HZQ10529.1 glutamine--tRNA ligase/YqeY domain fusion protein [Anaerolineae bacterium] | diamond | 255 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28263563 | 28263563 | PRJNA929522_S_NODE_4646_length_319_cov_1.207317_g4576_i0 | PRJNA929522 | 4646 | 319 | 1.207317 | 3.85134123 | Bacteria | 2 | Bacteria | Bacteria | 105 | 5.0399999999999995e-25 | NR | OGN88965.1 | 1797618 | g4576 | i0 | 55.8 | 4.85266457680251 | 86 | 37 | 80.9 | 1 | 262 | 5 | 9 | 93 | OGN88965.1 MAG: spermidine synthase [Chloroflexi bacterium RBG_13_46_14] | diamond | 1548 | 106 | 0.990566037735849 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium RBG_13_46_14 | ||||||
| 29077723 | 29077723 | PRJNA929522_S_NODE_928_length_655_cov_1.962199_g865_i0 | PRJNA929522 | 928 | 655 | 1.962199 | 12.85240345 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 85.9 | 2.2e-15 | NR | HND47413.1 | 2073117 | g865 | i0 | 60.9 | 0.316030534351145 | 69 | 27 | 31.6 | 0 | 180 | 386 | 486 | 554 | HND47413.1 Ty1/Copia family ribonuclease HI [Anaerolineales bacterium] | diamond | 207 | 85.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29235537 | 29235537 | PRJNA929522_S_NODE_1429_length_550_cov_2.121593_g1359_i0 | PRJNA929522 | 1429 | 550 | 2.121593 | 11.6687615 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 159 | 1.8e-42 | NR | MEJ2707415.1 | 2073117 | g1359 | i0 | 46.1 | 1.05272727272727 | 193 | 90 | 99.3 | 6 | 3 | 548 | 276 | 465 | MEJ2707415.1 S8 family serine peptidase [Anaerolineales bacterium] | diamond | 579 | 159 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29235538 | 29235538 | PRJNA929522_S_NODE_1709_length_506_cov_1.251732_g1639_i0 | PRJNA929522 | 1709 | 506 | 1.251732 | 6.33376392 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 97.1 | 7.02e-20 | NR | HND47413.1 | 2073117 | g1639 | i0 | 43.7 | 0.74703557312253 | 126 | 43 | 58.1 | 2 | 474 | 181 | 99 | 224 | HND47413.1 Ty1/Copia family ribonuclease HI [Anaerolineales bacterium] | diamond | 378 | 97.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29803687 | 29803687 | PRJNA929522_S_NODE_4631_length_319_cov_1.849593_g4561_i0 | PRJNA929522 | 4631 | 319 | 1.849593 | 5.90020167 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 45.4 | 0.00572 | NR | HZR97695.1 | 2026724 | g4561 | i0 | 58.8 | 0.31974921630094 | 34 | 14 | 32 | 0 | 317 | 216 | 120 | 153 | HZR97695.1 carboxypeptidase regulatory-like domain-containing protein [Chloroflexota bacterium] | diamond | 102 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29898635 | 29898635 | PRJNA929522_S_NODE_3931_length_342_cov_1.684015_g3861_i0 | PRJNA929522 | 3931 | 342 | 1.684015 | 5.7593313 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 120 | 4.77e-29 | NR | MCR4407542.1 | 2052143 | g3861 | i0 | 59.8 | 0.93859649122807 | 107 | 43 | 93.9 | 0 | 22 | 342 | 202 | 308 | MCR4407542.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Anaerolineae bacterium] | diamond | 321 | 120 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29961703 | 29961703 | PRJNA929522_S_NODE_531_length_843_cov_2.014286_g478_i0 | PRJNA929522 | 531 | 843 | 2.014286 | 16.98043098 | Chloroflexi bacterium AL-N1 | 2686367 | Bacteria | Bacteria | 108 | 2.7999999999999998e-24 | NR | NOK61067.1 | 2686367 | g478 | i0 | 36.4 | 2.74733096085409 | 214 | 121 | 71.5 | 7 | 235 | 837 | 25 | 236 | NOK61067.1 hypothetical protein [Chloroflexi bacterium AL-N1] | diamond | 2316 | 108 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium AL-N1 | ||||||
| 30221470 | 30221470 | PRJNA929522_S_NODE_4252_length_332_cov_1.100386_g4182_i0 | PRJNA929522 | 4252 | 332 | 1.100386 | 3.65328152 | Bacillati | 1783272 | Bacteria | Bacteria | 132 | 1.26e-33 | NR | MCP4358721.1 | 2026724 | g4182 | i0 | 56.9 | 8.71084337349398 | 109 | 45 | 96.7 | 1 | 10 | 330 | 140 | 248 | MCP4358721.1 4-coumarate--CoA ligase family protein [Chloroflexota bacterium] | diamond | 2892 | 132 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31415323 | 31415323 | PRJNA929522_S_NODE_3456_length_361_cov_2.131944_g3386_i0 | PRJNA929522 | 3456 | 361 | 2.131944 | 7.69631784 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 130 | 1.1399999999999999e-32 | NR | MCJ7510995.1 | 2026734 | g3386 | i0 | 54.7 | 3.14958448753463 | 95 | 43 | 78.9 | 0 | 290 | 6 | 166 | 260 | MCJ7510995.1 S8 family serine peptidase [Dehalococcoidia bacterium] | diamond | 1137 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 31636663 | 31636663 | PRJNA929522_S_NODE_3676_length_352_cov_0.913978_g3606_i0 | PRJNA929522 | 3676 | 352 | 0.913978 | 3.21720256 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 67 | 3.94e-10 | NR | HUI88050.1 | 2073117 | g3606 | i0 | 57.6 | 1.00568181818182 | 59 | 25 | 50.3 | 0 | 351 | 175 | 37 | 95 | HUI88050.1 alkaline phosphatase family protein [Anaerolineales bacterium] | diamond | 354 | 67 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32491115 | 32491115 | PRJNA929522_S_NODE_3399_length_364_cov_2.065292_g3329_i0 | PRJNA929522 | 3399 | 364 | 2.065292 | 7.51766288 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 109 | 6.93e-25 | NR | MCX7680696.1 | 2052143 | g3329 | i0 | 51.5 | 0.832417582417582 | 101 | 41 | 82.4 | 2 | 302 | 3 | 1053 | 1146 | MCX7680696.1 M14 family zinc carboxypeptidase [Anaerolineae bacterium] | diamond | 303 | 109 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32806150 | 32806150 | PRJNA929522_S_NODE_780_length_713_cov_2.101562_g720_i0 | PRJNA929522 | 780 | 713 | 2.101562 | 14.98413706 | Candidatus Ribeiella danica | 3140698 | Bacteria | Bacteria | 207 | 2.14e-58 | NR | MBK9710383.1 | 3140698 | g720 | i0 | 51 | 3.5343618513324 | 210 | 99 | 86.7 | 2 | 685 | 68 | 277 | 486 | MBK9710383.1 S8 family serine peptidase [Candidatus Ribeiella danica] | diamond | 2520 | 207 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Candidatus Ribeiella | Candidatus Ribeiella danica |
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);;