contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA698538" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17259451 | 17259451 | PRJNA698538_S_NODE_6654_length_385_cov_1.317308_g6488_i0 | PRJNA698538 | 6654 | 385 | 1.317308 | 5.0716358 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 88.6 | 5.77e-18 | NR | WP_189513867.1 | 67333 | g6488 | i0 | 58.2 | 1.23116883116883 | 79 | 31 | 60 | 1 | 322 | 92 | 203 | 281 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 474 | 88.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 24907557 | 24907557 | PRJNA698538_S_NODE_12860_length_327_cov_1.732283_g12694_i0 | PRJNA698538 | 12860 | 327 | 1.732283 | 5.66456541 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 80.1 | 1.22e-16 | NR | WP_229833205.1 | 67333 | g12694 | i0 | 77.1 | 0.440366972477064 | 48 | 11 | 44 | 0 | 29 | 172 | 71 | 118 | WP_229833205.1 hypothetical protein, partial [Streptomyces narbonensis] | diamond | 144 | 80.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 26987657 | 26987657 | PRJNA698538_S_NODE_30362_length_239_cov_2.319277_g30196_i0 | PRJNA698538 | 30362 | 239 | 2.319277 | 5.54307203 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 99.4 | 8.289999999999999e-23 | NR | WP_189513867.1 | 67333 | g30196 | i0 | 63.3 | 1.98326359832636 | 79 | 29 | 99.2 | 0 | 3 | 239 | 198 | 276 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 474 | 99.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 27019462 | 27019462 | PRJNA698538_S_NODE_30042_length_241_cov_1.238095_g29876_i0 | PRJNA698538 | 30042 | 241 | 1.238095 | 2.98380895 | Modestobacter sp. | 1873466 | Bacteria | Bacteria | 44.7 | 0.00779 | NR | MCW2677176.1 | 1873466 | g29876 | i0 | 42.6 | 0.759336099585062 | 61 | 26 | 64.7 | 3 | 73 | 228 | 826 | 886 | MCW2677176.1 hypothetical protein [Modestobacter sp.] | diamond | 183 | 44.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Geodermatophilales | Geodermatophilaceae | Modestobacter | Modestobacter sp. | ||
| 27145494 | 27145494 | PRJNA698538_S_NODE_23242_length_267_cov_1.484536_g23076_i0 | PRJNA698538 | 23242 | 267 | 1.484536 | 3.96371112 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 58.2 | 1.64e-7 | NR | WP_189513867.1 | 67333 | g23076 | i0 | 50.9 | 1.23595505617978 | 55 | 27 | 61.8 | 0 | 59 | 223 | 210 | 264 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 330 | 58.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 27177335 | 27177335 | PRJNA698538_S_NODE_24482_length_261_cov_1.228723_g24316_i0 | PRJNA698538 | 24482 | 261 | 1.228723 | 3.20696703 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 69.7 | 6.39e-13 | NR | WP_229833205.1 | 67333 | g24316 | i0 | 71.4 | 3.89655172413793 | 49 | 14 | 56.3 | 0 | 30 | 176 | 80 | 128 | WP_229833205.1 hypothetical protein, partial [Streptomyces narbonensis] | diamond | 1017 | 69.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 27556428 | 27556428 | PRJNA698538_S_NODE_1104_length_631_cov_11.417563_g945_i0 | PRJNA698538 | 1104 | 631 | 11.417563 | 72.04482253 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 47.8 | 0.0145 | NR | WP_189513867.1 | 67333 | g945 | i0 | 38.1 | 0.461172741679873 | 97 | 48 | 40.4 | 2 | 423 | 169 | 1 | 97 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 291 | 47.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 28093400 | 28093400 | PRJNA698538_S_NODE_23865_length_264_cov_1.089005_g23699_i0 | PRJNA698538 | 23865 | 264 | 1.089005 | 2.8749732 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 62 | 6.67e-9 | NR | WP_189513867.1 | 67333 | g23699 | i0 | 42.2 | 2.04545454545455 | 90 | 48 | 98.9 | 2 | 3 | 263 | 244 | 332 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 540 | 62 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 28219460 | 28219460 | PRJNA698538_S_NODE_15246_length_311_cov_2.214286_g15080_i0 | PRJNA698538 | 15246 | 311 | 2.214286 | 6.88642946 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 166 | 7.3e-50 | NR | WP_304135687.1 | 1528099 | g15080 | i0 | 100 | 1.7556270096463 | 91 | 0 | 87.8 | 0 | 274 | 2 | 1 | 91 | WP_304135687.1 hypothetical protein [Lawsonella clevelandensis] | diamond | 546 | 166 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 28630385 | 28630385 | PRJNA698538_S_NODE_16967_length_301_cov_0.899123_g16801_i0 | PRJNA698538 | 16967 | 301 | 0.899123 | 2.70636023 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 75.1 | 8.32e-15 | NR | WP_229833205.1 | 67333 | g16801 | i0 | 69.8 | 1.19601328903654 | 53 | 16 | 52.8 | 0 | 92 | 250 | 77 | 129 | WP_229833205.1 hypothetical protein, partial [Streptomyces narbonensis] | diamond | 360 | 75.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 28756424 | 28756424 | PRJNA698538_S_NODE_5847_length_397_cov_2.138889_g5681_i0 | PRJNA698538 | 5847 | 397 | 2.138889 | 8.49138933 | Corynebacterium mastitidis | 161890 | Bacteria | Bacteria | 63.5 | 7.31e-9 | NR | WP_156801801.1 | 161890 | g5681 | i0 | 31.7 | 0.763224181360202 | 101 | 69 | 76.3 | 0 | 395 | 93 | 204 | 304 | WP_156801801.1 hypothetical protein [Corynebacterium mastitidis] | diamond | 303 | 63.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium mastitidis | ||
| 29040879 | 29040879 | PRJNA698538_S_NODE_17288_length_299_cov_1.305310_g17122_i0 | PRJNA698538 | 17288 | 299 | 1.30531 | 3.9028769 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 45.4 | 0.00246 | NR | WP_229833205.1 | 67333 | g17122 | i0 | 56.4 | 0.391304347826087 | 39 | 17 | 39.1 | 0 | 206 | 90 | 65 | 103 | WP_229833205.1 hypothetical protein, partial [Streptomyces narbonensis] | diamond | 117 | 45.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 29198658 | 29198658 | PRJNA698538_S_NODE_8129_length_368_cov_1.044068_g7963_i0 | PRJNA698538 | 8129 | 368 | 1.044068 | 3.84217024 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 48.9 | 9.12e-4 | NR | WP_189513867.1 | 67333 | g7963 | i0 | 45.2 | 0.505434782608696 | 62 | 29 | 46.5 | 1 | 209 | 39 | 1 | 62 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 186 | 48.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 30220247 | 30220247 | PRJNA698538_S_NODE_18792_length_290_cov_1.419355_g18626_i0 | PRJNA698538 | 18792 | 290 | 1.419355 | 4.1161295 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.021 | NR | MES6069535.1 | 1747 | g18626 | i0 | 32.9 | 6.35172413793103 | 76 | 45 | 72.4 | 2 | 263 | 54 | 108 | 183 | MES6069535.1 RBD-like domain-containing protein [Cutibacterium acnes] | diamond | 1842 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 30493527 | 30493527 | PRJNA698538_S_NODE_27913_length_247_cov_1.770115_g27747_i0 | PRJNA698538 | 27913 | 247 | 1.770115 | 4.37218405 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 62.8 | 2.8e-10 | NR | WP_229833205.1 | 67333 | g27747 | i0 | 62 | 0.607287449392713 | 50 | 19 | 60.7 | 0 | 238 | 89 | 60 | 109 | WP_229833205.1 hypothetical protein, partial [Streptomyces narbonensis] | diamond | 150 | 62.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 30682855 | 30682855 | PRJNA698538_S_NODE_10613_length_344_cov_2.988930_g10447_i0 | PRJNA698538 | 10613 | 344 | 2.98893 | 10.2819192 | Ilumatobacteraceae bacterium | 2497619 | Bacteria | Bacteria | 57.4 | 8.75e-7 | NR | HEY4611321.1 | 2497619 | g10447 | i0 | 39.4 | 0.906976744186046 | 104 | 58 | 89 | 3 | 13 | 318 | 669 | 769 | HEY4611321.1 HAD-IC family P-type ATPase [Ilumatobacteraceae bacterium] | diamond | 312 | 57.4 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Ilumatobacteraceae | Ilumatobacteraceae bacterium | |||
| 30746225 | 30746225 | PRJNA698538_S_NODE_8434_length_364_cov_6.134021_g8268_i0 | PRJNA698538 | 8434 | 364 | 6.134021 | 22.32783644 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 67.4 | 2.53e-10 | NR | WP_189513867.1 | 67333 | g8268 | i0 | 39.6 | 0.791208791208791 | 96 | 57 | 78.3 | 1 | 363 | 79 | 1 | 96 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 288 | 67.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 30872567 | 30872567 | PRJNA698538_S_NODE_29614_length_242_cov_1.786982_g29448_i0 | PRJNA698538 | 29614 | 242 | 1.786982 | 4.32449644 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 88.6 | 9.65e-19 | NR | WP_189513867.1 | 67333 | g29448 | i0 | 70 | 1.48760330578512 | 60 | 18 | 74.4 | 0 | 182 | 3 | 251 | 310 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 360 | 88.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 31188212 | 31188212 | PRJNA698538_S_NODE_16435_length_304_cov_1.251082_g16269_i0 | PRJNA698538 | 16435 | 304 | 1.251082 | 3.80328928 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 61.6 | 1.46e-8 | NR | WP_189513867.1 | 67333 | g16269 | i0 | 75.6 | 0.809210526315789 | 41 | 10 | 40.5 | 0 | 272 | 150 | 211 | 251 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 246 | 61.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 31757821 | 31757821 | PRJNA698538_S_NODE_18117_length_294_cov_1.393665_g17951_i0 | PRJNA698538 | 18117 | 294 | 1.393665 | 4.0973751 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 62.4 | 6.97e-9 | NR | WP_189513867.1 | 67333 | g17951 | i0 | 63.8 | 0.959183673469388 | 47 | 17 | 48 | 0 | 290 | 150 | 150 | 196 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 282 | 62.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 31789257 | 31789257 | PRJNA698538_S_NODE_20657_length_280_cov_1.487923_g20491_i0 | PRJNA698538 | 20657 | 280 | 1.487923 | 4.1661844 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 50.8 | 1.75e-5 | NR | WP_229833205.1 | 67333 | g20491 | i0 | 46.6 | 0.621428571428571 | 58 | 23 | 54.6 | 2 | 271 | 119 | 36 | 92 | WP_229833205.1 hypothetical protein, partial [Streptomyces narbonensis] | diamond | 174 | 50.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 31789261 | 31789261 | PRJNA698538_S_NODE_28757_length_245_cov_0.895349_g28591_i0 | PRJNA698538 | 28757 | 245 | 0.895349 | 2.19360505 | Streptomyces narbonensis | 67333 | Bacteria | Bacteria | 66.6 | 1.16e-10 | NR | WP_189513867.1 | 67333 | g28591 | i0 | 50.6 | 1.93469387755102 | 79 | 30 | 89.4 | 3 | 2 | 220 | 221 | 296 | WP_189513867.1 RBD-like domain-containing protein [Streptomyces narbonensis] | diamond | 474 | 66.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces narbonensis | ||
| 32244008 | 32244008 | PRJNA698538_S_NODE_25358_length_257_cov_1.255435_g25192_i0 | PRJNA698538 | 25358 | 257 | 1.255435 | 3.22646795 | root | 1 | Root_unresolved | Root_unresolved | 47 | 4.11e-4 | NR | MES9334362.1 | 1747 | g25192 | i0 | 64.7 | 2.85992217898833 | 34 | 11 | 38.5 | 1 | 207 | 109 | 57 | 90 | MES9334362.1 endonuclease/exonuclease/phosphatase family protein [Cutibacterium acnes] | diamond | 735 | 47 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 32390673 | 32390673 | PRJNA698538_S_NODE_12799_length_327_cov_3.566929_g12633_i0 | PRJNA698538 | 12799 | 327 | 3.566929 | 11.66385783 | Lancefieldella rimae | 1383 | Bacteria | Bacteria | 50.8 | 3.41e-5 | NR | WP_315572553.1 | 1383 | g12633 | i0 | 34.7 | 0.871559633027523 | 95 | 54 | 80.7 | 2 | 325 | 62 | 12 | 105 | WP_315572553.1 hypothetical protein [Lancefieldella rimae] | diamond | 285 | 50.8 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriales | Atopobiaceae | Lancefieldella | Lancefieldella rimae | ||
| 32611934 | 32611934 | PRJNA698538_S_NODE_23240_length_267_cov_1.515464_g23074_i0 | PRJNA698538 | 23240 | 267 | 1.515464 | 4.04628888 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 43.9 | 0.0176 | NR | MCB0914918.1 | 2900548 | g23074 | i0 | 40.4 | 0.528089887640449 | 47 | 28 | 52.8 | 0 | 113 | 253 | 230 | 276 | MCB0914918.1 thioesterase family protein [Actinomycetota bacterium] | diamond | 141 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota 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);;