contig_metadata
22 rows where bioproject = "PRJNA1136957" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1559141 | 1559141 | PRJNA1136957_S_NODE_11362_length_254_cov_1.410256_g11265_i0 | PRJNA1136957 | 11362 | 254 | 1.410256 | 3.58205024 | Nocardioides scoriae | 642780 | Bacteria | Bacteria | 100 | 8.12e-17 | NTclustered | gi|1085860874|emb|LT629757.1| | 642780 | g11265 | i0 | 96.667 | 0.47244094488189 | 60 | 2 | 24 | 0 | 40 | 99 | 2658689 | 2658748 | Marmoricola scoriae strain DSM 22127 genome assembly, chromosome: I | blastn | 120 | 100 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides scoriae | ||
| 1559164 | 1559164 | PRJNA1136957_S_NODE_15462_length_221_cov_1.759259_g15365_i0 | PRJNA1136957 | 15462 | 221 | 1.759259 | 3.88796239 | Actinomyces wuliandei | 2057743 | Bacteria | Bacteria | 58.4 | 4.21e-4 | NTclustered | gi|1552076344|gb|CP025227.1| | 2057743 | g15365 | i0 | 90.909 | 0.199095022624434 | 44 | 2 | 19 | 2 | 174 | 216 | 2740185 | 2740227 | Actinomyces wuliandei strain 299 chromosome, complete genome | blastn | 44 | 58.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Actinomyces | Actinomyces wuliandei | ||
| 2835300 | 2835300 | PRJNA1136957_S_NODE_8483_length_289_cov_1.326087_g8386_i0 | PRJNA1136957 | 8483 | 289 | 1.326087 | 3.83239143 | Agrococcus sp. SL85 | 2995141 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2381128626|gb|CP113066.1| | 2995141 | g8386 | i0 | 100 | 0.100346020761246 | 29 | 0 | 10 | 0 | 171 | 199 | 1718431 | 1718403 | Agrococcus sp. SL85 chromosome | blastn | 29 | 54.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Agrococcus | Agrococcus sp. SL85 | ||
| 5387778 | 5387778 | PRJNA1136957_S_NODE_17985_length_205_cov_1.671233_g17888_i0 | PRJNA1136957 | 17985 | 205 | 1.671233 | 3.42602765 | Miltoncostaea marina | 2843215 | Bacteria | Bacteria | 215 | 2.16e-51 | NTclustered | gi|2030071733|gb|CP064655.1| | 2843215 | g17888 | i0 | 86.07 | 20.7853658536585 | 201 | 26 | 98 | 2 | 1 | 200 | 1293900 | 1294099 | Miltoncostaea marina strain SCSIO 60955 chromosome, complete genome | blastn | 4261 | 215 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Miltoncostaeales | Miltoncostaeaceae | Miltoncostaea | Miltoncostaea marina | ||
| 6662385 | 6662385 | PRJNA1136957_S_NODE_10166_length_267_cov_2.639423_g10069_i0 | PRJNA1136957 | 10166 | 267 | 2.639423 | 7.04725941 | Micromonospora sp. NBC_01813 | 2975988 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2651870791|gb|CP109067.1| | 2975988 | g10069 | i0 | 100 | 0.112359550561798 | 30 | 0 | 11 | 0 | 85 | 114 | 6185696 | 6185725 | Micromonospora sp. NBC_01813 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora sp. NBC_01813 | ||
| 11235368 | 11235368 | PRJNA1136957_S_NODE_8649_length_287_cov_0.885965_g8552_i0 | PRJNA1136957 | 8649 | 287 | 0.885965 | 2.54271955 | Arthrobacter | 1663 | Bacteria | Bacteria | 470 | 6.18e-128 | NTclustered | gi|2921126289|gb|CP102608.1| | 619291 | g8552 | i0 | 96.167 | 224.073170731707 | 287 | 11 | 100 | 0 | 1 | 287 | 460417 | 460131 | Arthrobacter sp. N1 chromosome, complete genome | blastn | 64309 | 470 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter sp. N1 | ||
| 12510753 | 12510753 | PRJNA1136957_S_NODE_9310_length_278_cov_1.566210_g9213_i0 | PRJNA1136957 | 9310 | 278 | 1.56621 | 4.3540638 | Micrococcus | 1269 | Bacteria | Bacteria | 514 | 2.7199999999999996e-141 | NTclustered | gi|1949953231|gb|CP066288.1| | 1270 | g9213 | i0 | 100 | 283.712230215827 | 278 | 0 | 100 | 0 | 1 | 278 | 2260522 | 2260799 | Micrococcus luteus strain FDAARGOS_1034 chromosome | blastn | 78872 | 514 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus luteus | ||
| 13038292 | 13038292 | PRJNA1136957_S_NODE_16211_length_216_cov_2.331210_g16114_i0 | PRJNA1136957 | 16211 | 216 | 2.33121 | 5.0354136 | Clavibacter capsici | 1874630 | Bacteria | Bacteria | 54.7 | 0.005 | NTclustered | gi|1826985222|gb|CP048045.1| | 1874630 | g16114 | i0 | 94.444 | 0.944444444444444 | 36 | 0 | 17 | 2 | 102 | 137 | 366925 | 366892 | Clavibacter capsici strain 1207 chromosome, complete genome | blastn | 204 | 54.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Clavibacter | Clavibacter capsici | ||
| 15587468 | 15587468 | PRJNA1136957_S_NODE_17193_length_210_cov_1.615894_g17096_i0 | PRJNA1136957 | 17193 | 210 | 1.615894 | 3.3933774 | Microbacterium sp. PM5 | 2014534 | Bacteria | Bacteria | 289 | 1.29e-73 | NTclustered | gi|1419380645|gb|CP022162.1| | 2014534 | g17096 | i0 | 91.429 | 7.35238095238095 | 210 | 18 | 100 | 0 | 1 | 210 | 173850 | 174059 | Microbacterium sp. PM5 genome | blastn | 1544 | 289 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. PM5 | ||
| 16334419 | 16334419 | PRJNA1136957_S_NODE_13213_length_237_cov_1.758427_g13116_i0 | PRJNA1136957 | 13213 | 237 | 1.758427 | 4.16747199 | root | 1 | Root_unresolved | Root_unresolved | 438 | 1.4e-118 | NTclustered | gi|2660106423|gb|CP138905.1| | 1831 | g13116 | i0 | 100 | 407.04641350211 | 237 | 0 | 100 | 0 | 1 | 237 | 559849 | 560085 | MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome | blastn | 96470 | 438 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus sp. (in: high G+C Gram-positive bacteria) | ||
| 19410508 | 19410508 | PRJNA1136957_S_NODE_17056_length_211_cov_1.203947_g16959_i0 | PRJNA1136957 | 17056 | 211 | 1.203947 | 2.54032817 | uncultured Actinomycetes bacterium | 152507 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|2874254042|emb|OY970366.1| | 152507 | g16959 | i0 | 100 | 0.14218009478673 | 30 | 0 | 14 | 0 | 34 | 63 | 193999 | 194028 | MAG: uncultured Actinomycetes bacterium isolate MFD02923.bin.c.1 genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | uncultured Actinomycetes bacterium | |||||
| 21433920 | 21433920 | PRJNA1136957_S_NODE_5097_length_352_cov_1.402730_g5000_i0 | PRJNA1136957 | 5097 | 352 | 1.40273 | 4.9376096 | Cutibacterium | 1912216 | Bacteria | Bacteria | 651 | 0 | NTclustered | gi|2548746222|gb|CP129004.1| | 1747 | g5000 | i0 | 100 | 285.159090909091 | 352 | 0 | 100 | 0 | 1 | 352 | 608943 | 608592 | Cutibacterium acnes strain EASDk81B chromosome, complete genome | blastn | 100376 | 651 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 21961341 | 21961341 | PRJNA1136957_S_NODE_15958_length_218_cov_1.534591_g15861_i0 | PRJNA1136957 | 15958 | 218 | 1.534591 | 3.34540838 | Amycolatopsis bartoniae | 941986 | Bacteria | Bacteria | 75 | 4.11e-9 | NTclustered | gi|2884838259|gb|CP174150.1| | 941986 | g15861 | i0 | 88.889 | 1.05045871559633 | 63 | 4 | 28 | 3 | 131 | 190 | 2931098 | 2931160 | Amycolatopsis bartoniae strain DSM 45807 chromosome, complete genome | blastn | 229 | 75 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Amycolatopsis | Amycolatopsis bartoniae | ||
| 22708892 | 22708892 | PRJNA1136957_S_NODE_4738_length_361_cov_4.860927_g4641_i0 | PRJNA1136957 | 4738 | 361 | 4.860927 | 17.54794647 | Bacillati | 1783272 | Bacteria | Bacteria | 52.8 | 0.034 | NTclustered | gi|2657055515|gb|CP108334.1| | 1961 | g4641 | i0 | 100 | 0.473684210526316 | 28 | 0 | 8 | 0 | 278 | 305 | 3284904 | 3284931 | Streptomyces virginiae strain NBC_00131 chromosome, complete genome | blastn | 171 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces virginiae | ||
| 23236905 | 23236905 | PRJNA1136957_S_NODE_3839_length_389_cov_2.754545_g3742_i0 | PRJNA1136957 | 3839 | 389 | 2.754545 | 10.71518005 | Nocardioides ochotonae | 2685869 | Bacteria | Bacteria | 52.8 | 0.037 | NTclustered | gi|1910930591|gb|CP061769.1| | 2685869 | g3742 | i0 | 96.875 | 0.0822622107969152 | 32 | 0 | 8 | 1 | 266 | 297 | 379040 | 379010 | Nocardioides ochotonae strain ZJ1313 chromosome, complete genome | blastn | 32 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides ochotonae | ||
| 23984329 | 23984329 | PRJNA1136957_S_NODE_16359_length_215_cov_2.737179_g16262_i0 | PRJNA1136957 | 16359 | 215 | 2.737179 | 5.88493485 | Streptomyces | 1883 | Bacteria | Bacteria | 119 | 1.84e-22 | NTclustered | gi|2667573168|gb|CP107811.1| | 2975770 | g16262 | i0 | 84.426 | 62.1162790697674 | 122 | 17 | 56 | 2 | 9 | 129 | 3117344 | 3117224 | Streptomyces sp. NBC_00539 chromosome, complete genome | blastn | 13355 | 119 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NBC_00539 | ||
| 25258313 | 25258313 | PRJNA1136957_S_NODE_12080_length_247_cov_1.888298_g11983_i0 | PRJNA1136957 | 12080 | 247 | 1.888298 | 4.66409606 | Cutibacterium | 1912216 | Bacteria | Bacteria | 457 | 4.05e-124 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g11983 | i0 | 100 | 268.141700404858 | 247 | 0 | 100 | 0 | 1 | 247 | 56944 | 56698 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 66231 | 457 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 26721759 | 26721759 | PRJNA1136957_S_NODE_15341_length_222_cov_1.460123_g15244_i0 | PRJNA1136957 | 15341 | 222 | 1.460123 | 3.24147306 | unclassified Streptomyces | 2593676 | Bacteria | Bacteria | 43.1 | 0.02 | NR | WP_241842784.1 | 2593676 | g15244 | i0 | 46.9 | 0.662162162162162 | 49 | 24 | 63.5 | 1 | 199 | 59 | 26 | 74 | WP_241842784.1 MULTISPECIES: hypothetical protein [unclassified Streptomyces] | diamond | 147 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | |||
| 29438374 | 29438374 | PRJNA1136957_S_NODE_20350_length_195_cov_0.897059_g20253_i0 | PRJNA1136957 | 20350 | 195 | 0.897059 | 1.74926505 | Kitasatospora indigofera | 67307 | Bacteria | Bacteria | 44.7 | 0.0042 | NR | WP_355657059.1 | 67307 | g20253 | i0 | 33.3 | 0.969230769230769 | 63 | 41 | 96.9 | 1 | 7 | 195 | 49 | 110 | WP_355657059.1 acyl-CoA thioesterase/bile acid-CoA:amino acid N-acyltransferase family protein [Kitasatospora indigofera] | diamond | 189 | 44.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora indigofera | ||
| 29881018 | 29881018 | PRJNA1136957_S_NODE_2671_length_436_cov_2.442971_g2574_i0 | PRJNA1136957 | 2671 | 436 | 2.442971 | 10.65135356 | Streptomyces sp. Rer75 | 2750011 | Bacteria | Bacteria | 43.5 | 0.0313 | NR | QLH27388.1 | 2750011 | g2574 | i0 | 42.1 | 0.784403669724771 | 57 | 31 | 37.8 | 1 | 281 | 117 | 53 | 109 | QLH27388.1 MFS transporter [Streptomyces sp. Rer75] | diamond | 342 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. Rer75 | ||
| 31418225 | 31418225 | PRJNA1136957_S_NODE_13516_length_235_cov_1.039773_g13419_i0 | PRJNA1136957 | 13516 | 235 | 1.039773 | 2.44346655 | Streptomyces | 1883 | Bacteria | Bacteria | 80.5 | 1.72e-15 | NR | WP_250402383.1 | 67285 | g13419 | i0 | 52.9 | 5.47659574468085 | 70 | 33 | 89.4 | 0 | 1 | 210 | 628 | 697 | WP_250402383.1 neutral/alkaline ceramidase [Streptomyces cellostaticus] | diamond | 1287 | 81.3 | 0.990159901599016 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces cellostaticus | ||
| 31461085 | 31461085 | PRJNA1136957_S_NODE_8916_length_283_cov_1.691964_g8819_i0 | PRJNA1136957 | 8916 | 283 | 1.691964 | 4.78825812 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 62.8 | 1.72e-9 | NR | MET0160153.1 | 2201156 | g8819 | i0 | 56.5 | 0.657243816254417 | 62 | 20 | 65.7 | 1 | 282 | 97 | 129 | 183 | MET0160153.1 oligoribonuclease [Acidimicrobiales bacterium] | diamond | 186 | 62.8 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales 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);;