contig_metadata
24 rows where bioproject = "PRJNA900028", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7253576 | 7253576 | PRJNA900028_P_NODE_34786_length_229_cov_2.327778_g34037_i0 | PRJNA900028 | 34786 | 229 | 2.327778 | 5.33061162 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 185 | 1.9299999999999994e-42 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g34037 | i0 | 84.946 | 261.301310043668 | 186 | 25 | 80 | 3 | 46 | 229 | 1304104 | 1304288 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 59838 | 185 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 8897887 | 8897887 | PRJNA900028_P_NODE_17947_length_281_cov_3.383621_g17198_i0 | PRJNA900028 | 17947 | 281 | 3.383621 | 9.50797501 | Bacteria | 2 | Bacteria | Bacteria | 204 | 6.76e-48 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g17198 | i0 | 80.139 | 73.8932384341637 | 287 | 45 | 100 | 11 | 1 | 281 | 1304902 | 1304622 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 20764 | 206 | 0.990291262135922 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 16177505 | 16177505 | PRJNA900028_P_NODE_153013_length_164_cov_1.521739_g152264_i0 | PRJNA900028 | 153013 | 164 | 1.521739 | 2.49565196 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 303 | 3.42e-78 | NTclustered | gi|1493551556|dbj|LC378776.1| | 2033014 | g152264 | i0 | 100 | 98.8109756097561 | 164 | 0 | 100 | 0 | 1 | 164 | 153 | 316 | Armatimonadetes bacterium LA-DMC-2W6 gene for 16S ribosomal RNA, partial sequence | blastn | 16205 | 303 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 18726579 | 18726579 | PRJNA900028_P_NODE_190235_length_161_cov_0.910714_g189486_i0 | PRJNA900028 | 190235 | 161 | 0.910714 | 1.46624954 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 65.8 | 1.72e-6 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g189486 | i0 | 87.719 | 0.354037267080745 | 57 | 5 | 35 | 2 | 106 | 161 | 801024 | 800969 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 57 | 65.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 26675628 | 26675628 | PRJNA900028_P_NODE_179441_length_162_cov_0.902655_g178692_i0 | PRJNA900028 | 179441 | 162 | 0.902655 | 1.4623011 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 90.9 | 1.38e-19 | NR | MBI3911232.1 | 2033014 | g178692 | i0 | 81.5 | 1.98148148148148 | 54 | 10 | 100 | 0 | 162 | 1 | 463 | 516 | MBI3911232.1 potassium-transporting ATPase subunit KdpA [Armatimonadota bacterium] | diamond | 321 | 90.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27782475 | 27782475 | PRJNA900028_P_NODE_178904_length_162_cov_0.902655_g178155_i0 | PRJNA900028 | 178904 | 162 | 0.902655 | 1.4623011 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 75.5 | 2.34e-14 | NR | MCW5936407.1 | 2682144 | g178155 | i0 | 62.3 | 0.981481481481482 | 53 | 20 | 98.1 | 0 | 162 | 4 | 220 | 272 | MCW5936407.1 bifunctional oligoribonuclease/PAP phosphatase NrnA [Fimbriimonadaceae bacterium] | diamond | 159 | 75.5 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27814171 | 27814171 | PRJNA900028_P_NODE_62964_length_194_cov_1.172414_g62215_i0 | PRJNA900028 | 62964 | 194 | 1.172414 | 2.27448316 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 115 | 1.04e-28 | NR | MCW3095391.1 | 2739509 | g62215 | i0 | 78.1 | 0.989690721649485 | 64 | 14 | 99 | 0 | 193 | 2 | 152 | 215 | MCW3095391.1 mandelate racemase/muconate lactonizing enzyme family protein [Chthonomonadaceae bacterium] | diamond | 192 | 115 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 28097980 | 28097980 | PRJNA900028_P_NODE_150305_length_165_cov_0.879310_g149556_i0 | PRJNA900028 | 150305 | 165 | 0.87931 | 1.4508615 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 69.7 | 1.5e-12 | NR | MCC7228853.1 | 2682144 | g149556 | i0 | 59.3 | 1.96363636363636 | 54 | 21 | 96.4 | 1 | 161 | 3 | 184 | 237 | MCC7228853.1 calcineurin-like phosphoesterase C-terminal domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 324 | 69.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28192571 | 28192571 | PRJNA900028_P_NODE_167726_length_163_cov_0.894737_g166977_i0 | PRJNA900028 | 167726 | 163 | 0.894737 | 1.45842131 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 66.6 | 1.38e-12 | NR | MBC8136836.1 | 2033014 | g166977 | i0 | 64 | 1.84049079754601 | 50 | 18 | 92 | 0 | 2 | 151 | 49 | 98 | MBC8136836.1 acylphosphatase [Armatimonadota bacterium] | diamond | 300 | 66.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28326576 | 28326576 | PRJNA900028_P_NODE_145266_length_165_cov_0.879310_g144517_i0 | PRJNA900028 | 145266 | 165 | 0.87931 | 1.4508615 | Armatimonas | 1042315 | Bacteria | Bacteria | 51.2 | 1.36e-5 | NR | WP_184197582.1 | 685828 | g144517 | i0 | 52.9 | 4.67272727272727 | 51 | 24 | 92.7 | 0 | 1 | 153 | 773 | 823 | WP_184197582.1 diguanylate cyclase [Armatimonas rosea] | diamond | 771 | 51.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas rosea | ||
| 28382241 | 28382241 | PRJNA900028_P_NODE_163786_length_163_cov_2.543860_g163037_i0 | PRJNA900028 | 163786 | 163 | 2.54386 | 4.1464918 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 58.5 | 3.24e-8 | NR | MFN8218559.1 | 2682145 | g163037 | i0 | 58.8 | 1.84049079754601 | 51 | 17 | 93.9 | 2 | 9 | 161 | 495 | 541 | MFN8218559.1 S8 family serine peptidase [Fimbriimonadales bacterium] | diamond | 300 | 58.5 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 28792516 | 28792516 | PRJNA900028_P_NODE_162627_length_164_cov_0.886957_g161878_i0 | PRJNA900028 | 162627 | 164 | 0.886957 | 1.45460948 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 90.9 | 2.48e-20 | NR | MCW3098729.1 | 2739509 | g161878 | i0 | 77.8 | 4.9390243902439 | 54 | 12 | 98.8 | 0 | 3 | 164 | 23 | 76 | MCW3098729.1 ABC-type polysaccharide/polyol phosphate export system, permease component [Chthonomonadaceae bacterium] | diamond | 810 | 90.9 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 28800116 | 28800116 | PRJNA900028_P_NODE_69947_length_189_cov_1.457143_g69198_i0 | PRJNA900028 | 69947 | 189 | 1.457143 | 2.75400027 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 59.7 | 1.79e-8 | NR | WP_025228725.1 | 1005039 | g69198 | i0 | 78.9 | 5.46031746031746 | 38 | 8 | 60.3 | 0 | 186 | 73 | 305 | 342 | WP_025228725.1 heat-inducible transcriptional repressor HrcA [Fimbriimonas ginsengisoli] | diamond | 1032 | 60.1 | 0.993344425956739 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 28918803 | 28918803 | PRJNA900028_P_NODE_186148_length_162_cov_0.902655_g185399_i0 | PRJNA900028 | 186148 | 162 | 0.902655 | 1.4623011 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 65.1 | 1.65e-10 | NR | MBW3637980.1 | 2033014 | g185399 | i0 | 67.3 | 0.962962962962963 | 52 | 15 | 96.3 | 1 | 162 | 7 | 140 | 189 | MBW3637980.1 glycosyltransferase family 39 protein [Armatimonadota bacterium] | diamond | 156 | 65.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29076999 | 29076999 | PRJNA900028_P_NODE_123448_length_167_cov_0.864407_g122699_i0 | PRJNA900028 | 123448 | 167 | 0.864407 | 1.44355969 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 60.1 | 9.86e-9 | NR | HVK06525.1 | 2933160 | g122699 | i0 | 60 | 0.988023952095808 | 55 | 19 | 98.8 | 1 | 1 | 165 | 144 | 195 | HVK06525.1 redoxin domain-containing protein [Armatimonadaceae bacterium] | diamond | 165 | 60.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 29084629 | 29084629 | PRJNA900028_P_NODE_101608_length_175_cov_1.269841_g100859_i0 | PRJNA900028 | 101608 | 175 | 1.269841 | 2.22222175 | root | 1 | Root_unresolved | Root_unresolved | 64.3 | 3.66e-10 | NR | MEA2553607.1 | 2682144 | g100859 | i0 | 52 | 1.83428571428571 | 50 | 24 | 85.7 | 0 | 1 | 150 | 308 | 357 | MEA2553607.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 321 | 64.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29368719 | 29368719 | PRJNA900028_P_NODE_163249_length_164_cov_0.886957_g162500_i0 | PRJNA900028 | 163249 | 164 | 0.886957 | 1.45460948 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 93.6 | 1.7400000000000003e-21 | NR | HEY0866683.1 | 1936159 | g162500 | i0 | 86.8 | 7.75609756097561 | 53 | 7 | 97 | 0 | 4 | 162 | 1 | 53 | HEY0866683.1 PspA/IM30 family protein [Fimbriimonas sp.] | diamond | 1272 | 93.6 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 29581737 | 29581737 | PRJNA900028_P_NODE_98630_length_176_cov_1.606299_g97881_i0 | PRJNA900028 | 98630 | 176 | 1.606299 | 2.82708624 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 92.8 | 3.28e-20 | NR | MDQ3812567.1 | 2033014 | g97881 | i0 | 70.2 | 1.94318181818182 | 57 | 17 | 97.2 | 0 | 1 | 171 | 131 | 187 | MDQ3812567.1 hypothetical protein [Armatimonadota bacterium] | diamond | 342 | 92.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30277312 | 30277312 | PRJNA900028_P_NODE_155852_length_164_cov_0.886957_g155103_i0 | PRJNA900028 | 155852 | 164 | 0.886957 | 1.45460948 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 63.2 | 7.92e-10 | NR | MBL8066048.1 | 2739509 | g155103 | i0 | 96.4 | 0.51219512195122 | 28 | 1 | 51.2 | 0 | 162 | 79 | 861 | 888 | MBL8066048.1 aconitate hydratase AcnA [Chthonomonadaceae bacterium] | diamond | 84 | 63.2 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30372133 | 30372133 | PRJNA900028_P_NODE_128312_length_167_cov_0.864407_g127563_i0 | PRJNA900028 | 128312 | 167 | 0.864407 | 1.44355969 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 54.3 | 1.07e-6 | NR | MBW3638150.1 | 2033014 | g127563 | i0 | 55.3 | 0.844311377245509 | 47 | 21 | 84.4 | 0 | 4 | 144 | 276 | 322 | MBW3638150.1 diguanylate cyclase [Armatimonadota bacterium] | diamond | 141 | 54.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31383145 | 31383145 | PRJNA900028_P_NODE_98296_length_176_cov_2.133858_g97547_i0 | PRJNA900028 | 98296 | 176 | 2.133858 | 3.75559008 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 70.1 | 2.46e-12 | NR | MES2465106.1 | 2033014 | g97547 | i0 | 97.2 | 0.613636363636364 | 36 | 1 | 61.4 | 0 | 2 | 109 | 290 | 325 | MES2465106.1 sugar ABC transporter permease [Armatimonadota bacterium] | diamond | 108 | 70.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31414607 | 31414607 | PRJNA900028_P_NODE_105356_length_173_cov_1.645161_g104607_i0 | PRJNA900028 | 105356 | 173 | 1.645161 | 2.84612853 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 45.8 | 0.00117 | NR | HVK03143.1 | 2933160 | g104607 | i0 | 43.5 | 0.797687861271676 | 46 | 26 | 79.8 | 0 | 34 | 171 | 134 | 179 | HVK03143.1 hypothetical protein [Armatimonadaceae bacterium] | diamond | 138 | 45.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 31793931 | 31793931 | PRJNA900028_P_NODE_132337_length_166_cov_0.871795_g131588_i0 | PRJNA900028 | 132337 | 166 | 0.871795 | 1.4471797 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 77.8 | 2.42e-15 | NR | HVK07109.1 | 2933160 | g131588 | i0 | 70.4 | 0.975903614457831 | 54 | 16 | 97.6 | 0 | 164 | 3 | 193 | 246 | HVK07109.1 farnesyl diphosphate synthase [Armatimonadaceae bacterium] | diamond | 162 | 77.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 32205517 | 32205517 | PRJNA900028_P_NODE_145538_length_165_cov_0.879310_g144789_i0 | PRJNA900028 | 145538 | 165 | 0.87931 | 1.4508615 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 81.3 | 3.29e-16 | NR | MBC7808974.1 | 2033014 | g144789 | i0 | 72.7 | 2 | 55 | 15 | 100 | 0 | 1 | 165 | 250 | 304 | MBC7808974.1 ABC transporter permease [Armatimonadota bacterium] | diamond | 330 | 81.3 | 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);;