RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA1108009" 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 · 13 ✖

bioproject 1

  • PRJNA1108009 · 13 ✖
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
3571080 3571080 PRJNA1108009_P_NODE_3983_length_701_cov_1.490446_g3679_i0 PRJNA1108009 3983 701 1.490446 10.44802646 Cyanobacteria bacterium UBA11049 2055787 Bacteria Bacteria 217 2.8099999999999998e-67   NR HCF26074.1 2055787 g3679 i0 52.9 8.60627674750357 227 97 95.9 5 672 1 4 223 HCF26074.1 short-chain dehydrogenase [Cyanobacteria bacterium UBA11049] diamond 6033 217 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
11223896 11223896 PRJNA1108009_P_NODE_23769_length_257_cov_1.619565_g23451_i0 PRJNA1108009 23769 257 1.619565 4.16228205 Cyanophyceae 3028117 Bacteria Bacteria 475 1.1699999999999999e-129   NTclustered gi|521763817|gb|KC463683.1| 1211 g23451 i0 100 101.937743190661 257 0 100 0 1 257 591 847 Uncultured cyanobacterium clone BkfYyy_800 16S ribosomal RNA gene, partial sequence blastn 26198 475 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
15515436 15515436 PRJNA1108009_P_NODE_16173_length_326_cov_1.217391_g15855_i0 PRJNA1108009 16173 326 1.217391 3.96869466 Cyanobacteria bacterium P01_A01_bin.135 3023243 Bacteria Bacteria 160 2.99e-48   NR MEO0406224.1 3023243 g15855 i0 67.3 2.95398773006135 107 35 98.5 0 326 6 33 139 MEO0406224.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_A01_bin.135] diamond 963 160 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_A01_bin.135
19338740 19338740 PRJNA1108009_P_NODE_18996_length_296_cov_1.717489_g18678_i0 PRJNA1108009 18996 296 1.717489 5.08376744 Synechococcus sp. LTW-R 2751170 Bacteria Bacteria 134 9.54e-27   NTclustered gi|1891299085|gb|CP059060.1| 2751170 g18678 i0 77.778 12.4054054054054 216 48 73 0 45 260 2039874 2039659 Synechococcus sp. LTW-R chromosome, complete genome blastn 3672 134 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. LTW-R
20614248 20614248 PRJNA1108009_P_NODE_27417_length_247_cov_0.885057_g27099_i0 PRJNA1108009 27417 247 0.885057 2.18609079 Calothrix sp. 336/3 1337936 Bacteria Bacteria 75 4.76e-9   NTclustered gi|817925425|gb|CP011382.1| 1337936 g27099 i0 100 2.23076923076923 40 0 17 0 1 40 817206 817167 Calothrix sp. 336/3, complete genome blastn 551 75 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. 336/3
27974978 27974978 PRJNA1108009_P_NODE_31565_length_241_cov_0.916667_g31247_i0 PRJNA1108009 31565 241 0.916667 2.20916747 Cyanophyceae 3028117 Bacteria Bacteria 108 2.56e-25   NR MBO1350831.1 2480853 g31247 i0 66.7 6.03734439834025 81 26 99.6 1 241 2 105 185 MBO1350831.1 leucine-rich repeat domain-containing protein [Hormoscilla sp. GUM202] diamond 1455 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Hormoscilla Hormoscilla sp. GUM202
28173037 28173037 PRJNA1108009_P_NODE_26726_length_248_cov_0.880000_g26408_i0 PRJNA1108009 26726 248 0.88 2.1824 Hormoscilla sp. SP5CHS1 2653675 Bacteria Bacteria 53.9 4.55e-6   NR MBC6453268.1 2653675 g26408 i0 43.9 1.42741935483871 57 32 69 0 240 70 9 65 MBC6453268.1 CHAT domain-containing protein [Hormoscilla sp. SP5CHS1] diamond 354 53.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Hormoscilla Hormoscilla sp. SP5CHS1
30415607 30415607 PRJNA1108009_P_NODE_26833_length_248_cov_0.880000_g26515_i0 PRJNA1108009 26833 248 0.88 2.1824 Oscillatoriaceae cyanobacterium 2664179 Bacteria Bacteria 48.1 4.75e-4   NR HEY9720540.1 2664179 g26515 i0 37.3 1.82661290322581 75 40 90.7 2 247 23 305 372 HEY9720540.1 kelch repeat-containing protein [Oscillatoriaceae cyanobacterium] diamond 453 48.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae   Oscillatoriaceae cyanobacterium
31047461 31047461 PRJNA1108009_P_NODE_21455_length_276_cov_1.251232_g21137_i0 PRJNA1108009 21455 276 1.251232 3.45340032 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 142 5.2799999999999995e-37   NR MDD3594140.1 2137880 g21137 i0 75.6 3.82608695652174 86 21 93.5 0 259 2 3 88 MDD3594140.1 DNA polymerase I [Candidatus Gastranaerophilales bacterium] diamond 1056 142 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
31141594 31141594 PRJNA1108009_P_NODE_29535_length_244_cov_0.900585_g29217_i0 PRJNA1108009 29535 244 0.900585 2.1974274 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 61.2 2.99e-9   NR MBL8086383.1 2711154 g29217 i0 48.6 0.860655737704918 70 32 86.1 2 1 210 79 144 MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] diamond 210 61.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
31236664 31236664 PRJNA1108009_P_NODE_24955_length_251_cov_0.865169_g24637_i0 PRJNA1108009 24955 251 0.865169 2.17157419 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 153 8.1e-43   NR MBR3604736.1 2137880 g24637 i0 91.6 1.9840637450199201 83 7 99.2 0 3 251 160 242 MBR3604736.1 hypothetical protein [Candidatus Gastranaerophilales bacterium] diamond 498 153 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
31426524 31426524 PRJNA1108009_P_NODE_29176_length_245_cov_0.895349_g28858_i0 PRJNA1108009 29176 245 0.895349 2.19360505 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 86.7 4.57e-19   NR MBL8086383.1 2711154 g28858 i0 76.5 0.624489795918367 51 12 62.4 0 245 93 94 144 MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] diamond 153 86.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
31742715 31742715 PRJNA1108009_P_NODE_21517_length_276_cov_0.837438_g21199_i0 PRJNA1108009 21517 276 0.837438 2.31132888 Geminocystis sp. NIES-37 2664100 Bacteria Bacteria 68.6 4.74e-11   NR WP_066348589.1 1615909 g21199 i0 44.4 0.978260869565217 90 45 97.8 2 274 5 2167 2251 WP_066348589.1 bluetail domain-containing putative surface protein [Geminocystis sp. NIES-3708] diamond 270 68.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Geminocystis Geminocystis sp. NIES-3708

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