RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA407087", tax_kingdom = "Bacillati" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 9 ✖

tax_kingdom 1

  • Bacillati · 9 ✖

bioproject 1

  • PRJNA407087 · 9 ✖

analysis 1

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
26632292 26632292 PRJNA407087_S_NODE_301_length_1388_cov_13.946284_g185_i0 PRJNA407087 301 1388 13.946284 193.57442192 Nostoc cycadae 246795 Bacteria Bacteria 79 1.88e-12   NR WP_245894956.1 246795 g185 i0 32 0.419308357348703 194 115 39.6 5 1358 810 50 237 WP_245894956.1 CAP domain-containing protein [Nostoc cycadae] diamond 582 79 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc cycadae
26663623 26663623 PRJNA407087_S_NODE_4241_length_266_cov_4.603376_g3778_i0 PRJNA407087 4241 266 4.603376 12.24498016 Symploca sp. SIO2E6 2607809 Bacteria Bacteria 42.7 0.0427   NR NET60595.1 2607809 g3778 i0 34.2 0.823308270676692 73 47 82.3 1 253 35 114 185 NET60595.1 CAP domain-containing protein [Symploca sp. SIO2E6] diamond 219 42.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Symploca Symploca sp. SIO2E6
27075430 27075430 PRJNA407087_S_NODE_4762_length_243_cov_4.252336_g4299_i0 PRJNA407087 4762 243 4.252336 10.33317648 Cyanobacteria bacterium SBLK 2821505 Bacteria Bacteria 64.3 9.2e-10   NR MBP0022171.1 2821505 g4299 i0 51.9 2.03703703703704 54 26 66.7 0 242 81 303 356 MBP0022171.1 colicin uptake protein [Cyanobacteria bacterium SBLK] diamond 495 64.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SBLK
28023092 28023092 PRJNA407087_S_NODE_1845_length_490_cov_8.340564_g835_i1 PRJNA407087 1845 490 8.340564 40.8687636 Nostocaceae cyanobacterium 2723028 Bacteria Bacteria 78.6 2.39e-14   NR MDJ0736756.1 2723028 g835 i1 39.1 7.7265306122449 156 78 94.9 7 482 18 59 198 MDJ0736756.1 CAP domain-containing protein [Nostocaceae cyanobacterium] diamond 3786 78.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae   Nostocaceae cyanobacterium
28370258 28370258 PRJNA407087_S_NODE_3906_length_283_cov_3.677165_g3443_i0 PRJNA407087 3906 283 3.677165 10.40637695 Cyanobacteria bacterium J06635_10 3023201 Bacteria Bacteria 55.5 1.25e-6   NR MEO1373427.1 3023201 g3443 i0 41.6 0.816254416961131 77 42 81.6 2 232 2 59 132 MEO1373427.1 CAP domain-containing protein [Cyanobacteria bacterium J06635_10] diamond 231 55.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06635_10
28654513 28654513 PRJNA407087_S_NODE_8707_length_162_cov_2.714286_g8244_i0 PRJNA407087 8707 162 2.714286 4.39714332 Cyanobacteria bacterium J06638_7 3023213 Bacteria Bacteria 41.6 0.0314   NR MEO1002761.1 3023213 g8244 i0 50 0.777777777777778 42 15 68.5 2 51 161 225 265 MEO1002761.1 aldo/keto reductase [Cyanobacteria bacterium J06638_7] diamond 126 41.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06638_7
29033636 29033636 PRJNA407087_S_NODE_8548_length_164_cov_2.244444_g8085_i0 PRJNA407087 8548 164 2.244444 3.68088816 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 89.7 1.09e-19   NR MBX9694561.1 2847862 g8085 i0 72.2 0.98780487804878 54 15 98.8 0 2 163 126 179 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 162 89.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29917617 29917617 PRJNA407087_S_NODE_1211_length_640_cov_10.517185_g835_i0 PRJNA407087 1211 640 10.517185 67.309984 Cyanobacteria bacterium J06598_3 3023150 Bacteria Bacteria 84 4.6e-15   NR MEL6814043.1 3023150 g835 i0 35.9 0.7828125 167 92 77.8 5 635 138 80 232 MEL6814043.1 CAP domain-containing protein [Cyanobacteria bacterium J06598_3] diamond 501 84 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06598_3
30643997 30643997 PRJNA407087_S_NODE_4693_length_246_cov_3.285714_g4230_i0 PRJNA407087 4693 246 3.285714 8.08285644 Cyanobacteria bacterium J06555_3 3023132 Bacteria Bacteria 45.4 7.89e-4   NR MEL7420175.1 3023132 g4230 i0 46.9 0.597560975609756 49 20 52.4 2 39 167 46 94 MEL7420175.1 aquaporin [Cyanobacteria bacterium J06555_3] diamond 147 45.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06555_3

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