contig_metadata
7 rows where bioproject = "PRJNA429937", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26600559 | 26600559 | PRJNA429937_P_NODE_136121_length_212_cov_2.595628_g113494_i0 | PRJNA429937 | 136121 | 212 | 2.595628 | 5.50273136 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 63.5 | 1.91e-10 | NR | HEY7495866.1 | 2528274 | g113494 | i0 | 85.7 | 0.495283018867925 | 35 | 5 | 49.5 | 0 | 210 | 106 | 93 | 127 | HEY7495866.1 type II toxin-antitoxin system VapC family toxin [Candidatus Tectimicrobiota bacterium] | diamond | 105 | 63.5 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 27075717 | 27075717 | PRJNA429937_P_NODE_79422_length_368_cov_2.651917_g57058_i0 | PRJNA429937 | 79422 | 368 | 2.651917 | 9.75905456 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 87.8 | 1.23e-17 | NR | HEX2277039.1 | 2528274 | g57058 | i0 | 88.4 | 0.35054347826087 | 43 | 5 | 35.1 | 0 | 368 | 240 | 308 | 350 | HEX2277039.1 cyclase family protein [Candidatus Tectimicrobiota bacterium] | diamond | 129 | 87.8 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 27265467 | 27265467 | PRJNA429937_P_NODE_95083_length_317_cov_2.579861_g72488_i0 | PRJNA429937 | 95083 | 317 | 2.579861 | 8.17815937 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 87.4 | 1.25e-17 | NR | HEX9868724.1 | 2528274 | g72488 | i0 | 71.4 | 0.529968454258675 | 56 | 16 | 53 | 0 | 260 | 93 | 209 | 264 | HEX9868724.1 group II intron reverse transcriptase/maturase [Candidatus Tectimicrobiota bacterium] | diamond | 168 | 87.4 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 28465420 | 28465420 | PRJNA429937_P_NODE_101706_length_297_cov_3.220149_g79092_i0 | PRJNA429937 | 101706 | 297 | 3.220149 | 9.56384253 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 60.1 | 8.78e-9 | NR | MCH7615782.1 | 2026769 | g79092 | i0 | 63 | 0.929292929292929 | 46 | 17 | 46.5 | 0 | 295 | 158 | 97 | 142 | MCH7615782.1 tetratricopeptide repeat protein [Nitrospinota bacterium] | diamond | 276 | 60.1 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinota bacterium | |||||
| 28812281 | 28812281 | PRJNA429937_P_NODE_104128_length_290_cov_3.616858_g81511_i0 | PRJNA429937 | 104128 | 290 | 3.616858 | 10.4888882 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 60.5 | 5.83e-9 | NR | MCH7615782.1 | 2026769 | g81511 | i0 | 61.7 | 1.57241379310345 | 47 | 18 | 48.6 | 0 | 236 | 96 | 96 | 142 | MCH7615782.1 tetratricopeptide repeat protein [Nitrospinota bacterium] | diamond | 456 | 60.5 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinota bacterium | |||||
| 29065348 | 29065348 | PRJNA429937_P_NODE_92488_length_325_cov_3.266892_g69902_i0 | PRJNA429937 | 92488 | 325 | 3.266892 | 10.617399 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 60.1 | 1.19e-8 | NR | MCH7615782.1 | 2026769 | g69902 | i0 | 63 | 0.849230769230769 | 46 | 17 | 42.5 | 0 | 323 | 186 | 97 | 142 | MCH7615782.1 tetratricopeptide repeat protein [Nitrospinota bacterium] | diamond | 276 | 60.1 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinota bacterium | |||||
| 29854614 | 29854614 | PRJNA429937_P_NODE_104851_length_288_cov_3.301158_g82233_i0 | PRJNA429937 | 104851 | 288 | 3.301158 | 9.50733504 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 60.1 | 7.92e-9 | NR | MCH7615782.1 | 2026769 | g82233 | i0 | 63 | 0.958333333333333 | 46 | 17 | 47.9 | 0 | 286 | 149 | 97 | 142 | MCH7615782.1 tetratricopeptide repeat protein [Nitrospinota bacterium] | diamond | 276 | 60.1 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinota 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);;