RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA713989" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA713989 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
1191281 1191281 PRJNA713989_S_NODE_12741_length_165_cov_0.879310_g12681_i0 PRJNA713989 12741 165 0.87931 1.4508615 Cutibacterium 1912216 Bacteria Bacteria 300 4.46e-77   NTclustered gi|1446500593|gb|CP031442.1| 1747 g12681 i0 99.394 64.0666666666667 165 1 100 0 1 165 921862 922026 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 10571 300 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
2466542 2466542 PRJNA713989_S_NODE_3622_length_269_cov_0.904545_g3562_i0 PRJNA713989 3622 269 0.904545 2.43322605 Dermacoccus 57495 Bacteria Bacteria 409 1.27e-109   NTclustered gi|336092981|gb|JF905610.1| 1043598 g3562 i0 94.096 186.468401486989 271 13 100 3 1 269 6 275 Dermacoccus sp. 103 16S ribosomal RNA gene, partial sequence blastn 50160 409 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Dermacoccus Dermacoccus sp. 103
5019533 5019533 PRJNA713989_S_NODE_10224_length_178_cov_1.015504_g10164_i0 PRJNA713989 10224 178 1.015504 1.80759712 Cutibacterium 1912216 Bacteria Bacteria 324 2.89e-84   NTclustered gi|966542502|gb|CP012354.1| 1747 g10164 i0 99.438 57.7415730337079 178 1 100 0 1 178 2207718 2207895 Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome blastn 10278 324 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
5019539 5019539 PRJNA713989_S_NODE_13004_length_164_cov_0.886957_g12944_i0 PRJNA713989 13004 164 0.886957 1.45460948 Corynebacterium 1716 Bacteria Bacteria 276 7.46e-70   NTclustered gi|2547382485|gb|CP129966.1| 3059081 g12944 i0 96.951 65.6036585365854 164 5 100 0 1 164 66663 66500 Corynebacterium sp. P4-C1 chromosome, complete genome blastn 10759 276 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium sp. P4-C1
12182674 12182674 PRJNA713989_S_NODE_11990_length_167_cov_0.864407_g11930_i0 PRJNA713989 11990 167 0.864407 1.44355969 Dermacoccus nishinomiyaensis 1274 Bacteria Bacteria 303 3.5e-78   NTclustered gi|1966870119|gb|CP068484.1| 1274 g11930 i0 99.401 10.0718562874251 167 1 100 0 1 167 2259316 2259482 Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome blastn 1682 303 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Dermacoccus Dermacoccus nishinomiyaensis
17281591 17281591 PRJNA713989_S_NODE_4514_length_246_cov_0.949239_g4454_i0 PRJNA713989 4514 246 0.949239 2.33512794 Cutibacterium acnes 1747 Bacteria Bacteria 364 2.509999999999999e-96   NTclustered gi|50839098|gb|AE017283.1| 267747 g4454 i0 93.496 290.211382113821 246 14 99 2 2 246 1522849 1523093 Propionibacterium acnes KPA171202, complete genome blastn 71392 364 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
20317632 20317632 PRJNA713989_S_NODE_12936_length_164_cov_0.886957_g12876_i0 PRJNA713989 12936 164 0.886957 1.45460948 Micrococcus 1269 Bacteria Bacteria 303 3.42e-78   NTclustered gi|1949953231|gb|CP066288.1| 1270 g12876 i0 100 26.890243902439 164 0 100 0 1 164 792716 792879 Micrococcus luteus strain FDAARGOS_1034 chromosome blastn 4410 303 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
21593500 21593500 PRJNA713989_S_NODE_14097_length_161_cov_0.910714_g14037_i0 PRJNA713989 14097 161 0.910714 1.46624954 Cutibacterium 1912216 Bacteria Bacteria 298 1.56e-76   NTclustered gi|966542502|gb|CP012354.1| 1747 g14037 i0 100 51 161 0 100 0 1 161 2183363 2183523 Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome blastn 8211 298 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
24929853 24929853 PRJNA713989_S_NODE_10480_length_176_cov_0.937008_g10420_i0 PRJNA713989 10480 176 0.937008 1.64913408 uncultured Actinomycetes bacterium 152507 Bacteria Bacteria 320 3.69e-83   NTclustered gi|373125954|gb|JN567135.1| 152507 g10420 i0 99.432 105.829545454545 176 1 100 0 1 176 423 248 Uncultured actinobacterium clone DDOUFH11 16S ribosomal RNA gene, partial sequence blastn 18626 320 1 Bacteria   Bacillati Actinomycetota Actinomycetes       uncultured Actinomycetes bacterium

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