RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA560029" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA560029 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
4958540 4958540 PRJNA560029_S_NODE_34124_length_245_cov_0.895349_g33900_i0 PRJNA560029 34124 245 0.895349 2.19360505 Cutibacterium 1912216 Bacteria Bacteria 364 2.5e-96   NTclustered gi|1446500593|gb|CP031442.1| 1747 g33900 i0 100 40.3551020408163 197 0 80 0 49 245 599640 599444 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 9887 364 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
8783331 8783331 PRJNA560029_S_NODE_23427_length_286_cov_5.173709_g23203_i0 PRJNA560029 23427 286 5.173709 14.79680774 Cutibacterium 1912216 Bacteria Bacteria 529 1e-145   NTclustered gi|1446500593|gb|CP031442.1| 1747 g23203 i0 100 63.7867132867133 286 0 100 0 1 286 2511957 2512242 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 18243 529 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
9472509 9472509 PRJNA560029_S_NODE_23408_length_286_cov_9.450704_g23184_i0 PRJNA560029 23408 286 9.450704 27.02901344 Streptomyces caniscabiei 2746961 Bacteria Bacteria 63.9 1.22e-5   NTclustered gi|2459819783|gb|CP119182.1| 2746961 g23184 i0 97.297 0.227272727272727 37 1 13 0 250 286 5222481 5222517 Streptomyces caniscabiei strain ID03-3A chromosome, complete genome blastn 65 63.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces caniscabiei
10748270 10748270 PRJNA560029_S_NODE_24409_length_282_cov_2.550239_g24185_i0 PRJNA560029 24409 282 2.550239 7.19167398 Mycobacteroides chelonae 1774 Bacteria Bacteria 54.7 0.007   NTclustered gi|2452106090|gb|CP118919.1| 1774 g24185 i0 100 0.308510638297872 29 0 10 0 3 31 2438638 2438610 Mycobacteroides chelonae strain MCHL-2035 chromosome, complete genome blastn 87 54.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacteroides Mycobacteroides chelonae
12023413 12023413 PRJNA560029_S_NODE_9850_length_368_cov_4.169492_g9626_i0 PRJNA560029 9850 368 4.169492 15.34373056 Brevibacterium casei 33889 Bacteria Bacteria 680 0   NTclustered gi|1958263390|gb|CP068173.1| 33889 g9626 i0 100 8.92934782608696 368 0 100 0 1 368 423891 424258 Brevibacterium casei strain FDAARGOS_1100 chromosome, complete genome blastn 3286 680 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium casei
13884288 13884288 PRJNA560029_S_NODE_31211_length_254_cov_1.458564_g30987_i0 PRJNA560029 31211 254 1.458564 3.70475256 Cutibacterium 1912216 Bacteria Bacteria 470 5.37e-128   NTclustered gi|1446500593|gb|CP031442.1| 1747 g30987 i0 100 277.992125984252 254 0 100 0 1 254 57794 58047 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 70610 470 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
18395699 18395699 PRJNA560029_S_NODE_18555_length_310_cov_2.021097_g18331_i0 PRJNA560029 18555 310 2.021097 6.2654007 Brevibacterium casei 33889 Bacteria Bacteria 573 4.999999999999998e-159   NTclustered gi|1958263390|gb|CP068173.1| 33889 g18331 i0 100 289.432258064516 310 0 100 0 1 310 173081 172772 Brevibacterium casei strain FDAARGOS_1100 chromosome, complete genome blastn 89724 573 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium casei
20256961 20256961 PRJNA560029_S_NODE_14856_length_331_cov_4.682171_g14632_i0 PRJNA560029 14856 331 4.682171 15.49798601 Cutibacterium 1912216 Bacteria Bacteria 612 1.14e-170   NTclustered gi|1446500593|gb|CP031442.1| 1747 g14632 i0 100 276.876132930514 331 0 100 0 1 331 55858 55528 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 91646 612 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
23496068 23496068 PRJNA560029_S_NODE_12319_length_348_cov_4.578182_g12095_i0 PRJNA560029 12319 348 4.578182 15.93207336 Lawsonella clevelandensis 1528099 Bacteria Bacteria 621 1.9999999999999997e-173   NTclustered gi|1723592958|emb|LR584267.1| 1528099 g12095 i0 98.851 291.23275862069 348 4 100 0 1 348 553604 553257 Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1 blastn 101349 621 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
24769915 24769915 PRJNA560029_S_NODE_10380_length_364_cov_1.766323_g10156_i0 PRJNA560029 10380 364 1.766323 6.42941572 Janibacter limosus 53458 Bacteria Bacteria 381 3.879999999999999e-101   NTclustered gi|2552390073|gb|CP087977.2| 53458 g10156 i0 85.754 0.983516483516483 358 51 98 0 7 364 1812585 1812942 Janibacter limosus strain P1(28)-3 chromosome, complete genome blastn 358 381 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Janibacter Janibacter limosus

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