RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA242641" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA242641 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
1056716 1056716 PRJNA242641_S_NODE_1701_length_177_cov_4.871622_g1673_i0 PRJNA242641 1701 177 4.871622 8.62277094 Corynebacterium 1716 Bacteria Bacteria 311 2.23e-80   NTclustered gi|2869804070|gb|CP175770.1| 38304 g1673 i0 99.415 361.717514124294 171 1 100 0 1 171 623415 623585 Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome blastn 64024 311 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium tuberculostearicum
4884646 4884646 PRJNA242641_S_NODE_1384_length_197_cov_11.875000_g1356_i0 PRJNA242641 1384 197 11.875 23.39375 Cutibacterium 1912216 Bacteria Bacteria 357 3.23e-94   NTclustered gi|1446500593|gb|CP031442.1| 1747 g1356 i0 99.49 210.893401015228 196 1 99 0 2 197 55152 54957 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 41546 357 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
4884650 4884650 PRJNA242641_S_NODE_44_length_911_cov_13.003401_g38_i0 PRJNA242641 44 911 13.003401 118.46098311 Cutibacterium 1912216 Bacteria Bacteria 1677 0   NTclustered gi|1446500593|gb|CP031442.1| 1747 g38 i0 99.89 283.479692645445 911 1 100 0 1 911 55360 56270 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 258250 1677 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
8709361 8709361 PRJNA242641_S_NODE_867_length_246_cov_11.852535_g839_i0 PRJNA242641 867 246 11.852535 29.1572361 Cutibacterium 1912216 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|1446500593|gb|CP031442.1| 1747 g839 i0 100 264.239837398374 246 0 100 0 1 246 56541 56296 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 65003 455 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
13810088 13810088 PRJNA242641_S_NODE_2431_length_151_cov_2.106557_g2403_i0 PRJNA242641 2431 151 2.106557 3.18090107 Micrococcus 1269 Bacteria Bacteria 274 2.42e-69   NTclustered gi|1949953231|gb|CP066288.1| 1270 g2403 i0 99.338 72.0993377483444 151 1 100 0 1 151 2260610 2260760 Micrococcus luteus strain FDAARGOS_1034 chromosome blastn 10887 274 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
15084237 15084237 PRJNA242641_S_NODE_392_length_370_cov_22.636364_g364_i0 PRJNA242641 392 370 22.636364 83.7545468 Cutibacterium 1912216 Bacteria Bacteria 673 0   NTclustered gi|1446500593|gb|CP031442.1| 1747 g364 i0 99.459 192.383783783784 370 2 100 0 1 370 53961 53592 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 71182 673 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
16359095 16359095 PRJNA242641_S_NODE_2093_length_161_cov_3.272727_g2065_i0 PRJNA242641 2093 161 3.272727 5.26909047 Micrococcus 1269 Bacteria Bacteria 298 1.56e-76   NTclustered gi|1891023613|gb|CP058971.1| 1270 g2065 i0 100 295.478260869565 161 0 100 0 1 161 345561 345721 Micrococcus luteus strain V017 chromosome, complete genome blastn 47572 298 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
18908120 18908120 PRJNA242641_S_NODE_835_length_251_cov_8.324324_g807_i0 PRJNA242641 835 251 8.324324 20.89405324 Micrococcus 1269 Bacteria Bacteria 407 4.2099999999999995e-109   NTclustered gi|1891023613|gb|CP058971.1| 1270 g807 i0 100 295.107569721116 220 0 88 0 32 251 346157 346376 Micrococcus luteus strain V017 chromosome, complete genome blastn 74072 407 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
22733458 22733458 PRJNA242641_S_NODE_638_length_288_cov_9.505792_g610_i0 PRJNA242641 638 288 9.505792 27.37668096 Corynebacterium 1716 Bacteria Bacteria 521 1.69e-143   NTclustered gi|2547420364|gb|CP073093.1| 38304 g610 i0 99.306 365.041666666667 288 2 100 0 1 288 760220 759933 Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome blastn 105132 521 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium tuberculostearicum
24008628 24008628 PRJNA242641_S_NODE_459_length_344_cov_4.123810_g431_i0 PRJNA242641 459 344 4.12381 14.1859064 Corynebacterium 1716 Bacteria Bacteria 636 7.059999999999998e-178   NTclustered gi|2869804070|gb|CP175770.1| 38304 g431 i0 100 341.723837209302 344 0 100 0 1 344 621728 622071 Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome blastn 117553 636 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium tuberculostearicum
25282763 25282763 PRJNA242641_S_NODE_220_length_498_cov_10.671642_g38_i1 PRJNA242641 220 498 10.671642 53.14477716 Cutibacterium 1912216 Bacteria Bacteria 761 0   NTclustered gi|966537955|gb|CP012352.1| 1747 g38 i1 95.588 244.367469879518 476 20 95 1 1 475 1775154 1775629 Cutibacterium acnes strain PA_15_2_L1 chromosome, complete genome blastn 121695 761 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
25282765 25282765 PRJNA242641_S_NODE_2360_length_152_cov_8.373984_g2332_i0 PRJNA242641 2360 152 8.373984 12.72845568 Corynebacterium 1716 Bacteria Bacteria 268 1.13e-67   NTclustered gi|2550471320|gb|CP100376.1| 38284 g2332 i0 99.324 356.315789473684 148 1 97 0 1 148 2342309 2342456 Corynebacterium accolens strain CA7 chromosome blastn 54160 268 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium accolens

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