contig_metadata
9 rows where bioproject = "PRJNA382558" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10608786 | 10608786 | PRJNA382558_S_NODE_6269_length_198_cov_6.621118_g6265_i0 | PRJNA382558 | 6269 | 198 | 6.621118 | 13.10981364 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 209 | 9.63e-50 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g6265 | i0 | 85.93 | 128.762626262626 | 199 | 24 | 99 | 4 | 1 | 197 | 1735400 | 1735596 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 25495 | 209 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 19530666 | 19530666 | PRJNA382558_S_NODE_13156_length_159_cov_5.139344_g13152_i0 | PRJNA382558 | 13156 | 159 | 5.139344 | 8.17155696 | candidate division TM6 bacterium Zodletone_IIa | 1511133 | Bacteria | Bacteria | 99.8 | 4.47e-25 | NR | KHD90160.1 | 1511133 | g13152 | i0 | 100 | 3 | 53 | 0 | 100 | 0 | 1 | 159 | 85 | 137 | KHD90160.1 hypothetical protein AH06_01250, partial [candidate division TM6 bacterium Zodletone_IIa] | diamond | 477 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | candidate division TM6 bacterium Zodletone_IIa | |||||||
| 26885478 | 26885478 | PRJNA382558_S_NODE_14541_length_154_cov_7.136752_g14537_i0 | PRJNA382558 | 14541 | 154 | 7.136752 | 10.99059808 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 55.8 | 2.56e-8 | NR | MFA5996095.1 | 2052139 | g14537 | i0 | 51 | 0.954545454545455 | 49 | 22 | 95.5 | 1 | 148 | 2 | 12 | 58 | MFA5996095.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 147 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27011814 | 27011814 | PRJNA382558_S_NODE_1902_length_273_cov_7.266949_g1898_i0 | PRJNA382558 | 1902 | 273 | 7.266949 | 19.83877077 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 124 | 8.26e-31 | NR | HYV86187.1 | 2052139 | g1898 | i0 | 65.9 | 0.967032967032967 | 88 | 30 | 96.7 | 0 | 8 | 271 | 326 | 413 | HYV86187.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 264 | 124 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27043533 | 27043533 | PRJNA382558_S_NODE_3362_length_235_cov_13.040404_g3358_i0 | PRJNA382558 | 3362 | 235 | 13.040404 | 30.6449494 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 44.7 | 0.00312 | NR | MFA5996101.1 | 2052139 | g3358 | i0 | 31.9 | 0.880851063829787 | 69 | 41 | 80.4 | 1 | 18 | 206 | 37 | 105 | MFA5996101.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 207 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 29759141 | 29759141 | PRJNA382558_S_NODE_8311_length_182_cov_8.937931_g8307_i0 | PRJNA382558 | 8311 | 182 | 8.937931 | 16.26703442 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 73.9 | 8.44e-14 | NR | MBI3735218.1 | 2107588 | g8307 | i0 | 56.4 | 0.906593406593407 | 55 | 24 | 90.7 | 0 | 181 | 17 | 126 | 180 | MBI3735218.1 hypothetical protein [Candidatus Sumerlaeota bacterium] | diamond | 165 | 73.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 31180656 | 31180656 | PRJNA382558_S_NODE_4935_length_212_cov_6.902857_g4931_i0 | PRJNA382558 | 4935 | 212 | 6.902857 | 14.63405684 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 51.6 | 1.86e-5 | NR | MDE2099859.1 | 2052139 | g4931 | i0 | 36.6 | 1.00471698113208 | 71 | 44 | 99.1 | 1 | 210 | 1 | 218 | 288 | MDE2099859.1 AAA family ATPase [Patescibacteria group bacterium] | diamond | 213 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31845079 | 31845079 | PRJNA382558_S_NODE_14177_length_155_cov_8.720339_g14173_i0 | PRJNA382558 | 14177 | 155 | 8.720339 | 13.51652545 | Candidatus Schekmanbacteria bacterium | 2419984 | Bacteria | Bacteria | 55.1 | 4.69e-7 | NR | MBI2566893.1 | 2419984 | g14173 | i0 | 45.1 | 0.987096774193548 | 51 | 28 | 98.7 | 0 | 153 | 1 | 164 | 214 | MBI2566893.1 hypothetical protein [Candidatus Schekmanbacteria bacterium] | diamond | 153 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Schekmaniibacteriota | Candidatus Schekmanbacteria bacterium | ||||||
| 32824813 | 32824813 | PRJNA382558_S_NODE_11620_length_165_cov_6.257812_g11616_i0 | PRJNA382558 | 11620 | 165 | 6.257812 | 10.3253898 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 90.1 | 6.29e-20 | NR | HVX56891.1 | 2973664 | g11616 | i0 | 85.5 | 1 | 55 | 8 | 100 | 0 | 165 | 1 | 73 | 127 | HVX56891.1 IS3 family transposase [Candidatus Saccharimonadales bacterium] | diamond | 165 | 90.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales 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);;