RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1248424" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 11 ✖

bioproject 1

  • PRJNA1248424 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
8006109 8006109 PRJNA1248424_P_NODE_47687_length_322_cov_2.349398_g41620_i0 PRJNA1248424 47687 322 2.349398 7.56506156 Moorena producens 3L 489825 Bacteria Bacteria 84 7.78e-18   NR EGJ32297.1 489825 g41620 i0 95 0.745341614906832 40 2 37.3 0 320 201 122 161 EGJ32297.1 carbon dioxide concentrating mechanism/carboxysome shell protein [Moorena producens 3L] diamond 240 84 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Moorena Moorena producens
28052678 28052678 PRJNA1248424_P_NODE_72705_length_248_cov_0.880000_g66636_i0 PRJNA1248424 72705 248 0.88 2.1824 Nostoc sp. NMS7 2815391 Bacteria Bacteria 145 4.16e-38   NR WP_292796573.1 2815391 g66636 i0 78 0.991935483870968 82 18 99.2 0 246 1 158 239 WP_292796573.1 SNF2-related protein [Nostoc sp. NMS7] diamond 246 145 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. NMS7
28841945 28841945 PRJNA1248424_P_NODE_28088_length_558_cov_1.247423_g22077_i0 PRJNA1248424 28088 558 1.247423 6.96062034 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 46.6 0.0263   NR MEL7522491.1 3023125 g22077 i0 37.7 0.327956989247312 61 37 32.3 1 402 223 313 373 MEL7522491.1 ribonuclease H family protein [Cyanobacteria bacterium J06553_1] diamond 183 46.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
29315690 29315690 PRJNA1248424_P_NODE_46889_length_325_cov_2.166667_g40822_i0 PRJNA1248424 46889 325 2.166667 7.04166775 Microcystis sp. 53602_E8 2904984 Bacteria Bacteria 63.9 3.49e-9   NR MCE2664493.1 2904984 g40822 i0 54.2 0.443076923076923 48 22 44.3 0 182 39 744 791 MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8] diamond 144 63.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. 53602_E8
29536723 29536723 PRJNA1248424_P_NODE_58690_length_279_cov_1.325243_g52622_i0 PRJNA1248424 58690 279 1.325243 3.69742797 Kaiparowitsia implicata 2303525 Bacteria Bacteria 43.1 0.0397   NR MBW4655476.1 2057771 g52622 i0 27.5 0.860215053763441 80 56 86 1 12 251 88 165 MBW4655476.1 amino acid ABC transporter permease [Kaiparowitsia implicata GSE-PSE-MK54-09C] diamond 240 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Kaiparowitsia Kaiparowitsia implicata
29725857 29725857 PRJNA1248424_P_NODE_15450_length_1193_cov_1.629464_g10875_i0 PRJNA1248424 15450 1193 1.629464 19.43950552 Microcystis sp. 53602_E8 2904984 Bacteria Bacteria 49.7 0.0248   NR MCE2664493.1 2904984 g10875 i0 41.7 0.12070410729254 48 28 12.1 0 794 651 754 801 MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8] diamond 144 49.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. 53602_E8
31369420 31369420 PRJNA1248424_P_NODE_45356_length_334_cov_2.191571_g39292_i0 PRJNA1248424 45356 334 2.191571 7.31984714 Pleurocapsa sp. MO_226.B13 3036786 Bacteria Bacteria 63.9 3.89e-9   NR MDJ0596593.1 3036786 g39292 i0 46 0.565868263473054 63 34 56.6 0 281 93 832 894 MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13] diamond 189 63.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. MO_226.B13
31748626 31748626 PRJNA1248424_P_NODE_55297_length_287_cov_2.635514_g49229_i0 PRJNA1248424 55297 287 2.635514 7.56392518 Coleofasciculaceae cyanobacterium 3081323 Bacteria Bacteria 62.8 5.73e-9   NR HEY9742802.1 3081323 g49229 i0 86.7 0.313588850174216 30 4 31.4 0 287 198 342 371 HEY9742802.1 ATP-binding protein [Coleofasciculaceae cyanobacterium] diamond 90 62.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae   Coleofasciculaceae cyanobacterium
32033512 32033512 PRJNA1248424_P_NODE_65398_length_261_cov_1.122340_g59329_i0 PRJNA1248424 65398 261 1.12234 2.9293074 Coleofasciculus sp. FACHB-112 3100458 Bacteria Bacteria 164 1.17e-44   NR WP_190818153.1 2692783 g59329 i0 96.5 0.988505747126437 86 3 98.9 0 3 260 45 130 WP_190818153.1 glycerol-3-phosphate acyltransferase [Coleofasciculus sp. FACHB-1120] diamond 258 164 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus sp. FACHB-1120
32508332 32508332 PRJNA1248424_P_NODE_47879_length_322_cov_0.907631_g41812_i0 PRJNA1248424 47879 322 0.907631 2.92257182 Pleurocapsa sp. MO_226.B13 3036786 Bacteria Bacteria 64.3 2.56e-9   NR MDJ0596593.1 3036786 g41812 i0 47 0.614906832298137 66 35 61.5 0 199 2 827 892 MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13] diamond 198 64.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. MO_226.B13
32886029 32886029 PRJNA1248424_P_NODE_17820_length_1007_cov_1.926124_g12708_i0 PRJNA1248424 17820 1007 1.926124 19.39606868 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 159 3.78e-39   NR MEL7520018.1 3023125 g12708 i0 38.7 1.35849056603774 230 135 67.3 2 321 998 695 922 MEL7520018.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1] diamond 1368 159 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1

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