contig_metadata
23 rows where bioproject = "PRJNA572587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1834440 | 1834440 | PRJNA572587_P_NODE_3582_length_688_cov_6.505477_g3302_i0 | PRJNA572587 | 3582 | 688 | 6.505477 | 44.75768176 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 306 | 2.6500000000000003e-100 | NR | MCL6533712.1 | 2033014 | g3302 | i0 | 97.4 | 0.667151162790698 | 153 | 4 | 66.7 | 0 | 217 | 675 | 1 | 153 | MCL6533712.1 molecular chaperone DnaJ [Armatimonadota bacterium] | diamond | 459 | 306 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 7513812 | 7513812 | PRJNA572587_P_NODE_24286_length_228_cov_8.564246_g23958_i0 | PRJNA572587 | 24286 | 228 | 8.564246 | 19.52648088 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 187 | 5.339999999999998e-43 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g23958 | i0 | 83.5 | 9.53508771929824 | 200 | 33 | 88 | 0 | 2 | 201 | 29582 | 29781 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 2174 | 187 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 15861412 | 15861412 | PRJNA572587_P_NODE_19093_length_260_cov_9.658768_g18765_i0 | PRJNA572587 | 19093 | 260 | 9.658768 | 25.1127968 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 329 | 9.77e-86 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g18765 | i0 | 91.667 | 181.973076923077 | 240 | 17 | 92 | 3 | 1 | 240 | 317090 | 316854 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 47313 | 329 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 17136675 | 17136675 | PRJNA572587_P_NODE_34954_length_186_cov_29.372263_g34626_i0 | PRJNA572587 | 34954 | 186 | 29.372263 | 54.63240918 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 116 | 3.81e-30 | NR | MCL6531744.1 | 2033014 | g34626 | i0 | 94.6 | 0.903225806451613 | 56 | 3 | 90.3 | 0 | 170 | 3 | 154 | 209 | MCL6531744.1 pseudouridine-5'-phosphate glycosidase [Armatimonadota bacterium] | diamond | 168 | 116 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 18411048 | 18411048 | PRJNA572587_P_NODE_5055_length_564_cov_12.097087_g4739_i0 | PRJNA572587 | 5055 | 564 | 12.097087 | 68.22757068 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 267 | 1.82e-66 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g4739 | i0 | 79.146 | 6.8794326241134804 | 398 | 74 | 70 | 7 | 21 | 413 | 1186594 | 1186201 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 3880 | 267 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 24785203 | 24785203 | PRJNA572587_P_NODE_34760_length_187_cov_7.021739_g34432_i0 | PRJNA572587 | 34760 | 187 | 7.021739 | 13.13065193 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52.8 | 0.016 | NTclustered | gi|2108374973|gb|CP070648.1| | 2033014 | g34432 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 0 | 139 | 166 | 3308830 | 3308857 | MAG: Armatimonadetes bacterium isolate bin88 chromosome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27237476 | 27237476 | PRJNA572587_P_NODE_10803_length_359_cov_1.580645_g10476_i0 | PRJNA572587 | 10803 | 359 | 1.580645 | 5.67451555 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 223 | 1.53e-65 | NR | MCX7688845.1 | 2682145 | g10476 | i0 | 97.3 | 0.927576601671309 | 111 | 3 | 92.8 | 0 | 25 | 357 | 393 | 503 | MCX7688845.1 dockerin type I domain-containing protein [Fimbriimonadales bacterium] | diamond | 333 | 223 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 27521774 | 27521774 | PRJNA572587_P_NODE_10223_length_371_cov_4.055901_g9896_i0 | PRJNA572587 | 10223 | 371 | 4.055901 | 15.04739271 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 205 | 4.72e-62 | NR | MCL6533828.1 | 2033014 | g9896 | i0 | 93.2 | 0.954177897574124 | 118 | 8 | 95.4 | 0 | 3 | 356 | 158 | 275 | MCL6533828.1 AI-2E family transporter [Armatimonadota bacterium] | diamond | 354 | 205 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27743179 | 27743179 | PRJNA572587_P_NODE_2144_length_883_cov_145.744604_g1952_i0 | PRJNA572587 | 2144 | 883 | 145.744604 | 1286.92485332 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 236 | 2.12e-75 | NR | MCX7688787.1 | 2682145 | g1952 | i0 | 98.4 | 0.421291053227633 | 124 | 2 | 42.1 | 0 | 591 | 220 | 1 | 124 | MCX7688787.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 372 | 236 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 27900583 | 27900583 | PRJNA572587_P_NODE_6945_length_466_cov_2.345324_g6621_i0 | PRJNA572587 | 6945 | 466 | 2.345324 | 10.92920984 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 175 | 1.99e-52 | NR | MCL6531910.1 | 2033014 | g6621 | i0 | 95.5 | 0.566523605150215 | 88 | 4 | 56.7 | 0 | 89 | 352 | 1 | 88 | MCL6531910.1 flavin reductase family protein [Armatimonadota bacterium] | diamond | 264 | 175 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28072157 | 28072157 | PRJNA572587_P_NODE_12845_length_325_cov_1.974638_g12517_i0 | PRJNA572587 | 12845 | 325 | 1.974638 | 6.4175735 | Bacteria | 2 | Bacteria | Bacteria | 45.8 | 7.71e-4 | NR | GIV22148.1 | 2033014 | g12517 | i0 | 66.7 | 0.775384615384615 | 36 | 12 | 33.2 | 0 | 24 | 131 | 37 | 72 | GIV22148.1 MAG: hypothetical protein KatS3mg023_3899 [Armatimonadota bacterium] | diamond | 252 | 45.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28279437 | 28279437 | PRJNA572587_P_NODE_2266_length_863_cov_2.984029_g2068_i0 | PRJNA572587 | 2266 | 863 | 2.984029 | 25.75217027 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 340 | 6.71e-114 | NR | MCL6534124.1 | 2033014 | g2068 | i0 | 96.7 | 0.632676709154114 | 182 | 6 | 63.3 | 0 | 710 | 165 | 1 | 182 | MCL6534124.1 tyrosine recombinase XerC [Armatimonadota bacterium] | diamond | 546 | 340 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28451302 | 28451302 | PRJNA572587_P_NODE_7146_length_458_cov_1.677262_g6821_i0 | PRJNA572587 | 7146 | 458 | 1.677262 | 7.68185996 | Bacteria | 2 | Bacteria | Bacteria | 220 | 9.18e-64 | NR | MCL6533925.1 | 2033014 | g6821 | i0 | 86.9 | 1.70305676855895 | 130 | 7 | 78.6 | 1 | 452 | 93 | 800 | 929 | MCL6533925.1 DUF1156 domain-containing protein [Armatimonadota bacterium] | diamond | 780 | 221 | 0.995475113122172 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28753242 | 28753242 | PRJNA572587_P_NODE_7567_length_442_cov_7.022901_g7242_i0 | PRJNA572587 | 7567 | 442 | 7.022901 | 31.04122242 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 132 | 4.65e-33 | NR | MER3473648.1 | 2033014 | g7242 | i0 | 63.9 | 0.658371040723982 | 97 | 35 | 65.8 | 0 | 291 | 1 | 332 | 428 | MER3473648.1 hypothetical protein [Armatimonadota bacterium] | diamond | 291 | 132 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29227108 | 29227108 | PRJNA572587_P_NODE_4649_length_592_cov_2.265193_g4338_i0 | PRJNA572587 | 4649 | 592 | 2.265193 | 13.40994256 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 205 | 1.96e-62 | NR | RMH10829.1 | 2033014 | g4338 | i0 | 83.1 | 0.597972972972973 | 118 | 15 | 59.8 | 1 | 432 | 79 | 162 | 274 | RMH10829.1 MAG: site-specific DNA-methyltransferase [Armatimonadota bacterium] | diamond | 354 | 205 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30111077 | 30111077 | PRJNA572587_P_NODE_8772_length_407_cov_1.905028_g8446_i0 | PRJNA572587 | 8772 | 407 | 1.905028 | 7.75346396 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 225 | 2.82e-71 | NR | MCS7172409.1 | 2033014 | g8446 | i0 | 89.8 | 0.943488943488944 | 128 | 13 | 94.3 | 0 | 384 | 1 | 64 | 191 | MCS7172409.1 branched-chain amino acid ABC transporter permease [Armatimonadota bacterium] | diamond | 384 | 225 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30364306 | 30364306 | PRJNA572587_P_NODE_3552_length_691_cov_45.919003_g3272_i0 | PRJNA572587 | 3552 | 691 | 45.919003 | 317.30031073 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 273 | 1.3699999999999997e-87 | NR | MEJ5295123.1 | 2682145 | g3272 | i0 | 94.6 | 0.638205499276411 | 147 | 8 | 63.8 | 0 | 226 | 666 | 1 | 147 | MEJ5295123.1 rod shape-determining protein RodA [Fimbriimonadales bacterium] | diamond | 441 | 273 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 30901078 | 30901078 | PRJNA572587_P_NODE_5234_length_552_cov_65.882704_g4918_i0 | PRJNA572587 | 5234 | 552 | 65.882704 | 363.67252608 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 179 | 7.05e-54 | NR | MCL6448901.1 | 2033014 | g4918 | i0 | 66.9 | 0.739130434782609 | 136 | 45 | 73.9 | 0 | 100 | 507 | 1 | 136 | MCL6448901.1 PadR family transcriptional regulator [Armatimonadota bacterium] | diamond | 408 | 179 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31944290 | 31944290 | PRJNA572587_P_NODE_43557_length_166_cov_0.871795_g43229_i0 | PRJNA572587 | 43557 | 166 | 0.871795 | 1.4471797 | Capsulimonas sp. | 2494211 | Bacteria | Bacteria | 101 | 2.76e-24 | NR | WP_348221818.1 | 2494211 | g43229 | i0 | 81.1 | 1.91566265060241 | 53 | 10 | 95.8 | 0 | 6 | 164 | 160 | 212 | WP_348221818.1 2-oxo acid dehydrogenase subunit E2 [Capsulimonas sp.] | diamond | 318 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas sp. | ||
| 32229418 | 32229418 | PRJNA572587_P_NODE_18318_length_266_cov_1.645161_g17990_i0 | PRJNA572587 | 18318 | 266 | 1.645161 | 4.37612826 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 162 | 2.19e-45 | NR | MCL6532117.1 | 2033014 | g17990 | i0 | 93.2 | 0.992481203007519 | 88 | 6 | 99.2 | 0 | 1 | 264 | 326 | 413 | MCL6532117.1 hypothetical protein [Armatimonadota bacterium] | diamond | 264 | 162 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32356064 | 32356064 | PRJNA572587_P_NODE_44279_length_165_cov_0.879310_g43951_i0 | PRJNA572587 | 44279 | 165 | 0.87931 | 1.4508615 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 68.2 | 1.42e-11 | NR | WP_395140740.1 | 1872638 | g43951 | i0 | 60 | 1 | 55 | 21 | 100 | 1 | 1 | 165 | 332 | 385 | WP_395140740.1 DUF6785 family protein [Armatimonas sp.] | diamond | 165 | 68.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 32671591 | 32671591 | PRJNA572587_P_NODE_44220_length_165_cov_1.241379_g43892_i0 | PRJNA572587 | 44220 | 165 | 1.241379 | 2.04827535 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 63.2 | 1.75e-10 | NR | MCL6533845.1 | 2033014 | g43892 | i0 | 100 | 0.581818181818182 | 32 | 0 | 58.2 | 0 | 165 | 70 | 146 | 177 | MCL6533845.1 cytochrome c [Armatimonadota bacterium] | diamond | 96 | 63.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32779575 | 32779575 | PRJNA572587_P_NODE_30220_length_202_cov_4.189542_g29892_i0 | PRJNA572587 | 30220 | 202 | 4.189542 | 8.46287484 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 5.13e-4 | NR | MBC7286469.1 | 2033014 | g29892 | i0 | 43.9 | 3.22277227722772 | 57 | 31 | 83.2 | 1 | 2 | 169 | 344 | 400 | MBC7286469.1 DUF262 domain-containing protein [Armatimonadota bacterium] | diamond | 651 | 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);;