contig_metadata
6 rows where bioproject = "PRJNA1005695", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4829157 | 4829157 | PRJNA1005695_P_NODE_35544_length_251_cov_0.876404_g34692_i0 | PRJNA1005695 | 35544 | 251 | 0.876404 | 2.19977404 | Armatimonadota | 67819 | Bacteria | Bacteria | 217 | 7.619999999999999e-52 | NTclustered | gi|1996217993|dbj|AP021858.1| | 2608984 | g34692 | i0 | 84.956 | 44.4820717131474 | 226 | 21 | 87 | 11 | 1 | 219 | 36034 | 35815 | Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome | blastn | 11165 | 217 | 1 | Bacteria | Bacillati | Armatimonadota | Candidatus Nitrosymbiomonas | Candidatus Nitrosymbiomonas proteolyticus | |||||
| 12907148 | 12907148 | PRJNA1005695_P_NODE_18271_length_354_cov_0.907473_g17419_i0 | PRJNA1005695 | 18271 | 354 | 0.907473 | 3.21245442 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 326 | 1.79e-84 | NTclustered | gi|2874253701|emb|OY969427.1| | 157466 | g17419 | i0 | 83.761 | 191.333333333333 | 351 | 50 | 98 | 6 | 1 | 347 | 3408735 | 3408388 | MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1 | blastn | 67732 | 326 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 18005140 | 18005140 | PRJNA1005695_P_NODE_13915_length_410_cov_0.741840_g13063_i0 | PRJNA1005695 | 13915 | 410 | 0.74184 | 3.041544 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 472 | 2.5499999999999997e-128 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g13063 | i0 | 87.591 | 237.50487804878 | 411 | 45 | 99 | 6 | 1 | 409 | 1878937 | 1878531 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 97377 | 472 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28140179 | 28140179 | PRJNA1005695_P_NODE_27325_length_286_cov_1.464789_g26473_i0 | PRJNA1005695 | 27325 | 286 | 1.464789 | 4.18929654 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 45.8 | 0.00216 | NR | HCA47543.1 | 2033014 | g26473 | i0 | 39.6 | 0.503496503496504 | 48 | 29 | 50.3 | 0 | 20 | 163 | 83 | 130 | HCA47543.1 hypothetical protein [Armatimonadota bacterium] | diamond | 144 | 45.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28802743 | 28802743 | PRJNA1005695_P_NODE_34988_length_252_cov_1.608939_g34136_i0 | PRJNA1005695 | 34988 | 252 | 1.608939 | 4.05452628 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 167 | 1.74e-48 | NR | MFN8139294.1 | 2682145 | g34136 | i0 | 97.6 | 0.988095238095238 | 83 | 2 | 98.8 | 0 | 251 | 3 | 195 | 277 | MFN8139294.1 histidinol-phosphate transaminase [Fimbriimonadales bacterium] | diamond | 249 | 167 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 29087295 | 29087295 | PRJNA1005695_P_NODE_25828_length_295_cov_1.405405_g24976_i0 | PRJNA1005695 | 25828 | 295 | 1.405405 | 4.14594475 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 86.7 | 1.05e-17 | NR | HIE52877.1 | 2033014 | g24976 | i0 | 48.9 | 0.894915254237288 | 88 | 39 | 89.5 | 1 | 30 | 293 | 246 | 327 | HIE52877.1 NADH:flavin oxidoreductase [Armatimonadota bacterium] | diamond | 264 | 86.7 | 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);;