RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA482207" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 20 ✖

bioproject 1

  • PRJNA482207 · 20 ✖
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
11300425 11300425 PRJNA482207_P_NODE_16889_length_269_cov_1.474490_g16779_i0 PRJNA482207 16889 269 1.47449 3.9663781 Cyanobacterium 102234 Bacteria Bacteria 54.7 0.007   NTclustered gi|428682694|gb|CP003947.1| 755178 g16779 i0 100 0.765799256505576 29 0 11 0 12 40 846801 846773 Cyanobacterium aponinum PCC 10605 chromosome, complete genome blastn 206 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium Cyanobacterium aponinum
11300462 11300462 PRJNA482207_P_NODE_29609_length_242_cov_0.911243_g29499_i0 PRJNA482207 29609 242 0.911243 2.20520806 Cyanophyceae 3028117 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|321271959|gb|HQ419056.1| 1211 g29499 i0 100 103 242 0 100 0 1 242 845 1086 Uncultured cyanobacterium clone AL58_2CY_13 16S ribosomal RNA gene, partial sequence blastn 24926 448 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
26664464 26664464 PRJNA482207_P_NODE_19661_length_251_cov_0.865169_g19551_i0 PRJNA482207 19661 251 0.865169 2.17157419 Rivularia sp. PCC 7116 373994 Bacteria Bacteria 116 5.79e-28   NR WP_015122203.1 373994 g19551 i0 71.3 0.956175298804781 80 23 95.6 0 12 251 739 818 WP_015122203.1 cadherin domain-containing protein [Rivularia sp. PCC 7116] diamond 240 116 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Rivulariaceae Rivularia Rivularia sp. PCC 7116
28150278 28150278 PRJNA482207_P_NODE_125_length_2333_cov_1.380088_g95_i1 PRJNA482207 125 2333 1.380088 32.19745304 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 137 5.870000000000001e-29   NR NJK52916.1 2720479 g95 i1 35.8 0.316330904414916 246 148 31.6 4 1407 2144 253 488 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 738 137 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
28166294 28166294 PRJNA482207_P_NODE_21025_length_250_cov_0.870056_g20915_i0 PRJNA482207 21025 250 0.870056 2.17514 Bacillati 1783272 Bacteria Bacteria 130 7.639999999999998e-35   NR NEP84575.1 2607804 g20915 i0 82.9 1.968 82 14 98.4 0 3 248 45 126 NEP84575.1 metal ABC transporter permease [Okeania sp. SIO3B3] diamond 492 131 0.99236641221374 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. SIO3B3
28244669 28244669 PRJNA482207_P_NODE_7206_length_371_cov_1.258389_g7096_i0 PRJNA482207 7206 371 1.258389 4.66862319 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 55.8 4.17e-6   NR NJK52916.1 2720479 g7096 i0 36.8 0.768194070080862 95 54 76.8 1 85 369 242 330 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 285 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
28402730 28402730 PRJNA482207_P_NODE_106_length_2497_cov_1.369224_g95_i0 PRJNA482207 106 2497 1.369224 34.18952328 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 137 7.58e-29   NR NJK52916.1 2720479 g95 i0 35.8 0.295554665598718 246 148 29.6 4 927 190 253 488 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 738 137 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
28434339 28434339 PRJNA482207_P_NODE_4066_length_473_cov_1.687500_g3956_i0 PRJNA482207 4066 473 1.6875 7.981875 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 72.4 1.59e-11   NR MEL7521725.1 3023125 g3956 i0 35.5 0.78646934460888 124 75 78.6 3 102 473 51 169 MEL7521725.1 hypothetical protein [Cyanobacteria bacterium J06553_1] diamond 372 72.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
28497583 28497583 PRJNA482207_P_NODE_24947_length_246_cov_0.890173_g24837_i0 PRJNA482207 24947 246 0.890173 2.18982558 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 45.1 0.00595   NR NJK52916.1 2720479 g24837 i0 34.2 0.890243902439024 73 48 89 0 27 245 398 470 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 219 45.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
28812846 28812846 PRJNA482207_P_NODE_15308_length_281_cov_1.245192_g15198_i0 PRJNA482207 15308 281 1.245192 3.49898952 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 56.2 1.08e-6   NR NJK52916.1 2720479 g15198 i0 47.4 0.608540925266904 57 30 60.9 0 92 262 322 378 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 171 56.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
29823316 29823316 PRJNA482207_P_NODE_10271_length_327_cov_0.842520_g10161_i0 PRJNA482207 10271 327 0.84252 2.7550404 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 47 0.00334   NR NJK52916.1 2720479 g10161 i0 46.8 0.431192660550459 47 25 43.1 0 315 175 430 476 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 141 47 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
29823317 29823317 PRJNA482207_P_NODE_111_length_2425_cov_1.867347_g99_i0 PRJNA482207 111 2425 1.867347 45.28316475 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 267 7.52e-72   NR NJK52916.1 2720479 g99 i0 33.7 0.68659793814433 555 340 68.4 8 1703 45 242 770 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 1665 267 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
29886865 29886865 PRJNA482207_P_NODE_9911_length_331_cov_0.895349_g9801_i0 PRJNA482207 9911 331 0.895349 2.96360519 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 50.4 2.04e-4   NR NJK52916.1 2720479 g9801 i0 40 0.725075528700906 80 46 71.6 2 278 42 277 355 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 240 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
29918461 29918461 PRJNA482207_P_NODE_8491_length_349_cov_0.717391_g8381_i0 PRJNA482207 8491 349 0.717391 2.50369459 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 63.2 8.01e-9   NR MEL7521725.1 3023125 g8381 i0 35.6 0.868194842406877 101 63 86.8 1 322 20 51 149 MEL7521725.1 hypothetical protein [Cyanobacteria bacterium J06553_1] diamond 303 63.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
30139077 30139077 PRJNA482207_P_NODE_28692_length_243_cov_0.864706_g28582_i0 PRJNA482207 28692 243 0.864706 2.10123558 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 83.6 8.99e-17   NR MBX9720367.1 2364082 g28582 i0 51.3 0.987654320987654 80 39 98.8 0 3 242 108 187 MBX9720367.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 240 83.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30345682 30345682 PRJNA482207_P_NODE_20912_length_250_cov_0.870056_g20802_i0 PRJNA482207 20912 250 0.870056 2.17514 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 58.2 1.68e-8   NR MEM9807947.1 3023279 g20802 i0 74.3 1.26 35 9 42 0 145 249 1 35 MEM9807947.1 DUF1801 domain-containing protein [Cyanobacteria bacterium P01_D01_bin.56] diamond 315 58.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_D01_bin.56
31181801 31181801 PRJNA482207_P_NODE_7535_length_365_cov_0.698630_g7425_i0 PRJNA482207 7535 365 0.69863 2.5499995 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 54.3 1.35e-5   NR NJK52916.1 2720479 g7425 i0 35.2 0.747945205479452 91 57 74.8 2 282 10 321 409 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 273 54.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
31466904 31466904 PRJNA482207_P_NODE_1276_length_795_cov_1.447368_g1196_i0 PRJNA482207 1276 795 1.447368 11.5065756 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 82.8 4.74e-14   NR MEL7521725.1 3023125 g1196 i0 29.2 0.735849056603774 195 115 73.6 4 52 636 8 179 MEL7521725.1 hypothetical protein [Cyanobacteria bacterium J06553_1] diamond 585 82.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
31782871 31782871 PRJNA482207_P_NODE_277_length_1611_cov_1.463589_g250_i0 PRJNA482207 277 1611 1.463589 23.57841879 Leptolyngbyaceae cyanobacterium SU_3_3 2720479 Bacteria Bacteria 188 5.199999999999998e-47   NR NJK52916.1 2720479 g250 i0 26.2 1.97951582867784 553 341 94.2 11 1560 43 571 1103 NJK52916.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SU_3_3] diamond 3189 188 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SU_3_3
32762906 32762906 PRJNA482207_P_NODE_780_length_992_cov_1.523395_g713_i0 PRJNA482207 780 992 1.523395 15.1120784 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 189 5.54e-52   NR MEL7521272.1 3023125 g713 i0 38.8 0.840725806451613 278 161 83.8 4 846 16 2 271 MEL7521272.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06553_1] diamond 834 189 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);;