RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 14 ✖

bioproject 1

  • PRJNA784298 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
2041149 2041149 PRJNA784298_P_NODE_11842_length_363_cov_3.958621_g11641_i0 PRJNA784298 11842 363 3.958621 14.36979423 Anabaena sp. WA113 1710889 Bacteria Bacteria 198 8.53e-63   NR OBQ16004.1 1710889 g11641 i0 98 0.818181818181818 99 2 81.8 0 362 66 52 150 OBQ16004.1 MAG: hypothetical protein AN488_20355 [Anabaena sp. WA113] diamond 297 198 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. WA113
13519051 13519051 PRJNA784298_P_NODE_14831_length_323_cov_2.808000_g14630_i0 PRJNA784298 14831 323 2.808 9.06984 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 172 1.98e-49   NR MBC7474771.1 2762020 g14630 i0 77.4 0.984520123839009 106 24 98.5 0 318 1 197 302 MBC7474771.1 adenylosuccinate synthase [Candidatus Sericytochromatia bacterium] diamond 318 172 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
26610226 26610226 PRJNA784298_P_NODE_17961_length_292_cov_1.981735_g17760_i0 PRJNA784298 17961 292 1.981735 5.7866662 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 172 2.02e-48   NR MBC7475323.1 2762020 g17760 i0 83.5 0.996575342465753 97 16 99.7 0 292 2 314 410 MBC7475323.1 N-6 DNA methylase [Candidatus Sericytochromatia bacterium] diamond 291 172 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
26682971 26682971 PRJNA784298_P_NODE_19481_length_280_cov_1.487923_g19280_i0 PRJNA784298 19481 280 1.487923 4.1661844 Microcystis 1125 Bacteria Bacteria 82.8 4.81e-16   NR WP_190381769.1 1125 g19280 i0 55.7 3.75 88 37 92.1 1 276 19 584 671 WP_190381769.1 MULTISPECIES: DUF4214 domain-containing protein [Microcystis] diamond 1050 83.6 0.990430622009569 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis  
27906217 27906217 PRJNA784298_P_NODE_14625_length_326_cov_0.833992_g14424_i0 PRJNA784298 14625 326 0.833992 2.71881392 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 72 2.25e-12   NR MCC5612706.1 2780403 g14424 i0 41.6 0.708588957055215 77 45 70.9 0 72 302 116 192 MCC5612706.1 hypothetical protein [Nostoc sp. CHAB 5834] diamond 231 72 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
28127583 28127583 PRJNA784298_P_NODE_10445_length_388_cov_2.457143_g10244_i0 PRJNA784298 10445 388 2.457143 9.53371484 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 108 2.2999999999999994e-24   NR MBC7475742.1 2762020 g10244 i0 44.6 0.935567010309278 121 67 93.6 0 381 19 303 423 MBC7475742.1 methyl-accepting chemotaxis protein [Candidatus Sericytochromatia bacterium] diamond 363 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
28317017 28317017 PRJNA784298_P_NODE_25806_length_244_cov_0.900585_g25605_i0 PRJNA784298 25806 244 0.900585 2.1974274 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 129 7.889999999999999e-34   NR WP_106370967.1 2107693 g25605 i0 95.8 0.872950819672131 71 3 87.3 0 213 1 1 71 WP_106370967.1 circadian clock protein LdpA [Chlorogloea sp. CCALA 695] diamond 213 129 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
28380082 28380082 PRJNA784298_P_NODE_21466_length_265_cov_2.250000_g21265_i0 PRJNA784298 21466 265 2.25 5.9625 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 76.3 5.72e-14   NR MBC7472678.1 2762020 g21265 i0 52.9 0.792452830188679 70 31 79.2 1 264 55 146 213 MBC7472678.1 hypothetical protein [Candidatus Sericytochromatia bacterium] diamond 210 76.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
29516635 29516635 PRJNA784298_P_NODE_3730_length_660_cov_1.594549_g3533_i0 PRJNA784298 3730 660 1.594549 10.5240234 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 48.1 0.00429   NR MBC7474572.1 2762020 g3533 i0 40 0.272727272727273 60 34 27.3 1 426 605 8 65 MBC7474572.1 hypothetical protein [Candidatus Sericytochromatia bacterium] diamond 180 48.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
29769249 29769249 PRJNA784298_P_NODE_22051_length_261_cov_3.079787_g21850_i0 PRJNA784298 22051 261 3.079787 8.03824407 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 76.6 5.35e-14   NR MBC7475742.1 2762020 g21850 i0 48.8 0.988505747126437 86 44 98.9 0 259 2 563 648 MBC7475742.1 methyl-accepting chemotaxis protein [Candidatus Sericytochromatia bacterium] diamond 258 76.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
29936635 29936635 PRJNA784298_P_NODE_26891_length_241_cov_0.916667_g26690_i0 PRJNA784298 26891 241 0.916667 2.20916747 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 138 9.37e-36   NR WP_106370250.1 2107693 g26690 i0 93.8 2.00414937759336 81 4 99.6 1 2 241 699 779 WP_106370250.1 single-stranded-DNA-specific exonuclease RecJ [Chlorogloea sp. CCALA 695] diamond 483 138 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
32076795 32076795 PRJNA784298_P_NODE_58_length_4690_cov_9.775395_g49_i0 PRJNA784298 58 4690 9.775395 458.4660255 Planktothricoides raciborskii 132608 Bacteria Bacteria 246 1.61e-61   NR WP_354635031.1 132608 g49 i0 42.2 0.282089552238806 441 234 27.5 11 1419 2708 543 973 WP_354635031.1 FG-GAP-like repeat-containing protein [Planktothricoides raciborskii] diamond 1323 246 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Planktothricoides Planktothricoides raciborskii
32393226 32393226 PRJNA784298_P_NODE_2979_length_739_cov_2.112613_g2790_i0 PRJNA784298 2979 739 2.112613 15.61221007 Prochlorococcus marinus 1219 Bacteria Bacteria 48.5 0.0138   NR WP_269603685.1 1219 g2790 i0 37.7 0.280108254397835 69 36 28 2 287 81 299 360 WP_269603685.1 DUF4214 domain-containing protein [Prochlorococcus marinus] diamond 207 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus marinus
32834781 32834781 PRJNA784298_P_NODE_3880_length_646_cov_1.891798_g3683_i0 PRJNA784298 3880 646 1.891798 12.22101508 Candidatus Margulisiibacteriota bacterium 2053573 Bacteria Bacteria 53.1 2.83e-4   NR MFA5879838.1 2053573 g3683 i0 36.2 0.436532507739938 94 59 43.2 1 203 481 210 303 MFA5879838.1 hypothetical protein [Candidatus Margulisiibacteriota bacterium] diamond 282 53.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Margulisiibacteriota         Candidatus Margulisiibacteriota bacterium

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