RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA792582 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
5043497 5043497 PRJNA792582_P_NODE_23324_length_357_cov_1.084507_g22510_i0 PRJNA792582 23324 357 1.084507 3.87168999 Richelia sp. RM2_1_2 2720436 Bacteria Bacteria 172 1.2e-49   NR NJO61023.1 2720436 g22510 i0 78.9 3.09243697478992 123 22 100 1 357 1 59 181 NJO61023.1 hypothetical protein [Richelia sp. RM2_1_2] diamond 1104 172 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Richelia Richelia sp. RM2_1_2
5880700 5880700 PRJNA792582_P_NODE_58065_length_242_cov_1.662722_g57251_i0 PRJNA792582 58065 242 1.662722 4.02378724 Mojavia 287846 Bacteria Bacteria 140 1.17e-36   NR MBW4561903.1 287848 g57251 i0 82.9 2.00826446280992 82 12 99.2 1 3 242 337 418 MBW4561903.1 PAS domain S-box protein [Mojavia pulchra JT2-VF2] diamond 486 140 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Mojavia Mojavia pulchra
26768909 26768909 PRJNA792582_P_NODE_52081_length_249_cov_0.875000_g51267_i0 PRJNA792582 52081 249 0.875 2.17875 Cyanobacteria bacterium K_DeepCast_35m_m2_023 2775549 Bacteria Bacteria 116 2.02e-28   NR MBM5800761.1 2775549 g51267 i0 84.1 0.759036144578313 63 10 75.9 0 249 61 231 293 MBM5800761.1 lysine--tRNA ligase [Cyanobacteria bacterium K_DeepCast_35m_m2_023] diamond 189 116 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium K_DeepCast_35m_m2_023
26809845 26809845 PRJNA792582_P_NODE_55761_length_245_cov_0.895349_g54947_i0 PRJNA792582 55761 245 0.895349 2.19360505 Bacteria 2 Bacteria Bacteria 117 1.52e-28   NR HCF30020.1 2055787 g54947 i0 74.7 3.68571428571429 75 19 91.8 0 245 21 674 748 HCF30020.1 hypothetical protein [Cyanobacteria bacterium UBA11049] diamond 903 118 0.991525423728814 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
27527664 27527664 PRJNA792582_P_NODE_34683_length_292_cov_1.853881_g33869_i0 PRJNA792582 34683 292 1.853881 5.41333252 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 157 1.42e-45   NR MBF2054067.1 2762020 g33869 i0 73.2 2.98972602739726 97 20 99.7 1 2 292 19 109 MBF2054067.1 DUF2071 domain-containing protein [Candidatus Sericytochromatia bacterium] diamond 873 157 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
28285270 28285270 PRJNA792582_P_NODE_46126_length_261_cov_1.425532_g45312_i0 PRJNA792582 46126 261 1.425532 3.72063852 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 110 7.030000000000001e-26   NR MFA6211873.1 2364082 g45312 i0 75 1.72413793103448 76 18 87.4 1 236 9 3021 3095 MFA6211873.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 450 110 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28664462 28664462 PRJNA792582_P_NODE_44007_length_267_cov_1.221649_g43193_i0 PRJNA792582 44007 267 1.221649 3.26180283 Aliterella atlantica 1827278 Bacteria Bacteria 147 2.07e-39   NR WP_200892446.1 1827278 g43193 i0 85.2 0.98876404494382 88 13 98.9 0 3 266 130 217 WP_200892446.1 iron uptake porin [Aliterella atlantica] diamond 264 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
28853649 28853649 PRJNA792582_P_NODE_42508_length_271_cov_1.505051_g41694_i0 PRJNA792582 42508 271 1.505051 4.07868821 Leptolyngbya sp. NK1-12 2547451 Bacteria Bacteria 119 9.119999999999999e-32   NR WNZ26623.1 2547451 g41694 i0 78.8 0.730627306273063 66 14 73.1 0 200 3 43 108 WNZ26623.1 helix-turn-helix transcriptional regulator [Leptolyngbya sp. NK1-12] diamond 198 119 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NK1-12
29304954 29304954 PRJNA792582_P_NODE_18709_length_398_cov_1.421538_g17895_i0 PRJNA792582 18709 398 1.421538 5.65772124 Bacteria 2 Bacteria Bacteria 122 1.18e-29   NR MEM6426234.1 3023272 g17895 i0 47.3 3.9572864321608 131 69 98.7 0 1 393 175 305 MEM6426234.1 NCS2 family permease [Cyanobacteria bacterium P01_D01_bin.128] diamond 1575 123 0.991869918699187 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_D01_bin.128
29705896 29705896 PRJNA792582_P_NODE_50910_length_250_cov_0.870056_g50096_i0 PRJNA792582 50910 250 0.870056 2.17514 Leptolyngbya ectocarpi 1202 Bacteria Bacteria 132 3e-36   NR WP_193994371.1 1202 g50096 i0 69.5 3.948 82 25 98.4 0 246 1 118 199 WP_193994371.1 pseudaminic acid cytidylyltransferase [Leptolyngbya ectocarpi] diamond 987 132 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya ectocarpi
29737661 29737661 PRJNA792582_P_NODE_55890_length_245_cov_0.895349_g55076_i0 PRJNA792582 55890 245 0.895349 2.19360505 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 139 3.13e-40   NR WP_009630788.1 927677 g55076 i0 80.2 1.98367346938776 81 16 99.2 0 244 2 2 82 WP_009630788.1 hypothetical protein [Synechocystis sp. PCC 7509] diamond 486 139 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
29864208 29864208 PRJNA792582_P_NODE_51771_length_249_cov_0.875000_g50957_i0 PRJNA792582 51771 249 0.875 2.17875 Cyanobacteria bacterium J06614_10 3023159 Bacteria Bacteria 43.9 0.0156   NR MEL6601992.1 3023159 g50957 i0 39.7 0.759036144578313 63 33 73.5 2 22 204 54 113 MEL6601992.1 polyamine aminopropyltransferase [Cyanobacteria bacterium J06614_10] diamond 189 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06614_10
29864214 29864214 PRJNA792582_P_NODE_57591_length_243_cov_0.905882_g56777_i0 PRJNA792582 57591 243 0.905882 2.20129326 Cylindrospermum sp. FACHB-282 2692794 Bacteria Bacteria 113 6.2600000000000005e-27   NR WP_190462630.1 2692794 g56777 i0 70 0.987654320987654 80 24 98.8 0 4 243 624 703 WP_190462630.1 caspase family protein [Cylindrospermum sp. FACHB-282] diamond 240 113 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Cylindrospermum Cylindrospermum sp. FACHB-282
29927593 29927593 PRJNA792582_P_NODE_44731_length_265_cov_1.348958_g43917_i0 PRJNA792582 44731 265 1.348958 3.5747387 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 43.5 0.00847   NR HEY9756459.1 3088181 g43917 i0 49 0.577358490566038 51 26 57.7 0 18 170 49 99 HEY9756459.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 153 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
29968230 29968230 PRJNA792582_P_NODE_51611_length_249_cov_0.931818_g50797_i0 PRJNA792582 51611 249 0.931818 2.32022682 Bacillati 1783272 Bacteria Bacteria 67 1.65e-11   NR CAA9570133.1 1936017 g50797 i0 88.6 0.843373493975904 35 4 42.2 0 145 249 1 35 CAA9570133.1 Phycocyanin beta chain [uncultured Synechococcales cyanobacterium] diamond 210 67 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales     uncultured Synechococcales cyanobacterium
30442237 30442237 PRJNA792582_P_NODE_27693_length_328_cov_1.811765_g26879_i0 PRJNA792582 27693 328 1.811765 5.9425892 Bacteria 2 Bacteria Bacteria 125 5.31e-32   NR MDY6783909.1 2847862 g26879 i0 58.7 9.96951219512195 109 45 99.7 0 1 327 80 188 MDY6783909.1 porphobilinogen synthase [Cyanobacteriota bacterium] diamond 3270 125 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30590819 30590819 PRJNA792582_P_NODE_42513_length_271_cov_1.479798_g41699_i0 PRJNA792582 42513 271 1.479798 4.01025258 Limnospira platensis 118562 Bacteria Bacteria 100 2.74e-23   NR MDV7390991.1 3080829 g41699 i0 96.4 0.619926199261993 56 2 62 0 168 1 1 56 MDV7390991.1 hypothetical protein [Arthrospira platensis SPKY1] diamond 168 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
30717162 30717162 PRJNA792582_P_NODE_58514_length_242_cov_0.911243_g57700_i0 PRJNA792582 58514 242 0.911243 2.20520806 Aliterella atlantica 1827278 Bacteria Bacteria 108 5.859999999999999e-28   NR WP_045052895.1 1827278 g57700 i0 77.6 0.830578512396694 67 15 83.1 0 204 4 1 67 WP_045052895.1 urease accessory protein UreE [Aliterella atlantica] diamond 201 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
31033521 31033521 PRJNA792582_P_NODE_36475_length_287_cov_1.406542_g35661_i0 PRJNA792582 36475 287 1.406542 4.03677554 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 100 2.2699999999999994e-23   NR WP_250123582.1 155894 g35661 i0 77.4 0.64808362369338 62 14 64.8 0 100 285 4 65 WP_250123582.1 EboA family metabolite traffic protein [Chroococcidiopsis sp. CCMEE 29] diamond 186 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
31728801 31728801 PRJNA792582_P_NODE_59577_length_241_cov_0.916667_g58763_i0 PRJNA792582 59577 241 0.916667 2.20916747 cyanobacterium TDX16 1503470 Bacteria Bacteria 168 2.2799999999999998e-46   NR OWY64690.1 1503470 g58763 i0 100 2.98755186721992 80 0 99.6 0 1 240 1671 1750 OWY64690.1 hypothetical protein B7486_45910 [cyanobacterium TDX16] diamond 720 168 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium TDX16
32076923 32076923 PRJNA792582_P_NODE_45318_length_263_cov_1.621053_g44504_i0 PRJNA792582 45318 263 1.621053 4.26336939 Calothrix sp. SM1_5_4 2720460 Bacteria Bacteria 46.2 0.00152   NR NJL26193.1 2720460 g44504 i0 55.8 0.490494296577947 43 19 49 0 263 135 129 171 NJL26193.1 5-(carboxyamino)imidazole ribonucleotide mutase [Calothrix sp. SM1_5_4] diamond 129 46.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. SM1_5_4
32140234 32140234 PRJNA792582_P_NODE_45118_length_264_cov_1.230366_g44304_i0 PRJNA792582 45118 264 1.230366 3.24816624 Nostoc sp. ChiQUE 1180 Bacteria Bacteria 60.1 3.97e-8   NR WP_322727887.1 3075376 g44304 i0 34.5 0.988636363636364 87 57 98.9 0 264 4 369 455 WP_322727887.1 hypothetical protein [Nostoc sp. ChiQUE01b] diamond 261 60.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. ChiQUE01b

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