contig_metadata
8 rows where bioproject = "PRJNA436017", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4917094 | 4917094 | PRJNA436017_P_NODE_10704_length_262_cov_9.031111_g10406_i0 | PRJNA436017 | 10704 | 262 | 9.031111 | 23.66151082 | Chthonomonas | 1077265 | Bacteria | Bacteria | 220 | 6.19e-53 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g10406 | i0 | 85.068 | 156.450381679389 | 221 | 27 | 82 | 5 | 45 | 260 | 1547 | 1766 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 40990 | 220 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 8741940 | 8741940 | PRJNA436017_P_NODE_2507_length_596_cov_20.685152_g2252_i0 | PRJNA436017 | 2507 | 596 | 20.685152 | 123.28350592 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 917 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g2252 | i0 | 94.755 | 298.818791946309 | 591 | 28 | 99 | 3 | 8 | 596 | 26878 | 27467 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 178096 | 917 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 17007895 | 17007895 | PRJNA436017_P_NODE_12894_length_234_cov_1.751269_g12596_i0 | PRJNA436017 | 12894 | 234 | 1.751269 | 4.09796946 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 143 | 1.21e-29 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g12596 | i0 | 80.976 | 28.7435897435897 | 205 | 18 | 87 | 12 | 6 | 209 | 2045116 | 2045300 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 6726 | 143 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 17008293 | 17008293 | PRJNA436017_P_NODE_8534_length_300_cov_3.224335_g8236_i0 | PRJNA436017 | 8534 | 300 | 3.224335 | 9.673005 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 141 | 5.790000000000001e-29 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g8236 | i0 | 86.719 | 0.713333333333333 | 128 | 15 | 42 | 2 | 91 | 217 | 316601 | 316727 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 214 | 141 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 20832500 | 20832500 | PRJNA436017_P_NODE_24217_length_166_cov_1.162791_g23919_i0 | PRJNA436017 | 24217 | 166 | 1.162791 | 1.93023306 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 104 | 3.78e-18 | NTclustered | gi|2874253701|emb|OY969427.1| | 157466 | g23919 | i0 | 85.437 | 95.9939759036145 | 103 | 12 | 61 | 3 | 63 | 163 | 3409556 | 3409657 | MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1 | blastn | 15935 | 104 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 21490913 | 21490913 | PRJNA436017_P_NODE_5817_length_372_cov_4.128358_g5521_i0 | PRJNA436017 | 5817 | 372 | 4.128358 | 15.35749176 | Chthonomonas | 1077265 | Bacteria | Bacteria | 337 | 8.719999999999998e-88 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g5521 | i0 | 87.291 | 316.870967741935 | 299 | 33 | 80 | 5 | 3 | 299 | 1827 | 1532 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 117876 | 337 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 24657318 | 24657318 | PRJNA436017_P_NODE_6940_length_338_cov_21.584718_g6643_i0 | PRJNA436017 | 6940 | 338 | 21.584718 | 72.95634684 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 261 | 4.87e-65 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g6643 | i0 | 86.42 | 33.9733727810651 | 243 | 28 | 71 | 4 | 99 | 338 | 1690473 | 1690233 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 11483 | 261 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 31434598 | 31434598 | PRJNA436017_P_NODE_10576_length_264_cov_3.057269_g10278_i0 | PRJNA436017 | 10576 | 264 | 3.057269 | 8.07119016 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 42.7 | 0.0415 | NR | MBX3097562.1 | 2682144 | g10278 | i0 | 27.8 | 0.897727272727273 | 79 | 43 | 77.3 | 2 | 25 | 228 | 120 | 195 | MBX3097562.1 ThuA domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 237 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae 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);;