RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA784979" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 6 ✖

bioproject 1

  • PRJNA784979 · 6 ✖
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
3316833 3316833 PRJNA784979_S_NODE_5983_length_202_cov_0.666667_g5941_i0 PRJNA784979 5983 202 0.666667 1.34666734 Leptolyngbya sp. 7M 2812896 Bacteria Bacteria 279 7.41e-71   NTclustered gi|2028908486|gb|CP070897.1| 2812896 g5941 i0 93.717 88.7673267326733 191 5 91 3 10 193 2152089 2152279 Leptolyngbya sp. 7M chromosome blastn 17931 279 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. 7M
20339807 20339807 PRJNA784979_S_NODE_8096_length_181_cov_1.553030_g8054_i0 PRJNA784979 8096 181 1.55303 2.8109843 root 1 Root_unresolved Root_unresolved 333 4.9000000000000015e-87   NTclustered gi|63022551|gb|DQ004310.1| 1211 g8054 i0 100 181.005524861878 180 0 99 0 2 181 228 49 Uncultured cyanobacterium clone PEN12 16S ribosomal RNA gene, partial sequence blastn 32762 335 0.994029850746269 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
29390622 29390622 PRJNA784979_S_NODE_10909_length_166_cov_0.871795_g10867_i0 PRJNA784979 10909 166 0.871795 1.4471797 Rivularia sp. IAM M-261 448371 Bacteria Bacteria 52 8.21e-7   NR GJD22964.1 448371 g10867 i0 63.3 1.08433734939759 30 11 54.2 0 90 1 67 96 GJD22964.1 hypothetical protein RIVM261_079200 [Rivularia sp. IAM M-261] diamond 180 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Rivulariaceae Rivularia Rivularia sp. IAM M-261
30316214 30316214 PRJNA784979_S_NODE_10332_length_167_cov_0.864407_g10290_i0 PRJNA784979 10332 167 0.864407 1.44355969 Bacteria 2 Bacteria Bacteria 76.6 9.78e-15   NR NJR71300.1 2720405 g10290 i0 66.7 1.94011976047904 54 18 97 0 2 163 194 247 NJR71300.1 hypothetical protein [Synechococcales cyanobacterium CRU_2_2] diamond 324 76.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales     Synechococcales cyanobacterium CRU_2_2
31539144 31539144 PRJNA784979_S_NODE_13216_length_161_cov_1.321429_g13174_i0 PRJNA784979 13216 161 1.321429 2.12750069 Scytonema sp. NUACC26 3140176 Bacteria Bacteria 53.1 2.5e-6   NR WP_407899023.1 3140176 g13174 i0 47.2 1.95652173913043 53 27 96.9 1 5 160 264 316 WP_407899023.1 hypothetical protein [Scytonema sp. NUACC26] diamond 315 53.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema sp. NUACC26
31950115 31950115 PRJNA784979_S_NODE_12337_length_163_cov_0.894737_g12295_i0 PRJNA784979 12337 163 0.894737 1.45842131 Xenococcus sp. PCC 73 102125 Bacteria Bacteria 108 1.29e-28   NR WP_006512060.1 102125 g12295 i0 98.1 0.993865030674847 54 1 99.4 0 162 1 74 127 WP_006512060.1 response regulator [Xenococcus sp. PCC 7305] diamond 162 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Xenococcaceae Xenococcus Xenococcus sp. PCC 7305

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