contig_metadata
11 rows where bioproject = "PRJNA704949" and tax_phylum = "Candidatus Poribacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5800882 | 5800882 | PRJNA704949_P_NODE_386605_length_437_cov_1.453608_g371527_i0 | PRJNA704949 | 386605 | 437 | 1.453608 | 6.35226696 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 104 | 9.69e-25 | NR | GIX06626.1 | 2026781 | g371527 | i0 | 72.2 | 3.03432494279176 | 72 | 20 | 49.4 | 0 | 255 | 40 | 4 | 75 | GIX06626.1 MAG: 2,3-bisphosphoglycerate-dependent phosphoglycerate mutase [Candidatus Poribacteria bacterium] | diamond | 1326 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 8351389 | 8351389 | PRJNA704949_P_NODE_480907_length_393_cov_1.427326_g465672_i0 | PRJNA704949 | 480907 | 393 | 1.427326 | 5.60939118 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 65.8 | 4.83e-6 | NTclustered | gi|2621703767|emb|OY762722.1| | 2026781 | g465672 | i0 | 95.238 | 2.98473282442748 | 42 | 1 | 10 | 1 | 279 | 319 | 1345184 | 1345225 | MAG: Candidatus Poribacteria bacterium isolate ed6806d3-dd7a-4409-98ee-5b7e1ebe3502 genome assembly, chromosome: 1 | blastn | 1173 | 65.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 28136485 | 28136485 | PRJNA704949_P_NODE_69485_length_922_cov_2.281787_g57966_i0 | PRJNA704949 | 69485 | 922 | 2.281787 | 21.03807614 | Bacteria | 2 | Bacteria | Bacteria | 239 | 8.689999999999998e-69 | NR | MDQ1316931.1 | 2026781 | g57966 | i0 | 71.6 | 2.09869848156182 | 162 | 46 | 52.7 | 0 | 1 | 486 | 679 | 840 | MDQ1316931.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 1935 | 239 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 29083583 | 29083583 | PRJNA704949_P_NODE_1597488_length_193_cov_1.083333_g1582149_i0 | PRJNA704949 | 1597488 | 193 | 1.083333 | 2.09083269 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 77 | 1.55e-14 | NR | MBI5116185.1 | 2026781 | g1582149 | i0 | 62.5 | 1.9740932642487 | 64 | 19 | 99.5 | 1 | 2 | 193 | 261 | 319 | MBI5116185.1 glycogen synthase GlgA [Candidatus Poribacteria bacterium] | diamond | 381 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 29703859 | 29703859 | PRJNA704949_P_NODE_397970_length_431_cov_1.361257_g382870_i0 | PRJNA704949 | 397970 | 431 | 1.361257 | 5.86701767 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 191 | 1.0199999999999998e-57 | NR | MDE0184101.1 | 2026781 | g382870 | i0 | 65.5 | 4.93503480278422 | 142 | 49 | 98.8 | 0 | 431 | 6 | 78 | 219 | MDE0184101.1 methylisocitrate lyase [Candidatus Poribacteria bacterium] | diamond | 2127 | 191 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 30114513 | 30114513 | PRJNA704949_P_NODE_1495632_length_201_cov_1.710526_g1480294_i0 | PRJNA704949 | 1495632 | 201 | 1.710526 | 3.43815726 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 42.4 | 0.0294 | NR | HHZ93559.1 | 2026781 | g1480294 | i0 | 39.3 | 2.22388059701493 | 56 | 32 | 80.6 | 1 | 191 | 30 | 634 | 689 | HHZ93559.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 447 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 30714791 | 30714791 | PRJNA704949_P_NODE_125714_length_712_cov_2.509804_g112686_i0 | PRJNA704949 | 125714 | 712 | 2.509804 | 17.86980448 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 219 | 2.7799999999999998e-68 | NR | MBI5154030.1 | 2026781 | g112686 | i0 | 55.6 | 0.825842696629214 | 196 | 87 | 82.6 | 0 | 588 | 1 | 1 | 196 | MBI5154030.1 metal-dependent hydrolase [Candidatus Poribacteria bacterium] | diamond | 588 | 219 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 31884843 | 31884843 | PRJNA704949_P_NODE_327957_length_471_cov_3.033175_g313038_i0 | PRJNA704949 | 327957 | 471 | 3.033175 | 14.28625425 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 49.7 | 0.00145 | NR | MFC1718514.1 | 2026781 | g313038 | i0 | 38.9 | 0.45859872611465 | 72 | 40 | 43.9 | 2 | 455 | 249 | 351 | 421 | MFC1718514.1 PAS domain S-box protein [Candidatus Poribacteria bacterium] | diamond | 216 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32265083 | 32265083 | PRJNA704949_P_NODE_821498_length_293_cov_2.045082_g806165_i0 | PRJNA704949 | 821498 | 293 | 2.045082 | 5.99209026 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 44.3 | 0.0182 | NR | MXZ01092.1 | 2026781 | g806165 | i0 | 71.4 | 0.286689419795222 | 28 | 8 | 28.7 | 0 | 206 | 289 | 5 | 32 | MXZ01092.1 DUF4062 domain-containing protein [Candidatus Poribacteria bacterium] | diamond | 84 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32359720 | 32359720 | PRJNA704949_P_NODE_1878959_length_172_cov_1.268293_g1863620_i0 | PRJNA704949 | 1878959 | 172 | 1.268293 | 2.18146396 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 56.2 | 2.51e-7 | NR | MEK7398426.1 | 2026781 | g1863620 | i0 | 47.2 | 0.924418604651163 | 53 | 28 | 92.4 | 0 | 5 | 163 | 544 | 596 | MEK7398426.1 DUF2723 domain-containing protein [Candidatus Poribacteria bacterium] | diamond | 159 | 56.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32769921 | 32769921 | PRJNA704949_P_NODE_783860_length_301_cov_3.313492_g768528_i0 | PRJNA704949 | 783860 | 301 | 3.313492 | 9.97361092 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 70.9 | 9.96e-12 | NR | MDE0185016.1 | 2026781 | g768528 | i0 | 45.8 | 1.37541528239203 | 72 | 39 | 71.8 | 0 | 283 | 68 | 735 | 806 | MDE0185016.1 ankyrin repeat domain-containing protein [Candidatus Poribacteria bacterium] | diamond | 414 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria 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);;