RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA557895" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJNA557895 · 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
3679600 3679600 PRJNA557895_P_NODE_33083_length_165_cov_0.879310_g32728_i0 PRJNA557895 33083 165 0.87931 1.4508615 Blastopirellula 265487 Bacteria Bacteria 233 4.5899999999999994e-57   NTclustered gi|12583963|gb|AF245367.1|AF245367 314230 g32728 i0 92.121 62.8606060606061 165 13 100 0 1 165 1819 1655 Pirellula marina 23S ribosomal RNA gene, partial sequence blastn 10372 233 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Blastopirellula Blastopirellula marina
29447028 29447028 PRJNA557895_P_NODE_21230_length_202_cov_0.888889_g20875_i0 PRJNA557895 21230 202 0.888889 1.79555578 Candidatus Brocadiaceae bacterium 2094028 Bacteria Bacteria 98.2 3.53e-24   NR MCP4267904.1 2094028 g20875 i0 70.8 0.965346534653465 65 19 96.5 0 1 195 83 147 MCP4267904.1 hypothetical protein [Candidatus Brocadiaceae bacterium] diamond 195 98.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae   Candidatus Brocadiaceae bacterium
29667908 29667908 PRJNA557895_P_NODE_28730_length_170_cov_1.685950_g28375_i0 PRJNA557895 28730 170 1.68595 2.866115 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 48.1 1.75e-4   NR MCG8430697.1 2035772 g28375 i0 43.9 1.00588235294118 57 31 98.8 1 168 1 315 371 MCG8430697.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Omnitrophota bacterium] diamond 171 48.1 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota 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);;