RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA358209" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 15 ✖

bioproject 1

  • PRJNA358209 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
2348526 2348526 PRJNA358209_P_NODE_702_length_165_cov_0.879310_g700_i0 PRJNA358209 702 165 0.87931 1.4508615 Cutibacterium 1912216 Bacteria Bacteria 305 9.59e-79   NTclustered gi|1446500593|gb|CP031442.1| 1747 g700 i0 100 52.9757575757576 165 0 100 0 1 165 1085960 1085796 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 8741 305 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
3623847 3623847 PRJNA358209_P_NODE_1063_length_162_cov_0.902655_g1061_i0 PRJNA358209 1063 162 0.902655 1.4623011 Cutibacterium 1912216 Bacteria Bacteria 300 4.36e-77   NTclustered gi|2493038017|gb|CP114010.1| 1747 g1061 i0 100 50.3950617283951 162 0 100 0 1 162 938864 939025 Cutibacterium acnes strain CBS-BPNBT19329 chromosome, complete genome blastn 8164 300 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
4226064 4226064 PRJNA358209_P_NODE_1164_length_161_cov_0.910714_g1162_i0 PRJNA358209 1164 161 0.910714 1.46624954 Dactylosporangium thailandense 47849 Bacteria Bacteria 54.7 0.004   NTclustered gi|2666977426|dbj|AP029195.1| 47849 g1162 i0 96.97 0.204968944099379 33 0 20 1 54 85 10748479 10748447 Dactylosporangium thailandense JCM 3084 DNA, complete genome blastn 33 54.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Dactylosporangium Dactylosporangium thailandense
4226086 4226086 PRJNA358209_P_NODE_924_length_163_cov_0.894737_g922_i0 PRJNA358209 924 163 0.894737 1.45842131 Mycobacteroides chelonae 1774 Bacteria Bacteria 302 1.22e-77   NTclustered gi|1951304461|gb|CP050223.1| 1774 g922 i0 100 98.6932515337423 163 0 100 0 1 163 1441346 1441508 Mycobacteroides chelonae strain Myco1 chromosome blastn 16087 302 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacteroides Mycobacteroides chelonae
5502503 5502503 PRJNA358209_P_NODE_465_length_167_cov_0.864407_g463_i0 PRJNA358209 465 167 0.864407 1.44355969 Georgenia sp. M64 3120520 Bacteria Bacteria 255 9.950000000000001e-64   NTclustered gi|2689060381|gb|CP145809.1| 3120520 g463 i0 95.062 1.1377245508982 162 8 97 0 1 162 2100127 2100288 Georgenia sp. M64 chromosome, complete genome blastn 190 255 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Bogoriellaceae Georgenia Georgenia sp. M64
9327019 9327019 PRJNA358209_P_NODE_708_length_165_cov_0.879310_g706_i0 PRJNA358209 708 165 0.87931 1.4508615 Staphylococcus epidermidis 1282 Bacteria Bacteria 305 9.59e-79   NTclustered gi|1518959137|gb|CP033782.1| 1282 g706 i0 100 100 165 0 100 0 1 165 697328 697492 Staphylococcus epidermidis strain FDAARGOS_529 chromosome, complete genome blastn 16500 305 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
13152594 13152594 PRJNA358209_P_NODE_1051_length_162_cov_0.902655_g1049_i0 PRJNA358209 1051 162 0.902655 1.4623011 Corynebacterium accolens 38284 Bacteria Bacteria 248 1.6e-61   NTclustered gi|2550484788|gb|CP100380.1| 38284 g1049 i0 94.444 22.858024691358 162 7 100 2 1 162 1136915 1136756 Corynebacterium accolens strain CA3 chromosome blastn 3703 248 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium accolens
16375639 16375639 PRJNA358209_P_NODE_213_length_218_cov_1.579882_g211_i0 PRJNA358209 213 218 1.579882 3.44414276 root 1 Root_unresolved Root_unresolved 403 4.62e-108   NTclustered gi|1214359213|gb|MF424753.1| 1613 g211 i0 100 194 218 0 100 0 1 218 445 662 Limosilactobacillus fermentum strain CAU6386 16S ribosomal RNA gene, partial sequence blastn 42292 403 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Limosilactobacillus Limosilactobacillus fermentum
16375647 16375647 PRJNA358209_P_NODE_653_length_166_cov_0.871795_g651_i0 PRJNA358209 653 166 0.871795 1.4471797 Cutibacterium 1912216 Bacteria Bacteria 307 2.69e-79   NTclustered gi|966542502|gb|CP012354.1| 1747 g651 i0 100 65.3132530120482 166 0 100 0 1 166 1080107 1080272 Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome blastn 10842 307 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
16375648 16375648 PRJNA358209_P_NODE_753_length_165_cov_0.879310_g751_i0 PRJNA358209 753 165 0.87931 1.4508615 Cutibacterium 1912216 Bacteria Bacteria 305 9.59e-79   NTclustered gi|2548746222|gb|CP129004.1| 1747 g751 i0 100 50.9272727272727 165 0 100 0 1 165 2323650 2323486 Cutibacterium acnes strain EASDk81B chromosome, complete genome blastn 8403 305 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
18924624 18924624 PRJNA358209_P_NODE_255_length_206_cov_1.171975_g253_i0 PRJNA358209 255 206 1.171975 2.4142685 Cutibacterium 1912216 Bacteria Bacteria 381 2.0199999999999994e-101   NTclustered gi|966542502|gb|CP012354.1| 1747 g253 i0 100 51.2621359223301 206 0 100 0 1 206 534543 534748 Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome blastn 10560 381 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
20199224 20199224 PRJNA358209_P_NODE_1096_length_162_cov_0.902655_g1094_i0 PRJNA358209 1096 162 0.902655 1.4623011 Cutibacterium 1912216 Bacteria Bacteria 300 4.36e-77   NTclustered gi|2548746222|gb|CP129004.1| 1747 g1094 i0 100 51.6234567901235 162 0 100 0 1 162 1056023 1055862 Cutibacterium acnes strain EASDk81B chromosome, complete genome blastn 8363 300 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
21474840 21474840 PRJNA358209_P_NODE_1097_length_162_cov_0.902655_g1095_i0 PRJNA358209 1097 162 0.902655 1.4623011 Corynebacterium 1716 Bacteria Bacteria 272 9.51e-69   NTclustered gi|1986028547|gb|CP069509.1| 161879 g1095 i0 96.914 4.96296296296296 162 5 100 0 1 162 227966 228127 Corynebacterium kroppenstedtii strain FDAARGOS_1192 chromosome, complete genome blastn 804 272 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium kroppenstedtii
22750013 22750013 PRJNA358209_P_NODE_998_length_163_cov_0.894737_g996_i0 PRJNA358209 998 163 0.894737 1.45842131 Cutibacterium 1912216 Bacteria Bacteria 302 1.22e-77   NTclustered gi|966542502|gb|CP012354.1| 1747 g996 i0 100 53.478527607362 163 0 100 0 1 163 2116724 2116562 Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome blastn 8717 302 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
25299359 25299359 PRJNA358209_P_NODE_980_length_163_cov_0.894737_g978_i0 PRJNA358209 980 163 0.894737 1.45842131 Mycobacteroides 670516 Bacteria Bacteria 302 1.22e-77   NTclustered gi|1951304461|gb|CP050223.1| 1774 g978 i0 100 12.9141104294479 163 0 100 0 1 163 284759 284597 Mycobacteroides chelonae strain Myco1 chromosome blastn 2105 302 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacteroides Mycobacteroides chelonae

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