RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA796639" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA796639 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
7158942 7158942 PRJNA796639_P_NODE_6286_length_248_cov_0.880000_g6161_i0 PRJNA796639 6286 248 0.88 2.1824 Mycolicibacterium chitae 1792 Bacteria Bacteria 54.7 0.006   NTclustered gi|1806410789|dbj|AP022604.1| 1792 g6161 i0 100 0.233870967741935 29 0 12 0 28 56 4866058 4866086 Mycolicibacterium chitae JCM 12403 DNA, nearly complete genome blastn 58 54.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium chitae
12260064 12260064 PRJNA796639_P_NODE_7370_length_243_cov_0.905882_g7245_i0 PRJNA796639 7370 243 0.905882 2.20129326 Nocardioides sp. S5 2017486 Bacteria Bacteria 449 6.65e-122   NTclustered gi|1999037722|gb|CP022296.1| 2017486 g7245 i0 100 230.102880658436 243 0 100 0 1 243 1843263 1843505 Nocardioides sp. S5 chromosome, complete genome blastn 55915 449 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp. S5
13534145 13534145 PRJNA796639_P_NODE_3431_length_304_cov_1.129870_g3306_i0 PRJNA796639 3431 304 1.12987 3.4348048 Streptomyces sp. cg36 3238798 Bacteria Bacteria 52.8 0.028   NTclustered gi|2784064359|gb|CP163520.1| 3238798 g3306 i0 100 0.0921052631578947 28 0 9 0 254 281 995425 995398 Streptomyces sp. cg36 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. cg36
16519500 16519500 PRJNA796639_P_NODE_1313_length_491_cov_1.031100_g1188_i0 PRJNA796639 1313 491 1.0311 5.062701 Cutibacterium 1912216 Bacteria Bacteria 898 0   NTclustered gi|2548746222|gb|CP129004.1| 1747 g1188 i0 99.594 270.720977596741 493 0 100 1 1 491 608443 608935 Cutibacterium acnes strain EASDk81B chromosome, complete genome blastn 132924 898 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
19068301 19068301 PRJNA796639_P_NODE_4275_length_280_cov_1.681159_g4150_i0 PRJNA796639 4275 280 1.681159 4.7072452 Nocardioides 1839 Bacteria Bacteria 501 2.13e-137   NTclustered gi|1605178659|gb|CP038267.1| 2518370 g4150 i0 98.929 235.482142857143 280 3 100 0 1 280 573651 573372 Nocardioides euryhalodurans strain MMS17-SY117 chromosome, complete genome blastn 65935 501 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides euryhalodurans
25443370 25443370 PRJNA796639_P_NODE_1860_length_410_cov_2.323442_g1735_i0 PRJNA796639 1860 410 2.323442 9.5261122 Cutibacterium 1912216 Bacteria Bacteria 758 0   NTclustered gi|1446500593|gb|CP031442.1| 1747 g1735 i0 100 250.648780487805 410 0 100 0 1 410 55374 55783 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 102766 758 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);;