RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA549880", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 4 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA549880 · 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
1787269 1787269 PRJNA549880_P_NODE_12722_length_247_cov_0.885057_g12629_i0 PRJNA549880 12722 247 0.885057 2.18609079 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 243 1.23e-59   NTclustered gi|1938775668|gb|CP054178.1| 2026777 g12629 i0 87.383 191.506072874494 214 23 85 4 1 211 194138 194350 MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome blastn 47302 243 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
30235897 30235897 PRJNA549880_P_NODE_15212_length_242_cov_0.911243_g15119_i0 PRJNA549880 15212 242 0.911243 2.20520806 Candidatus Brocadiales bacterium 2760054 Bacteria Bacteria 42 0.0368   NR MEE9200699.1 2760054 g15119 i0 65 0.247933884297521 20 7 24.8 0 175 116 30 49 MEE9200699.1 cytochrome C [Candidatus Brocadiales bacterium] diamond 60 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales     Candidatus Brocadiales bacterium
30299518 30299518 PRJNA549880_P_NODE_15272_length_242_cov_0.911243_g15179_i0 PRJNA549880 15272 242 0.911243 2.20520806 Anatilimnocola aggregata 2528021 Bacteria Bacteria 137 3.0599999999999995e-37   NR WP_202921142.1 2528021 g15179 i0 88.6 0.979338842975207 79 9 97.9 0 1 237 184 262 WP_202921142.1 NAD(P)H-dependent glycerol-3-phosphate dehydrogenase [Anatilimnocola aggregata] diamond 237 137 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Anatilimnocola Anatilimnocola aggregata
31689723 31689723 PRJNA549880_P_NODE_9637_length_261_cov_1.638298_g9544_i0 PRJNA549880 9637 261 1.638298 4.27595778 Phycisphaerales bacterium 2052180 Bacteria Bacteria 49.7 1.6e-4   NR MBT3202658.1 2052180 g9544 i0 62.1 0.333333333333333 29 11 33.3 0 155 69 439 467 MBT3202658.1 DUF1593 domain-containing protein [Phycisphaerales bacterium] diamond 87 49.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales 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);;