contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA1164198" and tax_phylum = "Actinomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10515628 | 10515628 | PRJNA1164198_P_NODE_26429_length_249_cov_0.886364_g26160_i0 | PRJNA1164198 | 26429 | 249 | 0.886364 | 2.20704636 | Brachybacterium muris | 219301 | Bacteria | Bacteria | 149 | 2.4199999999999998e-42 | NR | WP_017822414.1 | 219301 | g26160 | i0 | 90.2 | 0.987951807228916 | 82 | 8 | 98.8 | 0 | 247 | 2 | 25 | 106 | WP_017822414.1 DUF3097 domain-containing protein [Brachybacterium muris] | diamond | 246 | 149 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermabacteraceae | Brachybacterium | Brachybacterium muris | ||
| 13065608 | 13065608 | PRJNA1164198_P_NODE_30811_length_242_cov_0.923077_g30542_i0 | PRJNA1164198 | 30811 | 242 | 0.923077 | 2.23384634 | Kineococcus rubinsiae | 2609562 | Bacteria | Bacteria | 135 | 5.519999999999999e-35 | NR | WP_167587486.1 | 2609562 | g30542 | i0 | 86.3 | 0.991735537190083 | 80 | 11 | 99.2 | 0 | 3 | 242 | 444 | 523 | WP_167587486.1 glycoside hydrolase family 3 protein [Kineococcus rubinsiae] | diamond | 240 | 135 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kineosporiales | Kineosporiaceae | Kineococcus | Kineococcus rubinsiae | ||
| 16889104 | 16889104 | PRJNA1164198_P_NODE_29714_length_244_cov_0.912281_g29445_i0 | PRJNA1164198 | 29714 | 244 | 0.912281 | 2.22596564 | Aeromicrobium sp. Root472D3 | 1736540 | Bacteria | Bacteria | 155 | 9.429999999999997e-43 | NR | WP_056602979.1 | 1736540 | g29445 | i0 | 96.3 | 0.995901639344262 | 81 | 3 | 99.6 | 0 | 243 | 1 | 141 | 221 | WP_056602979.1 amino acid permease [Aeromicrobium sp. Root472D3] | diamond | 243 | 155 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Aeromicrobium | Aeromicrobium sp. Root472D3 | ||
| 20713343 | 20713343 | PRJNA1164198_P_NODE_28537_length_246_cov_0.901734_g28268_i0 | PRJNA1164198 | 28537 | 246 | 0.901734 | 2.21826564 | Propionibacteriaceae bacterium | 2021380 | Bacteria | Bacteria | 100 | 9.84e-24 | NR | MET0695756.1 | 2021380 | g28268 | i0 | 88.5 | 0.74390243902439 | 61 | 7 | 74.4 | 0 | 64 | 246 | 6 | 66 | MET0695756.1 IclR family transcriptional regulator [Propionibacteriaceae bacterium] | diamond | 183 | 100 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Propionibacteriaceae bacterium | |||
| 26596955 | 26596955 | PRJNA1164198_P_NODE_29241_length_244_cov_5.479532_g28972_i0 | PRJNA1164198 | 29241 | 244 | 5.479532 | 13.37005808 | Actinomycetospora flava | 3129232 | Bacteria | Bacteria | 43.5 | 0.0181 | NR | WP_337703644.1 | 3129232 | g28972 | i0 | 44.6 | 0.799180327868853 | 65 | 29 | 71.3 | 2 | 229 | 56 | 34 | 98 | WP_337703644.1 CPBP family intramembrane glutamic endopeptidase [Actinomycetospora flava] | diamond | 195 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinomycetospora | Actinomycetospora flava | ||
| 26996239 | 26996239 | PRJNA1164198_P_NODE_27922_length_247_cov_0.896552_g27653_i0 | PRJNA1164198 | 27922 | 247 | 0.896552 | 2.21448344 | Bacteria | 2 | Bacteria | Bacteria | 42.7 | 0.0242 | NR | WP_395474882.1 | 60894 | g27653 | i0 | 34.1 | 1.61538461538462 | 85 | 41 | 85 | 3 | 218 | 9 | 74 | 158 | WP_395474882.1 hypothetical protein [Saccharopolyspora spinosa] | diamond | 399 | 43.1 | 0.990719257540603 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharopolyspora | Saccharopolyspora spinosa | ||
| 28051159 | 28051159 | PRJNA1164198_P_NODE_27125_length_248_cov_0.891429_g26856_i0 | PRJNA1164198 | 27125 | 248 | 0.891429 | 2.21074392 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 110 | 1.3e-27 | NR | NCX04458.1 | 2900548 | g26856 | i0 | 59.8 | 1.98387096774194 | 82 | 33 | 99.2 | 0 | 2 | 247 | 42 | 123 | NCX04458.1 hypothetical protein [Actinomycetota bacterium] | diamond | 492 | 110 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 28872019 | 28872019 | PRJNA1164198_P_NODE_4848_length_570_cov_1.545272_g4599_i0 | PRJNA1164198 | 4848 | 570 | 1.545272 | 8.8080504 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 50.8 | 0.0012 | NR | MCZ7531284.1 | 2080302 | g4599 | i0 | 35.5 | 0.726315789473684 | 138 | 77 | 67.9 | 5 | 4 | 390 | 392 | 526 | MCZ7531284.1 hypothetical protein [Acidimicrobiia bacterium] | diamond | 414 | 50.8 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 28903461 | 28903461 | PRJNA1164198_P_NODE_25868_length_250_cov_0.881356_g25599_i0 | PRJNA1164198 | 25868 | 250 | 0.881356 | 2.20339 | Mycetocola zhadangensis | 1164595 | Bacteria | Bacteria | 139 | 1.18e-38 | NR | WP_416279446.1 | 1164595 | g25599 | i0 | 100 | 0.792 | 66 | 0 | 79.2 | 0 | 249 | 52 | 210 | 275 | WP_416279446.1 helix-turn-helix transcriptional regulator [Mycetocola zhadangensis] | diamond | 198 | 139 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Mycetocola | Mycetocola zhadangensis | ||
| 29093288 | 29093288 | PRJNA1164198_P_NODE_31648_length_229_cov_2.897436_g31379_i0 | PRJNA1164198 | 31648 | 229 | 2.897436 | 6.63512844 | Corynebacterium rouxii | 2719119 | Bacteria | Bacteria | 43.5 | 0.0105 | NR | VZH86393.1 | 2719119 | g31379 | i0 | 48.1 | 0.681222707423581 | 52 | 27 | 68.1 | 0 | 61 | 216 | 114 | 165 | VZH86393.1 hypothetical protein FRC0190_02303 [Corynebacterium rouxii] | diamond | 156 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium rouxii | ||
| 29408803 | 29408803 | PRJNA1164198_P_NODE_30889_length_242_cov_0.923077_g30620_i0 | PRJNA1164198 | 30889 | 242 | 0.923077 | 2.23384634 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 54.7 | 9.11e-8 | NR | WP_303678830.1 | 1528099 | g30620 | i0 | 100 | 0.297520661157025 | 24 | 0 | 29.8 | 0 | 1 | 72 | 44 | 67 | WP_303678830.1 type II toxin-antitoxin system HicB family antitoxin [Lawsonella clevelandensis] | diamond | 72 | 54.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 29471696 | 29471696 | PRJNA1164198_P_NODE_10910_length_376_cov_2.333333_g10642_i0 | PRJNA1164198 | 10910 | 376 | 2.333333 | 8.77333208 | Cellulomonas sp. NTE-D12 | 2962632 | Bacteria | Bacteria | 44.7 | 0.027 | NR | WP_337974423.1 | 2962632 | g10642 | i0 | 26.9 | 0.861702127659574 | 108 | 70 | 82.2 | 3 | 8 | 316 | 95 | 198 | WP_337974423.1 VIT1/CCC1 transporter family protein [Cellulomonas sp. NTE-D12] | diamond | 324 | 44.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Cellulomonadaceae | Cellulomonas | Cellulomonas sp. NTE-D12 | ||
| 29597972 | 29597972 | PRJNA1164198_P_NODE_30030_length_243_cov_1.141176_g29761_i0 | PRJNA1164198 | 30030 | 243 | 1.141176 | 2.77305768 | Streptomyces hilarionis | 2839954 | Bacteria | Bacteria | 43.5 | 0.0187 | NR | MCQ9136224.1 | 2839954 | g29761 | i0 | 51.2 | 1.06172839506173 | 43 | 20 | 53.1 | 1 | 69 | 197 | 147 | 188 | MCQ9136224.1 serine/threonine protein kinase [Streptomyces hilarionis] | diamond | 258 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces hilarionis | ||
| 29914273 | 29914273 | PRJNA1164198_P_NODE_17591_length_295_cov_0.824324_g17322_i0 | PRJNA1164198 | 17591 | 295 | 0.824324 | 2.4317558 | unclassified Streptomyces | 2593676 | Bacteria | Bacteria | 43.9 | 0.0235 | NR | WP_329425863.1 | 2593676 | g17322 | i0 | 38.3 | 0.955932203389831 | 94 | 32 | 84.4 | 5 | 271 | 23 | 63 | 141 | WP_329425863.1 MULTISPECIES: ABC transporter ATP-binding protein [unclassified Streptomyces] | diamond | 282 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | |||
| 29945788 | 29945788 | PRJNA1164198_P_NODE_19831_length_278_cov_1.765854_g19562_i0 | PRJNA1164198 | 19831 | 278 | 1.765854 | 4.90907412 | Micrococcales bacterium | 2026762 | Bacteria | Bacteria | 101 | 1.5000000000000002e-22 | NR | MCE1180104.1 | 2026762 | g19562 | i0 | 51.1 | 1.96402877697842 | 90 | 44 | 97.1 | 0 | 4 | 273 | 47 | 136 | MCE1180104.1 neutral/alkaline ceramidase [Micrococcales bacterium] | diamond | 546 | 101 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcales bacterium | ||||
| 30040454 | 30040454 | PRJNA1164198_P_NODE_20711_length_273_cov_0.950000_g20442_i0 | PRJNA1164198 | 20711 | 273 | 0.95 | 2.5935 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 43.9 | 0.0205 | NR | WP_361624954.1 | 3155377 | g20442 | i0 | 35.2 | 0.593406593406593 | 54 | 29 | 57.1 | 2 | 162 | 7 | 236 | 285 | WP_361624954.1 exo-alpha-sialidase [Streptomyces sp. NPDC046985] | diamond | 162 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC046985 | ||
| 30249536 | 30249536 | PRJNA1164198_P_NODE_5612_length_531_cov_2.262009_g5357_i0 | PRJNA1164198 | 5612 | 531 | 2.262009 | 12.01126779 | Bacteria | 2 | Bacteria | Bacteria | 119 | 4.1e-30 | NR | WP_069174204.1 | 1911 | g5357 | i0 | 48.6 | 8.07909604519774 | 142 | 67 | 77.4 | 3 | 530 | 120 | 27 | 167 | WP_069174204.1 TerD family protein [Streptomyces griseus] | diamond | 4290 | 120 | 0.991666666666667 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces griseus | ||
| 30451440 | 30451440 | PRJNA1164198_P_NODE_15393_length_315_cov_2.247934_g15124_i0 | PRJNA1164198 | 15393 | 315 | 2.247934 | 7.0809921 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 46.2 | 0.00118 | NR | GIT46276.1 | 2201156 | g15124 | i0 | 36.4 | 0.838095238095238 | 88 | 53 | 81 | 2 | 17 | 271 | 20 | 107 | GIT46276.1 MAG: hypothetical protein Ct9H300mP12_08610 [Acidimicrobiales bacterium] | diamond | 264 | 46.2 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 30798628 | 30798628 | PRJNA1164198_P_NODE_19554_length_280_cov_1.507246_g19285_i0 | PRJNA1164198 | 19554 | 280 | 1.507246 | 4.2202888 | Arthrobacter sp. B18 | 589273 | Bacteria | Bacteria | 181 | 2.5199999999999997e-56 | NR | WP_104118423.1 | 2058892 | g19285 | i0 | 91.4 | 2.98928571428571 | 93 | 8 | 99.6 | 0 | 2 | 280 | 85 | 177 | WP_104118423.1 hypothetical protein [Arthrobacter sp. B1805] | diamond | 837 | 181 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter sp. B1805 | ||
| 31019995 | 31019995 | PRJNA1164198_P_NODE_26575_length_249_cov_0.886364_g26306_i0 | PRJNA1164198 | 26575 | 249 | 0.886364 | 2.20704636 | Propionibacteriaceae bacterium | 2021380 | Bacteria | Bacteria | 144 | 2.34e-42 | NR | HEX8488088.1 | 2021380 | g26306 | i0 | 91.3 | 0.963855421686747 | 80 | 7 | 96.4 | 0 | 240 | 1 | 1 | 80 | HEX8488088.1 Lrp/AsnC family transcriptional regulator [Propionibacteriaceae bacterium] | diamond | 240 | 144 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Propionibacteriaceae bacterium | |||
| 31177614 | 31177614 | PRJNA1164198_P_NODE_24455_length_253_cov_0.866667_g24186_i0 | PRJNA1164198 | 24455 | 253 | 0.866667 | 2.19266751 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 109 | 1.19e-27 | NR | HEV7176722.1 | 2586742 | g24186 | i0 | 65.4 | 0.924901185770751 | 78 | 26 | 91.3 | 1 | 245 | 15 | 55 | 132 | HEV7176722.1 class I SAM-dependent methyltransferase [Solirubrobacteraceae bacterium] | diamond | 234 | 109 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 31873673 | 31873673 | PRJNA1164198_P_NODE_30077_length_243_cov_0.917647_g29808_i0 | PRJNA1164198 | 30077 | 243 | 0.917647 | 2.22988221 | Sediminivirga luteola | 1774748 | Bacteria | Bacteria | 167 | 1.7999999999999998e-48 | NR | WP_242136460.1 | 1774748 | g29808 | i0 | 88.8 | 0.987654320987654 | 80 | 9 | 98.8 | 0 | 242 | 3 | 87 | 166 | WP_242136460.1 IS1249 family transposase [Sediminivirga luteola] | diamond | 240 | 167 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Brevibacteriaceae | Sediminivirga | Sediminivirga luteola | ||
| 31956170 | 31956170 | PRJNA1164198_P_NODE_18097_length_291_cov_1.288991_g17828_i0 | PRJNA1164198 | 18097 | 291 | 1.288991 | 3.75096381 | Nocardioides | 1839 | Bacteria | Bacteria | 114 | 7.91e-30 | NR | EGD45623.1 | 408672 | g17828 | i0 | 55.6 | 2.94845360824742 | 90 | 40 | 92.8 | 0 | 22 | 291 | 28 | 117 | EGD45623.1 hypothetical protein NBCG_00100 [Nocardioidaceae bacterium Broad-1] | diamond | 858 | 115 | 0.991304347826087 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioidaceae bacterium Broad-1 | |||
| 32063471 | 32063471 | PRJNA1164198_P_NODE_29058_length_245_cov_0.906977_g28789_i0 | PRJNA1164198 | 29058 | 245 | 0.906977 | 2.22209365 | Microbacterium sp. Clip185 | 3025663 | Bacteria | Bacteria | 87.8 | 4.28e-18 | NR | WP_274287301.1 | 3025663 | g28789 | i0 | 91.5 | 1.15102040816327 | 47 | 4 | 57.6 | 0 | 104 | 244 | 1 | 47 | WP_274287301.1 cell division initiation protein [Microbacterium sp. Clip185] | diamond | 282 | 87.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. Clip185 | ||
| 32095189 | 32095189 | PRJNA1164198_P_NODE_23498_length_256_cov_1.322404_g23229_i0 | PRJNA1164198 | 23498 | 256 | 1.322404 | 3.38535424 | Kitasatospora sp. GAS2 | 1871188 | Bacteria | Bacteria | 43.5 | 0.0227 | NR | WP_280693357.1 | 3035283 | g23229 | i0 | 32.8 | 0.75 | 64 | 43 | 75 | 0 | 249 | 58 | 148 | 211 | WP_280693357.1 c-type cytochrome biogenesis protein CcsB [Kitasatospora sp. GAS204B] | diamond | 192 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora sp. GAS204B | ||
| 32209474 | 32209474 | PRJNA1164198_P_NODE_30258_length_243_cov_0.917647_g29989_i0 | PRJNA1164198 | 30258 | 243 | 0.917647 | 2.22988221 | Ilumatobacter | 682522 | Bacteria | Bacteria | 103 | 1.4599999999999995e-23 | NR | HUF98948.1 | 1967498 | g29989 | i0 | 63.3 | 3.90123456790123 | 79 | 29 | 97.5 | 0 | 5 | 241 | 834 | 912 | HUF98948.1 indolepyruvate ferredoxin oxidoreductase family protein [Ilumatobacter sp.] | diamond | 948 | 104 | 0.990384615384615 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Ilumatobacteraceae | Ilumatobacter | Ilumatobacter sp. | ||
| 32317002 | 32317002 | PRJNA1164198_P_NODE_26139_length_250_cov_0.881356_g25870_i0 | PRJNA1164198 | 26139 | 250 | 0.881356 | 2.20339 | Kocuria marina | 223184 | Bacteria | Bacteria | 174 | 2.8999999999999997e-48 | NR | WP_121544325.1 | 223184 | g25870 | i0 | 97.6 | 0.984 | 82 | 2 | 98.4 | 0 | 3 | 248 | 212 | 293 | WP_121544325.1 ATP-binding protein [Kocuria marina] | diamond | 246 | 174 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Kocuria | Kocuria marina |
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);;