RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA738523" 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 · 11 ✖

bioproject 1

  • PRJNA738523 · 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
6301788 6301788 PRJNA738523_P_NODE_4785_length_324_cov_1.394422_g4714_i0 PRJNA738523 4785 324 1.394422 4.51792728 Fischerella sp. 1191 Bacteria Bacteria 122 3.3699999999999997e-32   NR MCX7592451.1 1191 g4714 i0 57.4 3 108 40 98.1 2 319 2 49 152 MCX7592451.1 aldehyde dehydrogenase family protein [Fischerella sp.] diamond 972 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Hapalosiphonaceae Fischerella Fischerella sp.
10126401 10126401 PRJNA738523_P_NODE_6788_length_286_cov_1.436620_g6717_i0 PRJNA738523 6788 286 1.43662 4.1087332 Planktothrix 54304 Bacteria Bacteria 363 1.08e-95   NTclustered gi|2261196917|emb|LR882969.1| 1160 g6717 i0 89.655 179.566433566434 290 22 100 5 1 286 621922 622207 Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I blastn 51356 363 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix agardhii
15226276 15226276 PRJNA738523_P_NODE_14512_length_244_cov_0.900585_g14441_i0 PRJNA738523 14512 244 0.900585 2.1974274 Chroococcidiopsis 54298 Bacteria Bacteria 357 4.16e-94   NTclustered gi|428006994|gb|CP003597.1| 251229 g14441 i0 93.033 2 244 17 100 0 1 244 1448573 1448816 Chroococcidiopsis thermalis PCC 7203, complete genome blastn 488 357 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis thermalis
26735543 26735543 PRJNA738523_P_NODE_16621_length_226_cov_2.013072_g16550_i0 PRJNA738523 16621 226 2.013072 4.54954272 Pseudanabaena sp. 1153 Bacteria Bacteria 43.1 0.00758   NR MFN9059190.1 1153 g16550 i0 39.2 0.676991150442478 51 28 63.7 1 2 145 47 97 MFN9059190.1 glutathione S-transferase C-terminal domain-containing protein [Pseudanabaena sp.] diamond 153 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp.
28158172 28158172 PRJNA738523_P_NODE_13945_length_245_cov_0.895349_g13874_i0 PRJNA738523 13945 245 0.895349 2.19360505 Vulcanococcus limneticus 2170428 Bacteria Bacteria 49.7 1.33e-4   NR WP_411875297.1 2170428 g13874 i0 44.4 4.10204081632653 63 34 75.9 1 210 25 382 444 WP_411875297.1 protein kinase [Vulcanococcus limneticus] diamond 1005 49.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Vulcanococcus Vulcanococcus limneticus
29862892 29862892 PRJNA738523_P_NODE_15991_length_241_cov_0.916667_g15920_i0 PRJNA738523 15991 241 0.916667 2.20916747 Cyanobacteria bacterium P01_A01_bin.37 3023248 Bacteria Bacteria 47.8 5.94e-4   NR MEM7769706.1 3023248 g15920 i0 47.5 0.759336099585062 61 31 75.9 1 1 183 109 168 MEM7769706.1 DUF3102 domain-containing protein [Cyanobacteria bacterium P01_A01_bin.37] diamond 183 47.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_A01_bin.37
30378971 30378971 PRJNA738523_P_NODE_10532_length_251_cov_0.865169_g10461_i0 PRJNA738523 10532 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 55.5 1.39e-6   NR HAX80177.1 2055768 g10461 i0 40.2 3.9203187250996 82 47 98 1 4 249 956 1035 HAX80177.1 hypothetical protein [Cyanobacteria bacterium UBA11372] diamond 984 55.8 0.99462365591397806 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11372
31411357 31411357 PRJNA738523_P_NODE_11076_length_250_cov_0.870056_g11005_i0 PRJNA738523 11076 250 0.870056 2.17514 Microcoleus sp. SIO2G3 2607795 Bacteria Bacteria 148 4.25e-41   NR NEQ23861.1 2607795 g11005 i0 86.6 0.984 82 11 98.4 0 2 247 308 389 NEQ23861.1 transposase [Microcoleus sp. SIO2G3] diamond 246 148 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. SIO2G3
31759186 31759186 PRJNA738523_P_NODE_13137_length_246_cov_1.427746_g13066_i0 PRJNA738523 13137 246 1.427746 3.51225516 Crinalium epipsammum 241425 Bacteria Bacteria 47 0.00122   NR WP_015204356.1 241425 g13066 i0 36.9 0.792682926829268 65 38 79.3 1 244 50 525 586 WP_015204356.1 toll/interleukin-1 receptor domain-containing protein [Crinalium epipsammum] diamond 195 47 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Crinalium Crinalium epipsammum
32613253 32613253 PRJNA738523_P_NODE_7460_length_279_cov_1.495146_g7389_i0 PRJNA738523 7460 279 1.495146 4.17145734 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 114 4.61e-27   NR HEY9843383.1 2364082 g7389 i0 60.7 0.956989247311828 89 35 95.7 0 12 278 462 550 HEY9843383.1 DUF5939 domain-containing protein [Candidatus Obscuribacterales bacterium] diamond 267 114 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32812259 32812259 PRJNA738523_P_NODE_16060_length_241_cov_0.916667_g15989_i0 PRJNA738523 16060 241 0.916667 2.20916747 Leptolyngbyaceae 1890438 Bacteria Bacteria 115 7.05e-29   NR WNZ21473.1 2547451 g15989 i0 70.5 5.87551867219917 78 23 97.1 0 7 240 220 297 WNZ21473.1 2-hydroxyacid dehydrogenase [Leptolyngbya sp. NK1-12] diamond 1416 115 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NK1-12

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