contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA774958" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1208129 | 1208129 | PRJNA774958_P_NODE_21061_length_346_cov_1.062271_g20814_i0 | PRJNA774958 | 21061 | 346 | 1.062271 | 3.67545766 | Streptomyces | 1883 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|2654765215|gb|CP108591.1| | 2903763 | g20814 | i0 | 90.698 | 0.248554913294798 | 43 | 2 | 12 | 2 | 211 | 253 | 1671304 | 1671264 | Streptomyces sp. NBC_01180 chromosome, complete genome | blastn | 86 | 56.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NBC_01180 | ||
| 4580927 | 4580927 | PRJNA774958_P_NODE_39084_length_241_cov_0.916667_g38837_i0 | PRJNA774958 | 39084 | 241 | 0.916667 | 2.20916747 | Agromyces soli | 659012 | Bacteria | Bacteria | 446 | 8.519999999999999e-121 | NTclustered | gi|2216365065|gb|CP094533.1| | 659012 | g38837 | i0 | 100 | 95.9170124481328 | 241 | 0 | 100 | 0 | 1 | 241 | 1792888 | 1793128 | Agromyces soli strain KACC 16215 chromosome, complete genome | blastn | 23116 | 446 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Agromyces | Agromyces soli | ||
| 5856294 | 5856294 | PRJNA774958_P_NODE_34045_length_250_cov_0.870056_g33798_i0 | PRJNA774958 | 34045 | 250 | 0.870056 | 2.17514 | Bifidobacterium pseudocatenulatum | 28026 | Bacteria | Bacteria | 440 | 4.1399999999999976e-119 | NTclustered | gi|2119983138|gb|CP079231.1| | 28026 | g33798 | i0 | 98.4 | 19.336 | 250 | 4 | 100 | 0 | 1 | 250 | 2130704 | 2130953 | Bifidobacterium pseudocatenulatum strain YIT12820 chromosome, complete genome | blastn | 4834 | 440 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Bifidobacteriales | Bifidobacteriaceae | Bifidobacterium | Bifidobacterium pseudocatenulatum | ||
| 6312261 | 6312261 | PRJNA774958_P_NODE_31245_length_264_cov_1.382199_g30998_i0 | PRJNA774958 | 31245 | 264 | 1.382199 | 3.64900536 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.007 | NTclustered | gi|2655888157|gb|CP109280.1| | 1952 | g30998 | i0 | 100 | 1.625 | 29 | 0 | 11 | 0 | 25 | 53 | 3895067 | 3895039 | Streptomyces thermoviolaceus strain NBC 01629 chromosome, complete genome | blastn | 429 | 54.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces thermoviolaceus | ||
| 6312299 | 6312299 | PRJNA774958_P_NODE_36465_length_245_cov_1.593023_g36218_i0 | PRJNA774958 | 36465 | 245 | 1.593023 | 3.90290635 | Cutibacterium | 1912216 | Bacteria | Bacteria | 453 | 5.1900000000000006e-123 | NTclustered | gi|966542502|gb|CP012354.1| | 1747 | g36218 | i0 | 100 | 52.9755102040816 | 245 | 0 | 100 | 0 | 1 | 245 | 898862 | 899106 | Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome | blastn | 12979 | 453 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 7586223 | 7586223 | PRJNA774958_P_NODE_23466_length_323_cov_1.120000_g23219_i0 | PRJNA774958 | 23466 | 323 | 1.12 | 3.6176 | Actinomycetes | 1760 | Bacteria | Bacteria | 52.8 | 0.03 | NTclustered | gi|2689328232|dbj|AP029603.1| | 212365 | g23219 | i0 | 100 | 0.173374613003096 | 28 | 0 | 9 | 0 | 256 | 283 | 217687 | 217660 | Bifidobacterium porcinum JCM7042 DNA, complete genome | blastn | 56 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Bifidobacteriales | Bifidobacteriaceae | Bifidobacterium | Bifidobacterium porcinum | ||
| 10956690 | 10956690 | PRJNA774958_P_NODE_21149_length_345_cov_1.132353_g20902_i0 | PRJNA774958 | 21149 | 345 | 1.132353 | 3.90661785 | Rhodococcus sp. YL-1 | 1045808 | Bacteria | Bacteria | 316 | 1.05e-81 | NTclustered | gi|1130060859|gb|CP017299.1| | 1045808 | g20902 | i0 | 91.213 | 1.17101449275362 | 239 | 11 | 66 | 6 | 1 | 229 | 3829099 | 3829337 | Rhodococcus sp. YL-1, complete genome | blastn | 404 | 316 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus sp. YL-1 | ||
| 12232217 | 12232217 | PRJNA774958_P_NODE_16050_length_405_cov_1.301205_g15803_i0 | PRJNA774958 | 16050 | 405 | 1.301205 | 5.26988025 | Micrococcus lylae | 1273 | Bacteria | Bacteria | 732 | 0 | NTclustered | gi|2514694063|gb|CP126965.1| | 1273 | g15803 | i0 | 99.261 | 274.82962962963 | 406 | 2 | 100 | 1 | 1 | 405 | 1116621 | 1117026 | Micrococcus lylae strain UMB0955 chromosome, complete genome | blastn | 111306 | 732 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus lylae | ||
| 12687872 | 12687872 | PRJNA774958_P_NODE_38290_length_242_cov_0.911243_g38043_i0 | PRJNA774958 | 38290 | 242 | 0.911243 | 2.20520806 | Rhodococcus | 1827 | Bacteria | Bacteria | 448 | 2.3799999999999995e-121 | NTclustered | gi|2190692273|gb|CP091858.1| | 1833 | g38043 | i0 | 100 | 26.8471074380165 | 242 | 0 | 100 | 0 | 1 | 242 | 17719 | 17478 | Rhodococcus erythropolis strain CERE8 plasmid unnamed4, complete sequence | blastn | 6497 | 448 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus erythropolis | ||
| 13506509 | 13506509 | PRJNA774958_P_NODE_38451_length_242_cov_0.911243_g38204_i0 | PRJNA774958 | 38451 | 242 | 0.911243 | 2.20520806 | Streptomyces netropsis | 55404 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2700875784|gb|CP147867.1| | 55404 | g38204 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 209 | 236 | 348474 | 348447 | Streptomyces netropsis strain M-141 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces netropsis | ||
| 13962194 | 13962194 | PRJNA774958_P_NODE_36351_length_246_cov_0.890173_g36104_i0 | PRJNA774958 | 36351 | 246 | 0.890173 | 2.18982558 | Rhodococcoides | 3259750 | Bacteria | Bacteria | 455 | 1.4500000000000002e-123 | NTclustered | gi|2637134465|gb|CP140264.1| | 1828 | g36104 | i0 | 100 | 339.475609756098 | 246 | 0 | 100 | 0 | 1 | 246 | 1621521 | 1621276 | Rhodococcoides fascians strain GS01 chromosome, complete genome | blastn | 83511 | 455 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcoides | Rhodococcoides fascians | ||
| 14781436 | 14781436 | PRJNA774958_P_NODE_36032_length_246_cov_0.890173_g35785_i0 | PRJNA774958 | 36032 | 246 | 0.890173 | 2.18982558 | Streptomyces sp. cg36 | 3238798 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2784064359|gb|CP163520.1| | 3238798 | g35785 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 105 | 132 | 995425 | 995398 | Streptomyces sp. cg36 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. cg36 | ||
| 17330987 | 17330987 | PRJNA774958_P_NODE_33514_length_251_cov_0.865169_g33267_i0 | PRJNA774958 | 33514 | 251 | 0.865169 | 2.17157419 | Rhodococcoides fascians | 1828 | Bacteria | Bacteria | 464 | 2.47e-126 | NTclustered | gi|2637134465|gb|CP140264.1| | 1828 | g33267 | i0 | 100 | 1 | 251 | 0 | 100 | 0 | 1 | 251 | 5154428 | 5154678 | Rhodococcoides fascians strain GS01 chromosome, complete genome | blastn | 251 | 464 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcoides | Rhodococcoides fascians | ||
| 17785903 | 17785903 | PRJNA774958_P_NODE_37834_length_243_cov_0.905882_g37587_i0 | PRJNA774958 | 37834 | 243 | 0.905882 | 2.20129326 | Corynebacterium | 1716 | Bacteria | Bacteria | 449 | 6.65e-122 | NTclustered | gi|2869797333|gb|CP175765.1| | 38304 | g37587 | i0 | 100 | 366.008230452675 | 243 | 0 | 100 | 0 | 1 | 243 | 2385 | 2627 | Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome | blastn | 88940 | 449 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium tuberculostearicum | ||
| 18604523 | 18604523 | PRJNA774958_P_NODE_37015_length_244_cov_1.403509_g36768_i0 | PRJNA774958 | 37015 | 244 | 1.403509 | 3.42456196 | Agromyces soli | 659012 | Bacteria | Bacteria | 351 | 1.9399999999999998e-92 | NTclustered | gi|2216365065|gb|CP094533.1| | 659012 | g36768 | i0 | 92.623 | 2.13114754098361 | 244 | 18 | 100 | 0 | 1 | 244 | 737256 | 737499 | Agromyces soli strain KACC 16215 chromosome, complete genome | blastn | 520 | 351 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Agromyces | Agromyces soli | ||
| 19059905 | 19059905 | PRJNA774958_P_NODE_24535_length_314_cov_1.120332_g24288_i0 | PRJNA774958 | 24535 | 314 | 1.120332 | 3.51784248 | Nocardiaceae | 85025 | Bacteria | Bacteria | 568 | 2.3599999999999998e-157 | NTclustered | gi|2637134465|gb|CP140264.1| | 1828 | g24288 | i0 | 99.361 | 406.770700636943 | 313 | 2 | 99 | 0 | 1 | 313 | 1622027 | 1622339 | Rhodococcoides fascians strain GS01 chromosome, complete genome | blastn | 127726 | 568 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcoides | Rhodococcoides fascians | ||
| 19059910 | 19059910 | PRJNA774958_P_NODE_24755_length_312_cov_1.414226_g24508_i0 | PRJNA774958 | 24755 | 312 | 1.414226 | 4.41238512 | Nocardiaceae | 85025 | Bacteria | Bacteria | 571 | 1.81e-158 | NTclustered | gi|2637134465|gb|CP140264.1| | 1828 | g24508 | i0 | 99.679 | 383.11858974359 | 312 | 1 | 100 | 0 | 1 | 312 | 1623506 | 1623817 | Rhodococcoides fascians strain GS01 chromosome, complete genome | blastn | 119533 | 571 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcoides | Rhodococcoides fascians | ||
| 20334632 | 20334632 | PRJNA774958_P_NODE_30216_length_271_cov_1.469697_g29969_i0 | PRJNA774958 | 30216 | 271 | 1.469697 | 3.98287887 | Rhodococcus | 1827 | Bacteria | Bacteria | 501 | 2.05e-137 | NTclustered | gi|2660106423|gb|CP138905.1| | 1831 | g29969 | i0 | 100 | 49 | 271 | 0 | 100 | 0 | 1 | 271 | 68832 | 69102 | MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome | blastn | 13279 | 501 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus sp. (in: high G+C Gram-positive bacteria) | ||
| 21155194 | 21155194 | PRJNA774958_P_NODE_22617_length_331_cov_1.139535_g22370_i0 | PRJNA774958 | 22617 | 331 | 1.139535 | 3.77186085 | Schaalia radingae | 131110 | Bacteria | Bacteria | 58.4 | 6.7e-4 | NTclustered | gi|1086031159|emb|LT629792.1| | 131110 | g22370 | i0 | 89.13 | 0.308157099697885 | 46 | 5 | 14 | 0 | 257 | 302 | 973393 | 973348 | Actinomyces radingae strain DSM 9169 genome assembly, chromosome: I | blastn | 102 | 58.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Schaalia | Schaalia radingae | ||
| 22429770 | 22429770 | PRJNA774958_P_NODE_10938_length_493_cov_1.459524_g10692_i0 | PRJNA774958 | 10938 | 493 | 1.459524 | 7.19545332 | Mycobacteroides immunogenum | 83262 | Bacteria | Bacteria | 54.7 | 0.013 | NTclustered | gi|1041024973|gb|CP016189.1| | 83262 | g10692 | i0 | 100 | 0.117647058823529 | 29 | 0 | 6 | 0 | 192 | 220 | 373880 | 373908 | Mycobacteroides immunogenum strain FLAC016 chromosome, complete genome | blastn | 58 | 54.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacteroides | Mycobacteroides immunogenum | ||
| 23705599 | 23705599 | PRJNA774958_P_NODE_27919_length_287_cov_1.378505_g27672_i0 | PRJNA774958 | 27919 | 287 | 1.378505 | 3.95630935 | Streptomyces sp. SM1P | 3123042 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|2705505245|gb|CP149585.1| | 3123042 | g27672 | i0 | 100 | 0.0975609756097561 | 28 | 0 | 10 | 0 | 114 | 141 | 2270597 | 2270624 | Streptomyces sp. SM1P chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. SM1P |
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);;