RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax_phylum = "candidate division WOR-3"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • candidate division WOR-3 · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA432257 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_kingdom 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
14458632 14458632 PRJNA432257_S_NODE_49792_length_231_cov_77.592784_g49411_i0 PRJNA432257 49792 231 77.592784 179.23933104 Bacteria 2 Bacteria Bacteria 128 6.649999999999999e-37   NR MEO0075705.1 2052148 g49411 i0 93.4 1.66233766233766 61 4 79.2 0 47 229 1 61 MEO0075705.1 DNA methyltransferase [candidate division WOR-3 bacterium] diamond 384 129 0.992248062015504 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
14459136 14459136 PRJNA432257_S_NODE_90872_length_183_cov_39.705479_g90491_i0 PRJNA432257 90872 183 39.705479 72.66102657 Pseudomonadati 3379134 Bacteria Bacteria 80.9 5.96e-16   NR MEO0212837.1 2052148 g90491 i0 72.9 3.9344262295082 48 13 78.7 0 176 33 190 237 MEO0212837.1 type III-B CRISPR-associated protein Cas10/Cmr2 [candidate division WOR-3 bacterium] diamond 720 81.3 0.995079950799508 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
26949158 26949158 PRJNA432257_S_NODE_50302_length_230_cov_250.160622_g49921_i0 PRJNA432257 50302 230 250.160622 575.3694306 candidate division WOR-3 bacterium 2052148 Bacteria Bacteria 131 1.43e-33   NR MEO0074991.1 2052148 g49921 i0 92.2 0.834782608695652 64 5 83.5 0 194 3 619 682 MEO0074991.1 ATP-binding protein [candidate division WOR-3 bacterium] diamond 192 131 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
28875850 28875850 PRJNA432257_S_NODE_74688_length_198_cov_12.136646_g74307_i0 PRJNA432257 74688 198 12.136646 24.03055908 candidate division WOR-3 bacterium 2052148 Bacteria Bacteria 53.9 2.16e-6   NR MEO0209414.1 2052148 g74307 i0 90 0.454545454545455 30 3 45.5 0 156 67 255 284 MEO0209414.1 type III-B CRISPR module RAMP protein Cmr4 [candidate division WOR-3 bacterium] diamond 90 53.9 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
29270997 29270997 PRJNA432257_S_NODE_80389_length_192_cov_161.148387_g80008_i0 PRJNA432257 80389 192 161.148387 309.40490304 Bacteria 2 Bacteria Bacteria 58.2 6.77e-8   NR MCK4234440.1 2052148 g80008 i0 52.5 6.6875 61 28 93.8 1 12 191 370 430 MCK4234440.1 DNA gyrase subunit A [candidate division WOR-3 bacterium] diamond 1284 58.2 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
29349552 29349552 PRJNA432257_S_NODE_22629_length_309_cov_1.466912_g22248_i0 PRJNA432257 22629 309 1.466912 4.53275808 candidate division WOR-3 bacterium 2052148 Bacteria Bacteria 51.6 2.34e-5   NR MCK4328275.1 2052148 g22248 i0 45.8 0.699029126213592 72 35 67 4 97 303 31 101 MCK4328275.1 hypothetical protein [candidate division WOR-3 bacterium] diamond 216 51.6 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 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);;