contig_metadata
6 rows where bioproject = "PRJNA1126198", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4858557 | 4858557 | PRJNA1126198_P_NODE_5944_length_725_cov_2.349693_g5321_i0 | PRJNA1126198 | 5944 | 725 | 2.349693 | 17.03527425 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 1024 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g5321 | i0 | 92.372 | 221.201379310345 | 721 | 51 | 99 | 3 | 5 | 725 | 28225 | 28941 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 160371 | 1024 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 7408210 | 7408210 | PRJNA1126198_P_NODE_322826_length_260_cov_2.502674_g322105_i0 | PRJNA1126198 | 322826 | 260 | 2.502674 | 6.5069524 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 154 | 3.8e-44 | NR | NLN78885.1 | 2033014 | g322105 | i0 | 88.4 | 1.98461538461538 | 86 | 10 | 99.2 | 0 | 259 | 2 | 95 | 180 | NLN78885.1 ABC transporter ATP-binding protein [Armatimonadota bacterium] | diamond | 516 | 154 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 9209725 | 9209725 | PRJNA1126198_P_NODE_4528_length_836_cov_3.910878_g3971_i0 | PRJNA1126198 | 4528 | 836 | 3.910878 | 32.69494008 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 573 | 1.4499999999999995e-158 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g3971 | i0 | 79.481 | 566.74043062201 | 848 | 142 | 100 | 29 | 1 | 836 | 1306083 | 1305256 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 473795 | 573 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 27323173 | 27323173 | PRJNA1126198_P_NODE_291363_length_268_cov_1.087179_g290642_i0 | PRJNA1126198 | 291363 | 268 | 1.087179 | 2.91363972 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 101 | 1.2e-22 | NR | MES2460552.1 | 2033014 | g290642 | i0 | 49.4 | 0.996268656716418 | 89 | 45 | 99.6 | 0 | 1 | 267 | 109 | 197 | MES2460552.1 hypothetical protein [Armatimonadota bacterium] | diamond | 267 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30912638 | 30912638 | PRJNA1126198_P_NODE_413274_length_247_cov_1.431034_g412553_i0 | PRJNA1126198 | 413274 | 247 | 1.431034 | 3.53465398 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 121 | 1.83e-30 | NR | HSI73297.1 | 1936159 | g412553 | i0 | 68.8 | 8.74493927125506 | 80 | 25 | 97.2 | 0 | 245 | 6 | 368 | 447 | HSI73297.1 chromosomal replication initiator protein DnaA [Fimbriimonas sp.] | diamond | 2160 | 122 | 0.991803278688525 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 32662278 | 32662278 | PRJNA1126198_P_NODE_396820_length_249_cov_0.886364_g396099_i0 | PRJNA1126198 | 396820 | 249 | 0.886364 | 2.20704636 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 108 | 1.37e-26 | NR | MCH7945476.1 | 2033014 | g396099 | i0 | 59.5 | 0.951807228915663 | 79 | 32 | 95.2 | 0 | 248 | 12 | 187 | 265 | MCH7945476.1 hypothetical protein [Armatimonadota bacterium] | diamond | 237 | 108 | 1 | 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);;