contig_metadata
13 rows where bioproject = "PRJEB76780", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9066080 | 9066080 | PRJEB76780_P_NODE_7708_length_291_cov_1.252294_g7608_i0 | PRJEB76780 | 7708 | 291 | 1.252294 | 3.64417554 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 416 | 8.3e-112 | NTclustered | gi|2874254102|emb|OY970185.1| | 1672391 | g7608 | i0 | 92.466 | 216.463917525773 | 292 | 21 | 100 | 1 | 1 | 291 | 1857521 | 1857812 | MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 | blastn | 62991 | 416 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 19264291 | 19264291 | PRJEB76780_P_NODE_2636_length_505_cov_4.650463_g2536_i0 | PRJEB76780 | 2636 | 505 | 4.650463 | 23.48483815 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 158 | 2.15e-44 | NR | UCC15874.1 | 2026733 | g2536 | i0 | 54.5 | 5.36435643564356 | 132 | 60 | 78.4 | 0 | 397 | 2 | 7 | 138 | UCC15874.1 MAG: polyamine aminopropyltransferase [Dehalococcoidales bacterium] | diamond | 2709 | 158 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 28353398 | 28353398 | PRJEB76780_P_NODE_7766_length_290_cov_1.327189_g7666_i0 | PRJEB76780 | 7766 | 290 | 1.327189 | 3.8488481 | Caldilinea | 233191 | Bacteria | Bacteria | 135 | 4.0999999999999995e-36 | NR | HDN80834.1 | 2026724 | g7666 | i0 | 67.7 | 14.9586206896552 | 96 | 31 | 99.3 | 0 | 2 | 289 | 218 | 313 | HDN80834.1 S-methyl-5-thioribose-1-phosphate isomerase [Chloroflexota bacterium] | diamond | 4338 | 135 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28518683 | 28518683 | PRJEB76780_P_NODE_2607_length_508_cov_1.657471_g2507_i0 | PRJEB76780 | 2607 | 508 | 1.657471 | 8.41995268 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 48.1 | 0.00665 | NR | MCS7247849.1 | 2073117 | g2507 | i0 | 34.2 | 0.431102362204724 | 73 | 47 | 43.1 | 1 | 206 | 424 | 122 | 193 | MCS7247849.1 carboxypeptidase-like regulatory domain-containing protein [Anaerolineales bacterium] | diamond | 219 | 48.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28518688 | 28518688 | PRJEB76780_P_NODE_667_length_998_cov_2.167568_g597_i0 | PRJEB76780 | 667 | 998 | 2.167568 | 21.63232864 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 199 | 6.27e-58 | NR | MBA3468387.1 | 2720503 | g597 | i0 | 45.8 | 1.78557114228457 | 297 | 135 | 89.3 | 6 | 893 | 3 | 33 | 303 | MBA3468387.1 peptidoglycan-binding protein [Herpetosiphonaceae bacterium] | diamond | 1782 | 199 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 29024169 | 29024169 | PRJEB76780_P_NODE_868_length_890_cov_4.864137_g786_i0 | PRJEB76780 | 868 | 890 | 4.864137 | 43.2908193 | Ktedonosporobacter rubrisoli | 2509675 | Bacteria | Bacteria | 245 | 6.34e-77 | NR | WP_207229223.1 | 2509675 | g786 | i0 | 52.5 | 1.51685393258427 | 223 | 102 | 73.8 | 1 | 718 | 62 | 14 | 236 | WP_207229223.1 sulfotransferase family protein [Ktedonosporobacter rubrisoli] | diamond | 1350 | 245 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonosporobacteraceae | Ktedonosporobacter | Ktedonosporobacter rubrisoli | ||
| 29055482 | 29055482 | PRJEB76780_P_NODE_11088_length_250_cov_0.881356_g10988_i0 | PRJEB76780 | 11088 | 250 | 0.881356 | 2.20339 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 55.8 | 7.38e-7 | NR | TMF34315.1 | 2026724 | g10988 | i0 | 81.3 | 1.776 | 32 | 6 | 38.4 | 0 | 249 | 154 | 232 | 263 | TMF34315.1 MAG: methyltransferase domain-containing protein [Chloroflexota bacterium] | diamond | 444 | 55.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29497371 | 29497371 | PRJEB76780_P_NODE_2330_length_542_cov_1.304904_g2230_i0 | PRJEB76780 | 2330 | 542 | 1.304904 | 7.07257968 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 46.6 | 0.0288 | NR | MEM8860106.1 | 2026724 | g2230 | i0 | 25.4 | 0.979704797047971 | 177 | 127 | 95.2 | 2 | 528 | 13 | 887 | 1063 | MEM8860106.1 choice-of-anchor L domain-containing protein [Chloroflexota bacterium] | diamond | 531 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29749677 | 29749677 | PRJEB76780_P_NODE_10271_length_253_cov_0.866667_g10171_i0 | PRJEB76780 | 10271 | 253 | 0.866667 | 2.19266751 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 73.2 | 1.13e-13 | NR | HEY8172851.1 | 2026734 | g10171 | i0 | 47.9 | 0.865612648221344 | 73 | 36 | 86.6 | 1 | 235 | 17 | 1 | 71 | HEY8172851.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 219 | 73.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30982272 | 30982272 | PRJEB76780_P_NODE_4034_length_406_cov_1.726727_g3934_i0 | PRJEB76780 | 4034 | 406 | 1.726727 | 7.01051162 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 109 | 1.16e-24 | NR | MCU0474699.1 | 2052143 | g3934 | i0 | 53.3 | 6.16256157635468 | 122 | 48 | 89.4 | 2 | 2 | 364 | 341 | 454 | MCU0474699.1 S8 family serine peptidase [Anaerolineae bacterium] | diamond | 2502 | 109 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31139692 | 31139692 | PRJEB76780_P_NODE_2655_length_504_cov_1.329466_g2555_i0 | PRJEB76780 | 2655 | 504 | 1.329466 | 6.70050864 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 78.2 | 2.44e-13 | NR | HET7076843.1 | 2448782 | g2555 | i0 | 40.9 | 1.97619047619048 | 115 | 64 | 68.5 | 2 | 143 | 487 | 297 | 407 | HET7076843.1 choice-of-anchor A family protein [Chloroflexia bacterium] | diamond | 996 | 78.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 31551455 | 31551455 | PRJEB76780_P_NODE_1736_length_629_cov_1.962230_g1639_i0 | PRJEB76780 | 1736 | 629 | 1.96223 | 12.3424267 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 116 | 2.7300000000000003e-26 | NR | MCB9146451.1 | 2073117 | g1639 | i0 | 38.2 | 1.01112877583466 | 212 | 113 | 98.7 | 7 | 621 | 1 | 19 | 217 | MCB9146451.1 peroxidase [Anaerolineales bacterium] | diamond | 636 | 116 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32468920 | 32468920 | PRJEB76780_P_NODE_5639_length_341_cov_1.048507_g5539_i0 | PRJEB76780 | 5639 | 341 | 1.048507 | 3.57540887 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 52 | 6.43e-5 | NR | MCL6512254.1 | 2052143 | g5539 | i0 | 31.6 | 4.10850439882698 | 117 | 65 | 90.6 | 4 | 313 | 5 | 27 | 142 | MCL6512254.1 hypothetical protein [Anaerolineae bacterium] | diamond | 1401 | 52 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae 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);;