contig_metadata
20 rows where bioproject = "PRJNA814235", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4645910 | 4645910 | PRJNA814235_P_NODE_31904_length_338_cov_32.943522_g30518_i0 | PRJNA814235 | 31904 | 338 | 32.943522 | 111.34910436 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 257 | 6.3e-64 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g30518 | i0 | 93.642 | 154.846153846154 | 173 | 9 | 51 | 2 | 168 | 338 | 1306274 | 1306102 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 52338 | 257 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 8469794 | 8469794 | PRJNA814235_P_NODE_184987_length_151_cov_3.947368_g183592_i0 | PRJNA814235 | 184987 | 151 | 3.947368 | 5.96052568 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 75 | 2.63e-9 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g183592 | i0 | 89.655 | 0.384105960264901 | 58 | 6 | 38 | 0 | 74 | 131 | 117557 | 117614 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 58 | 75 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 8471633 | 8471633 | PRJNA814235_P_NODE_85307_length_206_cov_1.266272_g83912_i0 | PRJNA814235 | 85307 | 206 | 1.266272 | 2.60852032 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 99 | 2.28e-16 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g83912 | i0 | 89.744 | 43.495145631068 | 78 | 6 | 37 | 2 | 130 | 206 | 1305359 | 1305283 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 8960 | 99 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 8471691 | 8471691 | PRJNA814235_P_NODE_8867_length_632_cov_4.381513_g7786_i0 | PRJNA814235 | 8867 | 632 | 4.381513 | 27.69116216 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 289 | 4.39e-73 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g7786 | i0 | 84.642 | 141.642405063291 | 293 | 41 | 79 | 4 | 20 | 309 | 1306103 | 1306394 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 89518 | 289 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 13569925 | 13569925 | PRJNA814235_P_NODE_159311_length_167_cov_1.200000_g157916_i0 | PRJNA814235 | 159311 | 167 | 1.2 | 2.004 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 128 | 2.26e-25 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g157916 | i0 | 92.308 | 2.48502994011976 | 91 | 6 | 54 | 1 | 43 | 132 | 199807 | 199717 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 415 | 128 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 13572296 | 13572296 | PRJNA814235_P_NODE_8711_length_638_cov_12.051581_g7637_i0 | PRJNA814235 | 8711 | 638 | 12.051581 | 76.88908678 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 490 | 1.13e-133 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g7637 | i0 | 81.126 | 776.197492163009 | 657 | 85 | 100 | 27 | 1 | 638 | 1306495 | 1305859 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 495214 | 490 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 13981228 | 13981228 | PRJNA814235_P_NODE_66551_length_233_cov_3.122449_g65156_i0 | PRJNA814235 | 66551 | 233 | 3.122449 | 7.27530617 | Chthonomonas | 1077265 | Bacteria | Bacteria | 263 | 8.85e-66 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g65156 | i0 | 87.336 | 1.9656652360515 | 229 | 29 | 98 | 0 | 1 | 229 | 1245 | 1473 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 458 | 263 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 19077273 | 19077273 | PRJNA814235_P_NODE_12235_length_543_cov_290.266798_g11000_i0 | PRJNA814235 | 12235 | 543 | 290.266798 | 1576.14871314 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 599 | 1.52e-166 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g11000 | i0 | 92.217 | 193.830570902394 | 424 | 31 | 78 | 2 | 60 | 482 | 26868 | 27290 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 105250 | 604 | 0.991721854304636 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 21628807 | 21628807 | PRJNA814235_P_NODE_27537_length_364_cov_43.128440_g26158_i0 | PRJNA814235 | 27537 | 364 | 43.12844 | 156.9875216 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 291 | 6.7199999999999996e-74 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g26158 | i0 | 84.385 | 368.739010989011 | 301 | 41 | 82 | 6 | 8 | 305 | 29487 | 29784 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 134221 | 291 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 22492772 | 22492772 | PRJNA814235_P_NODE_144198_length_180_cov_1.475524_g142803_i0 | PRJNA814235 | 144198 | 180 | 1.475524 | 2.6559432 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 145 | 2.45e-30 | NTclustered | gi|2076452338|gb|CP075364.1| | 2682144 | g142803 | i0 | 81.461 | 2.90555555555556 | 178 | 32 | 99 | 1 | 1 | 178 | 667589 | 667413 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome | blastn | 523 | 145 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 22494356 | 22494356 | PRJNA814235_P_NODE_37178_length_313_cov_57.119565_g35789_i0 | PRJNA814235 | 37178 | 313 | 57.119565 | 178.78423845 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 315 | 3.38e-81 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g35789 | i0 | 86.824 | 222.05750798722 | 296 | 21 | 89 | 11 | 35 | 313 | 1306395 | 1306101 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 69504 | 315 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 22495017 | 22495017 | PRJNA814235_P_NODE_64938_length_236_cov_2.748744_g63543_i0 | PRJNA814235 | 64938 | 236 | 2.748744 | 6.48703584 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 231 | 2.53e-56 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g63543 | i0 | 85 | 277.940677966102 | 240 | 22 | 99 | 10 | 3 | 236 | 1305063 | 1305294 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 65594 | 231 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 23769958 | 23769958 | PRJNA814235_P_NODE_34659_length_324_cov_62.864111_g33271_i0 | PRJNA814235 | 34659 | 324 | 62.864111 | 203.67971964 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 399 | 9.429999999999998e-107 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g33271 | i0 | 89.058 | 434.848765432099 | 329 | 27 | 100 | 8 | 1 | 324 | 1306274 | 1305950 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 140891 | 399 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 28160083 | 28160083 | PRJNA814235_P_NODE_98425_length_203_cov_2.524096_g97030_i0 | PRJNA814235 | 98425 | 203 | 2.524096 | 5.12391488 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 45.4 | 0.00242 | NR | HLJ56217.1 | 2739509 | g97030 | i0 | 91.7 | 0.724137931034483 | 24 | 2 | 35.5 | 0 | 73 | 2 | 204 | 227 | HLJ56217.1 ABC transporter permease [Chthonomonadaceae bacterium] | diamond | 147 | 45.4 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 28452847 | 28452847 | PRJNA814235_P_NODE_108606_length_203_cov_2.108434_g107211_i0 | PRJNA814235 | 108606 | 203 | 2.108434 | 4.28012102 | Bacteria | 2 | Bacteria | Bacteria | 48.1 | 1.09e-4 | NR | HLK14675.1 | 2682144 | g107211 | i0 | 87 | 0.679802955665025 | 23 | 3 | 34 | 0 | 134 | 202 | 26 | 48 | HLK14675.1 DinB family protein [Fimbriimonadaceae bacterium] | diamond | 138 | 48.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29391340 | 29391340 | PRJNA814235_P_NODE_190549_length_151_cov_2.982456_g189154_i0 | PRJNA814235 | 190549 | 151 | 2.982456 | 4.50350856 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 86.3 | 4.9e-18 | NR | MBV9850834.1 | 2033014 | g189154 | i0 | 77.8 | 1.0728476821192101 | 54 | 8 | 99.3 | 1 | 2 | 151 | 518 | 571 | MBV9850834.1 alpha-mannosidase [Armatimonadota bacterium] | diamond | 162 | 86.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31034117 | 31034117 | PRJNA814235_P_NODE_104475_length_203_cov_2.253012_g103080_i0 | PRJNA814235 | 104475 | 203 | 2.253012 | 4.57361436 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 47 | 6.88e-4 | NR | GIV16289.1 | 2033014 | g103080 | i0 | 41.8 | 1.96551724137931 | 67 | 35 | 99 | 1 | 203 | 3 | 309 | 371 | GIV16289.1 MAG: serine protease MucD [Armatimonadota bacterium] | diamond | 399 | 47 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32045936 | 32045936 | PRJNA814235_P_NODE_103978_length_203_cov_2.271084_g102583_i0 | PRJNA814235 | 103978 | 203 | 2.271084 | 4.61030052 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 42 | 0.0406 | NR | MER3496253.1 | 2033014 | g102583 | i0 | 72 | 0.369458128078818 | 25 | 7 | 36.9 | 0 | 128 | 202 | 68 | 92 | MER3496253.1 hypothetical protein [Armatimonadota bacterium] | diamond | 75 | 42 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32709604 | 32709604 | PRJNA814235_P_NODE_93480_length_203_cov_2.897590_g92085_i0 | PRJNA814235 | 93480 | 203 | 2.89759 | 5.8821077 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 47.8 | 3.63e-4 | NR | MDQ3814230.1 | 2033014 | g92085 | i0 | 42.9 | 0.931034482758621 | 63 | 25 | 93.1 | 1 | 15 | 203 | 272 | 323 | MDQ3814230.1 Gfo/Idh/MocA family oxidoreductase [Armatimonadota bacterium] | diamond | 189 | 47.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32772451 | 32772451 | PRJNA814235_P_NODE_105160_length_203_cov_2.222892_g103765_i0 | PRJNA814235 | 105160 | 203 | 2.222892 | 4.51247076 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 46.2 | 0.0013 | NR | MEP6755997.1 | 2282151 | g103765 | i0 | 88 | 0.369458128078818 | 25 | 3 | 36.9 | 0 | 2 | 76 | 234 | 258 | MEP6755997.1 group II intron reverse transcriptase/maturase [Chthonomonadales bacterium] | diamond | 75 | 46.2 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales 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);;