RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA597223" 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

  • PRJNA597223 · 6 ✖

analysis 1

  • diamond · 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
27048284 27048284 PRJNA597223_P_NODE_78622_length_159_cov_2.193548_g76776_i0 PRJNA597223 78622 159 2.193548 3.48774132 Candidatus Laterigemmans baculatus 2770505 Bacteria Bacteria 83.2 5.77e-17   NR WP_164103780.1 2770505 g76776 i0 75 0.981132075471698 52 13 98.1 0 158 3 48 99 WP_164103780.1 M20 metallopeptidase family protein [Candidatus Laterigemmans baculatus] diamond 156 83.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Candidatus Laterigemmans Candidatus Laterigemmans baculatus
27995920 27995920 PRJNA597223_S_NODE_2785_length_186_cov_1.564626_g2728_i0 PRJNA597223 2785 186 1.564626 2.91020436 Singulisphaera sp. GP187 1882752 Bacteria Bacteria 58.5 4.6e-8   NR WP_074311456.1 1882752 g2728 i0 49.2 0.983870967741935 61 31 98.4 0 185 3 38 98 WP_074311456.1 tetratricopeptide repeat protein [Singulisphaera sp. GP187] diamond 183 58.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. GP187
28437986 28437986 PRJNA597223_P_NODE_62466_length_184_cov_1.288591_g60620_i0 PRJNA597223 62466 184 1.288591 2.37100744 Planctomycetales bacterium 2053591 Bacteria Bacteria 121 3.93e-30   NR MCA9199410.1 2053591 g60620 i0 93.4 0.994565217391304 61 4 99.5 0 184 2 156 216 MCA9199410.1 hypothetical protein [Planctomycetales bacterium] diamond 183 121 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
30251400 30251400 PRJNA597223_P_NODE_74312_length_164_cov_4.465116_g72466_i0 PRJNA597223 74312 164 4.465116 7.32279024 Pseudomonadati 3379134 Bacteria Bacteria 84.7 2.83e-19   NR MFI5381397.1 2795155 g72466 i0 72.5 2.79878048780488 51 14 93.3 0 157 5 55 105 MFI5381397.1 hypothetical protein [Tepidisphaerales bacterium] diamond 459 84.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales     Tepidisphaerales bacterium
30333094 30333094 PRJNA597223_P_NODE_49332_length_199_cov_1.658537_g47486_i0 PRJNA597223 49332 199 1.658537 3.30048863 Candidatus Brocadiaceae bacterium 2094028 Bacteria Bacteria 125 3.5900000000000004e-33   NR MCP4265690.1 2094028 g47486 i0 87.7 4.89949748743719 65 8 98 0 197 3 20 84 MCP4265690.1 hypothetical protein [Candidatus Brocadiaceae bacterium] diamond 975 125 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae   Candidatus Brocadiaceae bacterium
31375545 31375545 PRJNA597223_P_NODE_29436_length_279_cov_2.450820_g27590_i0 PRJNA597223 29436 279 2.45082 6.8377878 Gemmataceae bacterium 2052164 Bacteria Bacteria 77.8 2.72e-16   NR MCI0375991.1 2052164 g27590 i0 55.2 1.2258064516129 58 26 62.4 0 268 95 38 95 MCI0375991.1 YciI family protein [Gemmataceae bacterium] diamond 342 77.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae 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);;