contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1123309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3579687 | 3579687 | PRJNA1123309_P_NODE_67723_length_232_cov_3.194969_g67343_i0 | PRJNA1123309 | 67723 | 232 | 3.194969 | 7.41232808 | Chthonomonas | 1077265 | Bacteria | Bacteria | 196 | 9.06e-46 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g67343 | i0 | 84.729 | 115.801724137931 | 203 | 24 | 87 | 5 | 32 | 232 | 323 | 520 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 26866 | 196 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 8682282 | 8682282 | PRJNA1123309_P_NODE_67627_length_233_cov_12.625000_g67247_i0 | PRJNA1123309 | 67627 | 233 | 12.625 | 29.41625 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 211 | 3.25e-50 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g67247 | i0 | 84.163 | 212.437768240343 | 221 | 31 | 94 | 4 | 1 | 219 | 29563 | 29781 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 49498 | 211 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 11756624 | 11756624 | PRJNA1123309_P_NODE_20050_length_353_cov_1.667857_g19671_i0 | PRJNA1123309 | 20050 | 353 | 1.667857 | 5.88753521 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 385 | 2.8999999999999995e-102 | NTclustered | gi|2874253701|emb|OY969427.1| | 157466 | g19671 | i0 | 86.571 | 282.246458923513 | 350 | 45 | 99 | 2 | 5 | 353 | 3407467 | 3407119 | MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1 | blastn | 99633 | 385 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 13032302 | 13032302 | PRJNA1123309_P_NODE_67431_length_236_cov_2.785276_g67051_i0 | PRJNA1123309 | 67431 | 236 | 2.785276 | 6.57325136 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 226 | 1.18e-54 | NTclustered | gi|2076447151|gb|CP075366.1| | 2682144 | g67051 | i0 | 86.765 | 540.656779661017 | 204 | 26 | 86 | 1 | 4 | 207 | 893169 | 893371 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome | blastn | 127595 | 226 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 16855872 | 16855872 | PRJNA1123309_P_NODE_68334_length_216_cov_4.587413_g67954_i0 | PRJNA1123309 | 68334 | 216 | 4.587413 | 9.90881208 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 187 | 5.01e-43 | NTclustered | gi|1938770100|gb|CP054189.1| | 2739509 | g67954 | i0 | 83.981 | 65.8888888888889 | 206 | 22 | 93 | 11 | 16 | 215 | 126644 | 126444 | MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome | blastn | 14232 | 187 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 25255305 | 25255305 | PRJNA1123309_P_NODE_31400_length_292_cov_1.109589_g31020_i0 | PRJNA1123309 | 31400 | 292 | 1.109589 | 3.23999988 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 425 | 1.38e-114 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g31020 | i0 | 93.972 | 253.982876712329 | 282 | 15 | 96 | 2 | 8 | 288 | 29005 | 28725 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 74163 | 425 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli |
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);;