contig_metadata
10 rows where bioproject = "PRJNA597223", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3692146 | 3692146 | PRJNA597223_P_NODE_35703_length_243_cov_11.177885_g33857_i0 | PRJNA597223 | 35703 | 243 | 11.177885 | 27.16226055 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 196 | 9.56e-46 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g33857 | i0 | 81.857 | 200.950617283951 | 237 | 39 | 97 | 4 | 9 | 243 | 29785 | 29551 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 48831 | 196 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 5672829 | 5672829 | PRJNA597223_P_NODE_36425_length_240_cov_4.112195_g34579_i0 | PRJNA597223 | 36425 | 240 | 4.112195 | 9.869268 | Armatimonadetes bacterium Uphvl-Ar2 | 2004468 | Bacteria | Bacteria | 196 | 9.42e-46 | NTclustered | gi|1199101103|gb|CP021424.1| | 2004468 | g34579 | i0 | 83.645 | 0.891666666666667 | 214 | 29 | 88 | 6 | 1 | 211 | 2201002 | 2200792 | Armatimonadetes bacterium Uphvl-Ar2 genome | blastn | 214 | 196 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Uphvl-Ar2 | ||||||
| 6244300 | 6244300 | PRJNA597223_P_NODE_3925_length_876_cov_18.745541_g728_i4 | PRJNA597223 | 3925 | 876 | 18.745541 | 164.21093916 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 1273 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g728 | i4 | 92.947 | 212.461187214612 | 879 | 54 | 100 | 7 | 1 | 876 | 29173 | 28300 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 186116 | 1273 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 10069278 | 10069278 | PRJNA597223_P_NODE_3588_length_910_cov_12.955429_g728_i3 | PRJNA597223 | 3588 | 910 | 12.955429 | 117.8944039 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 1297 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g728 | i3 | 92.426 | 254.921978021978 | 911 | 65 | 100 | 3 | 1 | 910 | 29207 | 28300 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 231979 | 1297 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 10773155 | 10773155 | PRJNA597223_P_NODE_16589_length_407_cov_4.435484_g14783_i0 | PRJNA597223 | 16589 | 407 | 4.435484 | 18.05241988 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 316 | 1.25e-81 | NTclustered | gi|1493551556|dbj|LC378776.1| | 2033014 | g14783 | i0 | 93.119 | 57.2334152334152 | 218 | 11 | 53 | 4 | 1 | 216 | 1025 | 1240 | Armatimonadetes bacterium LA-DMC-2W6 gene for 16S ribosomal RNA, partial sequence | blastn | 23294 | 316 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 12619679 | 12619679 | PRJNA597223_P_NODE_1170_length_1512_cov_93.716317_g728_i0 | PRJNA597223 | 1170 | 1512 | 93.716317 | 1416.99071304 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 1282 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g728 | i0 | 91.004 | 474.580026455026 | 956 | 78 | 63 | 6 | 560 | 1512 | 29250 | 28300 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 717565 | 1282 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 17146863 | 17146863 | PRJNA597223_P_NODE_48374_length_201_cov_2.084337_g46528_i0 | PRJNA597223 | 48374 | 201 | 2.084337 | 4.18951737 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 191 | 3.55e-44 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g46528 | i0 | 83.744 | 562.63184079602 | 203 | 31 | 100 | 2 | 1 | 201 | 1304705 | 1304503 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 113089 | 191 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 19695825 | 19695825 | PRJNA597223_P_NODE_69896_length_171_cov_1.316176_g68050_i0 | PRJNA597223 | 69896 | 171 | 1.316176 | 2.25066096 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 158 | 2.9499999999999992e-34 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g68050 | i0 | 83.429 | 86.8654970760234 | 175 | 24 | 100 | 5 | 1 | 171 | 1306148 | 1306321 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 14854 | 158 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 22817946 | 22817946 | PRJNA597223_P_NODE_5178_length_766_cov_13.068399_g728_i5 | PRJNA597223 | 5178 | 766 | 13.068399 | 100.10393634 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 985 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g728 | i5 | 90 | 170.083550913838 | 770 | 66 | 100 | 8 | 1 | 766 | 28089 | 28851 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 130284 | 985 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 26795051 | 26795051 | PRJNA597223_P_NODE_50721_length_196_cov_1.490683_g48875_i0 | PRJNA597223 | 50721 | 196 | 1.490683 | 2.92173868 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 90.1 | 1.89e-19 | NR | HEY0866811.1 | 1936159 | g48875 | i0 | 65.6 | 1.95918367346939 | 64 | 22 | 98 | 0 | 1 | 192 | 165 | 228 | HEY0866811.1 DNA polymerase III subunit delta [Fimbriimonas sp.] | diamond | 384 | 90.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. |
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);;