RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 12 ✖

bioproject 1

  • PRJEB39269 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
57104 57104 PRJEB39269_P_NODE_62061_length_175_cov_2.323529_g61656_i0 PRJEB39269 62061 175 2.323529 4.06617575 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 90.5 2.26e-19   NR MBW4538427.1 1601998 g61656 i0 70.7 6.96 58 17 99.4 0 175 2 520 577 MBW4538427.1 amino acid adenylation domain-containing protein [Myxacorys chilensis ATA2-1-KO14] diamond 1218 90.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Myxacorys Myxacorys chilensis
2607005 2607005 PRJEB39269_P_NODE_73103_length_165_cov_0.976190_g72698_i0 PRJEB39269 73103 165 0.97619 1.6107135 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 98.6 3.5e-23   NR WP_022603964.1 582514 g72698 i0 79.6 9.8 54 11 98.2 0 163 2 123 176 WP_022603964.1 polyphosphate kinase 2 family protein [Rubidibacter lacunae] diamond 1617 98.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Rubidibacter Rubidibacter lacunae
8984149 8984149 PRJEB39269_P_NODE_65488_length_171_cov_1.553030_g65083_i0 PRJEB39269 65488 171 1.55303 2.6556813 Nostocales cyanobacterium ELA608 3064516 Bacteria Bacteria 101 9.34e-24   NR MEI6371988.1 3064516 g65083 i0 82.1 0.982456140350877 56 10 98.2 0 3 170 174 229 MEI6371988.1 NADH-quinone oxidoreductase subunit D [Nostocales cyanobacterium ELA608] diamond 168 101 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales     Nostocales cyanobacterium ELA608
12810604 12810604 PRJEB39269_P_NODE_67211_length_170_cov_2.694656_g66806_i0 PRJEB39269 67211 170 2.694656 4.5809152 Spirulina sp. 1157 Bacteria Bacteria 65.5 2.65e-11   NR WP_323225406.1 3110248 g66806 i0 87.1 0.547058823529412 31 4 54.7 0 95 3 101 131 WP_323225406.1 DNA-primase RepB domain-containing protein, partial [Spirulina sp. 06S082] diamond 93 65.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Spirulinales Spirulinaceae Spirulina Spirulina sp. 06S082
27949406 27949406 PRJEB39269_P_NODE_77745_length_160_cov_1.669421_g77340_i0 PRJEB39269 77745 160 1.669421 2.6710736 Chlorogloeopsis sp. ULAP 28069 Bacteria Bacteria 58.9 1.6e-8   NR WP_341994077.1 3107926 g77340 i0 46.2 1.8 52 28 97.5 0 4 159 101 152 WP_341994077.1 TIGR04255 family protein [Chlorogloeopsis sp. ULAP02] diamond 288 58.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Chlorogloeopsidaceae Chlorogloeopsis Chlorogloeopsis sp. ULAP02
28226680 28226680 PRJEB39269_P_NODE_62946_length_174_cov_1.822222_g62541_i0 PRJEB39269 62946 174 1.822222 3.17066628 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 95.1 5.15e-21   NR HVO23940.1 2053573 g62541 i0 75.4 1.96551724137931 57 14 98.3 0 3 173 693 749 HVO23940.1 TonB-dependent receptor [Candidatus Margulisiibacteriota bacterium] diamond 342 95.9 0.991657977059437 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Margulisiibacteriota         Candidatus Margulisiibacteriota bacterium
28353219 28353219 PRJEB39269_P_NODE_67106_length_170_cov_2.763359_g66701_i0 PRJEB39269 67106 170 2.763359 4.6977103 Bacillati 1783272 Bacteria Bacteria 53.1 2.3e-6   NR MBI2810935.1 2052166 g66701 i0 96.2 1.83529411764706 26 1 45.9 0 168 91 65 90 MBI2810935.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 312 53.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
28612467 28612467 PRJEB39269_P_NODE_84367_length_155_cov_2.525862_g83962_i0 PRJEB39269 84367 155 2.525862 3.9150861 Cylindrospermopsis raciborskii 77022 Bacteria Bacteria 101 2.09e-26   NR MBA4444480.1 2585138 g83962 i0 84.3 0.987096774193548 51 8 98.7 0 153 1 26 76 MBA4444480.1 hypothetical protein [Cylindrospermopsis raciborskii CS-506_C] diamond 153 101 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Cylindrospermopsis Cylindrospermopsis raciborskii
28801661 28801661 PRJEB39269_P_NODE_31368_length_247_cov_1.846154_g30963_i0 PRJEB39269 31368 247 1.846154 4.56000038 Alkalinema sp. FACHB-956 2692768 Bacteria Bacteria 91.3 3.4e-19   NR WP_190574486.1 2692768 g30963 i0 57.3 0.995951417004049 82 35 99.6 0 1 246 1191 1272 WP_190574486.1 SpvB/TcaC N-terminal domain-containing protein [Alkalinema sp. FACHB-956] diamond 246 91.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Alkalinema Alkalinema sp. FACHB-956
30349850 30349850 PRJEB39269_P_NODE_43512_length_208_cov_1.455621_g43107_i0 PRJEB39269 43512 208 1.455621 3.02769168 Prochlorococcus 1218 Bacteria Bacteria 53.1 5.03e-6   NR WP_152557473.1 1218 g43107 i0 36.2 1.96153846153846 69 44 99.5 0 208 2 235 303 WP_152557473.1 MULTISPECIES: hypothetical protein [Prochlorococcus] diamond 408 53.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus  
30349856 30349856 PRJEB39269_P_NODE_81972_length_157_cov_2.059322_g81567_i0 PRJEB39269 81972 157 2.059322 3.23313554 Cyanobacteria bacterium J06649_5 3023235 Bacteria Bacteria 79.3 1.27e-15   NR MEO0708174.1 3023235 g81567 i0 70 0.955414012738854 50 15 95.5 0 152 3 113 162 MEO0708174.1 WD40 repeat domain-containing protein [Cyanobacteria bacterium J06649_5] diamond 150 79.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06649_5
32024864 32024864 PRJEB39269_P_NODE_57918_length_181_cov_1.549296_g57513_i0 PRJEB39269 57918 181 1.549296 2.80422576 Cyanophyceae 3028117 Bacteria Bacteria 75.9 3.31e-14   NR WP_190454056.1 3028117 g57513 i0 62.7 0.977900552486188 59 22 97.8 0 3 179 1438 1496 WP_190454056.1 MULTISPECIES: PAS domain S-box protein [Cyanophyceae] diamond 177 75.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae        

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