contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJEB15333" and tax_kingdom = "Bacillati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26589669 | 26589669 | PRJEB15333_P_NODE_9141_length_223_cov_1.385057_g9057_i0 | PRJEB15333 | 9141 | 223 | 1.385057 | 3.08867711 | Trebonia sp. | 2767075 | Bacteria | Bacteria | 43.5 | 0.0153 | NR | HEY7279562.1 | 2767075 | g9057 | i0 | 37 | 0.982062780269058 | 73 | 36 | 87.4 | 3 | 8 | 202 | 220 | 290 | HEY7279562.1 hypothetical protein [Trebonia sp.] | diamond | 219 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Treboniaceae | Trebonia | Trebonia sp. | ||
| 26684819 | 26684819 | PRJEB15333_P_NODE_3661_length_332_cov_1.869258_g3577_i0 | PRJEB15333 | 3661 | 332 | 1.869258 | 6.20593656 | Oscillospiraceae bacterium | 2485925 | Bacteria | Bacteria | 43.9 | 0.0393 | NR | MBQ6539838.1 | 2485925 | g3577 | i0 | 31.8 | 0.795180722891566 | 88 | 53 | 75.9 | 4 | 3 | 254 | 155 | 239 | MBQ6539838.1 sodium:proton antiporter [Oscillospiraceae bacterium] | diamond | 264 | 43.9 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 26716169 | 26716169 | PRJEB15333_P_NODE_19461_length_164_cov_0.904348_g19377_i0 | PRJEB15333 | 19461 | 164 | 0.904348 | 1.48313072 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 41.6 | 0.0306 | NR | HEX5012711.1 | 2952938 | g19377 | i0 | 48.9 | 0.859756097560976 | 47 | 19 | 80.5 | 2 | 33 | 164 | 132 | 176 | HEX5012711.1 DUF4386 domain-containing protein [Candidatus Limnocylindrales bacterium] | diamond | 141 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 27222574 | 27222574 | PRJEB15333_P_NODE_17443_length_168_cov_0.873950_g17359_i0 | PRJEB15333 | 17443 | 168 | 0.87395 | 1.468236 | Arthrobacter echini | 1529066 | Bacteria | Bacteria | 41.2 | 0.0492 | NR | WP_136454026.1 | 1529066 | g17359 | i0 | 36.5 | 0.928571428571429 | 52 | 28 | 83.9 | 1 | 25 | 165 | 16 | 67 | WP_136454026.1 ATP-binding protein [Arthrobacter echini] | diamond | 156 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter echini | ||
| 27254274 | 27254274 | PRJEB15333_P_NODE_12863_length_191_cov_1.070423_g12779_i0 | PRJEB15333 | 12863 | 191 | 1.070423 | 2.04450793 | Brachybacterium sp. P6-1 | 1891286 | Bacteria | Bacteria | 42 | 0.0312 | NR | WP_083713220.1 | 1903186 | g12779 | i0 | 40 | 1.57068062827225 | 50 | 28 | 75.4 | 1 | 15 | 158 | 155 | 204 | WP_083713220.1 PGPGW domain-containing protein [Brachybacterium sp. P6-10-X1] | diamond | 300 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermabacteraceae | Brachybacterium | Brachybacterium sp. P6-10-X1 | ||
| 27475541 | 27475541 | PRJEB15333_P_NODE_8823_length_226_cov_4.214689_g8739_i0 | PRJEB15333 | 8823 | 226 | 4.214689 | 9.52519714 | Actinomycetales bacterium | 1911520 | Bacteria | Bacteria | 43.9 | 0.0119 | NR | MBU6147104.1 | 1911520 | g8739 | i0 | 42.6 | 0.809734513274336 | 61 | 26 | 69 | 2 | 160 | 5 | 121 | 181 | MBU6147104.1 hypothetical protein [Actinomycetales bacterium] | diamond | 183 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetales bacterium | ||||
| 27633542 | 27633542 | PRJEB15333_P_NODE_17384_length_168_cov_0.873950_g17300_i0 | PRJEB15333 | 17384 | 168 | 0.87395 | 1.468236 | Bacillales bacterium | 1904864 | Bacteria | Bacteria | 75.9 | 2.76e-14 | NR | HET7580570.1 | 1904864 | g17300 | i0 | 72.7 | 1.96428571428571 | 55 | 14 | 98.2 | 1 | 2 | 166 | 372 | 425 | HET7580570.1 DNA polymerase/3'-5' exonuclease PolX [Bacillales bacterium] | diamond | 330 | 75.9 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillales bacterium | ||||
| 27823053 | 27823053 | PRJEB15333_P_NODE_12944_length_190_cov_2.404255_g12860_i0 | PRJEB15333 | 12944 | 190 | 2.404255 | 4.5680845 | Actinomycetales bacterium | 1911520 | Bacteria | Bacteria | 43.5 | 0.0101 | NR | MBU6147104.1 | 1911520 | g12860 | i0 | 41 | 0.963157894736842 | 61 | 27 | 82.1 | 2 | 28 | 183 | 121 | 181 | MBU6147104.1 hypothetical protein [Actinomycetales bacterium] | diamond | 183 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetales bacterium | ||||
| 27917467 | 27917467 | PRJEB15333_P_NODE_8045_length_236_cov_1.139037_g7961_i0 | PRJEB15333 | 8045 | 236 | 1.139037 | 2.68812732 | Gaiellaceae bacterium | 2838783 | Bacteria | Bacteria | 42.7 | 0.0332 | NR | MDX6438183.1 | 2838783 | g7961 | i0 | 47.2 | 0.673728813559322 | 53 | 26 | 66.1 | 2 | 3 | 158 | 308 | 359 | MDX6438183.1 branched-chain amino acid transport system permease protein [Gaiellaceae bacterium] | diamond | 159 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Gaiellales | Gaiellaceae | Gaiellaceae bacterium | |||
| 28106939 | 28106939 | PRJEB15333_P_NODE_2025_length_424_cov_10.560000_g1943_i0 | PRJEB15333 | 2025 | 424 | 10.56 | 44.7744 | Frankiaceae bacterium | 2654182 | Bacteria | Bacteria | 43.1 | 0.0485 | NR | HWL37608.1 | 2654182 | g1943 | i0 | 31.4 | 0.608490566037736 | 86 | 48 | 53.1 | 2 | 43 | 267 | 5 | 90 | HWL37608.1 hypothetical protein [Frankiaceae bacterium] | diamond | 258 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Frankiales | Frankiaceae | Frankiaceae bacterium | |||
| 28264749 | 28264749 | PRJEB15333_P_NODE_3846_length_325_cov_1.514493_g3762_i0 | PRJEB15333 | 3846 | 325 | 1.514493 | 4.92210225 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 45.4 | 0.011 | NR | WP_351510576.1 | 3154534 | g3762 | i0 | 38.2 | 0.701538461538462 | 76 | 44 | 67.4 | 1 | 70 | 288 | 50 | 125 | WP_351510576.1 SpoIIE family protein phosphatase [Streptomyces sp. NPDC002055] | diamond | 228 | 45.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC002055 | ||
| 28296380 | 28296380 | PRJEB15333_P_NODE_7006_length_251_cov_1.004950_g6922_i0 | PRJEB15333 | 7006 | 251 | 1.00495 | 2.5224245 | Umezawaea tangerina | 84725 | Bacteria | Bacteria | 43.9 | 0.0157 | NR | WP_106188173.1 | 84725 | g6922 | i0 | 36.9 | 0.776892430278884 | 65 | 39 | 75.3 | 2 | 51 | 239 | 293 | 357 | WP_106188173.1 MFS transporter [Umezawaea tangerina] | diamond | 195 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Umezawaea | Umezawaea tangerina | ||
| 28707059 | 28707059 | PRJEB15333_P_NODE_15647_length_175_cov_0.865079_g15563_i0 | PRJEB15333 | 15647 | 175 | 0.865079 | 1.51388825 | Candidatus Pelethenecus faecipullorum | 2840900 | Bacteria | Bacteria | 42.7 | 0.00361 | NR | HIT49952.1 | 2840900 | g15563 | i0 | 35.6 | 1.01142857142857 | 59 | 35 | 96 | 1 | 174 | 7 | 20 | 78 | HIT49952.1 zinc ribbon domain-containing protein [Candidatus Pelethenecus faecipullorum] | diamond | 177 | 42.7 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Candidatus Pelethenecus | Candidatus Pelethenecus faecipullorum | ||||
| 28770016 | 28770016 | PRJEB15333_P_NODE_18627_length_166_cov_0.888889_g18543_i0 | PRJEB15333 | 18627 | 166 | 0.888889 | 1.47555574 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 55.1 | 5.59e-7 | NR | MBX9723358.1 | 2364082 | g18543 | i0 | 53.8 | 0.939759036144578 | 52 | 24 | 94 | 0 | 161 | 6 | 301 | 352 | MBX9723358.1 universal stress protein [Candidatus Obscuribacterales bacterium] | diamond | 156 | 55.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28927936 | 28927936 | PRJEB15333_P_NODE_20528_length_162_cov_0.920354_g20444_i0 | PRJEB15333 | 20528 | 162 | 0.920354 | 1.49097348 | Eubacteriales Family XIII. Incertae Sedis | 543314 | Bacteria | Bacteria | 41.2 | 0.0401 | NR | WP_148396037.1 | 543314 | g20444 | i0 | 39.2 | 0.944444444444444 | 51 | 28 | 90.7 | 2 | 16 | 162 | 42 | 91 | WP_148396037.1 MULTISPECIES: phosphatase PAP2 family protein [Anaerovoracaceae] | diamond | 153 | 41.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Anaerovoracaceae | ||||
| 29395184 | 29395184 | PRJEB15333_P_NODE_12549_length_193_cov_1.250000_g12465_i0 | PRJEB15333 | 12549 | 193 | 1.25 | 2.4125 | Micromonosporaceae | 28056 | Bacteria | Bacteria | 43.5 | 0.0104 | NR | MDT5032800.1 | 1871 | g12465 | i0 | 46.2 | 5.4559585492228 | 39 | 20 | 60.6 | 1 | 11 | 127 | 136 | 173 | MDT5032800.1 transporter, Spinster family, sphingosine-phosphate transporter [Actinoplanes sp.] | diamond | 1053 | 43.9 | 0.990888382687927 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Actinoplanes | Actinoplanes sp. | ||
| 29811886 | 29811886 | PRJEB15333_P_NODE_8971_length_225_cov_1.215909_g8887_i0 | PRJEB15333 | 8971 | 225 | 1.215909 | 2.73579525 | Actinoplanes lobatus | 113568 | Bacteria | Bacteria | 46.6 | 0.00124 | NR | WP_188119254.1 | 113568 | g8887 | i0 | 50 | 0.72 | 54 | 23 | 66.7 | 2 | 41 | 190 | 221 | 274 | WP_188119254.1 hypothetical protein [Actinoplanes lobatus] | diamond | 162 | 46.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Actinoplanes | Actinoplanes lobatus | ||
| 29969917 | 29969917 | PRJEB15333_P_NODE_19471_length_164_cov_0.904348_g19387_i0 | PRJEB15333 | 19471 | 164 | 0.904348 | 1.48313072 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 40.8 | 0.0144 | NR | MEP6903339.1 | 2900548 | g19387 | i0 | 42.6 | 0.859756097560976 | 47 | 24 | 82.3 | 2 | 30 | 164 | 13 | 58 | MEP6903339.1 transcriptional regulator [Actinomycetota bacterium] | diamond | 141 | 40.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30412613 | 30412613 | PRJEB15333_P_NODE_9073_length_224_cov_0.782857_g8989_i0 | PRJEB15333 | 9073 | 224 | 0.782857 | 1.75359968 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 43.5 | 0.0152 | NR | WP_415143840.1 | 35761 | g8989 | i0 | 36.5 | 0.696428571428571 | 52 | 33 | 69.6 | 0 | 64 | 219 | 271 | 322 | WP_415143840.1 MFS transporter [Nocardioides sp.] | diamond | 156 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 30507122 | 30507122 | PRJEB15333_P_NODE_2853_length_368_cov_11.241379_g2769_i0 | PRJEB15333 | 2853 | 368 | 11.241379 | 41.36827472 | Frankiaceae bacterium | 2654182 | Bacteria | Bacteria | 44.3 | 0.0117 | NR | HWL37608.1 | 2654182 | g2769 | i0 | 31.7 | 0.668478260869565 | 82 | 45 | 57.9 | 2 | 43 | 255 | 5 | 86 | HWL37608.1 hypothetical protein [Frankiaceae bacterium] | diamond | 246 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Frankiales | Frankiaceae | Frankiaceae bacterium | |||
| 30570022 | 30570022 | PRJEB15333_P_NODE_11373_length_202_cov_0.973856_g11289_i0 | PRJEB15333 | 11373 | 202 | 0.973856 | 1.96718912 | Phycicoccus jejuensis | 367299 | Bacteria | Bacteria | 42.4 | 0.0287 | NR | WP_404347920.1 | 367299 | g11289 | i0 | 39.1 | 0.683168316831683 | 46 | 28 | 68.3 | 0 | 6 | 143 | 204 | 249 | WP_404347920.1 acyltransferase family protein [Phycicoccus jejuensis] | diamond | 138 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Phycicoccus | Phycicoccus jejuensis | ||
| 31075925 | 31075925 | PRJEB15333_P_NODE_1915_length_435_cov_39.740933_g1834_i0 | PRJEB15333 | 1915 | 435 | 39.740933 | 172.87305855 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 45.1 | 0.0426 | NR | HEY6524554.1 | 2586742 | g1834 | i0 | 27.8 | 1.04137931034483 | 151 | 94 | 100 | 6 | 1 | 435 | 115 | 256 | HEY6524554.1 IPT/TIG domain-containing protein [Solirubrobacteraceae bacterium] | diamond | 453 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 31163869 | 31163869 | PRJEB15333_P_NODE_18615_length_166_cov_0.888889_g18531_i0 | PRJEB15333 | 18615 | 166 | 0.888889 | 1.47555574 | Bacillaceae | 186817 | Bacteria | Bacteria | 104 | 3.26e-25 | NR | WP_134339215.1 | 94137 | g18531 | i0 | 90.9 | 27.8313253012048 | 55 | 5 | 99.4 | 0 | 165 | 1 | 221 | 275 | WP_134339215.1 recombinase RecA [Filobacillus milosensis] | diamond | 4620 | 105 | 0.990476190476191 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Filobacillus | Filobacillus milosensis | ||
| 31201752 | 31201752 | PRJEB15333_P_NODE_4455_length_306_cov_1.120623_g4371_i0 | PRJEB15333 | 4455 | 306 | 1.120623 | 3.42910638 | Streptomyces olivoreticuli | 68246 | Bacteria | Bacteria | 47 | 0.00263 | NR | WP_301890529.1 | 68246 | g4371 | i0 | 36 | 0.872549019607843 | 89 | 43 | 86.3 | 3 | 282 | 19 | 863 | 938 | WP_301890529.1 DUF6603 domain-containing protein [Streptomyces olivoreticuli] | diamond | 267 | 47 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces olivoreticuli | ||
| 31487067 | 31487067 | PRJEB15333_P_NODE_14036_length_184_cov_0.911111_g13952_i0 | PRJEB15333 | 14036 | 184 | 0.911111 | 1.67644424 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 45.8 | 4.64e-4 | NR | MCC6404102.1 | 2682144 | g13952 | i0 | 42.4 | 0.96195652173913 | 59 | 28 | 96.2 | 1 | 1 | 177 | 30 | 82 | MCC6404102.1 DUF423 domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 177 | 45.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32303257 | 32303257 | PRJEB15333_P_NODE_19439_length_164_cov_0.904348_g19355_i0 | PRJEB15333 | 19439 | 164 | 0.904348 | 1.48313072 | Actinomycetes | 1760 | Bacteria | Bacteria | 42 | 0.0245 | NR | WP_037698221.1 | 1930 | g19355 | i0 | 48.6 | 1.26219512195122 | 37 | 18 | 65.9 | 1 | 2 | 109 | 768 | 804 | WP_037698221.1 non-ribosomal peptide synthetase [Streptomyces scabiei] | diamond | 207 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces scabiei | ||
| 32309690 | 32309690 | PRJEB15333_P_NODE_7899_length_238_cov_0.888889_g7815_i0 | PRJEB15333 | 7899 | 238 | 0.888889 | 2.11555582 | Nocardia sp. NPDC | 1821 | Bacteria | Bacteria | 43.5 | 0.0195 | NR | WP_356996942.1 | 3155256 | g7815 | i0 | 31.1 | 0.932773109243697 | 74 | 47 | 90.8 | 2 | 225 | 10 | 531 | 602 | WP_356996942.1 phage tail tape measure protein [Nocardia sp. NPDC046763] | diamond | 222 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Nocardia | Nocardia sp. NPDC046763 | ||
| 32594133 | 32594133 | PRJEB15333_P_NODE_3140_length_354_cov_16.127869_g3056_i0 | PRJEB15333 | 3140 | 354 | 16.127869 | 57.09265626 | Nocardioides baculatus | 2801337 | Bacteria | Bacteria | 46.6 | 0.00474 | NR | WP_201935394.1 | 2801337 | g3056 | i0 | 35.9 | 0.991525423728814 | 117 | 57 | 88.1 | 4 | 344 | 33 | 24 | 135 | WP_201935394.1 UbiA family prenyltransferase [Nocardioides baculatus] | diamond | 351 | 46.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides baculatus | ||
| 32877346 | 32877346 | PRJEB15333_P_NODE_7980_length_237_cov_0.872340_g7896_i0 | PRJEB15333 | 7980 | 237 | 0.87234 | 2.0674457999999998 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 43.9 | 0.0129 | NR | HYP18623.1 | 2448782 | g7896 | i0 | 34.7 | 1.24050632911392 | 49 | 32 | 62 | 0 | 59 | 205 | 60 | 108 | HYP18623.1 hypothetical protein [Chloroflexia bacterium] | diamond | 294 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia 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);;