RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1227535 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
15638349 15638349 PRJNA1227535_P_NODE_29773_length_243_cov_0.917647_g29649_i0 PRJNA1227535 29773 243 0.917647 2.22988221 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 121 4.5000000000000004e-30   NR MFN8575247.1 2762020 g29649 i0 77.5 0.987654320987654 80 18 98.8 0 242 3 241 320 MFN8575247.1 ABC transporter ATP-binding protein [Candidatus Sericytochromatia bacterium] diamond 240 121 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
26977838 26977838 PRJNA1227535_P_NODE_18702_length_263_cov_1.257895_g18578_i0 PRJNA1227535 18702 263 1.257895 3.30826385 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 84.3 7.02e-17   NR MBL0186372.1 2711154 g18578 i0 76.4 0.627376425855513 55 13 62.7 0 165 1 1 55 MBL0186372.1 ABC transporter permease [Candidatus Obscuribacter sp.] diamond 165 84.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
27325671 27325671 PRJNA1227535_P_NODE_28263_length_245_cov_0.906977_g28139_i0 PRJNA1227535 28263 245 0.906977 2.22209365 Trichocoleus sp. FACHB-591 2692872 Bacteria Bacteria 155 6.68e-42   NR WP_190550351.1 2692872 g28139 i0 87.7 1.98367346938776 81 10 99.2 0 243 1 1208 1288 WP_190550351.1 N-6 DNA methylase [Trichocoleus sp. FACHB-591] diamond 486 155 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Trichocoleusaceae Trichocoleus Trichocoleus sp. FACHB-591
28557202 28557202 PRJNA1227535_P_NODE_16927_length_268_cov_2.907692_g16804_i0 PRJNA1227535 16927 268 2.907692 7.79261456 Aliterella atlantica 1827278 Bacteria Bacteria 151 1.0899999999999998e-41   NR WP_200892242.1 1827278 g16804 i0 84.3 0.996268656716418 89 14 99.6 0 267 1 286 374 WP_200892242.1 LCP family protein [Aliterella atlantica] diamond 267 151 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
28557205 28557205 PRJNA1227535_P_NODE_18947_length_262_cov_1.650794_g18823_i0 PRJNA1227535 18947 262 1.650794 4.32508028 Scytonema sp. PRP1 3120513 Bacteria Bacteria 124 1.34e-30   NR WP_332993737.1 3120513 g18823 i0 70.2 1.75190839694656 84 24 95 1 14 262 195 278 WP_332993737.1 type I secretion system permease/ATPase [Scytonema sp. PRP1] diamond 459 124 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema sp. PRP1
28588827 28588827 PRJNA1227535_P_NODE_26427_length_247_cov_1.339080_g26303_i0 PRJNA1227535 26427 247 1.33908 3.3075276 Aliterella atlantica 1827278 Bacteria Bacteria 153 9.81e-45   NR WP_072044972.1 1827278 g26303 i0 82.7 0.983805668016194 81 14 98.4 0 247 5 18 98 WP_072044972.1 zinc-finger-containing protein [Aliterella atlantica] diamond 243 153 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
28683536 28683536 PRJNA1227535_P_NODE_11307_length_288_cov_1.306977_g11184_i0 PRJNA1227535 11307 288 1.306977 3.76409376 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 162 2.08e-44   NR MCA0315251.1 2052166 g11184 i0 82.1 0.989583333333333 95 17 99 0 287 3 352 446 MCA0315251.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 285 162 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
28922976 28922976 PRJNA1227535_P_NODE_25028_length_249_cov_0.886364_g24904_i0 PRJNA1227535 25028 249 0.886364 2.20704636 Cyanophyceae 3028117 Bacteria Bacteria 160 5.15e-46   NR WP_045055921.1 1827278 g24904 i0 100 3.90361445783133 81 0 97.6 0 244 2 151 231 WP_045055921.1 S1C family serine protease [Aliterella atlantica] diamond 972 160 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
29314876 29314876 PRJNA1227535_P_NODE_27529_length_246_cov_0.901734_g27405_i0 PRJNA1227535 27529 246 0.901734 2.21826564 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 150 5.16e-40   NR MCA0313749.1 2052166 g27405 i0 100 0.98780487804878 81 0 98.8 0 244 2 774 854 MCA0313749.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 243 150 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
29756748 29756748 PRJNA1227535_P_NODE_18331_length_264_cov_1.612565_g18207_i0 PRJNA1227535 18331 264 1.612565 4.2571716 Nostoc sp. XA013 2780408 Bacteria Bacteria 76.3 1.45e-15   NR MCC5654631.1 2780408 g18207 i0 53.2 0.704545454545455 62 29 70.5 0 6 191 46 107 MCC5654631.1 hypothetical protein [Nostoc sp. XA013] diamond 186 76.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. XA013
29946481 29946481 PRJNA1227535_P_NODE_23291_length_251_cov_1.533708_g23167_i0 PRJNA1227535 23291 251 1.533708 3.84960708 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 172 3.06e-51   NR MBY0549652.1 2364082 g23167 i0 100 0.99203187250996006 83 0 99.2 0 250 2 227 309 MBY0549652.1 SDR family oxidoreductase [Candidatus Obscuribacterales bacterium] diamond 249 172 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29965188 29965188 PRJNA1227535_P_NODE_26591_length_247_cov_0.896552_g26467_i0 PRJNA1227535 26591 247 0.896552 2.21448344 Cyanophyceae 3028117 Bacteria Bacteria 163 6.7599999999999985e-47   NR WP_009631263.1 927677 g26467 i0 95.1 1.97975708502024 81 4 98.4 0 5 247 193 273 WP_009631263.1 tetratricopeptide repeat protein [Synechocystis sp. PCC 7509] diamond 489 164 0.99390243902439 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
30565094 30565094 PRJNA1227535_P_NODE_9673_length_294_cov_1.855204_g9550_i0 PRJNA1227535 9673 294 1.855204 5.45429976 Cyanophyceae 3028117 Bacteria Bacteria 100 2.54e-22   NR WP_414586161.1 1680591 g9550 i0 59.6 6.6734693877551 94 35 92.9 2 293 21 266 359 WP_414586161.1 AAA-like domain-containing protein [Scytonema sp. PCC 10023] diamond 1962 101 0.99009900990099 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema sp. PCC 10023
30862606 30862606 PRJNA1227535_P_NODE_30614_length_242_cov_0.923077_g30490_i0 PRJNA1227535 30614 242 0.923077 2.23384634 Aliterella atlantica 1827278 Bacteria Bacteria 129 1.68e-35   NR WP_045056720.1 1827278 g30490 i0 78.8 0.991735537190083 80 17 99.2 0 1 240 79 158 WP_045056720.1 ACP phosphodiesterase [Aliterella atlantica] diamond 240 129 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
31020706 31020706 PRJNA1227535_P_NODE_29735_length_243_cov_0.917647_g29611_i0 PRJNA1227535 29735 243 0.917647 2.22988221 Aliterella atlantica 1827278 Bacteria Bacteria 147 3.96e-39   NR WP_045056169.1 1827278 g29611 i0 97.5 0.987654320987654 80 2 98.8 0 3 242 131 210 WP_045056169.1 cation:proton antiporter [Aliterella atlantica] diamond 240 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
31209690 31209690 PRJNA1227535_P_NODE_11775_length_286_cov_1.892019_g11652_i0 PRJNA1227535 11775 286 1.892019 5.41117434 Pantanalinema sp. GBBB05 2604139 Bacteria Bacteria 47.4 0.00154   NR MBL1177968.1 2604139 g11652 i0 44.2 1.86713286713287 86 37 89.2 4 271 17 1374 1449 MBL1177968.1 filamentous hemagglutinin N-terminal domain-containing protein [Pantanalinema sp. GBBB05] diamond 534 47.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Pantanalinema Pantanalinema sp. GBBB05
31323758 31323758 PRJNA1227535_P_NODE_11535_length_287_cov_1.457944_g11412_i0 PRJNA1227535 11535 287 1.457944 4.18429928 Bacteria 2 Bacteria Bacteria 103 1.88e-24   NR HEY9840260.1 2364082 g11412 i0 62.4 1.77700348432056 85 32 88.9 0 31 285 9 93 HEY9840260.1 diguanylate cyclase [Candidatus Obscuribacterales bacterium] diamond 510 103 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31387264 31387264 PRJNA1227535_P_NODE_22776_length_252_cov_0.871508_g22652_i0 PRJNA1227535 22776 252 0.871508 2.19620016 Nostoc 1177 Bacteria Bacteria 58.9 4.88e-9   NR MEH2076801.1 1180 g22652 i0 83.9 2.21428571428571 31 5 36.9 0 93 1 1 31 MEH2076801.1 RNA-guided endonuclease TnpB family protein [Nostoc sp.] diamond 558 58.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
31621297 31621297 PRJNA1227535_P_NODE_22256_length_253_cov_0.866667_g22132_i0 PRJNA1227535 22256 253 0.866667 2.19266751 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 162 7.8199999999999985e-47   NR MBX9770977.1 2364082 g22132 i0 96.4 0.99604743083004 84 3 99.6 0 2 253 43 126 MBX9770977.1 phosphoglycerate kinase [Candidatus Obscuribacterales bacterium] diamond 252 162 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32696347 32696347 PRJNA1227535_P_NODE_17980_length_265_cov_1.625000_g17857_i0 PRJNA1227535 17980 265 1.625 4.30625 Leptolyngbya sp. FACHB-541 2692810 Bacteria Bacteria 137 8.339999999999999e-38   NR WP_190796502.1 2692810 g17857 i0 79.5 2.96603773584906 88 18 99.6 0 2 265 157 244 WP_190796502.1 SDR family oxidoreductase [Leptolyngbya sp. FACHB-541] diamond 786 137 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-541

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