contig_metadata
11 rows where bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27319541 | 27319541 | PRJNA1022139_P_NODE_27443_length_276_cov_1.517241_g27338_i0 | PRJNA1022139 | 27443 | 276 | 1.517241 | 4.18758516 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 43.1 | 0.0391 | NR | HOS42235.1 | 2033014 | g27338 | i0 | 36.7 | 1.84782608695652 | 90 | 46 | 91.3 | 4 | 1 | 252 | 210 | 294 | HOS42235.1 SWIM zinc finger family protein [Armatimonadota bacterium] | diamond | 510 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28708885 | 28708885 | PRJNA1022139_P_NODE_20087_length_312_cov_1.230126_g19982_i0 | PRJNA1022139 | 20087 | 312 | 1.230126 | 3.83799312 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 67 | 2.55e-10 | NR | NUQ71235.1 | 2282151 | g19982 | i0 | 39.4 | 2.70192307692308 | 94 | 47 | 89.4 | 3 | 4 | 282 | 173 | 257 | NUQ71235.1 hypothetical protein [Chthonomonadales bacterium] | diamond | 843 | 67 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 28929774 | 28929774 | PRJNA1022139_P_NODE_24688_length_286_cov_1.098592_g24583_i0 | PRJNA1022139 | 24688 | 286 | 1.098592 | 3.14197312 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 44.3 | 0.0163 | NR | CAA9250576.1 | 157466 | g24583 | i0 | 45.2 | 0.881118881118881 | 84 | 40 | 82.9 | 3 | 36 | 272 | 216 | 298 | CAA9250576.1 HtrA protease/chaperone protein, partial [uncultured Armatimonadetes bacterium] | diamond | 252 | 44.3 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 29908745 | 29908745 | PRJNA1022139_P_NODE_30431_length_265_cov_1.604167_g30326_i0 | PRJNA1022139 | 30431 | 265 | 1.604167 | 4.25104255 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 43.1 | 0.0312 | NR | MCW5940485.1 | 2682144 | g30326 | i0 | 29.9 | 0.871698113207547 | 77 | 54 | 87.2 | 0 | 251 | 21 | 39 | 115 | MCW5940485.1 universal stress protein [Fimbriimonadaceae bacterium] | diamond | 231 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30311990 | 30311990 | PRJNA1022139_P_NODE_12_length_3411_cov_12.861893_g6_i1 | PRJNA1022139 | 12 | 3411 | 12.861893 | 438.71917023 | Bacteria | 2 | Bacteria | Bacteria | 52.4 | 0.0157 | NR | HSI73398.1 | 1936159 | g6 | i1 | 39.5 | 0.192612137203166 | 76 | 41 | 6.7 | 2 | 2837 | 2610 | 609 | 679 | HSI73398.1 PQQ-binding-like beta-propeller repeat protein [Fimbriimonas sp.] | diamond | 657 | 52.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 30817005 | 30817005 | PRJNA1022139_P_NODE_20514_length_309_cov_1.300847_g20409_i0 | PRJNA1022139 | 20514 | 309 | 1.300847 | 4.01961723 | FCB group | 1783270 | Bacteria | Bacteria | 84.7 | 8.77e-17 | NR | MDR3689127.1 | 1936159 | g20409 | i0 | 49.5 | 5.48543689320388 | 99 | 47 | 95.1 | 3 | 308 | 15 | 123 | 219 | MDR3689127.1 cellulase family glycosylhydrolase [Fimbriimonas sp.] | diamond | 1695 | 84.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 30951412 | 30951412 | PRJNA1022139_P_NODE_24834_length_285_cov_1.452830_g24729_i0 | PRJNA1022139 | 24834 | 285 | 1.45283 | 4.1405655 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 124 | 5.639999999999999e-31 | NR | HCE01256.1 | 2033014 | g24729 | i0 | 63.2 | 15 | 95 | 35 | 100 | 0 | 285 | 1 | 339 | 433 | HCE01256.1 HslU--HslV peptidase ATPase subunit [Armatimonadota bacterium] | diamond | 4275 | 124 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31425354 | 31425354 | PRJNA1022139_P_NODE_4076_length_630_cov_2.500898_g3972_i0 | PRJNA1022139 | 4076 | 630 | 2.500898 | 15.7556574 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 63.5 | 8.8e-8 | NR | HEY3266234.1 | 2033014 | g3972 | i0 | 31.3 | 0.838095238095238 | 176 | 103 | 78.1 | 7 | 585 | 94 | 462 | 631 | HEY3266234.1 PQQ-binding-like beta-propeller repeat protein [Armatimonadota bacterium] | diamond | 528 | 63.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31638827 | 31638827 | PRJNA1022139_P_NODE_156_length_2071_cov_12.903904_g6_i2 | PRJNA1022139 | 156 | 2071 | 12.903904 | 267.23985183999997 | Bacteria | 2 | Bacteria | Bacteria | 52.4 | 0.00823 | NR | HSI73398.1 | 1936159 | g6 | i2 | 39.5 | 0.317238049251569 | 76 | 41 | 11 | 2 | 575 | 802 | 609 | 679 | HSI73398.1 PQQ-binding-like beta-propeller repeat protein [Fimbriimonas sp.] | diamond | 657 | 52.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 32627150 | 32627150 | PRJNA1022139_P_NODE_2220_length_825_cov_1.514628_g2136_i0 | PRJNA1022139 | 2220 | 825 | 1.514628 | 12.495681 | Armatimonadia bacterium | 2663015 | Bacteria | Bacteria | 62.8 | 4.47e-7 | NR | MEN6302008.1 | 2663015 | g2136 | i0 | 28.9 | 0.818181818181818 | 225 | 150 | 81.1 | 4 | 131 | 799 | 21 | 237 | MEN6302008.1 PQQ-binding-like beta-propeller repeat protein [Armatimonadia bacterium] | diamond | 675 | 62.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadia bacterium | |||||
| 32816175 | 32816175 | PRJNA1022139_P_NODE_3680_length_658_cov_1.417094_g3577_i0 | PRJNA1022139 | 3680 | 658 | 1.417094 | 9.32447852 | Capsulimonadaceae bacterium | 2953755 | Bacteria | Bacteria | 47 | 0.0312 | NR | HEX5322765.1 | 2953755 | g3577 | i0 | 31.3 | 0.59726443768997 | 131 | 80 | 59.3 | 3 | 456 | 67 | 193 | 314 | HEX5322765.1 AEC family transporter [Capsulimonadaceae bacterium] | diamond | 393 | 47 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonadaceae 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);;