contig_metadata
6 rows where bioproject = "PRJNA1174207", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10519129 | 10519129 | PRJNA1174207_P_NODE_20949_length_310_cov_2.928270_g20420_i0 | PRJNA1174207 | 20949 | 310 | 2.92827 | 9.077637 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 363 | 1.18e-95 | NTclustered | gi|2076447151|gb|CP075366.1| | 2682144 | g20420 | i0 | 87.662 | 794.112903225806 | 308 | 32 | 99 | 2 | 3 | 310 | 893163 | 893464 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome | blastn | 246175 | 363 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 15068305 | 15068305 | PRJNA1174207_P_NODE_28932_length_269_cov_1.489796_g28403_i0 | PRJNA1174207 | 28932 | 269 | 1.489796 | 4.00755124 | Chthonomonas | 1077265 | Bacteria | Bacteria | 326 | 1.31e-84 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g28403 | i0 | 88.476 | 192.743494423792 | 269 | 31 | 100 | 0 | 1 | 269 | 1968 | 2236 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 51848 | 326 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 23268075 | 23268075 | PRJNA1174207_P_NODE_40839_length_242_cov_0.911243_g40310_i0 | PRJNA1174207 | 40839 | 242 | 0.911243 | 2.20520806 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 185 | 2.06e-42 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g40310 | i0 | 81.25 | 517.409090909091 | 240 | 36 | 98 | 9 | 5 | 240 | 1305914 | 1305680 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 125213 | 185 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 29093355 | 29093355 | PRJNA1174207_P_NODE_23228_length_294_cov_3.063348_g22699_i0 | PRJNA1174207 | 23228 | 294 | 3.063348 | 9.00624312 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 71.2 | 5.34e-13 | NR | HVK04704.1 | 2933160 | g22699 | i0 | 47.9 | 0.724489795918367 | 71 | 37 | 72.4 | 0 | 2 | 214 | 86 | 156 | HVK04704.1 DinB family protein [Armatimonadaceae bacterium] | diamond | 213 | 71.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 30134984 | 30134984 | PRJNA1174207_P_NODE_40932_length_242_cov_0.911243_g40403_i0 | PRJNA1174207 | 40932 | 242 | 0.911243 | 2.20520806 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 61.2 | 6.58e-9 | NR | WP_309719584.1 | 1872638 | g40403 | i0 | 47.4 | 1.41322314049587 | 57 | 30 | 70.7 | 0 | 241 | 71 | 198 | 254 | WP_309719584.1 SPOR domain-containing protein [Armatimonas sp.] | diamond | 342 | 61.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 31196780 | 31196780 | PRJNA1174207_P_NODE_42795_length_230_cov_3.222930_g42266_i0 | PRJNA1174207 | 42795 | 230 | 3.22293 | 7.412739 | Bacteria | 2 | Bacteria | Bacteria | 43.9 | 0.0093 | NR | MEP0767071.1 | 2575566 | g42266 | i0 | 33.3 | 1.95652173913043 | 75 | 43 | 88.7 | 1 | 221 | 18 | 112 | 186 | MEP0767071.1 PEP-CTERM sorting domain-containing protein [Fimbriimonadia bacterium] | diamond | 450 | 43.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadia 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);;