contig_metadata
8 rows where bioproject = "PRJNA565584", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14584180 | 14584180 | PRJNA565584_P_NODE_15592_length_824_cov_2.103862_g14530_i0 | PRJNA565584 | 15592 | 824 | 2.103862 | 17.33582288 | Bacteria | 2 | Bacteria | Bacteria | 291 | 3.829999999999998e-96 | NR | WP_237099245.1 | 35801 | g14530 | i0 | 61.5 | 9.31310679611651 | 213 | 78 | 77.5 | 1 | 89 | 727 | 3 | 211 | WP_237099245.1 peroxiredoxin [Nitrospina gracilis] | diamond | 7674 | 293 | 0.993174061433447 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinaceae | Nitrospina | Nitrospina gracilis | |
| 20260293 | 20260293 | PRJNA565584_P_NODE_121036_length_281_cov_1.480769_g119884_i0 | PRJNA565584 | 121036 | 281 | 1.480769 | 4.16096089 | Nitrospinales bacterium | 2833568 | Bacteria | Bacteria | 64.7 | 1.07e-9 | NR | MFQ5716009.1 | 2833568 | g119884 | i0 | 63.8 | 0.918149466192171 | 47 | 13 | 45.9 | 1 | 129 | 1 | 7 | 53 | MFQ5716009.1 ATP-dependent protease ATPase subunit HslU [Nitrospinales bacterium] | diamond | 258 | 64.7 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinales bacterium | |||
| 27490339 | 27490339 | PRJNA565584_P_NODE_94583_length_308_cov_1.302128_g93431_i0 | PRJNA565584 | 94583 | 308 | 1.302128 | 4.01055424 | Nitrospinaceae bacterium | 2358456 | Bacteria | Bacteria | 116 | 4.3e-29 | NR | MDP6335571.1 | 2358456 | g93431 | i0 | 61.4 | 1.97727272727273 | 101 | 29 | 98.4 | 2 | 2 | 304 | 88 | 178 | MDP6335571.1 formimidoylglutamase [Nitrospinaceae bacterium] | diamond | 609 | 116 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinaceae | Nitrospinaceae bacterium | ||
| 27900428 | 27900428 | PRJNA565584_P_NODE_148285_length_263_cov_1.921053_g147133_i0 | PRJNA565584 | 148285 | 263 | 1.921053 | 5.05236939 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 72 | 2.39e-12 | NR | MDH3599914.1 | 2528274 | g147133 | i0 | 44 | 0.958174904942966 | 84 | 47 | 95.8 | 0 | 252 | 1 | 512 | 595 | MDH3599914.1 hypothetical protein [Candidatus Tectimicrobiota bacterium] | diamond | 252 | 72 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 28608993 | 28608993 | PRJNA565584_P_NODE_73887_length_346_cov_0.717949_g72736_i0 | PRJNA565584 | 73887 | 346 | 0.717949 | 2.48410354 | Nitrospina | 35800 | Bacteria | Bacteria | 131 | 3.639999999999999e-35 | NR | MBT6345782.1 | 2024844 | g72736 | i0 | 59.8 | 9.89306358381503 | 102 | 41 | 88.4 | 0 | 311 | 6 | 9 | 110 | MBT6345782.1 alkene reductase [Nitrospina sp.] | diamond | 3423 | 131 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinaceae | Nitrospina | Nitrospina sp. | |
| 31785915 | 31785915 | PRJNA565584_P_NODE_133117_length_273_cov_1.920000_g131965_i0 | PRJNA565584 | 133117 | 273 | 1.92 | 5.2416 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 77 | 4.52e-14 | NR | MDH3603170.1 | 2528274 | g131965 | i0 | 45.2 | 1.81318681318681 | 84 | 46 | 92.3 | 0 | 272 | 21 | 308 | 391 | MDH3603170.1 UvrD-helicase domain-containing protein [Candidatus Tectimicrobiota bacterium] | diamond | 495 | 77 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 32292731 | 32292731 | PRJNA565584_P_NODE_151859_length_261_cov_1.478723_g150707_i0 | PRJNA565584 | 151859 | 261 | 1.478723 | 3.85946703 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 44.7 | 0.00902 | NR | MFQ5693793.1 | 2026769 | g150707 | i0 | 38.5 | 0.896551724137931 | 78 | 46 | 88.5 | 2 | 15 | 245 | 128 | 204 | MFQ5693793.1 hypothetical protein [Nitrospinota bacterium] | diamond | 234 | 44.7 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinota bacterium | |||||
| 32450806 | 32450806 | PRJNA565584_P_NODE_144119_length_266_cov_1.564767_g142967_i0 | PRJNA565584 | 144119 | 266 | 1.564767 | 4.16228022 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 146 | 3.93e-39 | NR | MEE8303395.1 | 2528274 | g142967 | i0 | 79.5 | 2.97744360902256 | 88 | 18 | 99.2 | 0 | 1 | 264 | 107 | 194 | MEE8303395.1 gamma-glutamyltransferase [Candidatus Tectimicrobiota bacterium] | diamond | 792 | 146 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota 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);;