RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA400209" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA400209 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
2356416 2356416 PRJNA400209_P_NODE_1142_length_491_cov_1.904762_g983_i0 PRJNA400209 1142 491 1.904762 9.35238142 Cutibacterium 1912216 Bacteria Bacteria 525 2.3499999999999993e-144   NTclustered gi|1446500593|gb|CP031442.1| 1747 g983 i0 100 174.865580448065 284 0 69 0 1 284 55733 55450 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 85859 525 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
3631800 3631800 PRJNA400209_P_NODE_1463_length_390_cov_3.110803_g1290_i0 PRJNA400209 1463 390 3.110803 12.1321317 root 1 Root_unresolved Root_unresolved 721 0   NTclustered gi|1820357328|gb|MT178134.1| 1747 g1290 i0 100 100 390 0 100 0 1 390 34 423 Cutibacterium acnes strain UIS0065 16S ribosomal RNA gene, partial sequence blastn 39000 721 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
3631805 3631805 PRJNA400209_P_NODE_423_length_772_cov_1.597577_g321_i0 PRJNA400209 423 772 1.597577 12.33329444 Cutibacterium 1912216 Bacteria Bacteria 492 3.85e-134   NTclustered gi|1446500593|gb|CP031442.1| 1747 g321 i0 100 151.367875647668 266 0 61 0 193 458 55417 55682 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 116856 492 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
8733809 8733809 PRJNA400209_P_NODE_447_length_754_cov_1.540690_g343_i0 PRJNA400209 447 754 1.54069 11.6168026 Cutibacterium 1912216 Bacteria Bacteria 431 8.309999999999998e-116   NTclustered gi|1446500593|gb|CP031442.1| 1747 g343 i0 100 144.65649867374 233 0 58 0 315 547 55682 55450 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 109071 431 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
10009058 10009058 PRJNA400209_P_NODE_1268_length_440_cov_1.613139_g1104_i0 PRJNA400209 1268 440 1.613139 7.0978116 Cutibacterium 1912216 Bacteria Bacteria 278 6.45e-70   NTclustered gi|1446500593|gb|CP031442.1| 1747 g1104 i0 100 175.352272727273 150 0 72 0 1 150 55738 55887 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 77155 278 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
11284289 11284289 PRJNA400209_P_NODE_889_length_568_cov_1.181818_g744_i0 PRJNA400209 889 568 1.181818 6.71272624 Cutibacterium 1912216 Bacteria Bacteria 303 1.4e-77   NTclustered gi|770220517|gb|KP762808.1| 1747 g744 i0 100 150.095070422535 164 0 59 0 405 568 356 519 Propionibacterium acnes strain V21B7 23S ribosomal RNA gene, partial sequence blastn 85254 303 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
12559680 12559680 PRJNA400209_P_NODE_1390_length_404_cov_1.666667_g1219_i0 PRJNA400209 1390 404 1.666667 6.73333468 Actinomycetes 1760 Bacteria Bacteria 237 9.97e-58   NTclustered gi|1446500593|gb|CP031442.1| 1747 g1219 i0 98.507 145.794554455446 134 2 57 0 1 134 56191 56324 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 58901 237 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
21482695 21482695 PRJNA400209_P_NODE_357_length_830_cov_1.576779_g261_i0 PRJNA400209 357 830 1.576779 13.0872657 Cutibacterium 1912216 Bacteria Bacteria 425 4.27e-114   NTclustered gi|1446500593|gb|CP031442.1| 1747 g261 i0 99.153 169.814457831325 236 2 68 0 370 605 57236 57001 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 140946 425 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes

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