contig_metadata
21 rows where bioproject = "PRJNA798905" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2068062 | 2068062 | PRJNA798905_S_NODE_36542_length_249_cov_1.750000_g36093_i0 | PRJNA798905 | 36542 | 249 | 1.75 | 4.3575 | Kribbella sp. CA-293567 | 3002436 | Bacteria | Bacteria | 62.1 | 3.74e-5 | NTclustered | gi|2425436797|gb|CP114065.1| | 3002436 | g36093 | i0 | 100 | 22.8072289156627 | 33 | 0 | 13 | 0 | 163 | 195 | 3580468 | 3580500 | Kribbella sp. CA-293567 chromosome, complete genome | blastn | 5679 | 62.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Kribbellaceae | Kribbella | Kribbella sp. CA-293567 | ||
| 4620892 | 4620892 | PRJNA798905_S_NODE_7584_length_488_cov_5.125301_g7135_i0 | PRJNA798905 | 7584 | 488 | 5.125301 | 25.01146888 | Tsukamurella tyrosinosolvens | 57704 | Bacteria | Bacteria | 701 | 0 | NTclustered | gi|2459075662|gb|CP119372.1| | 57704 | g7135 | i0 | 92.638 | 8.99180327868852 | 489 | 32 | 99 | 4 | 1 | 487 | 1448357 | 1447871 | Tsukamurella tyrosinosolvens strain NAN1 chromosome | blastn | 4388 | 701 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Tsukamurellaceae | Tsukamurella | Tsukamurella tyrosinosolvens | ||
| 11422192 | 11422192 | PRJNA798905_S_NODE_40629_length_237_cov_5.853659_g40180_i0 | PRJNA798905 | 40629 | 237 | 5.853659 | 13.87317183 | Bacteria | 2 | Bacteria | Bacteria | 250 | 7.0299999999999995e-62 | NTclustered | gi|1418363025|gb|CP030287.1| | 2099583 | g40180 | i0 | 85.654 | 2 | 237 | 34 | 100 | 0 | 1 | 237 | 8618876 | 8619112 | Streptomyces sp. ICC1 chromosome | blastn | 474 | 250 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. ICC1 | ||
| 12697816 | 12697816 | PRJNA798905_S_NODE_34470_length_256_cov_1.426230_g34021_i0 | PRJNA798905 | 34470 | 256 | 1.42623 | 3.6511488 | Mycobacteriales | 85007 | Bacteria | Bacteria | 83.2 | 1.57e-17 | NR | WP_358199943.1 | 37330 | g34021 | i0 | 69.4 | 2.28515625 | 49 | 15 | 57.4 | 0 | 256 | 110 | 147 | 195 | WP_358199943.1 hypothetical protein [Nocardia nova] | diamond | 585 | 83.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Nocardia | Nocardia nova | ||
| 17370792 | 17370792 | PRJNA798905_S_NODE_42154_length_230_cov_2.286624_g41705_i0 | PRJNA798905 | 42154 | 230 | 2.286624 | 5.2592352 | Micrococcus luteus | 1270 | Bacteria | Bacteria | 303 | 5.13e-78 | NTclustered | gi|1875928653|gb|CP059046.1| | 1270 | g41705 | i0 | 90.476 | 2.5304347826087 | 231 | 20 | 100 | 2 | 1 | 230 | 75270 | 75499 | Micrococcus luteus strain R17 chromosome, complete genome | blastn | 582 | 303 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus luteus | ||
| 22468881 | 22468881 | PRJNA798905_S_NODE_17218_length_354_cov_1.900356_g16769_i0 | PRJNA798905 | 17218 | 354 | 1.900356 | 6.72726024 | Corynebacterium minutissimum | 38301 | Bacteria | Bacteria | 597 | 3.43e-166 | NTclustered | gi|1986087704|gb|CP069533.1| | 38301 | g16769 | i0 | 97.708 | 360.579096045198 | 349 | 4 | 98 | 2 | 1 | 347 | 1163920 | 1163574 | Corynebacterium minutissimum strain FDAARGOS_1196 chromosome, complete genome | blastn | 127645 | 597 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium minutissimum | ||
| 22469670 | 22469670 | PRJNA798905_S_NODE_9358_length_447_cov_11.160428_g8909_i0 | PRJNA798905 | 9358 | 447 | 11.160428 | 49.88711316 | Nocardioides terrisoli | 3388267 | Bacteria | Bacteria | 669 | 0 | NTclustered | gi|2579173395|gb|CP134227.1| | 3388267 | g8909 | i0 | 96.333 | 215.391498881432 | 409 | 11 | 91 | 4 | 1 | 407 | 390947 | 390541 | Nocardioides terrisoli strain YR1 chromosome, complete genome | blastn | 96280 | 669 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides terrisoli | ||
| 22895751 | 22895751 | PRJNA798905_S_NODE_26898_length_291_cov_4.458716_g26449_i0 | PRJNA798905 | 26898 | 291 | 4.458716 | 12.97486356 | Bacteria | 2 | Bacteria | Bacteria | 538 | 1.6999999999999994e-148 | NTclustered | gi|1418363025|gb|CP030287.1| | 2099583 | g26449 | i0 | 100 | 5.28178694158076 | 291 | 0 | 100 | 0 | 1 | 291 | 8619339 | 8619629 | Streptomyces sp. ICC1 chromosome | blastn | 1537 | 538 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. ICC1 | ||
| 24169965 | 24169965 | PRJNA798905_S_NODE_40579_length_238_cov_2.296970_g40130_i0 | PRJNA798905 | 40579 | 238 | 2.29697 | 5.4667886 | Corynebacterium | 1716 | Bacteria | Bacteria | 359 | 1.12e-94 | NTclustered | gi|2099489108|gb|CP083646.1| | 108486 | g40130 | i0 | 94.068 | 2.96218487394958 | 236 | 14 | 99 | 0 | 3 | 238 | 2650745 | 2650980 | Corynebacterium falsenii strain FDAARGOS_1494 chromosome, complete genome | blastn | 705 | 359 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium falsenii | ||
| 27211814 | 27211814 | PRJNA798905_S_NODE_1302_length_1227_cov_281.519931_g118_i3 | PRJNA798905 | 1302 | 1227 | 281.519931 | 3454.24955337 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 48.9 | 0.0154 | NR | WP_389241032.1 | 3364690 | g118 | i3 | 32.1 | 0.198044009779951 | 81 | 51 | 19.6 | 2 | 247 | 8 | 3 | 80 | WP_389241032.1 phosphotransferase [Streptomyces sp. NPDC004111] | diamond | 243 | 48.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC004111 | ||
| 27243593 | 27243593 | PRJNA798905_S_NODE_27943_length_286_cov_2.084507_g27494_i0 | PRJNA798905 | 27943 | 286 | 2.084507 | 5.96169002 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 88.6 | 4.94e-18 | NR | MBM3688387.1 | 2900548 | g27494 | i0 | 55.2 | 8.2027972027972 | 87 | 33 | 88.1 | 2 | 31 | 282 | 101 | 184 | MBM3688387.1 DNA topoisomerase 4 subunit A [Actinomycetota bacterium] | diamond | 2346 | 88.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 27433447 | 27433447 | PRJNA798905_S_NODE_9783_length_440_cov_2.653951_g9334_i0 | PRJNA798905 | 9783 | 440 | 2.653951 | 11.6773844 | Tsukamurella tyrosinosolvens | 57704 | Bacteria | Bacteria | 124 | 2.3999999999999999e-32 | NR | WP_367582384.1 | 57704 | g9334 | i0 | 50.4 | 0.865909090909091 | 127 | 59 | 83.9 | 2 | 377 | 9 | 48 | 174 | WP_367582384.1 HNH endonuclease signature motif containing protein [Tsukamurella tyrosinosolvens] | diamond | 381 | 124 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Tsukamurellaceae | Tsukamurella | Tsukamurella tyrosinosolvens | ||
| 27568427 | 27568427 | PRJNA798905_S_NODE_17404_length_352_cov_5.136201_g16955_i0 | PRJNA798905 | 17404 | 352 | 5.136201 | 18.07942752 | Bacteria | 2 | Bacteria | Bacteria | 110 | 2.22e-28 | NR | HET9773339.1 | 2080302 | g16955 | i0 | 54.9 | 1.78125 | 102 | 43 | 86.9 | 2 | 333 | 28 | 27 | 125 | HET9773339.1 NADAR family protein [Acidimicrobiia bacterium] | diamond | 627 | 110 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 28727789 | 28727789 | PRJNA798905_S_NODE_567_length_1848_cov_230.835493_g118_i1 | PRJNA798905 | 567 | 1848 | 230.835493 | 4265.83991064 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 48.9 | 0.0268 | NR | WP_389241032.1 | 3364690 | g118 | i1 | 31.9 | 0.152597402597403 | 94 | 59 | 14.9 | 3 | 719 | 994 | 3 | 93 | WP_389241032.1 phosphotransferase [Streptomyces sp. NPDC004111] | diamond | 282 | 48.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC004111 | ||
| 29169932 | 29169932 | PRJNA798905_S_NODE_36009_length_250_cov_3.338983_g35560_i0 | PRJNA798905 | 36009 | 250 | 3.338983 | 8.3474575 | Cellulomonas composti | 266130 | Bacteria | Bacteria | 43.5 | 0.0215 | NR | WP_146842518.1 | 266130 | g35560 | i0 | 36.4 | 1.812 | 77 | 34 | 82.8 | 4 | 212 | 6 | 771 | 840 | WP_146842518.1 sulfide/dihydroorotate dehydrogenase-like FAD/NAD-binding protein [Cellulomonas composti] | diamond | 453 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Cellulomonadaceae | Cellulomonas | Cellulomonas composti | ||
| 29201499 | 29201499 | PRJNA798905_S_NODE_249_length_2756_cov_242.388744_g118_i0 | PRJNA798905 | 249 | 2756 | 242.388744 | 6680.23378464 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 48.9 | 0.0436 | NR | WP_389241032.1 | 3364690 | g118 | i0 | 31.9 | 0.102322206095791 | 94 | 59 | 10 | 3 | 2038 | 1763 | 3 | 93 | WP_389241032.1 phosphotransferase [Streptomyces sp. NPDC004111] | diamond | 282 | 48.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC004111 | ||
| 30527849 | 30527849 | PRJNA798905_S_NODE_24293_length_305_cov_6.431034_g23844_i0 | PRJNA798905 | 24293 | 305 | 6.431034 | 19.6146537 | Curtobacterium ammoniigenes | 395387 | Bacteria | Bacteria | 48.9 | 1.94e-4 | NR | WP_066514309.1 | 395387 | g23844 | i0 | 45.5 | 0.649180327868852 | 66 | 34 | 63 | 1 | 274 | 83 | 35 | 100 | WP_066514309.1 hypothetical protein [Curtobacterium ammoniigenes] | diamond | 198 | 48.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Curtobacterium | Curtobacterium ammoniigenes | ||
| 30749070 | 30749070 | PRJNA798905_S_NODE_1774_length_1032_cov_22.628780_g1415_i0 | PRJNA798905 | 1774 | 1032 | 22.62878 | 233.5290096 | Streptomyces sp. BRB | 1931 | Bacteria | Bacteria | 409 | 2.04e-139 | NR | WP_196191622.1 | 2769544 | g1415 | i0 | 83.4 | 0.73546511627907 | 253 | 42 | 73.5 | 0 | 774 | 16 | 98 | 350 | WP_196191622.1 hypothetical protein [Streptomyces sp. BRB081] | diamond | 759 | 409 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. BRB081 | ||
| 31222818 | 31222818 | PRJNA798905_S_NODE_7895_length_480_cov_5.068796_g7446_i0 | PRJNA798905 | 7895 | 480 | 5.068796 | 24.3302208 | Streptomyces sp. CHB9.2 | 2841670 | Bacteria | Bacteria | 220 | 1.5600000000000001e-63 | NR | WP_252940890.1 | 2841670 | g7446 | i0 | 67.7 | 0.9875 | 158 | 51 | 98.8 | 0 | 7 | 480 | 8 | 165 | WP_252940890.1 hypothetical protein [Streptomyces sp. CHB9.2] | diamond | 474 | 220 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. CHB9.2 | ||
| 31823846 | 31823846 | PRJNA798905_S_NODE_27277_length_289_cov_6.703704_g26828_i0 | PRJNA798905 | 27277 | 289 | 6.703704 | 19.37370456 | Coriobacteriaceae bacterium | 2011094 | Bacteria | Bacteria | 43.1 | 0.0451 | NR | MDO4436993.1 | 2011094 | g26828 | i0 | 35.7 | 0.726643598615917 | 70 | 38 | 66.4 | 3 | 3 | 194 | 164 | 232 | MDO4436993.1 DNA repair protein [Coriobacteriaceae bacterium] | diamond | 210 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriales | Coriobacteriaceae | Coriobacteriaceae bacterium | |||
| 31887212 | 31887212 | PRJNA798905_S_NODE_37197_length_247_cov_3.971264_g36748_i0 | PRJNA798905 | 37197 | 247 | 3.971264 | 9.80902208 | Haloechinothrix halophila | 1069073 | Bacteria | Bacteria | 42.7 | 0.0377 | NR | WP_034268929.1 | 1069073 | g36748 | i0 | 42.9 | 0.595141700404858 | 49 | 24 | 54.7 | 1 | 221 | 87 | 103 | 151 | WP_034268929.1 amidohydrolase [Haloechinothrix halophila] | diamond | 147 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Haloechinothrix | Haloechinothrix halophila |
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);;