contig_metadata
18 rows where bioproject = "PRJNA682078", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15964682 | 15964682 | PRJNA682078_P_NODE_274913_length_243_cov_0.905882_g273136_i0 | PRJNA682078 | 274913 | 243 | 0.905882 | 2.20129326 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 153 | 4.1e-42 | NR | MES2463516.1 | 2033014 | g273136 | i0 | 82.5 | 0.987654320987654 | 80 | 14 | 98.8 | 0 | 241 | 2 | 225 | 304 | MES2463516.1 carboxypeptidase M32 [Armatimonadota bacterium] | diamond | 240 | 153 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 18511434 | 18511434 | PRJNA682078_P_NODE_173635_length_278_cov_2.165854_g171858_i0 | PRJNA682078 | 173635 | 278 | 2.165854 | 6.02107412 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 193 | 1.45e-44 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g171858 | i0 | 80.784 | 3.98201438848921 | 255 | 42 | 90 | 6 | 21 | 271 | 1306767 | 1307018 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 1107 | 193 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 26797232 | 26797232 | PRJNA682078_P_NODE_206681_length_259_cov_1.440860_g204904_i0 | PRJNA682078 | 206681 | 259 | 1.44086 | 3.7318274 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 43.1 | 0.0271 | NR | GIV20198.1 | 2033014 | g204904 | i0 | 37.3 | 0.776061776061776 | 67 | 30 | 71.8 | 2 | 30 | 215 | 122 | 181 | GIV20198.1 MAG: hypothetical protein KatS3mg023_1949 [Armatimonadota bacterium] | diamond | 201 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26829036 | 26829036 | PRJNA682078_P_NODE_178261_length_276_cov_1.059113_g176484_i0 | PRJNA682078 | 178261 | 276 | 1.059113 | 2.92315188 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 147 | 9.329999999999999e-39 | NR | MBX3110308.1 | 2682144 | g176484 | i0 | 76.9 | 0.989130434782609 | 91 | 21 | 98.9 | 0 | 3 | 275 | 24 | 114 | MBX3110308.1 DUF3854 domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 273 | 147 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 26987054 | 26987054 | PRJNA682078_P_NODE_296922_length_229_cov_5.192308_g295145_i0 | PRJNA682078 | 296922 | 229 | 5.192308 | 11.89038532 | Armatimonadetes bacterium CG_4_1 | 2033014 | Bacteria | Bacteria | 145 | 4.9e-39 | NR | PIY44557.1 | 1973909 | g295145 | i0 | 100 | 0.96943231441048 | 74 | 0 | 96.9 | 0 | 6 | 227 | 46 | 119 | PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] | diamond | 222 | 145 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10 | ||||||
| 28092721 | 28092721 | PRJNA682078_P_NODE_202005_length_262_cov_1.216931_g200228_i0 | PRJNA682078 | 202005 | 262 | 1.216931 | 3.18835922 | Capsulimonas sp. | 2494211 | Bacteria | Bacteria | 146 | 2.04e-38 | NR | MCW3061469.1 | 2494211 | g200228 | i0 | 86.2 | 0.99618320610687 | 87 | 12 | 99.6 | 0 | 1 | 261 | 465 | 551 | MCW3061469.1 ftsK [Capsulimonas sp.] | diamond | 261 | 146 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas sp. | ||
| 28535013 | 28535013 | PRJNA682078_P_NODE_226227_length_251_cov_0.865169_g224450_i0 | PRJNA682078 | 226227 | 251 | 0.865169 | 2.17157419 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 105 | 2.21e-26 | NR | MBC8104851.1 | 2033014 | g224450 | i0 | 63.9 | 3.9203187250996 | 83 | 19 | 99.2 | 2 | 3 | 251 | 89 | 160 | MBC8104851.1 tetratricopeptide repeat protein [Armatimonadota bacterium] | diamond | 984 | 105 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29260805 | 29260805 | PRJNA682078_P_NODE_197929_length_264_cov_1.544503_g196152_i0 | PRJNA682078 | 197929 | 264 | 1.544503 | 4.07748792 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 132 | 2.01e-37 | NR | MES2462527.1 | 2033014 | g196152 | i0 | 75 | 1 | 88 | 22 | 100 | 0 | 1 | 264 | 24 | 111 | MES2462527.1 D-aminoacyl-tRNA deacylase [Armatimonadota bacterium] | diamond | 264 | 132 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30113564 | 30113564 | PRJNA682078_P_NODE_151452_length_293_cov_1.400000_g149675_i0 | PRJNA682078 | 151452 | 293 | 1.4 | 4.102 | Armatimonadia bacterium | 2663015 | Bacteria | Bacteria | 60.8 | 2.88e-8 | NR | MEN6549732.1 | 2663015 | g149675 | i0 | 37.1 | 0.716723549488055 | 70 | 40 | 71.7 | 1 | 280 | 71 | 212 | 277 | MEN6549732.1 DUF927 domain-containing protein [Armatimonadia bacterium] | diamond | 210 | 60.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadia bacterium | |||||
| 30113609 | 30113609 | PRJNA682078_P_NODE_253092_length_246_cov_2.358382_g251315_i0 | PRJNA682078 | 253092 | 246 | 2.358382 | 5.80161972 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 126 | 1.2399999999999998e-31 | NR | MBX3110308.1 | 2682144 | g251315 | i0 | 74.4 | 2.01219512195122 | 82 | 20 | 100 | 1 | 1 | 246 | 311 | 391 | MBX3110308.1 DUF3854 domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 495 | 126 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30208176 | 30208176 | PRJNA682078_P_NODE_242412_length_248_cov_0.880000_g240635_i0 | PRJNA682078 | 242412 | 248 | 0.88 | 2.1824 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 97.8 | 3.519999999999999e-23 | NR | MFN7172470.1 | 2682144 | g240635 | i0 | 59 | 3 | 83 | 33 | 99.2 | 1 | 246 | 1 | 45 | 127 | MFN7172470.1 imidazole glycerol phosphate synthase subunit HisH [Fimbriimonadaceae bacterium] | diamond | 744 | 97.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30524363 | 30524363 | PRJNA682078_P_NODE_162033_length_286_cov_1.000000_g160256_i0 | PRJNA682078 | 162033 | 286 | 1 | 2.86 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 105 | 1.4999999999999998e-24 | NR | WP_025226687.1 | 1005039 | g160256 | i0 | 59.1 | 0.923076923076923 | 88 | 36 | 92.3 | 0 | 3 | 266 | 204 | 291 | WP_025226687.1 rhomboid family protein [Fimbriimonas ginsengisoli] | diamond | 264 | 105 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 31662136 | 31662136 | PRJNA682078_P_NODE_198257_length_264_cov_1.308901_g196480_i0 | PRJNA682078 | 198257 | 264 | 1.308901 | 3.45549864 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 78.6 | 9.51e-15 | NR | KAA0228146.1 | 2033014 | g196480 | i0 | 50.6 | 2.88636363636364 | 85 | 42 | 96.6 | 0 | 9 | 263 | 35 | 119 | KAA0228146.1 MAG: TolC family protein [Armatimonadota bacterium] | diamond | 762 | 78.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31662182 | 31662182 | PRJNA682078_P_NODE_286637_length_241_cov_2.136905_g284860_i0 | PRJNA682078 | 286637 | 241 | 2.136905 | 5.14994105 | Armatimonadetes bacterium Cent15-Ar3 | 1987502 | Bacteria | Bacteria | 147 | 4.759999999999998e-42 | NR | OWU66334.1 | 1987502 | g284860 | i0 | 93.8 | 2.98755186721992 | 80 | 5 | 99.6 | 0 | 240 | 1 | 73 | 152 | OWU66334.1 MAG: flagellar biosynthesis protein FliA [Armatimonadetes bacterium Cent15-Ar3] | diamond | 720 | 147 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Cent15-Ar3 | ||||||
| 31851995 | 31851995 | PRJNA682078_P_NODE_244397_length_248_cov_0.880000_g242620_i0 | PRJNA682078 | 244397 | 248 | 0.88 | 2.1824 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 82.8 | 2.88e-16 | NR | MBI3928554.1 | 2033014 | g242620 | i0 | 53.7 | 2.15322580645161 | 82 | 35 | 95.6 | 1 | 1 | 237 | 281 | 362 | MBI3928554.1 succinylglutamate desuccinylase/aspartoacylase family protein [Armatimonadota bacterium] | diamond | 534 | 82.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32042025 | 32042025 | PRJNA682078_P_NODE_90178_length_368_cov_1.044068_g88403_i0 | PRJNA682078 | 90178 | 368 | 1.044068 | 3.84217024 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 118 | 4.44e-29 | NR | MBX3110304.1 | 2682144 | g88403 | i0 | 89.7 | 0.472826086956522 | 58 | 6 | 47.3 | 0 | 174 | 1 | 1 | 58 | MBX3110304.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 174 | 118 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32358655 | 32358655 | PRJNA682078_P_NODE_264679_length_245_cov_0.895349_g262902_i0 | PRJNA682078 | 264679 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 48.9 | 1.81e-4 | NR | MES2461498.1 | 2033014 | g262902 | i0 | 55.1 | 0.6 | 49 | 19 | 56.3 | 1 | 237 | 100 | 43 | 91 | MES2461498.1 hypothetical protein [Armatimonadota bacterium] | diamond | 147 | 48.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32453581 | 32453581 | PRJNA682078_P_NODE_224559_length_251_cov_0.865169_g222782_i0 | PRJNA682078 | 224559 | 251 | 0.865169 | 2.17157419 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 114 | 1.4700000000000002e-27 | NR | MBC8065470.1 | 2682144 | g222782 | i0 | 71.1 | 0.99203187250996006 | 83 | 24 | 99.2 | 0 | 1 | 249 | 31 | 113 | MBC8065470.1 endonuclease MutS2 [Fimbriimonadaceae bacterium] | diamond | 249 | 114 | 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);;