contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1655477 | 1655477 | PRJNA315314_S_NODE_14262_length_216_cov_4.732620_g13941_i0 | PRJNA315314 | 14262 | 216 | 4.73262 | 10.2224592 | Agreia sp. PsM1 | 1872416 | Bacteria | Bacteria | 141 | 3.08e-42 | NR | WP_367316755.1 | 3030533 | g13941 | i0 | 97.1 | 0.958333333333333 | 69 | 2 | 95.8 | 0 | 8 | 214 | 1 | 69 | WP_367316755.1 transposase domain-containing protein, partial [Agreia sp. PsM10] | diamond | 207 | 141 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Agreia | Agreia sp. PsM10 | ||
| 8033983 | 8033983 | PRJNA315314_S_NODE_15727_length_206_cov_33.084746_g15406_i0 | PRJNA315314 | 15727 | 206 | 33.084746 | 68.15457676 | Eggerthellaceae bacterium | 1972561 | Bacteria | Bacteria | 79.3 | 2.91e-15 | NR | MBQ9000606.1 | 1972561 | g15406 | i0 | 75 | 16.7766990291262 | 52 | 13 | 75.7 | 0 | 40 | 195 | 532 | 583 | MBQ9000606.1 ATP-dependent zinc metalloprotease FtsH [Eggerthellaceae bacterium] | diamond | 3456 | 79.3 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Eggerthellales | Eggerthellaceae | Eggerthellaceae bacterium | |||
| 11859304 | 11859304 | PRJNA315314_S_NODE_1110_length_724_cov_11.595683_g542_i2 | PRJNA315314 | 1110 | 724 | 11.595683 | 83.95274492 | Actinopolymorphaceae bacterium | 2952879 | Bacteria | Bacteria | 183 | 1.3499999999999998e-54 | NR | HEY6739884.1 | 2952879 | g542 | i2 | 72 | 2.52762430939227 | 125 | 35 | 51.8 | 0 | 427 | 53 | 43 | 167 | HEY6739884.1 hypothetical protein [Actinopolymorphaceae bacterium] | diamond | 1830 | 183 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Actinopolymorphaceae | Actinopolymorphaceae bacterium | |||
| 13134453 | 13134453 | PRJNA315314_S_NODE_1671_length_601_cov_10.638112_g542_i3 | PRJNA315314 | 1671 | 601 | 10.638112 | 63.93505312 | Actinopolymorphaceae bacterium | 2952879 | Bacteria | Bacteria | 183 | 2.2499999999999995e-55 | NR | HEY6739884.1 | 2952879 | g542 | i3 | 72 | 2.43594009983361 | 125 | 35 | 62.4 | 0 | 427 | 53 | 43 | 167 | HEY6739884.1 hypothetical protein [Actinopolymorphaceae bacterium] | diamond | 1464 | 183 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Actinopolymorphaceae | Actinopolymorphaceae bacterium | |||
| 16367911 | 16367911 | PRJNA315314_S_NODE_31553_length_152_cov_1.634146_g31232_i0 | PRJNA315314 | 31553 | 152 | 1.634146 | 2.48390192 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 75.9 | 6.25e-15 | NR | MBM3679877.1 | 2900548 | g31232 | i0 | 68 | 6.84868421052632 | 50 | 16 | 98.7 | 0 | 151 | 2 | 158 | 207 | MBM3679877.1 triose-phosphate isomerase [Actinomycetota bacterium] | diamond | 1041 | 75.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 22057109 | 22057109 | PRJNA315314_S_NODE_10598_length_249_cov_3.122727_g10277_i0 | PRJNA315314 | 10598 | 249 | 3.122727 | 7.77559023 | FCB group | 1783270 | Bacteria | Bacteria | 175 | 3.5e-54 | NR | WP_344397633.1 | 114695 | g10277 | i0 | 100 | 3 | 83 | 0 | 100 | 0 | 249 | 1 | 65 | 147 | WP_344397633.1 hypothetical protein, partial [Streptomyces asiaticus] | diamond | 747 | 175 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces asiaticus | ||
| 22057349 | 22057349 | PRJNA315314_S_NODE_24238_length_170_cov_1.617021_g23917_i0 | PRJNA315314 | 24238 | 170 | 1.617021 | 2.7489357 | Bacillati | 1783272 | Bacteria | Bacteria | 83.6 | 4.12e-19 | NR | WP_342455258.1 | 29539 | g23917 | i0 | 63 | 8.7 | 54 | 20 | 95.3 | 0 | 163 | 2 | 18 | 71 | WP_342455258.1 thioredoxin [Thermoleophilum album] | diamond | 1479 | 83.6 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Thermoleophilales | Thermoleophilaceae | Thermoleophilum | Thermoleophilum album | ||
| 27010984 | 27010984 | PRJNA315314_S_NODE_27782_length_160_cov_1.938931_g27461_i0 | PRJNA315314 | 27782 | 160 | 1.938931 | 3.1022896 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 90.5 | 7.27e-20 | NR | MDQ2761917.1 | 2900548 | g27461 | i0 | 73.1 | 0.975 | 52 | 14 | 97.5 | 0 | 158 | 3 | 30 | 81 | MDQ2761917.1 phage/plasmid replication protein, II/X family [Actinomycetota bacterium] | diamond | 156 | 90.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 27105799 | 27105799 | PRJNA315314_S_NODE_9162_length_267_cov_10.336134_g8841_i0 | PRJNA315314 | 9162 | 267 | 10.336134 | 27.59747778 | Mycolicibacter sinensis | 875328 | Bacteria | Bacteria | 42.7 | 0.0497 | NR | WP_064856798.1 | 875328 | g8841 | i0 | 37 | 0.820224719101124 | 73 | 44 | 79.8 | 1 | 243 | 31 | 299 | 371 | WP_064856798.1 PPE domain-containing protein [Mycolicibacter sinensis] | diamond | 219 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacter | Mycolicibacter sinensis | ||
| 27422215 | 27422215 | PRJNA315314_S_NODE_29883_length_155_cov_2.484127_g29562_i0 | PRJNA315314 | 29883 | 155 | 2.484127 | 3.85039685 | Micromonospora siamensis | 299152 | Bacteria | Bacteria | 61.6 | 1.92e-9 | NR | SCG34687.1 | 299152 | g29562 | i0 | 60.8 | 2.74838709677419 | 51 | 20 | 98.7 | 0 | 3 | 155 | 218 | 268 | SCG34687.1 Subtilase family protein [Micromonospora siamensis] | diamond | 426 | 61.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora siamensis | ||
| 28053366 | 28053366 | PRJNA315314_S_NODE_18425_length_192_cov_2.723926_g18104_i0 | PRJNA315314 | 18425 | 192 | 2.723926 | 5.22993792 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 43.5 | 0.00886 | NR | MCX6403818.1 | 2900548 | g18104 | i0 | 41.1 | 0.875 | 56 | 33 | 87.5 | 0 | 19 | 186 | 81 | 136 | MCX6403818.1 hypothetical protein [Actinomycetota bacterium] | diamond | 168 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 28748084 | 28748084 | PRJNA315314_S_NODE_22007_length_177_cov_2.317568_g21686_i0 | PRJNA315314 | 22007 | 177 | 2.317568 | 4.10209536 | Arthrobacter alpinus | 656366 | Bacteria | Bacteria | 43.1 | 0.00308 | NR | WP_239437099.1 | 656366 | g21686 | i0 | 39.6 | 1.6271186440678 | 48 | 27 | 78 | 1 | 158 | 21 | 50 | 97 | WP_239437099.1 hypothetical protein [Arthrobacter alpinus] | diamond | 288 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter alpinus | ||
| 28779535 | 28779535 | PRJNA315314_S_NODE_2367_length_514_cov_3.090722_g2068_i0 | PRJNA315314 | 2367 | 514 | 3.090722 | 15.88631108 | Paractinoplanes lichenicola | 2802976 | Bacteria | Bacteria | 77 | 7.04e-14 | NR | WP_307834430.1 | 2802976 | g2068 | i0 | 36.6 | 1.64007782101167 | 142 | 85 | 81.7 | 3 | 421 | 2 | 36 | 174 | WP_307834430.1 LURP-one-related/scramblase family protein [Paractinoplanes lichenicola] | diamond | 843 | 77 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Paractinoplanes | Paractinoplanes lichenicola | ||
| 28860213 | 28860213 | PRJNA315314_S_NODE_20148_length_184_cov_3.000000_g19827_i0 | PRJNA315314 | 20148 | 184 | 3 | 5.52 | Bacillati | 1783272 | Bacteria | Bacteria | 58.9 | 9.87e-9 | NR | WP_028643519.1 | 1380392 | g19827 | i0 | 52.5 | 2.90217391304348 | 61 | 26 | 99.5 | 1 | 184 | 2 | 102 | 159 | WP_028643519.1 LURP-one-related/scramblase family protein [Nocardioides sp. URHA0020] | diamond | 534 | 58.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. URHA0020 | ||
| 29302354 | 29302354 | PRJNA315314_S_NODE_14629_length_214_cov_1.075676_g14308_i0 | PRJNA315314 | 14629 | 214 | 1.075676 | 2.30194664 | Curtobacterium | 2034 | Bacteria | Bacteria | 63.2 | 1.56e-9 | NR | WP_065958989.1 | 1885315 | g14308 | i0 | 52.5 | 4.06542056074766 | 59 | 28 | 82.7 | 0 | 1 | 177 | 337 | 395 | WP_065958989.1 toxic anion resistance protein [Curtobacterium sp. UCD-KPL2560] | diamond | 870 | 63.5 | 0.995275590551181 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Curtobacterium | Curtobacterium sp. UCD-KPL2560 | ||
| 29916537 | 29916537 | PRJNA315314_S_NODE_18491_length_192_cov_1.411043_g18170_i0 | PRJNA315314 | 18491 | 192 | 1.411043 | 2.70920256 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 47.4 | 3.92e-4 | NR | WP_389374795.1 | 3364656 | g18170 | i0 | 53.5 | 0.671875 | 43 | 20 | 67.2 | 0 | 148 | 20 | 194 | 236 | WP_389374795.1 transposase family protein [Streptomyces sp. NPDC002659] | diamond | 129 | 47.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC002659 | ||
| 30453750 | 30453750 | PRJNA315314_S_NODE_5813_length_334_cov_7.468852_g5492_i0 | PRJNA315314 | 5813 | 334 | 7.468852 | 24.94596568 | Thermoleophilaceae bacterium | 2732252 | Bacteria | Bacteria | 111 | 1.01e-25 | NR | HEX8647503.1 | 2732252 | g5492 | i0 | 50.9 | 2.75748502994012 | 106 | 38 | 82.6 | 2 | 16 | 291 | 607 | 712 | HEX8647503.1 N-acetylmuramoyl-L-alanine amidase [Thermoleophilaceae bacterium] | diamond | 921 | 111 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Thermoleophilales | Thermoleophilaceae | Thermoleophilaceae bacterium | |||
| 30674569 | 30674569 | PRJNA315314_S_NODE_3433_length_431_cov_3.825871_g3113_i0 | PRJNA315314 | 3433 | 431 | 3.825871 | 16.48950401 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 84 | 8.6e-16 | NR | MEP6904043.1 | 2900548 | g3113 | i0 | 41.7 | 1.86542923433875 | 139 | 68 | 92.6 | 4 | 430 | 32 | 56 | 187 | MEP6904043.1 pesticin C-terminus-like muramidase [Actinomycetota bacterium] | diamond | 804 | 84 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30832593 | 30832593 | PRJNA315314_S_NODE_17114_length_199_cov_1.688235_g16793_i0 | PRJNA315314 | 17114 | 199 | 1.688235 | 3.35958765 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 77 | 1.59e-15 | NR | WP_358619153.1 | 3154466 | g16793 | i0 | 55.6 | 1.89949748743719 | 63 | 28 | 95 | 0 | 3 | 191 | 131 | 193 | WP_358619153.1 TerD family protein [Streptomyces sp. NPDC005962] | diamond | 378 | 77 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC005962 | ||
| 30864135 | 30864135 | PRJNA315314_S_NODE_8254_length_281_cov_4.023810_g7933_i0 | PRJNA315314 | 8254 | 281 | 4.02381 | 11.3069061 | Gaiellaceae bacterium | 2838783 | Bacteria | Bacteria | 55.8 | 9.72e-7 | NR | HLE99792.1 | 2838783 | g7933 | i0 | 39.2 | 0.790035587188612 | 74 | 42 | 75.8 | 1 | 232 | 20 | 42 | 115 | HLE99792.1 hypothetical protein [Gaiellaceae bacterium] | diamond | 222 | 55.8 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Gaiellales | Gaiellaceae | Gaiellaceae bacterium | |||
| 30990743 | 30990743 | PRJNA315314_S_NODE_11614_length_238_cov_4.210526_g11293_i0 | PRJNA315314 | 11614 | 238 | 4.210526 | 10.02105188 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 123 | 9.45e-32 | NR | MDQ2761917.1 | 2900548 | g11293 | i0 | 77.3 | 0.945378151260504 | 75 | 17 | 94.5 | 0 | 3 | 227 | 260 | 334 | MDQ2761917.1 phage/plasmid replication protein, II/X family [Actinomycetota bacterium] | diamond | 225 | 123 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 31085440 | 31085440 | PRJNA315314_S_NODE_28495_length_158_cov_2.604651_g28174_i0 | PRJNA315314 | 28495 | 158 | 2.604651 | 4.11534858 | Microbispora oryzae | 2806554 | Bacteria | Bacteria | 62.4 | 1.35e-9 | NR | WP_210155365.1 | 2806554 | g28174 | i0 | 63.8 | 1.87974683544304 | 47 | 17 | 89.2 | 0 | 2 | 142 | 361 | 407 | WP_210155365.1 vWA domain-containing protein [Microbispora oryzae] | diamond | 297 | 62.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Microbispora | Microbispora oryzae | ||
| 31211323 | 31211323 | PRJNA315314_S_NODE_5215_length_351_cov_8.040373_g4894_i0 | PRJNA315314 | 5215 | 351 | 8.040373 | 28.22170923 | Corynebacterium rouxii | 2719119 | Bacteria | Bacteria | 46.2 | 0.00366 | NR | VZH86393.1 | 2719119 | g4894 | i0 | 55.2 | 0.495726495726496 | 58 | 25 | 49.6 | 1 | 254 | 81 | 110 | 166 | VZH86393.1 hypothetical protein FRC0190_02303 [Corynebacterium rouxii] | diamond | 174 | 46.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium rouxii | ||
| 31608872 | 31608872 | PRJNA315314_S_NODE_26716_length_163_cov_1.029851_g26395_i0 | PRJNA315314 | 26716 | 163 | 1.029851 | 1.67865713 | Streptomyces | 1883 | Bacteria | Bacteria | 53.9 | 9.98e-7 | NR | WP_355982537.1 | 67280 | g26395 | i0 | 67.6 | 6.34969325153374 | 37 | 12 | 68.1 | 0 | 118 | 8 | 1 | 37 | WP_355982537.1 formyltransferase family protein [Streptomyces bobili] | diamond | 1035 | 53.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces bobili | ||
| 31749349 | 31749349 | PRJNA315314_S_NODE_14757_length_213_cov_1.956522_g14436_i0 | PRJNA315314 | 14757 | 213 | 1.956522 | 4.16739186 | Mycolicibacterium sp. | 2320850 | Bacteria | Bacteria | 75.1 | 6.21e-15 | NR | WP_293358887.1 | 2320850 | g14436 | i0 | 49.3 | 0.971830985915493 | 69 | 34 | 95.8 | 1 | 7 | 210 | 65 | 133 | WP_293358887.1 NUDIX domain-containing protein [Mycolicibacterium sp.] | diamond | 207 | 75.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium sp. | ||
| 31780971 | 31780971 | PRJNA315314_S_NODE_7917_length_287_cov_3.255814_g7596_i0 | PRJNA315314 | 7917 | 287 | 3.255814 | 9.34418618 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 100 | 5.51e-23 | NR | MDQ2761917.1 | 2900548 | g7596 | i0 | 53.6 | 1.01393728222997 | 97 | 43 | 99.3 | 1 | 286 | 2 | 170 | 266 | MDQ2761917.1 phage/plasmid replication protein, II/X family [Actinomycetota bacterium] | diamond | 291 | 100 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 31970883 | 31970883 | PRJNA315314_S_NODE_20578_length_182_cov_6.163399_g20257_i0 | PRJNA315314 | 20578 | 182 | 6.163399 | 11.21738618 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 50.8 | 2.24e-5 | NR | MDQ2761917.1 | 2900548 | g20257 | i0 | 72.4 | 0.478021978021978 | 29 | 8 | 47.8 | 0 | 3 | 89 | 327 | 355 | MDQ2761917.1 phage/plasmid replication protein, II/X family [Actinomycetota bacterium] | diamond | 87 | 50.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 32603611 | 32603611 | PRJNA315314_S_NODE_6180_length_325_cov_3.949324_g5859_i0 | PRJNA315314 | 6180 | 325 | 3.949324 | 12.835303 | Microbacterium endophyticum | 1526412 | Bacteria | Bacteria | 59.3 | 1.6e-7 | NR | WP_165140388.1 | 1526412 | g5859 | i0 | 41.5 | 1.97538461538462 | 106 | 53 | 97.8 | 3 | 322 | 5 | 4728 | 4824 | WP_165140388.1 putative Ig domain-containing protein [Microbacterium endophyticum] | diamond | 642 | 59.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium endophyticum |
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);;