RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA283169 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
26838862 26838862 PRJNA283169_S_NODE_1441_length_227_cov_0.123596_g1427_i0 PRJNA283169 1441 227 0.123596 0.28056292 Pirellula 123 Bacteria Bacteria 118 6.23e-29   NR HUP77528.1 117 g1427 i0 73 1.95594713656388 74 20 97.8 0 2 223 283 356 HUP77528.1 isoleucine--tRNA ligase [Pirellula sp.] diamond 444 118 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
27042527 27042527 PRJNA283169_P_NODE_462_length_569_cov_1.648077_g405_i0 PRJNA283169 462 569 1.648077 9.37755813 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 87.4 4.45e-17   NR MDR4496880.1 2268189 g405 i0 52.8 0.764499121265378 72 34 38 0 555 340 142 213 MDR4496880.1 FRG domain-containing protein [Candidatus Scalindua sp.] diamond 435 87.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
27168728 27168728 PRJNA283169_P_NODE_3742_length_215_cov_1.240964_g3679_i0 PRJNA283169 3742 215 1.240964 2.6680726 Humisphaera borealis 2807512 Bacteria Bacteria 103 8.690000000000001e-27   NR WP_206294221.1 2807512 g3679 i0 77.8 0.87906976744186 63 14 87.9 0 16 204 1 63 WP_206294221.1 PilZ domain-containing protein [Humisphaera borealis] diamond 189 103 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
28558598 28558598 PRJNA283169_P_NODE_907_length_408_cov_0.991643_g845_i0 PRJNA283169 907 408 0.991643 4.04590344 Gimesia chilikensis 2605989 Bacteria Bacteria 86.3 1.01e-16   NR WP_149339017.1 2605989 g845 i0 51.9 1.16176470588235 79 38 58.1 0 171 407 281 359 WP_149339017.1 CynX/NimT family MFS transporter [Gimesia chilikensis] diamond 474 86.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia chilikensis
28874107 28874107 PRJNA283169_P_NODE_4068_length_208_cov_0.899371_g4005_i0 PRJNA283169 4068 208 0.899371 1.87069168 Planctomycetales bacterium 2053591 Bacteria Bacteria 54.7 1.43e-6   NR MCA9184911.1 2053591 g4005 i0 44.4 2.01923076923077 72 31 92.3 4 3 194 5187 5257 MCA9184911.1 M10 family metallopeptidase C-terminal domain-containing protein [Planctomycetales bacterium] diamond 420 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
30136930 30136930 PRJNA283169_P_NODE_7812_length_163_cov_0.912281_g7749_i0 PRJNA283169 7812 163 0.912281 1.48701803 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 82.8 5.95e-17   NR MCR4343334.1 2268189 g7749 i0 72.2 0.993865030674847 54 15 99.4 0 162 1 41 94 MCR4343334.1 phage major capsid protein [Candidatus Scalindua sp.] diamond 162 82.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
30579395 30579395 PRJNA283169_P_NODE_5373_length_184_cov_1.896296_g5310_i0 PRJNA283169 5373 184 1.896296 3.48918464 Aureliella helgolandensis 2527968 Bacteria Bacteria 46.2 9.99e-4   NR WP_145078911.1 2527968 g5310 i0 39.7 1.89130434782609 58 35 94.6 0 182 9 1322 1379 WP_145078911.1 hypothetical protein [Aureliella helgolandensis] diamond 348 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Aureliella Aureliella helgolandensis
30850030 30850030 PRJNA283169_P_NODE_7894_length_163_cov_0.894737_g7831_i0 PRJNA283169 7894 163 0.894737 1.45842131 Bacteria 2 Bacteria Bacteria 78.6 1.58e-15   NR QKK07071.1 2026780 g7831 i0 64.8 1.98773006134969 54 19 99.4 0 1 162 197 250 QKK07071.1 MAG: S8 family serine peptidase [Planctomycetota bacterium] diamond 324 78.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30990540 30990540 PRJNA283169_S_NODE_1874_length_205_cov_0.064103_g1860_i0 PRJNA283169 1874 205 0.064103 0.13141115 Gemmataceae bacterium 2052164 Bacteria Bacteria 50.8 1.64e-5   NR MBX9682125.1 2052164 g1860 i0 44 0.731707317073171 50 28 73.2 0 152 3 1 50 MBX9682125.1 hypothetical protein [Gemmataceae bacterium] diamond 150 50.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31432923 31432923 PRJNA283169_S_NODE_2036_length_198_cov_0.120805_g2022_i0 PRJNA283169 2036 198 0.120805 0.2391939 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0109   NR HEY3320097.1 2026780 g2022 i0 44.7 1.10606060606061 38 21 57.6 0 50 163 323 360 HEY3320097.1 glycosyl hydrolase family 28-related protein [Planctomycetota bacterium] diamond 219 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31780745 31780745 PRJNA283169_P_NODE_3237_length_231_cov_0.857143_g3174_i0 PRJNA283169 3237 231 0.857143 1.98000033 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0443   NR MBN9118449.1 2026780 g3174 i0 33.3 0.935064935064935 72 44 88.3 1 210 7 116 187 MBN9118449.1 protein kinase [Planctomycetota bacterium] diamond 216 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31780754 31780754 PRJNA283169_S_NODE_2037_length_198_cov_0.107383_g2023_i0 PRJNA283169 2037 198 0.107383 0.21261834 Planctomycetota bacterium 2026780 Bacteria Bacteria 120 7.659999999999999e-31   NR MCY2982620.1 2026780 g2023 i0 83.1 2.95454545454545 65 11 98.5 0 2 196 251 315 MCY2982620.1 hypothetical protein [Planctomycetota bacterium] diamond 585 120 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32477139 32477139 PRJNA283169_S_NODE_2219_length_191_cov_0.176056_g2205_i0 PRJNA283169 2219 191 0.176056 0.33626696 Phycisphaerae bacterium 2026778 Bacteria Bacteria 49.3 7.87e-5   NR MBL9150778.1 2026778 g2205 i0 55.8 1.30366492146597 43 18 66 1 131 6 5 47 MBL9150778.1 ATP-binding protein [Phycisphaerae bacterium] diamond 249 49.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae 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);;