RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA734313" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA734313 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
1196731 1196731 PRJNA734313_S_NODE_8421_length_321_cov_2.653285_g8308_i0 PRJNA734313 8421 321 2.653285 8.51704485 Cutibacterium 1912216 Bacteria Bacteria 593 3.9899999999999986e-165   NTclustered gi|1446500593|gb|CP031442.1| 1747 g8308 i0 100 273.647975077882 321 0 100 0 1 321 55854 55534 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 87841 593 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
5025022 5025022 PRJNA734313_S_NODE_26444_length_180_cov_1.458647_g26331_i0 PRJNA734313 26444 180 1.458647 2.6255646 Corynebacterium 1716 Bacteria Bacteria 322 1.05e-83   NTclustered gi|2547420364|gb|CP073093.1| 38304 g26331 i0 98.889 356.95 180 2 100 0 1 180 293809 293988 Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome blastn 64251 322 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium tuberculostearicum
8370014 8370014 PRJNA734313_S_NODE_4207_length_419_cov_3.002688_g4097_i0 PRJNA734313 4207 419 3.002688 12.58126272 Brevibacterium casei 33889 Bacteria Bacteria 728 0   NTclustered gi|1943100173|gb|CP065629.1| 33889 g4097 i0 100 274.644391408115 394 0 94 0 26 419 598230 598623 Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome blastn 115076 728 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium casei
8370030 8370030 PRJNA734313_S_NODE_9807_length_300_cov_1.458498_g9694_i0 PRJNA734313 9807 300 1.458498 4.375494 Brevibacterium casei 33889 Bacteria Bacteria 555 1.7399999999999995e-153   NTclustered gi|1943100173|gb|CP065629.1| 33889 g9694 i0 100 312.716666666667 300 0 100 0 1 300 599712 599413 Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome blastn 93815 555 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium casei
10125342 10125342 PRJNA734313_S_NODE_1988_length_525_cov_3.364017_g1882_i0 PRJNA734313 1988 525 3.364017 17.66108925 Cutibacterium 1912216 Bacteria Bacteria 970 0   NTclustered gi|1446500593|gb|CP031442.1| 1747 g1882 i0 100 272.038095238095 525 0 100 0 1 525 57384 56860 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 142820 970 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
12676356 12676356 PRJNA734313_S_NODE_31150_length_165_cov_1.296610_g31037_i0 PRJNA734313 31150 165 1.29661 2.1394065 Rhodococcus 1827 Bacteria Bacteria 305 9.59e-79   NTclustered gi|2660106423|gb|CP138905.1| 1831 g31037 i0 100 404.806060606061 165 0 100 0 1 165 559208 559372 MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome blastn 66793 305 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus sp. (in: high G+C Gram-positive bacteria)
13950682 13950682 PRJNA734313_S_NODE_35231_length_159_cov_1.821429_g35118_i0 PRJNA734313 35231 159 1.821429 2.89607211 Cutibacterium 1912216 Bacteria Bacteria 294 1.98e-75   NTclustered gi|1446500593|gb|CP031442.1| 1747 g35118 i0 100 279.14465408805 159 0 100 0 1 159 56703 56861 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 44384 294 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
13950684 13950684 PRJNA734313_S_NODE_5491_length_382_cov_1.904478_g5378_i0 PRJNA734313 5491 382 1.904478 7.27510596 Cutibacterium 1912216 Bacteria Bacteria 701 0   NTclustered gi|1446500593|gb|CP031442.1| 1747 g5378 i0 99.738 274.230366492147 382 1 100 0 1 382 56116 56497 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 104756 701 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
18568464 18568464 PRJNA734313_S_NODE_14775_length_245_cov_1.030303_g14662_i0 PRJNA734313 14775 245 1.030303 2.52424235 Lawsonella clevelandensis 1528099 Bacteria Bacteria 385 1.92e-102   NTclustered gi|1723592958|emb|LR584267.1| 1528099 g14662 i0 98.182 327.334693877551 220 4 90 0 1 220 552822 553041 Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1 blastn 80197 385 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
20323269 20323269 PRJNA734313_S_NODE_19676_length_210_cov_2.503067_g19563_i0 PRJNA734313 19676 210 2.503067 5.2564407 Cutibacterium 1912216 Bacteria Bacteria 388 1.24e-103   NTclustered gi|1446500593|gb|CP031442.1| 1747 g19563 i0 100 50.9857142857143 210 0 100 0 1 210 964095 964304 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 10707 388 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
21598949 21598949 PRJNA734313_S_NODE_33377_length_162_cov_0.886957_g33264_i0 PRJNA734313 33377 162 0.886957 1.43687034 Microlunatus 29404 Bacteria Bacteria 217 4.5199999999999996e-52   NTclustered gi|470475867|ref|NR_076305.1| 29405 g33264 i0 90.741 82.0061728395062 162 15 100 0 1 162 245 406 Microlunatus phosphovorus strain NM-1 23S ribosomal RNA gene, complete sequence blastn 13285 217 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Microlunatus Microlunatus phosphovorus
24943148 24943148 PRJNA734313_S_NODE_11180_length_281_cov_1.961538_g11067_i0 PRJNA734313 11180 281 1.961538 5.51192178 Lawsonella clevelandensis 1528099 Bacteria Bacteria 448 2.8299999999999996e-121   NTclustered gi|1723592958|emb|LR584267.1| 1528099 g11067 i0 95.374 279.818505338078 281 13 100 0 1 281 551905 552185 Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1 blastn 78629 448 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
24943157 24943157 PRJNA734313_S_NODE_18220_length_219_cov_1.662791_g18107_i0 PRJNA734313 18220 219 1.662791 3.64151229 Actinomyces naeslundii 1655 Bacteria Bacteria 374 3.64e-99   NTclustered gi|1948661326|gb|CP066049.1| 1655 g18107 i0 97.696 548.65296803653 217 5 99 0 3 219 295494 295710 Actinomyces naeslundii strain FDAARGOS_1037 chromosome, complete genome blastn 120155 374 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces naeslundii
25423413 25423413 PRJNA734313_S_NODE_33660_length_162_cov_0.886957_g33547_i0 PRJNA734313 33660 162 0.886957 1.43687034 Gardnerella 2701 Bacteria Bacteria 300 4.36e-77   NTclustered gi|470485651|ref|NR_076711.1| 2702 g33547 i0 100 292.913580246914 162 0 100 0 1 162 1013 852 Gardnerella vaginalis strain 409-05 23S ribosomal RNA gene, complete sequence blastn 47452 300 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Gardnerella Gardnerella vaginalis

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