contig_metadata
24 rows where bioproject = "PRJNA986547", tax_phylum = "Armatimonadota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 974273 | 974273 | PRJNA986547_P_NODE_7261_length_259_cov_3.543011_g7179_i0 | PRJNA986547 | 7261 | 259 | 3.543011 | 9.17639849 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 169 | 2.94e-47 | NR | MDH4389661.1 | 1936159 | g7179 | i0 | 95.3 | 4.92277992277992 | 85 | 4 | 98.5 | 0 | 257 | 3 | 131 | 215 | MDH4389661.1 NADH-quinone oxidoreductase subunit NuoG [Fimbriimonas sp.] | diamond | 1275 | 169 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 11177626 | 11177626 | PRJNA986547_P_NODE_7309_length_259_cov_2.059140_g7227_i0 | PRJNA986547 | 7309 | 259 | 2.05914 | 5.3331726 | PVC group | 1783257 | Bacteria | Bacteria | 143 | 1.4899999999999998e-37 | NR | HID06958.1 | 2033014 | g7227 | i0 | 76.2 | 6.81081081081081 | 84 | 20 | 97.3 | 0 | 257 | 6 | 507 | 590 | HID06958.1 right-handed parallel beta-helix repeat-containing protein [Armatimonadota bacterium] | diamond | 1764 | 143 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 13727714 | 13727714 | PRJNA986547_P_NODE_14071_length_228_cov_2.264516_g13989_i0 | PRJNA986547 | 14071 | 228 | 2.264516 | 5.16309648 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 359 | 1.07e-94 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g13989 | i0 | 95.946 | 41.6052631578947 | 222 | 8 | 97 | 1 | 6 | 226 | 1878009 | 1877788 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 9486 | 359 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 16574761 | 16574761 | PRJNA986547_P_NODE_10093_length_246_cov_7.323699_g10011_i0 | PRJNA986547 | 10093 | 246 | 7.323699 | 18.01629954 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 322 | 1.53e-83 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g10011 | i0 | 90.283 | 162.024390243902 | 247 | 22 | 100 | 2 | 1 | 246 | 27658 | 27413 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 39858 | 322 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 16574829 | 16574829 | PRJNA986547_P_NODE_3673_length_295_cov_6.220721_g3591_i0 | PRJNA986547 | 3673 | 295 | 6.220721 | 18.35112695 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 344 | 4.03e-90 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g3591 | i0 | 87.667 | 980.725423728814 | 300 | 32 | 100 | 3 | 1 | 295 | 26828 | 27127 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 289314 | 344 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 24223940 | 24223940 | PRJNA986547_P_NODE_3999_length_290_cov_7.967742_g3917_i0 | PRJNA986547 | 3999 | 290 | 7.967742 | 23.1064518 | Bacteria | 2 | Bacteria | Bacteria | 499 | 7.98e-137 | NTclustered | gi|95115294|gb|DQ501336.1| | 157466 | g3917 | i0 | 97.917 | 97.9137931034483 | 288 | 6 | 99 | 0 | 1 | 288 | 1044 | 1331 | Uncultured candidate division OP10 bacterium clone ST11-34 16S ribosomal RNA gene, partial sequence | blastn | 28395 | 499 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 26620780 | 26620780 | PRJNA986547_P_NODE_5001_length_279_cov_2.252427_g4919_i0 | PRJNA986547 | 5001 | 279 | 2.252427 | 6.28427133 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 90.1 | 1.32e-19 | NR | MDH4387495.1 | 1936159 | g4919 | i0 | 85.4 | 1.03225806451613 | 48 | 7 | 51.6 | 0 | 1 | 144 | 205 | 252 | MDH4387495.1 ABC transporter permease [Fimbriimonas sp.] | diamond | 288 | 90.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 27468997 | 27468997 | PRJNA986547_P_NODE_12803_length_236_cov_4.736196_g12721_i0 | PRJNA986547 | 12803 | 236 | 4.736196 | 11.17742256 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 108 | 3.7100000000000005e-27 | NR | MDH4387502.1 | 1936159 | g12721 | i0 | 90 | 1.51271186440678 | 60 | 6 | 76.3 | 0 | 33 | 212 | 176 | 235 | MDH4387502.1 SDR family NAD(P)-dependent oxidoreductase [Fimbriimonas sp.] | diamond | 357 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 27658492 | 27658492 | PRJNA986547_P_NODE_16764_length_202_cov_5.620155_g16682_i0 | PRJNA986547 | 16764 | 202 | 5.620155 | 11.3527131 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 65.9 | 6.6e-11 | NR | MEI7575475.1 | 2033014 | g16682 | i0 | 87.1 | 0.920792079207921 | 31 | 4 | 46 | 0 | 198 | 106 | 211 | 241 | MEI7575475.1 hypothetical protein [Armatimonadota bacterium] | diamond | 186 | 65.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27847598 | 27847598 | PRJNA986547_P_NODE_14784_length_221_cov_6.763514_g14702_i0 | PRJNA986547 | 14784 | 221 | 6.763514 | 14.94736594 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 77 | 9.66e-15 | NR | MEI7575374.1 | 2033014 | g14702 | i0 | 48.5 | 0.895927601809955 | 66 | 34 | 89.6 | 0 | 23 | 220 | 115 | 180 | MEI7575374.1 phosphotransferase [Armatimonadota bacterium] | diamond | 198 | 77 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27942570 | 27942570 | PRJNA986547_P_NODE_12685_length_237_cov_4.018293_g12603_i0 | PRJNA986547 | 12685 | 237 | 4.018293 | 9.52335441 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 69.3 | 1.12e-11 | NR | MBS1719048.1 | 2033014 | g12603 | i0 | 54.4 | 0.860759493670886 | 68 | 31 | 86.1 | 0 | 223 | 20 | 146 | 213 | MBS1719048.1 TlpA family protein disulfide reductase [Armatimonadota bacterium] | diamond | 204 | 69.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27974053 | 27974053 | PRJNA986547_P_NODE_7045_length_261_cov_1.585106_g6963_i0 | PRJNA986547 | 7045 | 261 | 1.585106 | 4.13712666 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 97.1 | 5.94e-23 | NR | MEI7575354.1 | 2033014 | g6963 | i0 | 55.8 | 1.79310344827586 | 77 | 34 | 88.5 | 0 | 26 | 256 | 1 | 77 | MEI7575354.1 hypothetical protein [Armatimonadota bacterium] | diamond | 468 | 97.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28100191 | 28100191 | PRJNA986547_P_NODE_12585_length_238_cov_2.896970_g12503_i0 | PRJNA986547 | 12585 | 238 | 2.89697 | 6.8947886 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 101 | 4.63e-25 | NR | MDH4389199.1 | 1936159 | g12503 | i0 | 64.1 | 0.983193277310924 | 78 | 28 | 98.3 | 0 | 3 | 236 | 75 | 152 | MDH4389199.1 RNA polymerase sigma factor [Fimbriimonas sp.] | diamond | 234 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 28416213 | 28416213 | PRJNA986547_P_NODE_8486_length_251_cov_1.668539_g8404_i0 | PRJNA986547 | 8486 | 251 | 1.668539 | 4.18803289 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 110 | 9.94e-28 | NR | MEI7577691.1 | 2033014 | g8404 | i0 | 76.5 | 0.812749003984064 | 68 | 16 | 81.3 | 0 | 205 | 2 | 58 | 125 | MEI7577691.1 ComF family protein [Armatimonadota bacterium] | diamond | 204 | 110 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28579954 | 28579954 | PRJNA986547_P_NODE_16807_length_202_cov_4.093023_g16725_i0 | PRJNA986547 | 16807 | 202 | 4.093023 | 8.26790646 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 73.9 | 2.22e-13 | NR | MDH4389415.1 | 1936159 | g16725 | i0 | 83.3 | 1.27722772277228 | 42 | 7 | 62.4 | 0 | 199 | 74 | 1163 | 1204 | MDH4389415.1 transcription-repair coupling factor [Fimbriimonas sp.] | diamond | 258 | 74.3 | 0.994616419919246 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 28832359 | 28832359 | PRJNA986547_P_NODE_9108_length_249_cov_2.488636_g9026_i0 | PRJNA986547 | 9108 | 249 | 2.488636 | 6.19670364 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 94.7 | 2.06e-20 | NR | MDH4387941.1 | 1936159 | g9026 | i0 | 80.4 | 3.68674698795181 | 51 | 10 | 61.4 | 0 | 1 | 153 | 574 | 624 | MDH4387941.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis enzyme MnmG [Fimbriimonas sp.] | diamond | 918 | 95.1 | 0.995793901156677 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 29110813 | 29110813 | PRJNA986547_P_NODE_4648_length_283_cov_1.700000_g4566_i0 | PRJNA986547 | 4648 | 283 | 1.7 | 4.811 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 118 | 1.26e-30 | NR | HLO97159.1 | 1936159 | g4566 | i0 | 67.6 | 1.56890459363958 | 74 | 24 | 78.4 | 0 | 61 | 282 | 1 | 74 | HLO97159.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Fimbriimonas sp.] | diamond | 444 | 118 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 29868536 | 29868536 | PRJNA986547_P_NODE_6211_length_267_cov_4.876289_g6129_i0 | PRJNA986547 | 6211 | 267 | 4.876289 | 13.01969163 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 61.6 | 1.45e-9 | NR | MEI7576627.1 | 2033014 | g6129 | i0 | 37.1 | 1 | 89 | 56 | 100 | 0 | 1 | 267 | 2 | 90 | MEI7576627.1 hypothetical protein [Armatimonadota bacterium] | diamond | 267 | 61.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30215856 | 30215856 | PRJNA986547_P_NODE_5632_length_273_cov_1.165000_g5550_i0 | PRJNA986547 | 5632 | 273 | 1.165 | 3.18045 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 59.3 | 6.89e-9 | NR | MBX3110286.1 | 2682144 | g5550 | i0 | 60 | 0.43956043956044 | 40 | 16 | 44 | 0 | 152 | 271 | 1 | 40 | MBX3110286.1 iron-sulfur cluster assembly scaffold protein [Fimbriimonadaceae bacterium] | diamond | 120 | 59.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30689849 | 30689849 | PRJNA986547_P_NODE_10573_length_245_cov_1.587209_g10491_i0 | PRJNA986547 | 10573 | 245 | 1.587209 | 3.88866205 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 112 | 1.24e-26 | NR | MEI7577986.1 | 2033014 | g10491 | i0 | 68.9 | 1.81224489795918 | 74 | 23 | 90.6 | 0 | 22 | 243 | 453 | 526 | MEI7577986.1 penicillin-binding protein 2 [Armatimonadota bacterium] | diamond | 444 | 112 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30853822 | 30853822 | PRJNA986547_P_NODE_6734_length_263_cov_2.215789_g6652_i0 | PRJNA986547 | 6734 | 263 | 2.215789 | 5.82752507 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 120 | 7.13e-30 | NR | MDH4389211.1 | 1936159 | g6652 | i0 | 75 | 1.56273764258555 | 68 | 17 | 77.6 | 0 | 259 | 56 | 24 | 91 | MDH4389211.1 alpha-amylase family glycosyl hydrolase [Fimbriimonas sp.] | diamond | 411 | 120 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 31069308 | 31069308 | PRJNA986547_P_NODE_8095_length_253_cov_4.822222_g8013_i0 | PRJNA986547 | 8095 | 253 | 4.822222 | 12.20022166 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 153 | 5.47e-41 | NR | MDH4387429.1 | 1936159 | g8013 | i0 | 94 | 0.99604743083004 | 84 | 5 | 99.6 | 0 | 253 | 2 | 578 | 661 | MDH4387429.1 primosomal protein N' [Fimbriimonas sp.] | diamond | 252 | 153 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 31416897 | 31416897 | PRJNA986547_P_NODE_8016_length_254_cov_2.441989_g7934_i0 | PRJNA986547 | 8016 | 254 | 2.441989 | 6.20265206 | Armatimonadetes bacterium Cent15-Ar3 | 1987502 | Bacteria | Bacteria | 133 | 3.3299999999999997e-35 | NR | OWU65095.1 | 1987502 | g7934 | i0 | 76.2 | 0.992125984251969 | 84 | 20 | 99.2 | 0 | 252 | 1 | 64 | 147 | OWU65095.1 MAG: hypothetical protein CBB60_006440 [Armatimonadetes bacterium Cent15-Ar3] | diamond | 252 | 133 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Cent15-Ar3 | ||||||
| 31480438 | 31480438 | PRJNA986547_P_NODE_9796_length_247_cov_2.954023_g9714_i0 | PRJNA986547 | 9796 | 247 | 2.954023 | 7.29643681 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 134 | 1.71e-38 | NR | MBI3912532.1 | 2033014 | g9714 | i0 | 97.1 | 0.838056680161943 | 69 | 2 | 83.8 | 0 | 40 | 246 | 1 | 69 | MBI3912532.1 RNA chaperone Hfq [Armatimonadota bacterium] | diamond | 207 | 134 | 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);;