contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA951388" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 934758 | 934758 | PRJNA951388_S_NODE_11301_length_243_cov_1.358824_g11174_i0 | PRJNA951388 | 11301 | 243 | 1.358824 | 3.30194232 | Rhodococcus sp. DN22 | 357684 | Bacteria | Bacteria | 449 | 6.65e-122 | NTclustered | gi|2675877924|gb|CP133326.1| | 357684 | g11174 | i0 | 100 | 48 | 243 | 0 | 100 | 0 | 1 | 243 | 4270423 | 4270181 | Rhodococcus sp. DN22 strain strain DN22 chromosome, complete genome | blastn | 11664 | 449 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus sp. DN22 | ||
| 3814796 | 3814796 | PRJNA951388_S_NODE_3983_length_408_cov_2.591045_g3856_i0 | PRJNA951388 | 3983 | 408 | 2.591045 | 10.5714636 | Cutibacterium | 1912216 | Bacteria | Bacteria | 754 | 0 | NTclustered | gi|2548746222|gb|CP129004.1| | 1747 | g3856 | i0 | 100 | 273.882352941176 | 408 | 0 | 100 | 0 | 1 | 408 | 608485 | 608892 | Cutibacterium acnes strain EASDk81B chromosome, complete genome | blastn | 111744 | 754 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 7640721 | 7640721 | PRJNA951388_S_NODE_11786_length_235_cov_2.364198_g11659_i0 | PRJNA951388 | 11786 | 235 | 2.364198 | 5.5558653 | Kocuria | 57493 | Bacteria | Bacteria | 435 | 1.79e-117 | NTclustered | gi|1540076968|emb|LR134391.1| | 1275 | g11659 | i0 | 100 | 270.527659574468 | 235 | 0 | 100 | 0 | 1 | 235 | 1080204 | 1080438 | Kocuria rosea strain NCTC7514 genome assembly, chromosome: 1 | blastn | 63574 | 435 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Kocuria | Kocuria rosea | ||
| 7640724 | 7640724 | PRJNA951388_S_NODE_2646_length_469_cov_2.732323_g2519_i0 | PRJNA951388 | 2646 | 469 | 2.732323 | 12.81459487 | Corynebacterium | 1716 | Bacteria | Bacteria | 771 | 0 | NTclustered | gi|1958403034|gb|CP068165.1| | 169292 | g2519 | i0 | 96.391 | 401.92750533049 | 471 | 12 | 100 | 5 | 1 | 469 | 400190 | 399723 | Corynebacterium aurimucosum strain FDAARGOS_1110 chromosome, complete genome | blastn | 188504 | 771 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium aurimucosum | ||
| 12413864 | 12413864 | PRJNA951388_S_NODE_8930_length_280_cov_3.946860_g8803_i0 | PRJNA951388 | 8930 | 280 | 3.94686 | 11.051208 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 484 | 2.15e-132 | NTclustered | gi|1723592958|emb|LR584267.1| | 1528099 | g8803 | i0 | 97.857 | 327.960714285714 | 280 | 6 | 100 | 0 | 1 | 280 | 552129 | 551850 | Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1 | blastn | 91829 | 484 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 22940506 | 22940506 | PRJNA951388_S_NODE_12538_length_219_cov_4.500000_g12411_i0 | PRJNA951388 | 12538 | 219 | 4.5 | 9.855 | Cutibacterium | 1912216 | Bacteria | Bacteria | 383 | 6.05e-102 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g12411 | i0 | 98.182 | 239.936073059361 | 220 | 3 | 100 | 1 | 1 | 219 | 55619 | 55838 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 52546 | 383 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 22940520 | 22940520 | PRJNA951388_S_NODE_8658_length_286_cov_1.784038_g8531_i0 | PRJNA951388 | 8658 | 286 | 1.784038 | 5.10234868 | Cellulomonas | 1707 | Bacteria | Bacteria | 529 | 1e-145 | NTclustered | gi|2571366987|gb|OR498076.1| | 40001 | g8531 | i0 | 100 | 103 | 286 | 0 | 100 | 0 | 1 | 286 | 874 | 589 | Cellulomonas sp. strain ATA003 16S ribosomal RNA gene, partial sequence | blastn | 29458 | 529 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Cellulomonadaceae | Cellulomonas | Cellulomonas sp. |
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);;