RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1020641" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1020641 · 6 ✖

analysis 1

  • blastn · 6 ✖

tax_clade 0

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
1002995 1002995 PRJNA1020641_P_NODE_3901_length_309_cov_0.944915_g3858_i0 PRJNA1020641 3901 309 0.944915 2.91978735 Rhodococcus 1827 Bacteria Bacteria 477 4.0199999999999996e-130   NTclustered gi|2921205402|gb|CP134707.1| 37919 g3858 i0 94.516 404.333333333333 310 16 100 1 1 309 2199209 2199518 Rhodococcus opacus strain DSM 43205 chromosome, complete genome blastn 124939 477 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus opacus
2278068 2278068 PRJNA1020641_P_NODE_2582_length_380_cov_1.504886_g2539_i0 PRJNA1020641 2582 380 1.504886 5.7185668 Cutibacterium 1912216 Bacteria Bacteria 702 0   NTclustered gi|1446500593|gb|CP031442.1| 1747 g2539 i0 100 247.776315789474 380 0 100 0 1 380 55417 55796 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 94155 702 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
11206244 11206244 PRJNA1020641_P_NODE_4669_length_278_cov_1.468293_g4626_i0 PRJNA1020641 4669 278 1.468293 4.08185454 Actinomycetes 1760 Bacteria Bacteria 425 1.31e-114   NTclustered gi|1345633730|emb|LT985188.1| 75385 g4626 i0 94.245 312.053956834532 278 16 100 0 1 278 1730498 1730221 Micropruina glycogenica isolate 1 genome assembly, chromosome: 1 blastn 86751 425 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Micropruina Micropruina glycogenica
15463311 15463311 PRJNA1020641_P_NODE_7133_length_243_cov_0.870588_g7090_i0 PRJNA1020641 7133 243 0.870588 2.11552884 Pedococcus sp. KACC 23699 3149228 Bacteria Bacteria 124 4.579999999999999e-24   NTclustered gi|2739524205|gb|CP157483.1| 3149228 g7090 i0 96.053 26.7448559670782 76 3 31 0 103 178 3703373 3703298 Pedococcus sp. KACC 23699 chromosome, complete genome blastn 6499 124 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Pedococcus Pedococcus sp. KACC 23699
18854652 18854652 PRJNA1020641_P_NODE_2415_length_393_cov_1.212500_g2372_i0 PRJNA1020641 2415 393 1.2125 4.765125 Corynebacterium 1716 Bacteria Bacteria 669 0   NTclustered gi|1899780227|gb|CP061031.1| 2735136 g2372 i0 97.692 285.681933842239 390 8 100 1 1 390 710642 711030 Corynebacterium wankanglinii strain zg-913 chromosome, complete genome blastn 112273 675 0.991111111111111 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium wankanglinii
20561727 20561727 PRJNA1020641_P_NODE_4137_length_299_cov_0.871681_g4094_i0 PRJNA1020641 4137 299 0.871681 2.60632619 Pseudonocardia sp. EC080625-04 1096868 Bacteria Bacteria 514 2.95e-141   NTclustered gi|928461215|gb|CP010989.1| 1096868 g4094 i0 97.659 371.080267558528 299 7 100 0 1 299 2981890 2981592 Pseudonocardia sp. EC080625-04, complete genome blastn 110953 514 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia sp. EC080625-04

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;