RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA534016" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA534016 · 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
1782860 1782860 PRJNA534016_P_NODE_16982_length_244_cov_0.900585_g16892_i0 PRJNA534016 16982 244 0.900585 2.1974274 Planctomycetota bacterium 2026780 Bacteria Bacteria 54.7 0.006   NTclustered gi|2621705096|emb|OY763323.1| 2026780 g16892 i0 94.444 0.147540983606557 36 1 15 1 120 155 720407 720441 MAG: Planctomycetota bacterium isolate 3a5a21b3-ef55-46fa-90a9-c954c41cad77 genome assembly, chromosome: 1 blastn 36 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
8160211 8160211 PRJNA534016_P_NODE_12487_length_259_cov_3.010753_g12397_i0 PRJNA534016 12487 259 3.010753 7.79785027 uncultured Verrucomicrobia subdivision 3 bacterium 257465 Bacteria Bacteria 479 9.13e-131   NTclustered gi|378401408|emb|HE648177.1| 257465 g12397 i0 100 98.4362934362934 259 0 100 0 1 259 1413 1155 Uncultured Verrucomicrobia subdivision 3 bacterium partial 16S rRNA gene, clone P3 blastn 25495 479 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales     uncultured Verrucomicrobia subdivision 3 bacterium
23459766 23459766 PRJNA534016_P_NODE_2619_length_505_cov_3.164352_g2529_i0 PRJNA534016 2619 505 3.164352 15.9799776 Roseimaritima multifibrata 1930274 Bacteria Bacteria 54.7 0.014   NTclustered gi|1712444166|gb|CP036262.1| 1930274 g2529 i0 94.286 0.0693069306930693 35 2 7 0 368 402 5343731 5343697 Roseimaritima multifibrata strain FF011L chromosome, complete genome blastn 35 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Roseimaritima Roseimaritima multifibrata
23459782 23459782 PRJNA534016_P_NODE_3699_length_427_cov_0.870056_g3609_i0 PRJNA534016 3699 427 0.870056 3.71513912 Kolteria novifilia 2527975 Bacteria Bacteria 285 3.73e-72   NTclustered gi|1712629967|gb|CP036279.1| 2527975 g3609 i0 79.487 138.47775175644 429 67 100 12 1 427 1830635 1830226 Planctomycetes bacterium Pan216 chromosome, complete genome blastn 59130 285 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Kolteriales Kolteriaceae Kolteria Kolteria novifilia

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