RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA785164", 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 · 18 ✖

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 18 ✖

bioproject 1

  • PRJNA785164 · 18 ✖
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
7145265 7145265 PRJNA785164_P_NODE_64566_length_213_cov_4.185714_g64101_i0 PRJNA785164 64566 213 4.185714 8.91557082 Kovacikia minuta 2931930 Bacteria Bacteria 385 1.63e-102   NTclustered gi|2098452651|gb|CP083582.1| 2653194 g64101 i0 99.526 137.746478873239 211 1 99 0 1 211 4175605 4175815 Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome blastn 29340 385 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Kovacikia Kovacikia minuta
26800434 26800434 PRJNA785164_P_NODE_53281_length_249_cov_0.875000_g52816_i0 PRJNA785164 53281 249 0.875 2.17875 Dolichospermum sp. DET73 2717879 Bacteria Bacteria 71.2 1.51e-13   NR MBO1052853.1 2717879 g52816 i0 47.3 0.891566265060241 74 39 89.2 0 3 224 55 128 MBO1052853.1 ribonuclease HI [Dolichospermum sp. DET73] diamond 222 71.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp. DET73
27116643 27116643 PRJNA785164_P_NODE_39682_length_286_cov_1.446009_g39217_i0 PRJNA785164 39682 286 1.446009 4.13558574 Microcoleus sp. herbarium19 3055440 Bacteria Bacteria 55.1 2.51e-6   NR WP_333272795.1 3055440 g39217 i0 38.9 0.944055944055944 90 52 94.4 1 17 286 130 216 WP_333272795.1 hypothetical protein [Microcoleus sp. herbarium19] diamond 270 55.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. herbarium19
27148040 27148040 PRJNA785164_P_NODE_57222_length_245_cov_1.343023_g56757_i0 PRJNA785164 57222 245 1.343023 3.29040635 Aphanizomenon flos-aquae WA1 1176 Bacteria Bacteria 79 6.8e-15   NR OBQ43517.1 1710896 g56757 i0 42 5.95102040816327 81 47 99.2 0 245 3 553 633 OBQ43517.1 MAG: hypothetical protein AN484_11905 [Aphanizomenon flos-aquae WA102] diamond 1458 79 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Aphanizomenon Aphanizomenon flos-aquae
27433146 27433146 PRJNA785164_P_NODE_57563_length_245_cov_0.895349_g57098_i0 PRJNA785164 57563 245 0.895349 2.19360505 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 110 1.93e-26   NR MBA4079027.1 2067979 g57098 i0 98.2 0.685714285714286 56 1 68.6 0 78 245 1 56 MBA4079027.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 168 110 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
28064334 28064334 PRJNA785164_P_NODE_48805_length_257_cov_1.456522_g48340_i0 PRJNA785164 48805 257 1.456522 3.74326154 Stenomitos sp. 3088177 Bacteria Bacteria 56.6 2.31e-7   NR HEY9826375.1 3088177 g48340 i0 44.9 0.805447470817121 69 38 80.5 0 215 9 5 73 HEY9826375.1 hypothetical protein [Stenomitos sp.] diamond 207 56.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Stenomitos Stenomitos sp.
28285164 28285164 PRJNA785164_P_NODE_55706_length_247_cov_0.885057_g55241_i0 PRJNA785164 55706 247 0.885057 2.18609079 Cyanobacteria bacterium SZAS LIN-3 2807732 Bacteria Bacteria 48.1 2.52e-4   NR MBS1993463.1 2807732 g55241 i0 42.6 0.65587044534413 54 30 64.4 1 247 89 123 176 MBS1993463.1 hypothetical protein [Cyanobacteria bacterium SZAS LIN-3] diamond 162 48.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS LIN-3
28443470 28443470 PRJNA785164_P_NODE_56606_length_246_cov_0.890173_g56141_i0 PRJNA785164 56606 246 0.890173 2.18982558 Microseira sp. BLCC-F43 3153602 Bacteria Bacteria 125 2.36e-34   NR WP_374885282.1 3153602 g56141 i0 67.9 0.98780487804878 81 26 98.8 0 246 4 55 135 WP_374885282.1 DinB family protein [Microseira sp. BLCC-F43] diamond 243 125 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Microseira Microseira sp. BLCC-F43
28632930 28632930 PRJNA785164_P_NODE_63527_length_232_cov_2.031447_g63062_i0 PRJNA785164 63527 232 2.031447 4.71295704 Cyanobacteria bacterium SZAS LIN-5 2807734 Bacteria Bacteria 89 1.9e-20   NR MBS2005127.1 2807734 g63062 i0 91.8 1.26724137931034 49 4 63.4 0 147 1 1 49 MBS2005127.1 Rrf2 family transcriptional regulator [Cyanobacteria bacterium SZAS LIN-5] diamond 294 89 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS LIN-5
29169626 29169626 PRJNA785164_P_NODE_56829_length_246_cov_0.890173_g56364_i0 PRJNA785164 56829 246 0.890173 2.18982558 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 172 6.23e-52   NR MBA4073781.1 2067979 g56364 i0 97.6 1 82 2 100 0 1 246 150 231 MBA4073781.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 246 172 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
29990528 29990528 PRJNA785164_P_NODE_32971_length_317_cov_1.163934_g32506_i0 PRJNA785164 32971 317 1.163934 3.68967078 Coleofasciculus chthonoplastes 64178 Bacteria Bacteria 61.6 1.77e-8   NR WP_006105016.1 64178 g32506 i0 33.3 0.766561514195584 81 54 76.7 0 301 59 152 232 WP_006105016.1 glycosyltransferase family A protein [Coleofasciculus chthonoplastes] diamond 243 61.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus chthonoplastes
30370071 30370071 PRJNA785164_P_NODE_52372_length_250_cov_0.870056_g51907_i0 PRJNA785164 52372 250 0.870056 2.17514 Calothrix sp. SM1_5_4 2720460 Bacteria Bacteria 46.6 1.47e-4   NR NJL25963.1 2720460 g51907 i0 50 0.72 60 29 70.8 1 201 25 3 62 NJL25963.1 hypothetical protein [Calothrix sp. SM1_5_4] diamond 180 46.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. SM1_5_4
30622242 30622242 PRJNA785164_P_NODE_62193_length_241_cov_0.916667_g61728_i0 PRJNA785164 62193 241 0.916667 2.20916747 Cyanobacteria bacterium P01_H01_bin.21 3023318 Bacteria Bacteria 91.7 7.410000000000001e-21   NR MEM1256231.1 3023318 g61728 i0 60 0.933609958506224 75 30 93.4 0 240 16 121 195 MEM1256231.1 NAD(P)-binding domain-containing protein [Cyanobacteria bacterium P01_H01_bin.21] diamond 225 91.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_H01_bin.21
30694801 30694801 PRJNA785164_P_NODE_51373_length_251_cov_0.865169_g50908_i0 PRJNA785164 51373 251 0.865169 2.17157419 Nostocales 1161 Bacteria Bacteria 65.1 5.42e-10   NR MBW4675933.1 1874567 g50908 i0 56.7 2.85657370517928 60 24 69.3 2 30 203 474 533 MBW4675933.1 hypothetical protein [Desmonostoc geniculatum HA4340-LM1] diamond 717 65.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Desmonostoc Desmonostoc geniculatum
30717052 30717052 PRJNA785164_P_NODE_57374_length_245_cov_0.895349_g56909_i0 PRJNA785164 57374 245 0.895349 2.19360505 Leptolyngbyaceae cyanobacterium bins.302 2971802 Bacteria Bacteria 51.2 3.67e-5   NR MDX2242410.1 2971802 g56909 i0 40 0.918367346938776 75 39 91.8 2 11 235 44 112 MDX2242410.1 hypothetical protein [Leptolyngbyaceae cyanobacterium bins.302] diamond 225 51.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium bins.302
30780341 30780341 PRJNA785164_P_NODE_55754_length_247_cov_0.885057_g55289_i0 PRJNA785164 55754 247 0.885057 2.18609079 Pseudanabaena sp. 1153 Bacteria Bacteria 71.2 3.41e-12   NR MFN7394176.1 1153 g55289 i0 48.7 0.923076923076923 76 37 91.1 2 230 6 234 308 MFN7394176.1 hypothetical protein [Pseudanabaena sp.] diamond 228 71.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp.
31001611 31001611 PRJNA785164_P_NODE_42054_length_278_cov_1.292683_g41589_i0 PRJNA785164 42054 278 1.292683 3.59365874 Microcoleus sp. 44472 Bacteria Bacteria 56.2 8.9e-7   NR WP_371120867.1 44472 g41589 i0 53.4 0.62589928057554 58 19 54 1 276 127 155 212 WP_371120867.1 phage recombination protein Bet [Microcoleus sp.] diamond 174 56.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp.
32834796 32834796 PRJNA785164_P_NODE_49340_length_255_cov_2.637363_g48875_i0 PRJNA785164 49340 255 2.637363 6.72527565 Leptolyngbyaceae cyanobacterium RM2_2_4 2720439 Bacteria Bacteria 63.5 1.91e-9   NR NJO48208.1 2720439 g48875 i0 70 0.470588235294118 40 12 47.1 0 134 253 49 88 NJO48208.1 RNA ligase (ATP) [Leptolyngbyaceae cyanobacterium RM2_2_4] diamond 120 63.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium RM2_2_4

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