RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA235310" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJNA235310 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
1642143 1642143 PRJNA235310_P_NODE_2462_length_246_cov_1.284264_g2436_i0 PRJNA235310 2462 246 1.284264 3.15928944 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 339 1.5199999999999998e-88   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g2436 i0 91.6 116.829268292683 250 14 100 6 1 246 2759258 2759504 Planctomyces sp. SH-PL62, complete genome blastn 28740 339 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
2917942 2917942 PRJNA235310_P_NODE_1883_length_289_cov_1.208333_g1857_i0 PRJNA235310 1883 289 1.208333 3.49208237 Singulisphaera acidiphila 466153 Bacteria Bacteria 202 2.51e-47   NTclustered gi|430012750|gb|CP003364.1| 886293 g1857 i0 83.482 319.688581314879 224 30 76 7 66 285 7354547 7354767 Singulisphaera acidiphila DSM 18658, complete genome blastn 92390 202 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera acidiphila
9295419 9295419 PRJNA235310_P_NODE_2528_length_243_cov_0.958763_g2502_i0 PRJNA235310 2528 243 0.958763 2.32979409 Tautonia plasticadhaerens 2527974 Bacteria Bacteria 267 7.19e-67   NTclustered gi|1712713678|gb|CP036426.1| 2527974 g2502 i0 86.585 110.765432098765 246 28 100 5 1 243 267449 267206 Tautonia plasticadhaerens strain ElP chromosome blastn 26916 267 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Tautonia Tautonia plasticadhaerens

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