contig_metadata
8 rows where bioproject = "PRJNA929940" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12388284 | 12388284 | PRJNA929940_S_NODE_49730_length_161_cov_1.016129_g49495_i0 | PRJNA929940 | 49730 | 161 | 1.016129 | 1.63596769 | Neomicrococcus aestuarii | 556325 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|1109133054|gb|CP018135.1| | 556325 | g49495 | i0 | 96.97 | 0.204968944099379 | 33 | 1 | 20 | 0 | 75 | 107 | 1146950 | 1146918 | Neomicrococcus aestuarii strain B18 chromosome, complete genome | blastn | 33 | 56.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Neomicrococcus | Neomicrococcus aestuarii | ||
| 15282713 | 15282713 | PRJNA929940_S_NODE_55692_length_154_cov_1.316239_g55457_i0 | PRJNA929940 | 55692 | 154 | 1.316239 | 2.02700806 | Micrococcus | 1269 | Bacteria | Bacteria | 279 | 5.33e-71 | NTclustered | gi|1891023613|gb|CP058971.1| | 1270 | g55457 | i0 | 99.351 | 340.876623376623 | 154 | 1 | 100 | 0 | 1 | 154 | 346142 | 346295 | Micrococcus luteus strain V017 chromosome, complete genome | blastn | 52495 | 279 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus luteus | ||
| 16212069 | 16212069 | PRJNA929940_S_NODE_30513_length_194_cov_2.783439_g30278_i0 | PRJNA929940 | 30513 | 194 | 2.783439 | 5.39987166 | uncultured Actinomycetes bacterium | 152507 | Bacteria | Bacteria | 348 | 1.91e-91 | NTclustered | gi|686688730|gb|KM031457.1| | 152507 | g30278 | i0 | 98.969 | 98.2886597938144 | 194 | 2 | 100 | 0 | 1 | 194 | 397 | 590 | Uncultured actinobacterium clone D9-49 16S ribosomal RNA gene, partial sequence | blastn | 19068 | 348 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | uncultured Actinomycetes bacterium | |||||
| 20381129 | 20381129 | PRJNA929940_S_NODE_18016_length_239_cov_1.504950_g17781_i0 | PRJNA929940 | 18016 | 239 | 1.50495 | 3.5968305 | Micrococcus | 1269 | Bacteria | Bacteria | 412 | 8.549999999999998e-111 | NTclustered | gi|1891023613|gb|CP058971.1| | 1270 | g17781 | i0 | 97.908 | 191.02510460251 | 239 | 3 | 100 | 2 | 1 | 239 | 346165 | 345929 | Micrococcus luteus strain V017 chromosome, complete genome | blastn | 45655 | 412 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus luteus | ||
| 24206365 | 24206365 | PRJNA929940_S_NODE_49119_length_161_cov_3.209677_g48884_i0 | PRJNA929940 | 49119 | 161 | 3.209677 | 5.16757997 | Micrococcus | 1269 | Bacteria | Bacteria | 298 | 1.56e-76 | NTclustered | gi|1891023613|gb|CP058971.1| | 1270 | g48884 | i0 | 100 | 295.478260869565 | 161 | 0 | 100 | 0 | 1 | 161 | 345721 | 345561 | Micrococcus luteus strain V017 chromosome, complete genome | blastn | 47572 | 298 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus luteus | ||
| 27656975 | 27656975 | PRJNA929940_S_NODE_22604_length_218_cov_2.425414_g22369_i0 | PRJNA929940 | 22604 | 218 | 2.425414 | 5.28740252 | Streptomyces sp. NBC_ | 1931 | Bacteria | Bacteria | 43.1 | 0.0199 | NR | WP_327288926.1 | 2903769 | g22369 | i0 | 39.6 | 0.729357798165138 | 53 | 27 | 72.9 | 1 | 205 | 47 | 225 | 272 | WP_327288926.1 S9 family peptidase [Streptomyces sp. NBC_01198] | diamond | 159 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NBC_01198 | ||
| 28137632 | 28137632 | PRJNA929940_S_NODE_7645_length_328_cov_3.154639_g7410_i0 | PRJNA929940 | 7645 | 328 | 3.154639 | 10.34721592 | Bacteria | 2 | Bacteria | Bacteria | 44.3 | 0.0227 | NR | WP_409923725.1 | 1967498 | g7410 | i0 | 26.5 | 1.85670731707317 | 102 | 64 | 89.6 | 2 | 308 | 15 | 138 | 232 | WP_409923725.1 GntR family transcriptional regulator [Ilumatobacter sp.] | diamond | 609 | 44.7 | 0.991051454138702 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Ilumatobacteraceae | Ilumatobacter | Ilumatobacter sp. | ||
| 29456184 | 29456184 | PRJNA929940_S_NODE_57510_length_152_cov_1.426087_g57275_i0 | PRJNA929940 | 57510 | 152 | 1.426087 | 2.16765224 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 55.8 | 2.52e-7 | NR | MFM8237608.1 | 2900548 | g57275 | i0 | 92.3 | 4.55921052631579 | 26 | 2 | 51.3 | 0 | 152 | 75 | 27 | 52 | MFM8237608.1 adenosylhomocysteinase [Actinomycetota bacterium] | diamond | 693 | 55.8 | 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);;