contig_metadata
8 rows where bioproject = "PRJNA206070" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5469406 | 5469406 | PRJNA206070_S_NODE_10265_length_373_cov_30.869048_g8390_i0 | PRJNA206070 | 10265 | 373 | 30.869048 | 115.14154904 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 425 | 1.81e-114 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g8390 | i0 | 90.244 | 64.4504021447721 | 328 | 28 | 87 | 4 | 41 | 366 | 29469 | 29794 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 24040 | 425 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 5470071 | 5470071 | PRJNA206070_S_NODE_9325_length_406_cov_33.292683_g7452_i0 | PRJNA206070 | 9325 | 406 | 33.292683 | 135.16829298 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 640 | 6.54e-179 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g7452 | i0 | 95.074 | 905.536945812808 | 406 | 20 | 100 | 0 | 1 | 406 | 1687578 | 1687983 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 367648 | 640 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 8019478 | 8019478 | PRJNA206070_S_NODE_12047_length_322_cov_120.140351_g10171_i0 | PRJNA206070 | 12047 | 322 | 120.140351 | 386.85193022 | uncultured Fimbriimonas sp. | 1936177 | Bacteria | Bacteria | 512 | 1.1499999999999998e-140 | NTclustered | gi|1154724300|gb|KX379253.1| | 1936177 | g10171 | i0 | 95.342 | 98.9409937888199 | 322 | 15 | 100 | 0 | 1 | 322 | 15 | 336 | Uncultured Fimbriimonas sp. clone OD-9 16S ribosomal RNA gene, partial sequence | blastn | 31859 | 512 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | uncultured Fimbriimonas sp. | ||
| 10570438 | 10570438 | PRJNA206070_S_NODE_22989_length_184_cov_3.319728_g21113_i0 | PRJNA206070 | 22989 | 184 | 3.319728 | 6.10829952 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 228 | 2.4299999999999996e-55 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g21113 | i0 | 90.643 | 41.5597826086956 | 171 | 16 | 93 | 0 | 1 | 171 | 1878813 | 1878983 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 7647 | 228 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 14395214 | 14395214 | PRJNA206070_S_NODE_13272_length_296_cov_4.096525_g11396_i0 | PRJNA206070 | 13272 | 296 | 4.096525 | 12.125714 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 309 | 1.48e-79 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g11396 | i0 | 85.619 | 1.01013513513514 | 299 | 38 | 100 | 5 | 1 | 296 | 1625531 | 1625827 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 299 | 309 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 27326873 | 27326873 | PRJNA206070_S_NODE_28443_length_159_cov_1.581967_g26567_i0 | PRJNA206070 | 28443 | 159 | 1.581967 | 2.51532753 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 77 | 8.87e-16 | NR | MFQ3669016.1 | 2682144 | g26567 | i0 | 63.5 | 0.981132075471698 | 52 | 19 | 98.1 | 0 | 2 | 157 | 80 | 131 | MFQ3669016.1 WcaF family extracellular polysaccharide biosynthesis acetyltransferase [Fimbriimonadaceae bacterium] | diamond | 156 | 77 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30579250 | 30579250 | PRJNA206070_S_NODE_26593_length_166_cov_1.511628_g24717_i0 | PRJNA206070 | 26593 | 166 | 1.511628 | 2.50930248 | Armatimonadetes bacterium CG_4_1 | 2033014 | Bacteria | Bacteria | 103 | 5.899999999999999e-24 | NR | PIY44557.1 | 1973909 | g24717 | i0 | 100 | 0.993975903614458 | 55 | 0 | 99.4 | 0 | 2 | 166 | 182 | 236 | PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] | diamond | 165 | 103 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10 | ||||||
| 32350435 | 32350435 | PRJNA206070_S_NODE_20459_length_202_cov_1.418182_g18583_i0 | PRJNA206070 | 20459 | 202 | 1.418182 | 2.86472764 | Armatimonadetes bacterium CG_4_1 | 2033014 | Bacteria | Bacteria | 127 | 1.61e-32 | NR | PIY44557.1 | 1973909 | g18583 | i0 | 100 | 0.98019801980198 | 66 | 0 | 98 | 0 | 200 | 3 | 475 | 540 | PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] | diamond | 198 | 127 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10 |
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);;