RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA816047 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
25728699 25728699 PRJNA816047a_S_NODE_33050_length_360_cov_1.153310_g30390_i0 PRJNA816047 33050 360 1.15331 4.151916 Planctomyces sp. SH-PL14 1632864 Bacteria Bacteria 52.8 0.034   NTclustered gi|1015434452|gb|CP011270.1| 1632864 g30390 i0 92.308 0.108333333333333 39 0 10 2 26 61 8434915 8434953 Planctomyces sp. SH-PL14, complete genome blastn 39 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
25740677 25740677 PRJNA816047d_S_NODE_48114_length_317_cov_1.912879_g46279_i0 PRJNA816047 48114 317 1.912879 6.06382643 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 159 1.7e-34   NTclustered gi|2814788363|emb|OY780964.2| 2691551 g46279 i0 85.35 11.8485804416404 157 19 49 4 4 158 1564587 1564741 MAG: Thermoguttaceae bacterium isolate 5d2646e0-01ad-46f9-a460-09296c79865c genome assembly, chromosome: 1 blastn 3756 159 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
25742854 25742854 PRJNA816047d_S_NODE_94722_length_253_cov_2.720000_g92887_i0 PRJNA816047 94722 253 2.72 6.8816 Gemmataceae bacterium 2052164 Bacteria Bacteria 158 4.729999999999999e-34   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g92887 i0 85.065 0.608695652173913 154 23 61 0 27 180 2929075 2929228 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 154 158 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
25866104 25866104 PRJNA816047a_S_NODE_51443_length_293_cov_1.172727_g48783_i0 PRJNA816047 51443 293 1.172727 3.43609011 Planctomycetales bacterium 2053591 Bacteria Bacteria 52.8 0.027   NTclustered gi|2210174292|gb|CP060262.1| 2053591 g48783 i0 100 0.0955631399317406 28 0 10 0 204 231 3594886 3594913 MAG: Planctomycetales bacterium isolate HK-STAS-UBP7_A-1 chromosome, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
25876115 25876115 PRJNA816047d_S_NODE_41491_length_336_cov_4.494700_g39656_i0 PRJNA816047 41491 336 4.4947 15.102192 Aureliella sp. 2795609 Bacteria Bacteria 93.5 1.87e-14   NTclustered gi|2626244095|emb|OY829846.1| 2795609 g39656 i0 96.429 19.2083333333333 56 2 17 0 156 211 5751578 5751523 MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1 blastn 6454 93.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Aureliella Aureliella sp.
26143612 26143612 PRJNA816047b_S_NODE_39917_length_270_cov_1.558376_g37605_i0 PRJNA816047 39917 270 1.558376 4.2076152 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 156 1.83e-33   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g37605 i0 81.026 1.17037037037037 195 37 72 0 76 270 2457860 2457666 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 316 156 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium

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