RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA534016" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 8 ✖

bioproject 1

  • PRJNA534016 · 8 ✖

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
27267428 27267428 PRJNA534016_P_NODE_3083_length_465_cov_2.012755_g2993_i0 PRJNA534016 3083 465 2.012755 9.35931075 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 160 2.2499999999999994e-42   NR MFN7263240.1 2847862 g2993 i0 51 0.987096774193548 153 73 98.7 1 461 3 510 660 MFN7263240.1 hypothetical protein [Cyanobacteriota bacterium] diamond 459 160 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27693258 27693258 PRJNA534016_P_NODE_12804_length_257_cov_1.673913_g12714_i0 PRJNA534016 12804 257 1.673913 4.30195641 Oscillatoria 1158 Bacteria Bacteria 50.1 1.17e-4   NR WP_017717697.1 1173028 g12714 i0 43.7 1.65758754863813 71 31 77 3 32 229 245 311 WP_017717697.1 WD40 repeat domain-containing serine/threonine protein kinase [Oscillatoria sp. PCC 10802] diamond 426 50.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria sp. PCC 10802
28309594 28309594 PRJNA534016_P_NODE_9246_length_285_cov_1.372642_g9156_i0 PRJNA534016 9246 285 1.372642 3.9120297 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 94.4 4.46e-20   NR MFN7263240.1 2847862 g9156 i0 56.6 0.8 76 33 80 0 57 284 600 675 MFN7263240.1 hypothetical protein [Cyanobacteriota bacterium] diamond 228 94.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28467523 28467523 PRJNA534016_P_NODE_12186_length_262_cov_1.455026_g12096_i0 PRJNA534016 12186 262 1.455026 3.81216812 Synechococcaceae cyanobacterium SM2_3_2 2720471 Bacteria Bacteria 59.3 6.5e-8   NR NJL98425.1 2720471 g12096 i0 43.8 3.70992366412214 80 45 91.6 0 21 260 284 363 NJL98425.1 folate/biopterin family MFS transporter [Synechococcaceae cyanobacterium SM2_3_2] diamond 972 59.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae   Synechococcaceae cyanobacterium SM2_3_2
31310032 31310032 PRJNA534016_P_NODE_14475_length_249_cov_1.750000_g14385_i0 PRJNA534016 14475 249 1.75 4.3575 Cyanobacteria bacterium RM1_2_2 2720432 Bacteria Bacteria 100 1.09e-22   NR NJO80405.1 2720432 g14385 i0 87.5 0.674698795180723 56 7 67.5 0 80 247 364 419 NJO80405.1 SH3 domain-containing protein [Cyanobacteria bacterium RM1_2_2] diamond 168 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium RM1_2_2
31468481 31468481 PRJNA534016_P_NODE_7936_length_301_cov_1.736842_g7846_i0 PRJNA534016 7936 301 1.736842 5.22789442 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 51.6 5.78e-5   NR MFN7263240.1 2847862 g7846 i0 32.3 0.98671096345515 99 49 92.7 3 1 279 171 257 MFN7263240.1 hypothetical protein [Cyanobacteriota bacterium] diamond 297 51.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31595023 31595023 PRJNA534016_P_NODE_276_length_1443_cov_3.171533_g239_i0 PRJNA534016 276 1443 3.171533 45.76522119 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 235 4.04e-65   NR MFN7263240.1 2847862 g239 i0 32 0.960498960498961 462 280 94.2 11 1359 1 1 437 MFN7263240.1 hypothetical protein [Cyanobacteriota bacterium] diamond 1386 235 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32195926 32195926 PRJNA534016_P_NODE_5458_length_356_cov_1.632509_g5368_i0 PRJNA534016 5458 356 1.632509 5.81173204 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 152 4.19e-40   NR MFN7263240.1 2847862 g5368 i0 57.8 0.918539325842697 109 46 91.9 0 11 337 675 783 MFN7263240.1 hypothetical protein [Cyanobacteriota bacterium] diamond 327 152 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota 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);;