contig_metadata
25 rows where bioproject = "PRJNA1011844", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1002078 | 1002078 | PRJNA1011844_P_NODE_172581_length_223_cov_14.566667_g164000_i0 | PRJNA1011844 | 172581 | 223 | 14.566667 | 32.48366741 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 79.7 | 1.89e-15 | NR | HEY3282945.1 | 2033014 | g164000 | i0 | 60.9 | 1.77578475336323 | 69 | 20 | 83.4 | 1 | 18 | 203 | 25 | 93 | HEY3282945.1 molecular chaperone DnaJ [Armatimonadota bacterium] | diamond | 396 | 79.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 9084216 | 9084216 | PRJNA1011844_P_NODE_20328_length_1242_cov_17.629598_g15179_i0 | PRJNA1011844 | 20328 | 1242 | 17.629598 | 218.95960716 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 101 | 1.35e-19 | NR | HEY3282945.1 | 2033014 | g15179 | i0 | 57 | 0.22463768115942 | 93 | 33 | 20.8 | 1 | 908 | 651 | 1 | 93 | HEY3282945.1 molecular chaperone DnaJ [Armatimonadota bacterium] | diamond | 279 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 12909421 | 12909421 | PRJNA1011844_P_NODE_11251_length_1698_cov_6.702154_g8085_i0 | PRJNA1011844 | 11251 | 1698 | 6.702154 | 113.80257492 | Fimbriimonadia bacterium | 2575566 | Bacteria | Bacteria | 403 | 2.88e-131 | NR | MCW5934187.1 | 2575566 | g8085 | i0 | 46.6 | 5.40812720848057 | 515 | 241 | 89.8 | 12 | 1686 | 163 | 33 | 520 | MCW5934187.1 AMP-binding protein [Fimbriimonadia bacterium] | diamond | 9183 | 403 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadia bacterium | |||||
| 12910063 | 12910063 | PRJNA1011844_P_NODE_16671_length_1392_cov_10.175133_g12262_i0 | PRJNA1011844 | 16671 | 1392 | 10.175133 | 141.63785136 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 80.1 | 5.02e-13 | NR | MBZ0214235.1 | 2682144 | g12262 | i0 | 34.1 | 0.808189655172414 | 170 | 95 | 34.1 | 5 | 273 | 746 | 1 | 165 | MBZ0214235.1 protein kinase [Fimbriimonadaceae bacterium] | diamond | 1125 | 80.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 14185225 | 14185225 | PRJNA1011844_P_NODE_18532_length_1312_cov_12.275222_g13739_i0 | PRJNA1011844 | 18532 | 1312 | 12.275222 | 161.05091264 | Bacteria | 2 | Bacteria | Bacteria | 103 | 6.680000000000001e-21 | NR | MBN9501068.1 | 2033014 | g13739 | i0 | 34.3 | 1.54801829268293 | 230 | 124 | 49.4 | 7 | 1018 | 371 | 65 | 281 | MBN9501068.1 S1/P1 nuclease [Armatimonadota bacterium] | diamond | 2031 | 104 | 0.990384615384615 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 19281380 | 19281380 | PRJNA1011844_P_NODE_11736_length_1663_cov_18.954088_g8460_i0 | PRJNA1011844 | 11736 | 1663 | 18.954088 | 315.20648344 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 279 | 1.05e-83 | NR | HET6382228.1 | 2033014 | g8460 | i0 | 37.9 | 1.79314491882141 | 499 | 241 | 87.5 | 15 | 77 | 1531 | 24 | 467 | HET6382228.1 glycoside hydrolase family 30 beta sandwich domain-containing protein [Armatimonadota bacterium] | diamond | 2982 | 279 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 20128425 | 20128425 | PRJNA1011844_P_NODE_158936_length_242_cov_3.804734_g150356_i0 | PRJNA1011844 | 158936 | 242 | 3.804734 | 9.20745628 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 189 | 1.5899999999999996e-43 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g150356 | i0 | 82.569 | 254.330578512397 | 218 | 35 | 89 | 3 | 8 | 223 | 29569 | 29785 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 61548 | 189 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 22678767 | 22678767 | PRJNA1011844_P_NODE_151138_length_247_cov_3.408046_g142559_i0 | PRJNA1011844 | 151138 | 247 | 3.408046 | 8.41787362 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 237 | 5.74e-58 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g142559 | i0 | 85.043 | 65.7611336032389 | 234 | 33 | 94 | 2 | 3 | 235 | 27380 | 27612 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 16243 | 237 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 27121567 | 27121567 | PRJNA1011844_P_NODE_20602_length_1232_cov_14.606557_g15407_i0 | PRJNA1011844 | 20602 | 1232 | 14.606557 | 179.95278224 | Bacteria | 2 | Bacteria | Bacteria | 103 | 3.57e-21 | NR | MBN9501068.1 | 2033014 | g15407 | i0 | 34.3 | 1.64853896103896 | 230 | 124 | 52.6 | 7 | 1005 | 358 | 65 | 281 | MBN9501068.1 S1/P1 nuclease [Armatimonadota bacterium] | diamond | 2031 | 104 | 0.990384615384615 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27287614 | 27287614 | PRJNA1011844_P_NODE_20203_length_1247_cov_16.485520_g5502_i3 | PRJNA1011844 | 20203 | 1247 | 16.48552 | 205.5744344 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 53.1 | 0.00112 | NR | MFO8081052.1 | 2033014 | g5502 | i3 | 35.9 | 0.247794707297514 | 103 | 63 | 24.1 | 1 | 22 | 321 | 126 | 228 | MFO8081052.1 PQQ-binding-like beta-propeller repeat protein [Armatimonadota bacterium] | diamond | 309 | 53.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27603756 | 27603756 | PRJNA1011844_P_NODE_7864_length_1989_cov_10.115866_g5502_i0 | PRJNA1011844 | 7864 | 1989 | 10.115866 | 201.20457474 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 49.7 | 0.0293 | NR | MFO8081052.1 | 2033014 | g5502 | i0 | 36.3 | 0.153846153846154 | 102 | 62 | 14.9 | 1 | 773 | 1069 | 126 | 227 | MFO8081052.1 PQQ-binding-like beta-propeller repeat protein [Armatimonadota bacterium] | diamond | 306 | 49.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27982332 | 27982332 | PRJNA1011844_P_NODE_124965_length_276_cov_3.152709_g116388_i0 | PRJNA1011844 | 124965 | 276 | 3.152709 | 8.70147684 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 43.5 | 0.0284 | NR | HOK54617.1 | 2033014 | g116388 | i0 | 33.3 | 0.652173913043478 | 60 | 39 | 64.1 | 1 | 50 | 226 | 245 | 304 | HOK54617.1 C10 family peptidase [Armatimonadota bacterium] | diamond | 180 | 43.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28234792 | 28234792 | PRJNA1011844_P_NODE_8646_length_1913_cov_9.038587_g5502_i1 | PRJNA1011844 | 8646 | 1913 | 9.038587 | 172.90816931 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 49.7 | 0.0278 | NR | MFO8081052.1 | 2033014 | g5502 | i1 | 36.3 | 0.159958180867747 | 102 | 62 | 15.5 | 1 | 1217 | 921 | 126 | 227 | MFO8081052.1 PQQ-binding-like beta-propeller repeat protein [Armatimonadota bacterium] | diamond | 306 | 49.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29592342 | 29592342 | PRJNA1011844_P_NODE_99110_length_329_cov_8.285156_g90543_i0 | PRJNA1011844 | 99110 | 329 | 8.285156 | 27.25816324 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 80.1 | 4.75e-15 | NR | MBL1152025.1 | 2033014 | g90543 | i0 | 40.7 | 3.66565349544073 | 108 | 31 | 98.5 | 2 | 5 | 328 | 1 | 75 | MBL1152025.1 A/G-specific adenine glycosylase [Armatimonadota bacterium] | diamond | 1206 | 80.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29750211 | 29750211 | PRJNA1011844_P_NODE_142911_length_254_cov_1.624309_g134333_i0 | PRJNA1011844 | 142911 | 254 | 1.624309 | 4.12574486 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 153 | 1.3999999999999996e-41 | NR | MCC6444417.1 | 2033014 | g134333 | i0 | 90.2 | 0.968503937007874 | 82 | 8 | 96.9 | 0 | 3 | 248 | 331 | 412 | MCC6444417.1 DUF4157 domain-containing protein [Armatimonadota bacterium] | diamond | 246 | 153 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30343573 | 30343573 | PRJNA1011844_P_NODE_150032_length_248_cov_1.702857_g141453_i0 | PRJNA1011844 | 150032 | 248 | 1.702857 | 4.22308536 | PVC group | 1783257 | Bacteria | Bacteria | 103 | 2.06e-23 | NR | WP_184193273.1 | 685828 | g141453 | i0 | 63.4 | 6.87096774193548 | 71 | 26 | 85.9 | 0 | 231 | 19 | 382 | 452 | WP_184193273.1 right-handed parallel beta-helix repeat-containing protein [Armatimonas rosea] | diamond | 1704 | 103 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas rosea | ||
| 30634982 | 30634982 | PRJNA1011844_P_NODE_67133_length_472_cov_3.290727_g58695_i0 | PRJNA1011844 | 67133 | 472 | 3.290727 | 15.53223144 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 69.3 | 2.13e-10 | NR | MBZ0214179.1 | 2682144 | g58695 | i0 | 36.2 | 1.49364406779661 | 141 | 85 | 86.4 | 3 | 427 | 20 | 25 | 165 | MBZ0214179.1 serine/threonine protein kinase [Fimbriimonadaceae bacterium] | diamond | 705 | 69.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30753812 | 30753812 | PRJNA1011844_P_NODE_153594_length_246_cov_0.890173_g145014_i0 | PRJNA1011844 | 153594 | 246 | 0.890173 | 2.18982558 | Bacillati | 1783272 | Bacteria | Bacteria | 92 | 1.71e-19 | NR | GIV21115.1 | 2033014 | g145014 | i0 | 55.3 | 5.5609756097561 | 76 | 34 | 92.7 | 0 | 232 | 5 | 62 | 137 | GIV21115.1 MAG: hypothetical protein KatS3mg023_2866 [Armatimonadota bacterium] | diamond | 1368 | 92 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30824585 | 30824585 | PRJNA1011844_P_NODE_134834_length_263_cov_3.484211_g126256_i0 | PRJNA1011844 | 134834 | 263 | 3.484211 | 9.16347493 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 45.4 | 0.00336 | NR | MCS7190195.1 | 2682145 | g126256 | i0 | 50 | 0.387832699619772 | 34 | 17 | 38.8 | 0 | 192 | 91 | 5 | 38 | MCS7190195.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 102 | 45.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 31614920 | 31614920 | PRJNA1011844_P_NODE_117556_length_287_cov_2.813084_g108980_i0 | PRJNA1011844 | 117556 | 287 | 2.813084 | 8.07355108 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 45.4 | 4.59e-4 | NR | HLK61614.1 | 2739509 | g108980 | i0 | 65.5 | 0.303135888501742 | 29 | 10 | 30.3 | 0 | 199 | 285 | 23 | 51 | HLK61614.1 ankyrin repeat domain-containing protein [Chthonomonadaceae bacterium] | diamond | 87 | 45.4 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 31867971 | 31867971 | PRJNA1011844_P_NODE_75717_length_421_cov_2.925287_g67219_i0 | PRJNA1011844 | 75717 | 421 | 2.925287 | 12.31545827 | Capsulimonadaceae bacterium | 2953755 | Bacteria | Bacteria | 48.1 | 0.00319 | NR | MDR3707833.1 | 2953755 | g67219 | i0 | 30.5 | 2.22327790973872 | 131 | 70 | 89.8 | 2 | 19 | 396 | 143 | 257 | MDR3707833.1 protein kinase [Capsulimonadaceae bacterium] | diamond | 936 | 48.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonadaceae bacterium | |||
| 31899690 | 31899690 | PRJNA1011844_P_NODE_28057_length_1007_cov_2.314775_g21642_i0 | PRJNA1011844 | 28057 | 1007 | 2.314775 | 23.30978425 | Armatimonadetes bacterium CG_4_1 | 2033014 | Bacteria | Bacteria | 307 | 6.23e-97 | NR | PIY44557.1 | 1973909 | g21642 | i0 | 99.4 | 0.48857994041708 | 164 | 1 | 48.9 | 0 | 1007 | 516 | 131 | 294 | PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] | diamond | 492 | 307 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10 | ||||||
| 31955129 | 31955129 | PRJNA1011844_P_NODE_113377_length_294_cov_8.461538_g104801_i0 | PRJNA1011844 | 113377 | 294 | 8.461538 | 24.87692172 | Armatimonadota | 67819 | Bacteria | Bacteria | 149 | 3.94e-41 | NR | MBX7135421.1 | 2682144 | g104801 | i0 | 72.8 | 6.60204081632653 | 92 | 25 | 93.9 | 0 | 10 | 285 | 66 | 157 | MBX7135421.1 pyridoxal phosphate-dependent aminotransferase [Fimbriimonadaceae bacterium] | diamond | 1941 | 149 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 31962968 | 31962968 | PRJNA1011844_P_NODE_87458_length_368_cov_14.613559_g78907_i0 | PRJNA1011844 | 87458 | 368 | 14.613559 | 53.77789712 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 49.7 | 4.79e-4 | NR | MFO8081052.1 | 2033014 | g78907 | i0 | 36.7 | 0.798913043478261 | 98 | 59 | 77.4 | 1 | 360 | 76 | 130 | 227 | MFO8081052.1 PQQ-binding-like beta-propeller repeat protein [Armatimonadota bacterium] | diamond | 294 | 49.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32564395 | 32564395 | PRJNA1011844_P_NODE_18959_length_1295_cov_6.216039_g14077_i0 | PRJNA1011844 | 18959 | 1295 | 6.216039 | 80.49770505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 53.1 | 0.00207 | NR | MCX6379460.1 | 2033014 | g14077 | i0 | 30.3 | 0.451737451737452 | 195 | 121 | 44.5 | 5 | 16 | 591 | 144 | 326 | MCX6379460.1 serine/threonine-protein kinase [Armatimonadota bacterium] | diamond | 585 | 53.1 | 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);;