RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA814235 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
12705618 12705618 PRJNA814235_P_NODE_152850_length_172_cov_2.007407_g151455_i0 PRJNA814235 152850 172 2.007407 3.45274004 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 104 1.78e-26   NR OWY59350.1 1503470 g151455 i0 96.4 2.93023255813953 56 2 97.7 0 169 2 19 74 OWY59350.1 UMP kinase, partial [cyanobacterium TDX16] diamond 504 104 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium TDX16
18669224 18669224 PRJNA814235_P_NODE_48535_length_274_cov_1.696203_g47142_i0 PRJNA814235 48535 274 1.696203 4.64759622 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 172 5.38e-52   NR OWY60602.1 1503470 g47142 i0 89 12.9525547445255 91 10 99.6 0 1 273 36 126 OWY60602.1 erythromycin biosynthesis sensory transduction protein eryC1, partial [cyanobacterium TDX16] diamond 3549 173 0.994219653179191 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium TDX16
26801118 26801118 PRJNA814235_P_NODE_120161_length_203_cov_1.710843_g118766_i0 PRJNA814235 120161 203 1.710843 3.47301129 Trichocoleus desertorum 1481672 Bacteria Bacteria 52.8 6.19e-6   NR WP_348230487.1 1481672 g118766 i0 48.6 1.064039408867 72 27 91.6 1 15 200 5 76 WP_348230487.1 ABC transporter ATP-binding protein [Trichocoleus desertorum] diamond 216 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Trichocoleusaceae Trichocoleus Trichocoleus desertorum
26809990 26809990 PRJNA814235_P_NODE_196101_length_150_cov_5.955752_g194706_i0 PRJNA814235 196101 150 5.955752 8.933628 Bacteria 2 Bacteria Bacteria 46.2 6.11e-4   NR WP_332867532.1 1579216 g194706 i0 92 4.56 25 2 50 0 2 76 238 262 WP_332867532.1 glucose-6-phosphate dehydrogenase [Pannus brasiliensis] diamond 684 46.6 0.991416309012876 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Pannus Pannus brasiliensis
27022741 27022741 PRJNA814235_P_NODE_151642_length_173_cov_2.007353_g150247_i0 PRJNA814235 151642 173 2.007353 3.47272069 Synechococcaceae cyanobacterium 2588875 Bacteria Bacteria 40.8 0.0466   NR MEB3200027.1 2588875 g150247 i0 48.9 0.815028901734104 47 16 81.5 2 4 144 69 107 MEB3200027.1 hypothetical protein [Synechococcaceae cyanobacterium] diamond 141 40.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae   Synechococcaceae cyanobacterium
27339030 27339030 PRJNA814235_P_NODE_58663_length_248_cov_3.606635_g57269_i0 PRJNA814235 58663 248 3.606635 8.9444548 Thermosynechococcaceae cyanobacterium MS004 2881380 Bacteria Bacteria 42.4 0.0494   NR MCG9891895.1 2881380 g57269 i0 50 0.508064516129032 42 19 48.4 1 48 167 21 62 MCG9891895.1 prohibitin family protein [Thermosynechococcaceae cyanobacterium MS004] diamond 126 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Acaryochloridales Thermosynechococcaceae   Thermosynechococcaceae cyanobacterium MS004
27496886 27496886 PRJNA814235_P_NODE_200443_length_150_cov_2.911504_g199048_i0 PRJNA814235 200443 150 2.911504 4.367256 Nostoc sp. 1180 Bacteria Bacteria 47.8 1.83e-4   NR WP_334917704.1 1180 g199048 i0 96 0.5 25 1 50 0 75 1 25 49 WP_334917704.1 NB-ARC domain-containing protein [Nostoc sp.] diamond 75 47.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
27496919 27496919 PRJNA814235_P_NODE_89243_length_203_cov_3.608434_g87848_i0 PRJNA814235 89243 203 3.608434 7.32512102 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 43.9 0.00874   NR MBX9696133.1 2847862 g87848 i0 79.2 0.354679802955665 24 5 35.5 0 130 201 717 740 MBX9696133.1 M1 family metallopeptidase [Cyanobacteriota bacterium] diamond 72 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27663514 27663514 PRJNA814235_P_NODE_46824_length_279_cov_1.599174_g45432_i0 PRJNA814235 46824 279 1.599174 4.46169546 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 90.1 6.1e-21   NR OWY60765.1 1503470 g45432 i0 97.8 3.95698924731183 46 1 49.5 0 279 142 73 118 OWY60765.1 hypothetical protein B7486_67410 [cyanobacterium TDX16] diamond 1104 90.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium TDX16
28096644 28096644 PRJNA814235_P_NODE_109445_length_203_cov_2.084337_g108050_i0 PRJNA814235 109445 203 2.084337 4.23120411 Nostocaceae cyanobacterium 2723028 Bacteria Bacteria 42.7 0.0223   NR HLO86113.1 2723028 g108050 i0 79.2 0.354679802955665 24 5 35.5 0 74 3 619 642 HLO86113.1 ATP-binding protein [Nostocaceae cyanobacterium] diamond 72 42.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae   Nostocaceae cyanobacterium
28349250 28349250 PRJNA814235_P_NODE_35546_length_321_cov_1.588028_g34157_i0 PRJNA814235 35546 321 1.588028 5.09756988 Microcystis sp. M04BS1 2771195 Bacteria Bacteria 171 6.949999999999998e-47   NR MCA2554290.1 2771195 g34157 i0 90.7 1 107 10 100 0 1 321 65 171 MCA2554290.1 T9SS type A sorting domain-containing protein [Microcystis sp. M04BS1] diamond 321 171 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. M04BS1
28349282 28349282 PRJNA814235_P_NODE_85026_length_206_cov_2.207101_g83631_i0 PRJNA814235 85026 206 2.207101 4.54662806 Coleofasciculus sp. FACHB-125 2692784 Bacteria Bacteria 50.1 2.88e-6   NR WP_190414828.1 2692784 g83631 i0 91.3 0.33495145631068 23 2 33.5 0 2 70 30 52 WP_190414828.1 hypothetical protein [Coleofasciculus sp. FACHB-125] diamond 69 50.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus sp. FACHB-125
28570221 28570221 PRJNA814235_P_NODE_140787_length_183_cov_2.191781_g139392_i0 PRJNA814235 140787 183 2.191781 4.01095923 cyanobacterium TDX16 1503470 Bacteria Bacteria 117 2.7799999999999998e-31   NR OWY59332.1 1503470 g139392 i0 91.7 0.983606557377049 60 5 98.4 0 182 3 11 70 OWY59332.1 glucoamylase, partial [cyanobacterium TDX16] diamond 180 117 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium TDX16
28791228 28791228 PRJNA814235_P_NODE_90567_length_203_cov_3.295181_g89172_i0 PRJNA814235 90567 203 3.295181 6.68921743 Oscillatoriaceae cyanobacterium 2664179 Bacteria Bacteria 45.8 0.00182   NR HEY9724203.1 2664179 g89172 i0 80 0.369458128078818 25 5 36.9 0 2 76 350 374 HEY9724203.1 helicase-related protein [Oscillatoriaceae cyanobacterium] diamond 75 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae   Oscillatoriaceae cyanobacterium
28885892 28885892 PRJNA814235_P_NODE_133268_length_191_cov_2.214286_g131873_i0 PRJNA814235 133268 191 2.214286 4.22928626 Cyanobacteria bacterium HKST-UBA02 2775582 Bacteria Bacteria 48.9 5.15e-5   NR MCA9805583.1 2775582 g131873 i0 41.7 0.942408376963351 60 29 84.8 1 4 165 30 89 MCA9805583.1 hypothetical protein [Cyanobacteria bacterium HKST-UBA02] diamond 180 48.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium HKST-UBA02
28917392 28917392 PRJNA814235_P_NODE_39948_length_302_cov_2.845283_g38557_i0 PRJNA814235 39948 302 2.845283 8.59275466 Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40 3070899 Bacteria Bacteria 76.3 1.28e-13   NR MDQ5938180.1 3070899 g38557 i0 58.5 0.645695364238411 65 27 64.6 0 301 107 150 214 MDQ5938180.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40] diamond 195 76.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
29044100 29044100 PRJNA814235_P_NODE_34228_length_327_cov_1.737931_g32840_i0 PRJNA814235 34228 327 1.737931 5.68303437 cyanobacterium TDX16 1503470 Bacteria Bacteria 122 1.2499999999999998e-32   NR OWY59876.1 1503470 g32840 i0 77.6 1.24770642201835 76 17 69.7 0 100 327 3 78 OWY59876.1 hypothetical protein B7486_72215, partial [cyanobacterium TDX16] diamond 408 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium TDX16
29462731 29462731 PRJNA814235_P_NODE_90090_length_203_cov_3.397590_g88695_i0 PRJNA814235 90090 203 3.39759 6.8971077 Cyanophyceae 3028117 Bacteria Bacteria 52.4 8.84e-6   NR WP_265238452.1 439293 g88695 i0 100 14.8965517241379 24 0 35.5 0 130 201 32 55 WP_265238452.1 DNA polymerase I [Lyngbya sp. CCAP 1446/10] diamond 3024 52.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Lyngbya Lyngbya sp. CCAP 1446/10
29706497 29706497 PRJNA814235_P_NODE_114590_length_203_cov_1.951807_g113195_i0 PRJNA814235 114590 203 1.951807 3.96216821 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 48.1 2.23e-4   NR MBX9693684.1 2847862 g113195 i0 87.5 0.354679802955665 24 3 35.5 0 131 202 182 205 MBX9693684.1 class I SAM-dependent methyltransferase [Cyanobacteriota bacterium] diamond 72 48.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29833206 29833206 PRJNA814235_P_NODE_100011_length_203_cov_2.445783_g98616_i0 PRJNA814235 100011 203 2.445783 4.96493949 Crinalium sp. 3088173 Bacteria Bacteria 60.1 1.71e-8   NR HEY9621010.1 3088173 g98616 i0 47.8 0.990147783251232 67 33 99 1 3 203 1262 1326 HEY9621010.1 tandem-95 repeat protein [Crinalium sp.] diamond 201 60.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Crinalium Crinalium sp.
29959555 29959555 PRJNA814235_P_NODE_121031_length_203_cov_1.560241_g119636_i0 PRJNA814235 121031 203 1.560241 3.16728923 Phormidium sp. 1199 Bacteria Bacteria 49.7 7.6e-5   NR HEY9300555.1 1199 g119636 i0 92 0.369458128078818 25 2 36.9 0 3 77 163 187 HEY9300555.1 hypothetical protein [Phormidium sp.] diamond 75 49.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Phormidium Phormidium sp.
30275804 30275804 PRJNA814235_P_NODE_118332_length_203_cov_1.825301_g116937_i0 PRJNA814235 118332 203 1.825301 3.70536103 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 44.3 0.00197   NR HEY9756462.1 3088181 g116937 i0 72.7 0.32512315270936 22 6 32.5 0 200 135 94 115 HEY9756462.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 66 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
30591439 30591439 PRJNA814235_P_NODE_112573_length_203_cov_2.000000_g111178_i0 PRJNA814235 112573 203 2 4.06 Aliterella atlantica 1827278 Bacteria Bacteria 53.1 3.32e-6   NR WP_045056217.1 1827278 g111178 i0 100 0.738916256157635 25 0 36.9 0 76 2 171 195 WP_045056217.1 ribose-5-phosphate isomerase RpiA [Aliterella atlantica] diamond 150 53.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
30663376 30663376 PRJNA814235_P_NODE_110273_length_203_cov_2.060241_g108878_i0 PRJNA814235 110273 203 2.060241 4.18228923 Leptolyngbya 47251 Bacteria Bacteria 90.1 2.18e-19   NR MEB3267406.1 47254 g108878 i0 65.7 9.78325123152709 67 7 99 1 203 3 80 130 MEB3267406.1 S-(hydroxymethyl)glutathione dehydrogenase/class III alcohol dehydrogenase [Leptolyngbya sp.] diamond 1986 90.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp.
30852953 30852953 PRJNA814235_P_NODE_142074_length_182_cov_1.344828_g140679_i0 PRJNA814235 142074 182 1.344828 2.44758696 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 73.9 1.2e-15   NR OWY61475.1 1503470 g140679 i0 81.6 4.03846153846154 49 5 80.8 1 182 36 29 73 OWY61475.1 hypothetical protein B7486_63590, partial [cyanobacterium TDX16] diamond 735 73.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium TDX16
30875834 30875834 PRJNA814235_P_NODE_101514_length_203_cov_2.379518_g100119_i0 PRJNA814235 101514 203 2.379518 4.83042154 Cyanobacteria bacterium UBA11049 2055787 Bacteria Bacteria 46.6 9.04e-4   NR HCF26448.1 2055787 g100119 i0 84 0.369458128078818 25 4 36.9 0 129 203 2 26 HCF26448.1 hypothetical protein [Cyanobacteria bacterium UBA11049] diamond 75 46.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
31919387 31919387 PRJNA814235_P_NODE_97017_length_203_cov_2.608434_g95622_i0 PRJNA814235 97017 203 2.608434 5.29512102 Chroococcus sp. FPU1 1974212 Bacteria Bacteria 55.1 2.32e-7   NR WP_206817641.1 1974212 g95622 i0 96 0.369458128078818 25 1 36.9 0 3 77 100 124 WP_206817641.1 SRPBCC family protein [Chroococcus sp. FPU101] diamond 75 55.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Chroococcus Chroococcus sp. FPU101
31950847 31950847 PRJNA814235_P_NODE_109977_length_203_cov_2.072289_g108582_i0 PRJNA814235 109977 203 2.072289 4.20674667 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 43.5 0.0118   NR MFQ3618680.1 2847862 g108582 i0 72 0.369458128078818 25 7 36.9 0 75 1 13 37 MFQ3618680.1 hypothetical protein [Cyanobacteriota bacterium] diamond 75 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32149612 32149612 PRJNA814235_P_NODE_38058_length_310_cov_1.934066_g36668_i0 PRJNA814235 38058 310 1.934066 5.9956046 Bacteria 2 Bacteria Bacteria 96.3 3.24e-21   NR MBS1999176.1 2807731 g36668 i0 58 1.56774193548387 81 34 78.4 0 310 68 13 93 MBS1999176.1 acyltransferase [Cyanobacteria bacterium SZAS LIN-2] diamond 486 96.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS LIN-2
32267521 32267521 PRJNA814235_P_NODE_122858_length_202_cov_2.369697_g121463_i0 PRJNA814235 122858 202 2.369697 4.78678794 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 44.3 0.00511   NR MDY6936157.1 2847862 g121463 i0 75 1.41089108910891 24 6 35.6 0 2 73 119 142 MDY6936157.1 bifunctional 4-hydroxy-2-oxoglutarate aldolase/2-dehydro-3-deoxy-phosphogluconate aldolase [Cyanobacteriota bacterium] diamond 285 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32299368 32299368 PRJNA814235_P_NODE_163119_length_164_cov_1.480315_g161724_i0 PRJNA814235 163119 164 1.480315 2.4277166 Chroococcidiopsis sp. SAG 2 3088168 Bacteria Bacteria 103 1.74e-24   NR WP_317110840.1 171389 g161724 i0 98.1 0.951219512195122 52 1 95.1 0 158 3 1 52 WP_317110840.1 IS630 family transposase [Chroococcidiopsis sp. SAG 2025] diamond 156 103 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. SAG 2025
32772455 32772455 PRJNA814235_P_NODE_109720_length_203_cov_2.078313_g108325_i0 PRJNA814235 109720 203 2.078313 4.21897539 Cyanophyceae 3028117 Bacteria Bacteria 49.3 1.04e-4   NR WP_190767714.1 3028117 g108325 i0 100 0.354679802955665 24 0 35.5 0 202 131 190 213 WP_190767714.1 MULTISPECIES: 23S rRNA (adenine(2503)-C(2))-methyltransferase RlmN [Cyanophyceae] diamond 72 49.3 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);;