contig_metadata
6 rows where bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3294512 | 3294512 | PRJNA763243_P_NODE_36683_length_285_cov_43.745283_g36337_i0 | PRJNA763243 | 36683 | 285 | 43.745283 | 124.67405655 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 429 | 1.04e-115 | NTclustered | gi|156121571|gb|EF447059.1| | 157466 | g36337 | i0 | 95.849 | 90.5684210526316 | 265 | 11 | 93 | 0 | 9 | 273 | 265 | 1 | Uncultured candidate division OP10 bacterium clone 1317 16S ribosomal RNA gene, partial sequence | blastn | 25812 | 429 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 5847618 | 5847618 | PRJNA763243_P_NODE_73045_length_206_cov_5.270677_g72699_i0 | PRJNA763243 | 73045 | 206 | 5.270677 | 10.85759462 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 176 | 1.02e-39 | NTclustered | gi|2076452338|gb|CP075364.1| | 2682144 | g72699 | i0 | 82.039 | 61.4805825242718 | 206 | 37 | 100 | 0 | 1 | 206 | 667425 | 667630 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome | blastn | 12665 | 176 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 12222860 | 12222860 | PRJNA763243_P_NODE_37070_length_284_cov_10.739336_g36724_i0 | PRJNA763243 | 37070 | 284 | 10.739336 | 30.49971424 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 178 | 4.15e-40 | NTclustered | gi|2874253689|emb|OY969415.1| | 157466 | g36724 | i0 | 81.333 | 48.6584507042254 | 225 | 36 | 78 | 6 | 52 | 273 | 3914811 | 3915032 | MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1 | blastn | 13819 | 178 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 22882939 | 22882939 | PRJNA763243_P_NODE_39418_length_278_cov_2.887805_g39072_i0 | PRJNA763243 | 39418 | 278 | 2.887805 | 8.0280979 | Chthonomonas | 1077265 | Bacteria | Bacteria | 239 | 1.83e-58 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g39072 | i0 | 86.758 | 133.672661870504 | 219 | 23 | 78 | 6 | 61 | 276 | 1235 | 1020 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 37161 | 239 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 22883003 | 22883003 | PRJNA763243_P_NODE_56958_length_246_cov_2.560694_g56612_i0 | PRJNA763243 | 56958 | 246 | 2.560694 | 6.29930724 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 315 | 2.57e-81 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g56612 | i0 | 92.308 | 235.434959349593 | 221 | 17 | 90 | 0 | 15 | 235 | 28471 | 28251 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 57917 | 315 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 32117701 | 32117701 | PRJNA763243_P_NODE_66718_length_232_cov_8.471698_g66372_i0 | PRJNA763243 | 66718 | 232 | 8.471698 | 19.65433936 | Armatimonadia | 1042312 | Bacteria | Bacteria | 134 | 4.7200000000000004e-36 | NR | MBC8143393.1 | 2033014 | g66372 | i0 | 89.2 | 5.74137931034483 | 74 | 8 | 95.7 | 0 | 227 | 6 | 282 | 355 | MBC8143393.1 type IV pilus twitching motility protein PilT [Armatimonadota bacterium] | diamond | 1332 | 135 | 0.992592592592593 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;