contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2474121 | 2474121 | PRJNA745553_S_NODE_7502_length_434_cov_1.972299_g7307_i0 | PRJNA745553 | 7502 | 434 | 1.972299 | 8.55977766 | Chthonomonas | 1077265 | Bacteria | Bacteria | 401 | 3.609999999999999e-107 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g7307 | i0 | 87.679 | 162.65668202765 | 349 | 38 | 80 | 5 | 89 | 434 | 1556 | 1902 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 70593 | 401 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 5026936 | 5026936 | PRJNA745553_S_NODE_28824_length_227_cov_2.500000_g28629_i0 | PRJNA745553 | 28824 | 227 | 2.5 | 5.675 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 254 | 5.16e-63 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g28629 | i0 | 88.942 | 55.5242290748899 | 208 | 20 | 91 | 3 | 11 | 217 | 29581 | 29786 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 12604 | 254 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 10928083 | 10928083 | PRJNA745553_S_NODE_15969_length_308_cov_16.455319_g15774_i0 | PRJNA745553 | 15969 | 308 | 16.455319 | 50.68238252 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 274 | 5.64e-69 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g15774 | i0 | 86.992 | 0.798701298701299 | 246 | 28 | 79 | 4 | 24 | 267 | 1625878 | 1625635 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 246 | 274 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 10928266 | 10928266 | PRJNA745553_S_NODE_27049_length_239_cov_4.253012_g26854_i0 | PRJNA745553 | 27049 | 239 | 4.253012 | 10.16469868 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 224 | 4.3e-54 | NTclustered | gi|2076452338|gb|CP075364.1| | 2682144 | g26854 | i0 | 88.421 | 97.928870292887 | 190 | 17 | 78 | 5 | 28 | 214 | 667597 | 667410 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome | blastn | 23405 | 224 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 12203651 | 12203651 | PRJNA745553_S_NODE_21310_length_268_cov_1.579487_g21115_i0 | PRJNA745553 | 21310 | 268 | 1.579487 | 4.23302516 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 263 | 1.04e-65 | NTclustered | gi|2874253701|emb|OY969427.1| | 157466 | g21115 | i0 | 84.791 | 219.369402985075 | 263 | 39 | 98 | 1 | 1 | 263 | 3407445 | 3407184 | MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1 | blastn | 58791 | 263 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 16501615 | 16501615 | PRJNA745553_S_NODE_18013_length_291_cov_1.481651_g17818_i0 | PRJNA745553 | 18013 | 291 | 1.481651 | 4.31160441 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 322 | 1.86e-83 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g17818 | i0 | 86.689 | 88.2199312714777 | 293 | 36 | 100 | 3 | 1 | 291 | 28942 | 29233 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 25672 | 322 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 23677070 | 23677070 | PRJNA745553_S_NODE_1419_length_712_cov_20.586854_g556_i1 | PRJNA745553 | 1419 | 712 | 20.586854 | 146.57840048 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 832 | 0 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g556 | i1 | 89.697 | 214.009831460674 | 660 | 57 | 92 | 9 | 58 | 711 | 1687573 | 1688227 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 152375 | 832 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 24950929 | 24950929 | PRJNA745553_S_NODE_5940_length_474_cov_6.049875_g5746_i0 | PRJNA745553 | 5940 | 474 | 6.049875 | 28.6764075 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 211 | 7.19e-50 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g5746 | i0 | 83.478 | 66.746835443038 | 230 | 34 | 48 | 4 | 4 | 231 | 1305729 | 1305502 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 31638 | 211 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes 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);;