RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond" and bioproject = "PRJNA380129"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 3

bioproject 1

  • PRJNA380129 · 20 ✖

analysis 1

  • diamond · 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
2952630 2952630 PRJNA380129_P_NODE_3363_length_222_cov_1.803109_g3039_i0 PRJNA380129 3363 222 1.803109 4.00290198 FCB group 1783270 Bacteria Bacteria 125 1.13e-32   NR WP_247176211.1 562 g3039 i0 79.2 91.5 72 15 97.3 0 221 6 75 146 WP_247176211.1 polysaccharide biosynthesis protein [Escherichia coli] diamond 20313 126 0.992063492063492 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27264730 27264730 PRJNA380129_P_NODE_1323_length_507_cov_2.119247_g1006_i0 PRJNA380129 1323 507 2.119247 10.74458229 Bacteroidota bacterium 1898104 Bacteria Bacteria 72.4 9.99e-13   NR MES2875510.1 1898104 g1006 i0 42.5 0.473372781065089 80 46 47.3 0 49 288 1 80 MES2875510.1 hypothetical protein [Bacteroidota bacterium] diamond 240 72.4 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27264731 27264731 PRJNA380129_P_NODE_3183_length_287_cov_4.457364_g2859_i0 PRJNA380129 3183 287 4.457364 12.79263468 Vampirovibrionales bacterium 2692181 Bacteria Bacteria 50.1 1.45e-4   NR MEB3286183.1 2692181 g2859 i0 50.8 0.679442508710801 65 30 65.9 2 73 261 175 239 MEB3286183.1 hypothetical protein [Vampirovibrionales bacterium] diamond 195 50.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria Vampirovibriophyceae Vampirovibrionales     Vampirovibrionales bacterium
27296276 27296276 PRJNA380129_P_NODE_3223_length_273_cov_3.004098_g2899_i0 PRJNA380129 3223 273 3.004098 8.20118754 Candidatus Levyibacteriota bacterium 2052151 Bacteria Bacteria 74.7 2.86e-13   NR MBI2430860.1 2052151 g2899 i0 73.2 1.08791208791209 41 11 45.1 0 130 8 242 282 MBI2430860.1 hypothetical protein [Candidatus Levyibacteriota bacterium] diamond 297 74.7 1 Bacteria Bacteria candidate phyla   Candidatus Levyibacteriota         Candidatus Levyibacteriota bacterium
28338356 28338356 PRJNA380129_P_NODE_3346_length_227_cov_1.515152_g3022_i0 PRJNA380129 3346 227 1.515152 3.43939504 Holosporales bacterium 2053559 Bacteria Bacteria 55.8 2.58e-7   NR HCI48806.1 2053559 g3022 i0 50 0.740088105726872 56 28 74 0 175 8 27 82 HCI48806.1 hypothetical protein [Holosporales bacterium] diamond 168 55.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Holosporales     Holosporales bacterium
28527974 28527974 PRJNA380129_P_NODE_3127_length_309_cov_1.946429_g2803_i0 PRJNA380129 3127 309 1.946429 6.01446561 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 107 1.62e-24   NR AVM87439.1 3063761 g2803 i0 48.1 1.04854368932039 108 49 98.1 1 308 6 1020 1127 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 324 107 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
28622623 28622623 PRJNA380129_P_NODE_2307_length_382_cov_0.713881_g1983_i0 PRJNA380129 2307 382 0.713881 2.72702542 bacterium 1869227 Bacteria Bacteria 55.5 9.41e-7   NR MFN9908892.1 1869227 g1983 i0 66.7 0.832460732984293 36 12 28.3 0 380 273 32 67 MFN9908892.1 hypothetical protein [bacterium] diamond 318 55.5 1 Bacteria               bacterium
28748758 28748758 PRJNA380129_P_NODE_1447_length_473_cov_5.752252_g1127_i0 PRJNA380129 1447 473 5.752252 27.20815196 Spirochaetia bacterium 2053615 Bacteria Bacteria 187 2.2999999999999998e-55   NR TRZ64495.1 2053615 g1127 i0 57.1 0.976744186046512 154 52 88.8 1 472 53 138 291 TRZ64495.1 MAG: hypothetical protein D4Q79_01425 [Spirochaetia bacterium] diamond 462 187 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28875048 28875048 PRJNA380129_P_NODE_3068_length_336_cov_4.677524_g2744_i0 PRJNA380129 3068 336 4.677524 15.71648064 Chloroflexota bacterium 2026724 Bacteria Bacteria 73.6 8.97e-14   NR MBI2954900.1 2026724 g2744 i0 40.4 1.66964285714286 94 55 83.9 1 53 334 61 153 MBI2954900.1 hypothetical protein [Chloroflexota bacterium] diamond 561 73.6 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28906440 28906440 PRJNA380129_P_NODE_3308_length_242_cov_2.539906_g2984_i0 PRJNA380129 3308 242 2.539906 6.14657252 Parcubacteria group bacterium GW2 2026774 Bacteria Bacteria 110 2.39e-28   NR KKQ77766.1 1618783 g2984 i0 72.7 2.47933884297521 66 18 81.8 0 1 198 109 174 KKQ77766.1 MAG: polymerase III epsilon subunit protein [Parcubacteria group bacterium GW2011_GWA1_38_7] diamond 600 110 1 Bacteria Bacteria candidate phyla             Parcubacteria group bacterium GW2011_GWA1_38_7
28938321 28938321 PRJNA380129_P_NODE_3368_length_220_cov_3.717277_g3044_i0 PRJNA380129 3368 220 3.717277 8.1780094 Bdellovibrionales bacterium CG1 2053517 Bacteria Bacteria 70.9 1.88e-12   NR PIU00040.1 1973927 g3044 i0 59.3 0.804545454545455 59 24 80.5 0 219 43 199 257 PIU00040.1 MAG: hypothetical protein COT74_06735 [Bdellovibrionales bacterium CG10_big_fil_rev_8_21_14_0_10_45_34] diamond 177 70.9 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium CG10_big_fil_rev_8_21_14_0_10_45_34
29033151 29033151 PRJNA380129_P_NODE_3588_length_171_cov_2.014085_g3264_i0 PRJNA380129 3588 171 2.014085 3.44408535 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 68.6 1.14e-11   NR MEN9405062.1 2762014 g3264 i0 70.6 0.894736842105263 51 15 89.5 0 156 4 46 96 MEN9405062.1 Synechococcus virus Syn5 [Candidatus Parcubacteria bacterium] diamond 153 68.6 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria bacterium
29159430 29159430 PRJNA380129_P_NODE_3669_length_156_cov_2.661417_g3345_i0 PRJNA380129 3669 156 2.661417 4.15181052 Bryobacterales bacterium 2026791 Bacteria Bacteria 41.6 0.00881   NR MCU1326627.1 2026791 g3345 i0 62.5 0.461538461538462 24 9 46.2 0 156 85 57 80 MCU1326627.1 hypothetical protein [Bryobacterales bacterium] diamond 72 41.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
29538035 29538035 PRJNA380129_P_NODE_3130_length_307_cov_3.244604_g2806_i0 PRJNA380129 3130 307 3.244604 9.96093428 Caulobacteraceae bacterium 1978230 Bacteria Bacteria 43.5 0.0408   NR MDB5480411.1 1978230 g2806 i0 33.3 0.527687296416938 54 33 52.8 1 222 61 194 244 MDB5480411.1 putative cytochrome c1 signal peptide protein [Caulobacteraceae bacterium] diamond 162 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae   Caulobacteraceae bacterium
30439773 30439773 PRJNA380129_P_NODE_3193_length_284_cov_2.372549_g2869_i0 PRJNA380129 3193 284 2.372549 6.73803916 root 1 Root_unresolved Root_unresolved 92.4 2.1e-19   NR HKU51007.1 70125 g2869 i0 48.4 1.96478873239437 93 48 98.2 0 1 279 296 388 HKU51007.1 DNA polymerase [Nitrospira sp.] diamond 558 92.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30454419 30454419 PRJNA380129_P_NODE_3393_length_212_cov_1.519126_g3069_i0 PRJNA380129 3393 212 1.519126 3.22054712 Chloroflexota bacterium 2026724 Bacteria Bacteria 73.6 3.46e-13   NR MEO8608317.1 2026724 g3069 i0 68.5 0.764150943396226 54 17 76.4 0 2 163 880 933 MEO8608317.1 LAGLIDADG family homing endonuclease [Chloroflexota bacterium] diamond 162 73.6 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32051900 32051900 PRJNA380129_P_NODE_3458_length_197_cov_3.107143_g3134_i0 PRJNA380129 3458 197 3.107143 6.12107171 Bacteria 2 Bacteria Bacteria 49.7 7.3e-5   NR MBI2021079.1 2053557 g3134 i0 85.7 0.852791878172589 28 4 42.6 0 86 3 1 28 MBI2021079.1 DNA polymerase III subunit alpha [Candidatus Giovannonibacteria bacterium] diamond 168 50.1 0.992015968063872 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium
32066441 32066441 PRJNA380129_P_NODE_3478_length_192_cov_5.288344_g3154_i0 PRJNA380129 3478 192 5.288344 10.15362048 Candidatus Vogelbacteria bacterium 2053638 Bacteria Bacteria 73.2 2.67e-13   NR MCE9628997.1 2053638 g3154 i0 58.9 0.875 56 23 87.5 0 170 3 222 277 MCE9628997.1 phosphoglycerate kinase [Candidatus Vogelbacteria bacterium] diamond 168 73.2 1 Bacteria Bacteria candidate phyla   Candidatus Vogeliibacteriota         Candidatus Vogelbacteria bacterium
32256729 32256729 PRJNA380129_P_NODE_3258_length_259_cov_3.678261_g2934_i0 PRJNA380129 3258 259 3.678261 9.52669599 bacterium 1869227 Bacteria Bacteria 51.2 4.67e-5   NR MBR1775716.1 1869227 g2934 i0 53.8 0.451737451737452 39 18 45.2 0 14 130 207 245 MBR1775716.1 hypothetical protein [bacterium] diamond 117 51.2 1 Bacteria               bacterium
32792911 32792911 PRJNA380129_P_NODE_3460_length_197_cov_1.958333_g3136_i0 PRJNA380129 3460 197 1.958333 3.85791601 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 80.1 9.04e-16   NR HPZ75255.1 2026773 g3136 i0 57.1 0.959390862944162 63 27 95.9 0 189 1 172 234 HPZ75255.1 DNA methyltransferase [Candidatus Pacearchaeota archaeon] diamond 189 80.1 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon

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