RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA694770", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 27 ✖

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 27 ✖

bioproject 1

  • PRJNA694770 · 27 ✖
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
7054048 7054048 PRJNA694770_P_NODE_76526_length_253_cov_1.344444_g76232_i0 PRJNA694770 76526 253 1.344444 3.40144332 Microcoleus vaginatus 119532 Bacteria Bacteria 446 9.01e-121   NTclustered gi|2212798032|gb|CP031740.1| 669365 g76232 i0 98.419 5.48221343873518 253 4 100 0 1 253 1476309 1476057 Microcoleus vaginatus PCC 9802 chromosome, complete genome blastn 1387 446 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus vaginatus
7054246 7054246 PRJNA694770_P_NODE_83966_length_248_cov_1.760000_g83672_i0 PRJNA694770 83966 248 1.76 4.3648 Anabaena sp. YBS01 2490939 Bacteria Bacteria 370 5.45e-98   NTclustered gi|1772285456|gb|CP034058.1| 2490939 g83672 i0 93.878 99.2620967741936 245 15 99 0 4 248 5551161 5550917 Anabaena sp. YBS01 chromosome, complete genome blastn 24617 370 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. YBS01
10109963 10109963 PRJNA694770_P_NODE_87148_length_247_cov_0.885057_g86854_i0 PRJNA694770 87148 247 0.885057 2.18609079 Tolypothrix 111782 Bacteria Bacteria 191 4.53e-44   NTclustered gi|2316438351|gb|CP064879.1| 1188 g86854 i0 80.723 2.01619433198381 249 44 100 4 1 247 1297797 1298043 Tolypothrix sp. PCC 7601 chromosome, complete genome blastn 498 191 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Tolypothrichaceae Tolypothrix Tolypothrix sp. PCC 7601
13429455 13429455 PRJNA694770_P_NODE_86971_length_247_cov_0.885057_g86677_i0 PRJNA694770 86971 247 0.885057 2.18609079 Coleofasciculus sp. C3-bin4 2768885 Bacteria Bacteria 121 7.87e-30   NR MBD0362614.1 2768885 g86677 i0 79.5 1.77327935222672 73 15 88.7 0 26 244 449 521 MBD0362614.1 Hpt domain-containing protein [Coleofasciculus sp. C3-bin4] diamond 438 121 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus sp. C3-bin4
13429656 13429656 PRJNA694770_P_NODE_94351_length_244_cov_0.900585_g94057_i0 PRJNA694770 94351 244 0.900585 2.1974274 Anabaena sp. YBS01 2490939 Bacteria Bacteria 424 4.05e-114   NTclustered gi|1772285456|gb|CP034058.1| 2490939 g94057 i0 97.951 1 244 5 100 0 1 244 5565376 5565619 Anabaena sp. YBS01 chromosome, complete genome blastn 244 424 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. YBS01
16483453 16483453 PRJNA694770_P_NODE_45313_length_310_cov_1.649789_g45019_i0 PRJNA694770 45313 310 1.649789 5.1143459 Nostocaceae 1162 Bacteria Bacteria 573 4.999999999999998e-159   NTclustered gi|47118302|dbj|BA000019.2| 103690 g45019 i0 100 21.1516129032258 310 0 100 0 1 310 4273831 4273522 Nostoc sp. PCC 7120 DNA, complete genome blastn 6557 573 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. PCC 7120 = FACHB-418
18527823 18527823 PRJNA694770_P_NODE_95015_length_243_cov_0.905882_g94721_i0 PRJNA694770 95015 243 0.905882 2.20129326 Cylindrospermum sp. NIES-4074 2005457 Bacteria Bacteria 54.7 0.006   NTclustered gi|1210208533|dbj|AP018269.1| 2005457 g94721 i0 100 0.119341563786008 29 0 12 0 199 227 5836035 5836007 Cylindrospermum sp. NIES-4074 DNA, nearly complete genome blastn 29 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Cylindrospermum Cylindrospermum sp. NIES-4074
21077420 21077420 PRJNA694770_P_NODE_61197_length_278_cov_1.190244_g60903_i0 PRJNA694770 61197 278 1.190244 3.30887832 Nostoc sp. NIES-3756 1751286 Bacteria Bacteria 215 3.08e-51   NTclustered gi|953513865|dbj|AP017296.1| 1751286 g60903 i0 81.749 0.946043165467626 263 43 94 5 18 278 401496 401755 Nostoc sp. NIES-3756 plasmid pNOS3756_1 DNA, complete genome blastn 263 215 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. NIES-3756
21078145 21078145 PRJNA694770_P_NODE_87897_length_247_cov_0.885057_g87603_i0 PRJNA694770 87897 247 0.885057 2.18609079 Leptolyngbya sp. BL0902 1115757 Bacteria Bacteria 86.1 2.2e-12   NTclustered gi|1949996095|gb|CP046155.1| 1115757 g87603 i0 87.013 0.311740890688259 77 9 31 1 132 208 3596278 3596353 Leptolyngbya sp. BL0902 chromosome, complete genome blastn 77 86.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. BL0902
22857283 22857283 PRJNA694770_P_NODE_1238_length_1768_cov_6.083186_g1100_i0 PRJNA694770 1238 1768 6.083186 107.55072848 Chroococcidiopsis 54298 Bacteria Bacteria 2409 0   NTclustered gi|225696258|gb|FJ805925.1| 259957 g1100 i0 91.241 103.377262443439 1781 138 99 16 1 1767 1642 3418 Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 182771 2409 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
24133195 24133195 PRJNA694770_P_NODE_89599_length_246_cov_0.890173_g89305_i0 PRJNA694770 89599 246 0.890173 2.18982558 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 104 5.94e-24   NR HEY9783051.1 3088178 g89305 i0 65.8 0.963414634146341 79 27 96.3 0 245 9 195 273 HEY9783051.1 methyl-accepting chemotaxis protein [Leptolyngbyaceae cyanobacterium] diamond 237 104 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
26734011 26734011 PRJNA694770_P_NODE_16781_length_459_cov_1.158031_g16487_i0 PRJNA694770 16781 459 1.158031 5.31536229 Hormoscilla sp. GUM202 2480853 Bacteria Bacteria 135 1.14e-36   NR MBO1347609.1 2480853 g16487 i0 44.4 0.941176470588235 144 79 93.5 1 430 2 42 185 MBO1347609.1 hypothetical protein [Hormoscilla sp. GUM202] diamond 432 135 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Hormoscilla Hormoscilla sp. GUM202
26797773 26797773 PRJNA694770_P_NODE_68741_length_266_cov_1.445596_g68447_i0 PRJNA694770 68741 266 1.445596 3.84528536 Cyanophyceae 3028117 Bacteria Bacteria 99.8 4.59e-22   NR WP_190450257.1 3028117 g68447 i0 54 4.09398496240602 87 39 97 1 8 265 355 441 WP_190450257.1 MULTISPECIES: DUF4347 domain-containing protein [Cyanophyceae] diamond 1089 99.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae        
27367393 27367393 PRJNA694770_P_NODE_91003_length_245_cov_0.895349_g90709_i0 PRJNA694770 91003 245 0.895349 2.19360505 Leptolyngbya sp. NIES-3755 1752064 Bacteria Bacteria 72.8 8.6e-14   NR BAU11884.1 1752064 g90709 i0 48.4 2.66938775510204 62 29 75.9 1 7 192 79 137 BAU11884.1 HNH endonuclease [Leptolyngbya sp. NIES-3755] diamond 654 72.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NIES-3755
27946732 27946732 PRJNA694770_P_NODE_58685_length_281_cov_1.903846_g58391_i0 PRJNA694770 58685 281 1.903846 5.34980726 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 57.4 3.89e-7   NR MFL0770513.1 1220 g58391 i0 55.3 6.45907473309609 47 21 50.2 0 277 137 180 226 MFL0770513.1 hypothetical protein [Prochlorococcus sp.] diamond 1815 57.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus sp.
28093303 28093303 PRJNA694770_P_NODE_93905_length_244_cov_0.900585_g93611_i0 PRJNA694770 93905 244 0.900585 2.1974274 Chroococcidiopsis sp. SAG 2 3088168 Bacteria Bacteria 139 2.529999999999999e-38   NR WP_410500857.1 171389 g93611 i0 87.7 0.995901639344262 81 10 99.6 0 1 243 203 283 WP_410500857.1 tyrosine-type recombinase/integrase [Chroococcidiopsis sp. SAG 2025] diamond 243 139 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. SAG 2025
28409092 28409092 PRJNA694770_P_NODE_98286_length_242_cov_0.911243_g97992_i0 PRJNA694770 98286 242 0.911243 2.20520806 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 158 3.5299999999999996e-46   NR WP_009632809.1 927677 g97992 i0 96.2 0.979338842975207 79 3 97.9 0 242 6 165 243 WP_009632809.1 diaminopimelate epimerase [Synechocystis sp. PCC 7509] diamond 237 158 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
28882558 28882558 PRJNA694770_P_NODE_61648_length_277_cov_1.509804_g61354_i0 PRJNA694770 61648 277 1.509804 4.18215708 Cyanobacteria bacterium DS2.008 2067976 Bacteria Bacteria 154 9.17e-45   NR MBA4049704.1 2067976 g61354 i0 100 0.812274368231047 75 0 81.2 0 227 3 1 75 MBA4049704.1 hypothetical protein [Cyanobacteria bacterium DS2.008] diamond 225 154 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium DS2.008
29293063 29293063 PRJNA694770_P_NODE_35209_length_343_cov_0.840741_g34915_i0 PRJNA694770 35209 343 0.840741 2.88374163 Coleofasciculus sp. G1-WW12-02 3068483 Bacteria Bacteria 101 3.72e-22   NR MEQ8756460.1 3068483 g34915 i0 56.6 2.08163265306122 83 33 72.6 1 252 4 1052 1131 MEQ8756460.1 response regulator [Coleofasciculus sp. G1-WW12-02] diamond 714 101 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus sp. G1-WW12-02
29450711 29450711 PRJNA694770_P_NODE_67050_length_269_cov_1.071429_g66756_i0 PRJNA694770 67050 269 1.071429 2.88214401 Laspinema palackyanum 3231601 Bacteria Bacteria 124 1.1000000000000001e-30   NR WP_367289630.1 3231601 g66756 i0 66.3 1.97397769516729 89 30 99.3 0 269 3 471 559 WP_367289630.1 Ig-like domain-containing protein [Laspinema palackyanum] diamond 531 124 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Laspinemataceae Laspinema Laspinema palackyanum
30082439 30082439 PRJNA694770_P_NODE_58172_length_282_cov_1.473684_g57878_i0 PRJNA694770 58172 282 1.473684 4.15578888 Calothrix sp. PCC 7716 2853227 Bacteria Bacteria 48.1 5.36e-4   NR BDA66277.1 2853227 g57878 i0 39.2 2.06382978723404 97 52 95.7 2 11 280 61 157 BDA66277.1 transcriptional regulator, AraC family [Calothrix sp. PCC 7716] diamond 582 48.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. PCC 7716
30272499 30272499 PRJNA694770_P_NODE_91812_length_245_cov_0.895349_g91518_i0 PRJNA694770 91812 245 0.895349 2.19360505 Halotia branconii 1620816 Bacteria Bacteria 131 3.44e-36   NR WP_281483078.1 1620816 g91518 i0 71.6 1.98367346938776 81 23 99.2 0 243 1 22 102 WP_281483078.1 hypothetical protein [Halotia branconii] diamond 486 131 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nodulariaceae Halotia Halotia branconii
30335769 30335769 PRJNA694770_P_NODE_54232_length_288_cov_1.283721_g53938_i0 PRJNA694770 54232 288 1.283721 3.69711648 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 107 2.68e-26   NR MEK7431537.1 2847862 g53938 i0 54.5 1.03125 99 42 100 1 1 288 21 119 MEK7431537.1 intradiol ring-cleavage dioxygenase [Cyanobacteriota bacterium] diamond 297 107 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30567514 30567514 PRJNA694770_P_NODE_47333_length_304_cov_2.000000_g47039_i0 PRJNA694770 47333 304 2 6.08 Nostoc 1177 Bacteria Bacteria 80.1 5.8e-15   NR WP_409881199.1 3075388 g47039 i0 55.1 2.67434210526316 89 30 85.9 2 4 264 265 345 WP_409881199.1 DUF4347 domain-containing protein, partial [Nostoc sp. DedQUE02] diamond 813 80.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. DedQUE02
31042124 31042124 PRJNA694770_P_NODE_98875_length_241_cov_1.470238_g98581_i0 PRJNA694770 98875 241 1.470238 3.54327358 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 42 0.0137   NR WP_144872594.1 1982969 g98581 i0 41.1 2.86307053941909 56 32 68.5 1 240 76 28 83 WP_144872594.1 hypothetical protein [Hyella patelloides] diamond 690 42.4 0.990566037735849 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Hyella Hyella patelloides
32359219 32359219 PRJNA694770_P_NODE_97399_length_242_cov_0.911243_g97105_i0 PRJNA694770 97399 242 0.911243 2.20520806 Nostoc linckia z16 1628751 Bacteria Bacteria 61.6 8e-11   NR PHK26613.1 1628751 g97105 i0 90.6 0.396694214876033 32 3 39.7 0 240 145 1 32 PHK26613.1 ArsR family transcriptional regulator, partial [Nostoc linckia z16] diamond 96 61.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc linckia
32863691 32863691 PRJNA694770_P_NODE_83420_length_249_cov_0.875000_g83126_i0 PRJNA694770 83420 249 0.875 2.17875 Xenococcaceae cyanobacterium MO_167.B27 3036636 Bacteria Bacteria 45.1 0.0036   NR MDJ0746978.1 3036636 g83126 i0 47.4 0.903614457831325 38 20 45.8 0 248 135 109 146 MDJ0746978.1 tetratricopeptide repeat protein [Xenococcaceae cyanobacterium MO_167.B27] diamond 225 45.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Xenococcaceae   Xenococcaceae cyanobacterium MO_167.B27

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