RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA771359" 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 · 7 ✖

bioproject 1

  • PRJNA771359 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27021690 27021690 PRJNA771359_S_NODE_3022_length_193_cov_2.000000_g2939_i0 PRJNA771359 3022 193 2 3.86 Nostoc sp. CCY 9925 3103865 Bacteria Bacteria 60.1 1.19e-9   NR WP_414570021.1 3103865 g2939 i0 91.7 2.23834196891192 36 3 56 0 84 191 1 36 WP_414570021.1 hypothetical protein [Nostoc sp. CCY 9925] diamond 432 60.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CCY 9925
28284790 28284790 PRJNA771359_S_NODE_1986_length_235_cov_4.661616_g1903_i0 PRJNA771359 1986 235 4.661616 10.9547976 Cyanobacteria bacterium UBA11371 2055770 Bacteria Bacteria 48.9 5.1e-5   NR HAZ48354.1 2055770 g1903 i0 75 0.408510638297872 32 8 40.9 0 124 219 9 40 HAZ48354.1 hypothetical protein [Cyanobacteria bacterium UBA11371] diamond 96 48.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11371
28421072 28421072 PRJNA771359_S_NODE_4586_length_159_cov_0.950820_g4503_i0 PRJNA771359 4586 159 0.95082 1.5118038 Nostoc 1177 Bacteria Bacteria 77.8 2.84e-17   NR WP_251955932.1 1178 g4503 i0 85 4.52830188679245 40 6 75.5 0 158 39 38 77 WP_251955932.1 Nif11-like leader peptide family natural product precursor [Nostoc commune] diamond 720 77.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc commune
29074575 29074575 PRJNA771359_S_NODE_4668_length_157_cov_11.716667_g4585_i0 PRJNA771359 4668 157 11.716667 18.39516719 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 45.4 1.84e-4   NR MBX9694480.1 2847862 g4585 i0 80.8 0.496815286624204 26 5 49.7 0 75 152 3 28 MBX9694480.1 hypothetical protein [Cyanobacteriota bacterium] diamond 78 45.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29705429 29705429 PRJNA771359_S_NODE_4070_length_167_cov_2.100000_g3987_i0 PRJNA771359 4070 167 2.1 3.507 Nostoc 1177 Bacteria Bacteria 92 5.929999999999999e-23   NR WP_099067786.1 1177 g3987 i0 100 0.790419161676647 44 0 79 0 1 132 26 69 WP_099067786.1 MULTISPECIES: photosystem II assembly protein Psb35 [Nostoc] diamond 132 92 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc  
30369718 30369718 PRJNA771359_S_NODE_5152_length_151_cov_1.973684_g5069_i0 PRJNA771359 5152 151 1.973684 2.98026284 Pseudanabaena sp. PCC 68 1153 Bacteria Bacteria 113 1.9299999999999995e-31   NR WP_036947030.1 118173 g5069 i0 100 0.973509933774834 49 0 97.4 0 150 4 21 69 WP_036947030.1 hypothetical protein [Pseudanabaena sp. PCC 6802] diamond 147 113 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp. PCC 6802
32139778 32139778 PRJNA771359_S_NODE_3218_length_187_cov_2.186667_g3135_i0 PRJNA771359 3218 187 2.186667 4.08906729 Cyanobacteria bacterium CRU_2_1 2720403 Bacteria Bacteria 81.3 1e-18   NR NJR63772.1 2720403 g3135 i0 90.9 0.705882352941177 44 4 70.6 0 3 134 12 55 NJR63772.1 ssl1498 family light-harvesting-like protein [Cyanobacteria bacterium CRU_2_1] diamond 132 81.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium CRU_2_1

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