RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1249535 · 31 ✖

analysis 1

  • diamond · 31 ✖
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
26630603 26630603 PRJNA1249535_S_NODE_283101_length_262_cov_2.089947_g279718_i0 PRJNA1249535 283101 262 2.089947 5.47566114 Cyanobium sp. 2164130 Bacteria Bacteria 43.9 0.0153   NR HYP03358.1 2164130 g279718 i0 48.8 0.469465648854962 41 21 46.9 0 50 172 176 216 HYP03358.1 hypothetical protein [Cyanobium sp.] diamond 123 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp.
26915572 26915572 PRJNA1249535_S_NODE_76902_length_406_cov_7.447447_g73521_i0 PRJNA1249535 76902 406 7.447447 30.23663482 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 77 2.43e-13   NR MEL7520018.1 3023125 g73521 i0 36.9 1.73645320197044 122 73 87.2 1 378 25 785 906 MEL7520018.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1] diamond 705 77 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
27010277 27010277 PRJNA1249535_S_NODE_130402_length_348_cov_5.447273_g127019_i0 PRJNA1249535 130402 348 5.447273 18.95651004 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 122 2.07e-29   NR MEL7079339.1 3023143 g127019 i0 50.9 0.96551724137931 112 55 96.6 0 345 10 137 248 MEL7079339.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2] diamond 336 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
27199944 27199944 PRJNA1249535_S_NODE_271922_length_268_cov_2.594872_g268539_i0 PRJNA1249535 271922 268 2.594872 6.95425696 Coleofasciculaceae cyanobacterium 3081323 Bacteria Bacteria 45.1 0.00806   NR HEY9638047.1 3081323 g268539 i0 35.4 0.727611940298508 65 34 72.8 1 265 71 1023 1079 HEY9638047.1 DUF3131 domain-containing protein [Coleofasciculaceae cyanobacterium] diamond 195 45.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae   Coleofasciculaceae cyanobacterium
27421576 27421576 PRJNA1249535_S_NODE_136343_length_344_cov_4.291513_g132960_i0 PRJNA1249535 136343 344 4.291513 14.76280472 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 91.3 1.17e-18   NR MEL7520018.1 3023125 g132960 i0 41.9 0.915697674418605 105 57 88.1 1 333 31 785 889 MEL7520018.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1] diamond 315 91.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
27579247 27579247 PRJNA1249535_S_NODE_34704_length_546_cov_6.503171_g31426_i0 PRJNA1249535 34704 546 6.503171 35.50731366 Cyanobacteria bacterium J06614_10 3023159 Bacteria Bacteria 71.2 9.29e-11   NR MEL6606429.1 3023159 g31426 i0 37.9 1.12637362637363 103 59 56.6 1 545 237 48 145 MEL6606429.1 hypothetical protein [Cyanobacteria bacterium J06614_10] diamond 615 71.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06614_10
27831761 27831761 PRJNA1249535_S_NODE_213444_length_299_cov_2.769912_g210061_i0 PRJNA1249535 213444 299 2.769912 8.28203688 Microcystis sp. 53602_E8 2904984 Bacteria Bacteria 52 4.1e-5   NR MCE2664493.1 2904984 g210061 i0 52.2 0.461538461538462 46 21 46.2 1 2 139 753 797 MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8] diamond 138 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. 53602_E8
27926607 27926607 PRJNA1249535_S_NODE_328405_length_235_cov_5.401235_g325022_i0 PRJNA1249535 328405 235 5.401235 12.69290225 Calothrix sp. NIES-21 1187 Bacteria Bacteria 130 2.33e-33   NR WP_096597307.1 1954172 g325022 i0 81.8 0.982978723404255 77 14 98.3 0 233 3 400 476 WP_096597307.1 calcium-binding protein [Calothrix sp. NIES-2100] diamond 231 130 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. NIES-2100
28147773 28147773 PRJNA1249535_S_NODE_342385_length_212_cov_4.143885_g339002_i0 PRJNA1249535 342385 212 4.143885 8.7850362 Nodularia chucula 3093667 Bacteria Bacteria 40.4 0.0168   NR WP_414528782.1 3093667 g339002 i0 47.2 0.509433962264151 36 15 45.3 1 114 209 9 44 WP_414528782.1 hypothetical protein [Nodularia chucula] diamond 108 40.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nodulariaceae Nodularia Nodularia chucula
28716012 28716012 PRJNA1249535_S_NODE_26507_length_599_cov_4.979087_g23307_i0 PRJNA1249535 26507 599 4.979087 29.82473113 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 48.9 0.00396   NR MEL7079638.1 3023143 g23307 i0 28.5 1.00667779632721 123 79 60.1 4 97 456 40 156 MEL7079638.1 zinc finger CCCH domain-containing protein [Cyanobacteria bacterium J06582_2] diamond 603 48.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
28905099 28905099 PRJNA1249535_S_NODE_267368_length_270_cov_5.741117_g263985_i0 PRJNA1249535 267368 270 5.741117 15.5010159 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 56.2 7.7300000000000005e-07   NR MEL7523110.1 3023125 g263985 i0 48 12.3333333333333 50 26 55.6 0 80 229 101 150 MEL7523110.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06553_1] diamond 3330 56.6 0.992932862190813 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
29315794 29315794 PRJNA1249535_S_NODE_219129_length_296_cov_2.896861_g215746_i0 PRJNA1249535 219129 296 2.896861 8.57470856 Synechococcus sp. 1131 Bacteria Bacteria 44.3 0.0189   NR MEB3264391.1 1131 g215746 i0 55.9 0.344594594594595 34 15 34.5 0 152 253 113 146 MEB3264391.1 F420-0:Gamma-glutamyl ligase [Synechococcus sp.] diamond 102 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp.
29410427 29410427 PRJNA1249535_S_NODE_221269_length_295_cov_2.500000_g217886_i0 PRJNA1249535 221269 295 2.5 7.375 Hydrococcus sp. Prado102 2929567 Bacteria Bacteria 44.3 0.0197   NR MCU0532343.1 2929567 g217886 i0 29.9 0.783050847457627 77 54 78.3 0 233 3 187 263 MCU0532343.1 peptidase domain-containing ABC transporter [Hydrococcus sp. Prado102] diamond 231 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hydrococcaceae Hydrococcus Hydrococcus sp. Prado102
29441920 29441920 PRJNA1249535_S_NODE_91390_length_385_cov_2.980769_g88008_i0 PRJNA1249535 91390 385 2.980769 11.47596065 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 66.2 1.33e-10   NR MEL7079690.1 3023143 g88008 i0 46.5 1.88571428571429 71 37 55.3 1 214 2 2 71 MEL7079690.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2] diamond 726 66.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
29694429 29694429 PRJNA1249535_S_NODE_58290_length_451_cov_2.423280_g54925_i0 PRJNA1249535 58290 451 2.42328 10.9289928 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 103 5.600000000000001e-23   NR MEL7522377.1 3023125 g54925 i0 43.6 1.86917960088692 140 68 87.1 3 3 395 144 281 MEL7522377.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1] diamond 843 103 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
29757735 29757735 PRJNA1249535_S_NODE_251271_length_279_cov_3.223301_g247888_i0 PRJNA1249535 251271 279 3.223301 8.99300979 Stenomitos sp. 3088177 Bacteria Bacteria 44.7 0.012   NR HEY9833652.1 3088177 g247888 i0 50 0.387096774193548 36 18 38.7 0 83 190 61 96 HEY9833652.1 reverse transcriptase domain-containing protein [Stenomitos sp.] diamond 108 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Stenomitos Stenomitos sp.
29947343 29947343 PRJNA1249535_S_NODE_104131_length_370_cov_10.397306_g100748_i0 PRJNA1249535 104131 370 10.397306 38.4700322 Cyanobacteria bacterium J06649_11 3023232 Bacteria Bacteria 73.6 2.07e-13   NR MEO0686447.1 3023232 g100748 i0 47.9 0.591891891891892 73 38 59.2 0 132 350 3 75 MEO0686447.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06649_11] diamond 219 73.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06649_11
30484525 30484525 PRJNA1249535_S_NODE_186953_length_313_cov_4.504167_g183570_i0 PRJNA1249535 186953 313 4.504167 14.09804271 Rhizonema sp. PD38 3019275 Bacteria Bacteria 43.5 0.0429   NR MDF5730427.1 3019275 g183570 i0 32.2 0.565495207667732 59 40 56.5 0 67 243 204 262 MDF5730427.1 hypothetical protein [Rhizonema sp. PD38] diamond 177 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Rhizonemataceae Rhizonema Rhizonema sp. PD38
30516064 30516064 PRJNA1249535_S_NODE_29133_length_579_cov_17.859684_g25907_i0 PRJNA1249535 29133 579 17.859684 103.40757036 Leptolyngbyaceae cyanobacterium C42_A2020_001 2811131 Bacteria Bacteria 46.2 0.0448   NR MBF2029437.1 2811131 g25907 i0 37.2 0.487046632124352 94 44 45.6 4 357 94 186 270 MBF2029437.1 protein kinase [Leptolyngbyaceae cyanobacterium C42_A2020_001] diamond 282 46.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium C42_A2020_001
30831902 30831902 PRJNA1249535_S_NODE_131834_length_347_cov_5.197080_g128451_i0 PRJNA1249535 131834 347 5.19708 18.0338676 Cyanobacteria bacterium P01_G01_bin.4 3023305 Bacteria Bacteria 45.8 0.00994   NR MEM8717056.1 3023305 g128451 i0 60 0.302593659942363 35 14 30.3 0 105 1 502 536 MEM8717056.1 reverse transcriptase family protein [Cyanobacteria bacterium P01_G01_bin.4] diamond 105 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_G01_bin.4
30927022 30927022 PRJNA1249535_S_NODE_232734_length_289_cov_2.537037_g229351_i0 PRJNA1249535 232734 289 2.537037 7.33203693 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 43.5 0.0323   NR MBX9688120.1 2364082 g229351 i0 33.7 0.892733564013841 86 55 87.2 1 277 26 145 230 MBX9688120.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 258 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31401107 31401107 PRJNA1249535_S_NODE_165816_length_325_cov_4.575397_g162433_i0 PRJNA1249535 165816 325 4.575397 14.87004025 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 108 1.09e-24   NR MEL7079339.1 3023143 g162433 i0 45.7 0.969230769230769 105 57 96.9 0 325 11 123 227 MEL7079339.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2] diamond 315 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
31622216 31622216 PRJNA1249535_S_NODE_176016_length_319_cov_4.934959_g172633_i0 PRJNA1249535 176016 319 4.934959 15.74251921 Microcystis sp. 53602_E8 2904984 Bacteria Bacteria 57 9.13e-7   NR MCE2664493.1 2904984 g172633 i0 50.9 0.517241379310345 55 27 51.7 0 74 238 747 801 MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8] diamond 165 57 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. 53602_E8
31748767 31748767 PRJNA1249535_S_NODE_317257_length_244_cov_0.912281_g313874_i0 PRJNA1249535 317257 244 0.912281 2.22596564 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 43.5 0.0184   NR MEL7079705.1 3023143 g313874 i0 57.7 0.319672131147541 26 11 32 0 87 164 58 83 MEL7079705.1 hypothetical protein [Cyanobacteria bacterium J06582_2] diamond 78 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
31938532 31938532 PRJNA1249535_S_NODE_279477_length_264_cov_2.151832_g276094_i0 PRJNA1249535 279477 264 2.151832 5.68083648 Microcystis sp. 53602_E8 2904984 Bacteria Bacteria 55.5 1.65e-6   NR MCE2664493.1 2904984 g276094 i0 44.4 0.715909090909091 63 35 71.6 0 34 222 751 813 MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8] diamond 189 55.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. 53602_E8
32096827 32096827 PRJNA1249535_S_NODE_214338_length_298_cov_6.328889_g210955_i0 PRJNA1249535 214338 298 6.328889 18.86008922 Pleurocapsa sp. MO_226.B13 3036786 Bacteria Bacteria 43.9 0.0287   NR MDJ0596593.1 3036786 g210955 i0 54.3 0.634228187919463 35 16 35.2 0 298 194 858 892 MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13] diamond 189 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. MO_226.B13
32128696 32128696 PRJNA1249535_S_NODE_205038_length_303_cov_5.839130_g201655_i0 PRJNA1249535 205038 303 5.83913 17.6925639 Microcystis sp. 53602_E8 2904984 Bacteria Bacteria 63.2 5.04e-9   NR MCE2664493.1 2904984 g201655 i0 36.1 0.821782178217822 83 53 82.2 0 53 301 731 813 MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8] diamond 249 63.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. 53602_E8
32223467 32223467 PRJNA1249535_S_NODE_153478_length_333_cov_2.653846_g150095_i0 PRJNA1249535 153478 333 2.653846 8.83730718 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 92 5.63e-19   NR MEL7520018.1 3023125 g150095 i0 42.9 1.00900900900901 112 61 98.2 1 330 4 778 889 MEL7520018.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1] diamond 336 92 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
32571742 32571742 PRJNA1249535_S_NODE_338279_length_226_cov_4.267974_g334896_i0 PRJNA1249535 338279 226 4.267974 9.64562124 cyanobacterium endosymbiont of Epithemia clementina EcSB 3034674 Bacteria Bacteria 43.1 0.0214   NR WP_281153357.1 3034674 g334896 i0 41.7 0.63716814159292 48 26 63.7 1 152 9 11 56 WP_281153357.1 FAD-dependent oxidoreductase [cyanobacterium endosymbiont of Epithemia clementina EcSB] diamond 144 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium endosymbiont of Epithemia clementina EcSB
32571751 32571751 PRJNA1249535_S_NODE_54319_length_463_cov_4.274359_g50962_i0 PRJNA1249535 54319 463 4.274359 19.79028217 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 98.2 1.8e-20   NR MEL7520018.1 3023125 g50962 i0 42.6 0.790496760259179 122 66 76.5 1 12 365 785 906 MEL7520018.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1] diamond 366 98.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
32809731 32809731 PRJNA1249535_S_NODE_60520_length_444_cov_5.196765_g57151_i0 PRJNA1249535 60520 444 5.196765 23.0736366 Symploca 105591 Bacteria Bacteria 45.8 0.0219   NR NER22228.1 2607769 g57151 i0 31 0.959459459459459 71 48 47.3 1 177 386 271 341 NER22228.1 tetratricopeptide repeat protein [Symploca sp. SIO1C2] diamond 426 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Symploca Symploca sp. SIO1C2

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