contig_metadata
18 rows where bioproject = "PRJNA929922", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14933660 | 14933660 | PRJNA929922_P_NODE_118952_length_249_cov_0.875000_g118412_i0 | PRJNA929922 | 118952 | 249 | 0.875 | 2.17875 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 250 | 7.4499999999999995e-62 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g118412 | i0 | 85.246 | 0.979919678714859 | 244 | 34 | 98 | 2 | 7 | 249 | 4521393 | 4521635 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 244 | 250 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 26676384 | 26676384 | PRJNA929922_P_NODE_136181_length_246_cov_0.890173_g135641_i0 | PRJNA929922 | 136181 | 246 | 0.890173 | 2.18982558 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 127 | 5.299999999999999e-32 | NR | MDQ2801098.1 | 2033014 | g135641 | i0 | 70.4 | 0.98780487804878 | 81 | 24 | 98.8 | 0 | 3 | 245 | 574 | 654 | MDQ2801098.1 TonB-dependent receptor [Armatimonadota bacterium] | diamond | 243 | 127 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26803254 | 26803254 | PRJNA929922_P_NODE_142101_length_245_cov_0.895349_g141561_i0 | PRJNA929922 | 142101 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 91.3 | 2.95e-19 | NR | MBC7806589.1 | 2033014 | g141561 | i0 | 57.5 | 0.979591836734694 | 80 | 34 | 98 | 0 | 245 | 6 | 297 | 376 | MBC7806589.1 hypothetical protein [Armatimonadota bacterium] | diamond | 240 | 91.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27088229 | 27088229 | PRJNA929922_P_NODE_159062_length_242_cov_0.911243_g158522_i0 | PRJNA929922 | 159062 | 242 | 0.911243 | 2.20520806 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 87 | 9.34e-18 | NR | HVK06232.1 | 2933160 | g158522 | i0 | 54.7 | 1.06611570247934 | 86 | 27 | 91.7 | 1 | 235 | 14 | 436 | 521 | HVK06232.1 APC family permease [Armatimonadaceae bacterium] | diamond | 258 | 87 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 27530465 | 27530465 | PRJNA929922_P_NODE_156703_length_242_cov_0.911243_g156163_i0 | PRJNA929922 | 156703 | 242 | 0.911243 | 2.20520806 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 78.6 | 7.81e-15 | NR | HZP81800.1 | 2739509 | g156163 | i0 | 55.1 | 0.966942148760331 | 78 | 34 | 95.5 | 1 | 10 | 240 | 74 | 151 | HZP81800.1 enolase C-terminal domain-like protein [Chthonomonadaceae bacterium] | diamond | 234 | 78.6 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 27561812 | 27561812 | PRJNA929922_P_NODE_157604_length_242_cov_0.911243_g157064_i0 | PRJNA929922 | 157604 | 242 | 0.911243 | 2.20520806 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 77.4 | 2.2e-14 | NR | MBC7808734.1 | 2033014 | g157064 | i0 | 61.7 | 1.48760330578512 | 60 | 22 | 74.4 | 1 | 61 | 240 | 310 | 368 | MBC7808734.1 Ig-like domain-containing protein [Armatimonadota bacterium] | diamond | 360 | 77.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27846069 | 27846069 | PRJNA929922_P_NODE_120404_length_249_cov_0.875000_g119864_i0 | PRJNA929922 | 120404 | 249 | 0.875 | 2.17875 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 135 | 2.73e-37 | NR | MES2462206.1 | 2033014 | g119864 | i0 | 86.6 | 0.987951807228916 | 82 | 11 | 98.8 | 0 | 3 | 248 | 46 | 127 | MES2462206.1 DUF1553 domain-containing protein [Armatimonadota bacterium] | diamond | 246 | 135 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27941014 | 27941014 | PRJNA929922_P_NODE_143945_length_244_cov_0.900585_g143405_i0 | PRJNA929922 | 143945 | 244 | 0.900585 | 2.1974274 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 76.6 | 5.61e-15 | NR | HLJ55898.1 | 2739509 | g143405 | i0 | 68.3 | 0.504098360655738 | 41 | 13 | 50.4 | 0 | 113 | 235 | 3 | 43 | HLJ55898.1 SurA N-terminal domain-containing protein [Chthonomonadaceae bacterium] | diamond | 123 | 76.6 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 28358329 | 28358329 | PRJNA929922_P_NODE_142126_length_245_cov_0.895349_g141586_i0 | PRJNA929922 | 142126 | 245 | 0.895349 | 2.19360505 | Capsulimonas | 2494209 | Bacteria | Bacteria | 70.9 | 6.26e-13 | NR | MDQ2688581.1 | 2033014 | g141586 | i0 | 81.6 | 0.930612244897959 | 38 | 7 | 46.5 | 0 | 245 | 132 | 149 | 186 | MDQ2688581.1 glycosyltransferase family 2 protein [Armatimonadota bacterium] | diamond | 228 | 70.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29172472 | 29172472 | PRJNA929922_P_NODE_122469_length_248_cov_0.880000_g121929_i0 | PRJNA929922 | 122469 | 248 | 0.88 | 2.1824 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 129 | 5.89e-33 | NR | MFI5386935.1 | 2682145 | g121929 | i0 | 71.3 | 0.967741935483871 | 80 | 23 | 96.8 | 0 | 248 | 9 | 13 | 92 | MFI5386935.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 240 | 129 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 30278034 | 30278034 | PRJNA929922_P_NODE_152792_length_243_cov_0.905882_g152252_i0 | PRJNA929922 | 152792 | 243 | 0.905882 | 2.20129326 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 161 | 6.03e-44 | NR | MCW3096380.1 | 2739509 | g152252 | i0 | 97.5 | 0.987654320987654 | 80 | 2 | 98.8 | 0 | 241 | 2 | 22 | 101 | MCW3096380.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 240 | 161 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30530333 | 30530333 | PRJNA929922_P_NODE_139793_length_245_cov_0.895349_g139253_i0 | PRJNA929922 | 139793 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 53.1 | 7.8e-6 | NR | MCC2668357.1 | 2033014 | g139253 | i0 | 37.5 | 0.979591836734694 | 80 | 44 | 98 | 2 | 245 | 6 | 264 | 337 | MCC2668357.1 hypothetical protein [Armatimonadota bacterium] | diamond | 240 | 53.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30846422 | 30846422 | PRJNA929922_P_NODE_147614_length_244_cov_0.900585_g147074_i0 | PRJNA929922 | 147614 | 244 | 0.900585 | 2.1974274 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 78.6 | 8.92e-15 | NR | HTE17626.1 | 2033014 | g147074 | i0 | 56.3 | 0.786885245901639 | 64 | 28 | 78.7 | 0 | 3 | 194 | 762 | 825 | HTE17626.1 YfhO family protein [Armatimonadota bacterium] | diamond | 192 | 78.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30877966 | 30877966 | PRJNA929922_P_NODE_139934_length_245_cov_0.895349_g139394_i0 | PRJNA929922 | 139934 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 156 | 1.77e-44 | NR | MBC8136072.1 | 2033014 | g139394 | i0 | 91.4 | 0.991836734693878 | 81 | 7 | 99.2 | 0 | 244 | 2 | 98 | 178 | MBC8136072.1 AAA family ATPase [Armatimonadota bacterium] | diamond | 243 | 156 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31573676 | 31573676 | PRJNA929922_P_NODE_136156_length_246_cov_0.890173_g135616_i0 | PRJNA929922 | 136156 | 246 | 0.890173 | 2.18982558 | Capsulimonas corticalis | 2219043 | Bacteria | Bacteria | 97.8 | 1.61e-21 | NR | WP_165864656.1 | 2219043 | g135616 | i0 | 57.8 | 1.01219512195122 | 83 | 32 | 97.6 | 1 | 245 | 6 | 594 | 676 | WP_165864656.1 beta-galactosidase [Capsulimonas corticalis] | diamond | 249 | 97.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas corticalis | ||
| 31921418 | 31921418 | PRJNA929922_P_NODE_135957_length_246_cov_0.890173_g135417_i0 | PRJNA929922 | 135957 | 246 | 0.890173 | 2.18982558 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 109 | 6e-26 | NR | MES2464637.1 | 2033014 | g135417 | i0 | 74.7 | 0.963414634146341 | 79 | 20 | 96.3 | 0 | 8 | 244 | 295 | 373 | MES2464637.1 MFS transporter [Armatimonadota bacterium] | diamond | 237 | 109 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32086732 | 32086732 | PRJNA929922_P_NODE_113658_length_250_cov_0.870056_g113118_i0 | PRJNA929922 | 113658 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 117 | 5.68e-29 | NR | MBC7529312.1 | 2739509 | g113118 | i0 | 75.6 | 3.972 | 82 | 19 | 98.4 | 1 | 4 | 249 | 222 | 302 | MBC7529312.1 magnesium transporter [Chthonomonadaceae bacterium] | diamond | 993 | 117 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 32301502 | 32301502 | PRJNA929922_P_NODE_126219_length_248_cov_0.880000_g125679_i0 | PRJNA929922 | 126219 | 248 | 0.88 | 2.1824 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 86.7 | 1.39e-17 | NR | HMS57175.1 | 2682144 | g125679 | i0 | 60.8 | 3.58064516129032 | 74 | 28 | 89.5 | 1 | 230 | 9 | 65 | 137 | HMS57175.1 family 78 glycoside hydrolase catalytic domain [Fimbriimonadaceae bacterium] | diamond | 888 | 86.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);;