contig_metadata
16 rows where bioproject = "PRJNA1028258", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2279832 | 2279832 | PRJNA1028258_P_NODE_137202_length_234_cov_0.860606_g136639_i0 | PRJNA1028258 | 137202 | 234 | 0.860606 | 2.01381804 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 77.8 | 3.59e-15 | NR | MFM7320311.1 | 2033014 | g136639 | i0 | 56.4 | 1.78205128205128 | 78 | 29 | 93.6 | 1 | 227 | 9 | 39 | 116 | MFM7320311.1 SDR family NAD(P)-dependent oxidoreductase [Armatimonadota bacterium] | diamond | 417 | 77.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 2714389 | 2714389 | PRJNA1028258_P_NODE_159583_length_229_cov_0.887500_g159020_i0 | PRJNA1028258 | 159583 | 229 | 0.8875 | 2.032375 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 196 | 8.92e-46 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g159020 | i0 | 82.328 | 3.34061135371179 | 232 | 35 | 100 | 5 | 1 | 229 | 1689085 | 1688857 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 765 | 196 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 3990702 | 3990702 | PRJNA1028258_P_NODE_172764_length_226_cov_0.904459_g172201_i0 | PRJNA1028258 | 172764 | 226 | 0.904459 | 2.04407734 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 131 | 1.54e-33 | NR | HZT43780.1 | 2739509 | g172201 | i0 | 85.3 | 4.9646017699115 | 75 | 11 | 99.6 | 0 | 225 | 1 | 300 | 374 | HZT43780.1 molecular chaperone DnaK [Chthonomonadaceae bacterium] | diamond | 1122 | 131 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 8657904 | 8657904 | PRJNA1028258_P_NODE_150247_length_231_cov_0.876543_g149684_i0 | PRJNA1028258 | 150247 | 231 | 0.876543 | 2.02481433 | Capsulimonadales bacterium | 2971800 | Bacteria | Bacteria | 127 | 3.02e-34 | NR | MDX1934911.1 | 2971800 | g149684 | i0 | 85.7 | 1 | 77 | 11 | 100 | 0 | 1 | 231 | 9 | 85 | MDX1934911.1 DUF1559 domain-containing protein [Capsulimonadales bacterium] | diamond | 231 | 127 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadales bacterium | ||||
| 27216556 | 27216556 | PRJNA1028258_P_NODE_85422_length_279_cov_1.352381_g84859_i0 | PRJNA1028258 | 85422 | 279 | 1.352381 | 3.77314299 | root | 1 | Root_unresolved | Root_unresolved | 124 | 1.0799999999999999e-32 | NR | MFN3421020.1 | 2033014 | g84859 | i0 | 62.9 | 3.82795698924731 | 89 | 33 | 95.7 | 0 | 277 | 11 | 19 | 107 | MFN3421020.1 hypothetical protein [Armatimonadota bacterium] | diamond | 1068 | 124 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27256249 | 27256249 | PRJNA1028258_P_NODE_144303_length_232_cov_1.472393_g143740_i0 | PRJNA1028258 | 144303 | 232 | 1.472393 | 3.41595176 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 48.1 | 3.96e-4 | NR | HEV2471644.1 | 2282151 | g143740 | i0 | 68.8 | 0.413793103448276 | 32 | 10 | 41.4 | 0 | 232 | 137 | 194 | 225 | HEV2471644.1 S53 family peptidase [Chthonomonadales bacterium] | diamond | 96 | 48.1 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 27856266 | 27856266 | PRJNA1028258_P_NODE_136225_length_234_cov_0.860606_g135662_i0 | PRJNA1028258 | 136225 | 234 | 0.860606 | 2.01381804 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 46.2 | 0.00119 | NR | HEX2999774.1 | 2033014 | g135662 | i0 | 38.3 | 0.769230769230769 | 60 | 36 | 76.9 | 1 | 206 | 27 | 40 | 98 | HEX2999774.1 superoxide dismutase family protein [Armatimonadota bacterium] | diamond | 180 | 46.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27856318 | 27856318 | PRJNA1028258_P_NODE_69525_length_308_cov_1.087866_g68962_i0 | PRJNA1028258 | 69525 | 308 | 1.087866 | 3.35062728 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 95.5 | 1.41e-21 | NR | MCC2670364.1 | 2033014 | g68962 | i0 | 52.5 | 5.91233766233766 | 101 | 47 | 97.4 | 1 | 8 | 307 | 63 | 163 | MCC2670364.1 novO [Armatimonadota bacterium] | diamond | 1821 | 95.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27951133 | 27951133 | PRJNA1028258_P_NODE_166865_length_227_cov_0.898734_g166302_i0 | PRJNA1028258 | 166865 | 227 | 0.898734 | 2.04012618 | Capsulimonadales bacterium | 2971800 | Bacteria | Bacteria | 82.8 | 2.15e-16 | NR | MDX1931645.1 | 2971800 | g166302 | i0 | 50.7 | 0.911894273127753 | 69 | 33 | 91.2 | 1 | 209 | 3 | 177 | 244 | MDX1931645.1 HEAT repeat domain-containing protein [Capsulimonadales bacterium] | diamond | 207 | 82.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadales bacterium | ||||
| 28519511 | 28519511 | PRJNA1028258_P_NODE_138087_length_234_cov_0.860606_g137524_i0 | PRJNA1028258 | 138087 | 234 | 0.860606 | 2.01381804 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 46.6 | 5.58e-4 | NR | NCO36237.1 | 2033014 | g137524 | i0 | 37.1 | 1.57692307692308 | 62 | 29 | 79.5 | 1 | 47 | 232 | 7 | 58 | NCO36237.1 Hsp20/alpha crystallin family protein [Armatimonadota bacterium] | diamond | 369 | 46.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29782360 | 29782360 | PRJNA1028258_P_NODE_41391_length_393_cov_1.444444_g40828_i0 | PRJNA1028258 | 41391 | 393 | 1.444444 | 5.67666492 | Chthonomonas sp. | 2282153 | Bacteria | Bacteria | 63.5 | 8.35e-9 | NR | MBL8041002.1 | 2282153 | g40828 | i0 | 67.4 | 0.32824427480916 | 43 | 13 | 32.8 | 1 | 9 | 137 | 256 | 297 | MBL8041002.1 matrilysin family metalloendoprotease [Chthonomonas sp.] | diamond | 129 | 63.5 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas sp. | ||
| 30035186 | 30035186 | PRJNA1028258_P_NODE_87451_length_276_cov_0.980676_g86888_i0 | PRJNA1028258 | 87451 | 276 | 0.980676 | 2.70666576 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 43.9 | 0.0219 | NR | MBX3095839.1 | 2682144 | g86888 | i0 | 28.4 | 0.956521739130435 | 88 | 48 | 79.3 | 1 | 234 | 16 | 212 | 299 | MBX3095839.1 NADH-quinone oxidoreductase subunit M [Fimbriimonadaceae bacterium] | diamond | 264 | 43.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30319937 | 30319937 | PRJNA1028258_P_NODE_124112_length_241_cov_1.238372_g123549_i0 | PRJNA1028258 | 124112 | 241 | 1.238372 | 2.98447652 | Armatimonadia bacterium | 2663015 | Bacteria | Bacteria | 101 | 6.579999999999999e-23 | NR | MEN6643490.1 | 2663015 | g123549 | i0 | 63.3 | 0.983402489626556 | 79 | 29 | 98.3 | 0 | 239 | 3 | 6 | 84 | MEN6643490.1 phage terminase large subunit family protein [Armatimonadia bacterium] | diamond | 237 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadia bacterium | |||||
| 30319974 | 30319974 | PRJNA1028258_P_NODE_177672_length_225_cov_0.910256_g177109_i0 | PRJNA1028258 | 177672 | 225 | 0.910256 | 2.048076 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52.8 | 7.45e-6 | NR | MBC7287207.1 | 2033014 | g177109 | i0 | 42 | 1.88 | 69 | 39 | 92 | 1 | 6 | 212 | 202 | 269 | MBC7287207.1 hypothetical protein [Armatimonadota bacterium] | diamond | 423 | 52.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30848650 | 30848650 | PRJNA1028258_P_NODE_109474_length_253_cov_1.157609_g108911_i0 | PRJNA1028258 | 109474 | 253 | 1.157609 | 2.92875077 | Bacteria | 2 | Bacteria | Bacteria | 138 | 4.63e-37 | NR | MBS1715899.1 | 2033014 | g108911 | i0 | 71.4 | 1.99209486166008 | 84 | 24 | 99.6 | 0 | 1 | 252 | 177 | 260 | MBS1715899.1 PQQ-dependent sugar dehydrogenase [Armatimonadota bacterium] | diamond | 504 | 138 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31330565 | 31330565 | PRJNA1028258_P_NODE_179076_length_224_cov_2.103226_g178513_i0 | PRJNA1028258 | 179076 | 224 | 2.103226 | 4.71122624 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 47.4 | 6.6e-4 | NR | MBM3497929.1 | 2033014 | g178513 | i0 | 40.3 | 3.08035714285714 | 62 | 34 | 83 | 1 | 188 | 3 | 199 | 257 | MBM3497929.1 hypothetical protein [Armatimonadota bacterium] | diamond | 690 | 47.4 | 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);;