RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA849822" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA849822 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
3389437 3389437 PRJNA849822_P_NODE_41703_length_244_cov_0.894737_g41529_i0 PRJNA849822 41703 244 0.894737 2.18315828 Planctomycetota bacterium 2026780 Bacteria Bacteria 60.2 1.32e-4   NTclustered gi|2108175171|gb|CP070715.1| 2026780 g41529 i0 81.69 0.549180327868853 71 13 29 0 174 244 75048 75118 MAG: Planctomycetota bacterium isolate bin49 chromosome blastn 134 60.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
9766772 9766772 PRJNA849822_P_NODE_39348_length_246_cov_1.092486_g39174_i0 PRJNA849822 39348 246 1.092486 2.68751556 Roseimaritima ulvae 980254 Bacteria Bacteria 309 1.19e-79   NTclustered gi|1727550343|gb|CP042914.1| 980254 g39174 i0 90.295 52.0772357723577 237 21 96 2 11 246 6158479 6158244 Roseimaritima ulvae strain UC8 chromosome, complete genome blastn 12811 309 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Roseimaritima Roseimaritima ulvae
18689920 18689920 PRJNA849822_P_NODE_2495_length_1042_cov_3.850361_g2366_i0 PRJNA849822 2495 1042 3.850361 40.12076162 Singulisphaera acidiphila 466153 Bacteria Bacteria 69.4 1.05e-6   NTclustered gi|430012750|gb|CP003364.1| 886293 g2366 i0 83.333 0.0748560460652591 78 10 7 1 848 925 2170801 2170727 Singulisphaera acidiphila DSM 18658, complete genome blastn 78 69.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera acidiphila
19965122 19965122 PRJNA849822_P_NODE_3616_length_851_cov_3.514139_g3459_i0 PRJNA849822 3616 851 3.514139 29.90532289 Bremerella volcania 2527984 Bacteria Bacteria 913 0   NTclustered gi|1712647354|gb|CP036289.1| 2527984 g3459 i0 86.163 120.137485311398 860 101 99 12 6 851 2674752 2673897 Bremerella volcania strain Pan97 chromosome, complete genome blastn 102237 913 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Bremerella Bremerella volcania

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