RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA558770 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
23494915 23494915 PRJNA558770_P_NODE_65119_length_258_cov_7.399103_g63114_i0 PRJNA558770 65119 258 7.399103 19.08968574 Longimicrobium sp. 2029185 Bacteria Bacteria 61.2 1.38e-8   NR HST57339.1 2029185 g63114 i0 62.8 1.06976744186047 43 16 50 0 1 129 93 135 HST57339.1 class I SAM-dependent DNA methyltransferase [Longimicrobium sp.] diamond 276 61.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
26889295 26889295 PRJNA558770_P_NODE_233361_length_234_cov_2.708543_g231356_i0 PRJNA558770 233361 234 2.708543 6.33799062 Longimicrobium sp. 2029185 Bacteria Bacteria 49.3 1.54e-4   NR HEX8673465.1 2029185 g231356 i0 87.5 0.307692307692308 24 3 30.8 0 233 162 7 30 HEX8673465.1 IS481 family transposase [Longimicrobium sp.] diamond 72 49.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
27426760 27426760 PRJNA558770_P_NODE_241843_length_234_cov_2.497487_g239838_i0 PRJNA558770 241843 234 2.497487 5.84411958 Longimicrobium sp. 2029185 Bacteria Bacteria 47.4 1.3e-4   NR HEX8213207.1 2029185 g239838 i0 91.7 0.615384615384615 24 2 30.8 0 161 232 3 26 HEX8213207.1 hypothetical protein [Longimicrobium sp.] diamond 144 47.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
27584404 27584404 PRJNA558770_P_NODE_289384_length_234_cov_1.582915_g287379_i0 PRJNA558770 289384 234 1.582915 3.7040211 Longimicrobium sp. 2029185 Bacteria Bacteria 68.6 2.68e-11   NR HLL84737.1 2029185 g287379 i0 50 3 78 38 100 1 1 234 54 130 HLL84737.1 response regulator [Longimicrobium sp.] diamond 702 68.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
27900000 27900000 PRJNA558770_P_NODE_265025_length_234_cov_2.000000_g263020_i0 PRJNA558770 265025 234 2 4.68 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 44.3 0.00614   NR MEE8550470.1 2026742 g263020 i0 79.2 0.615384615384615 24 5 30.8 0 232 161 78 101 MEE8550470.1 ribosome recycling factor [Gemmatimonadota bacterium] diamond 144 44.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29131728 29131728 PRJNA558770_P_NODE_387089_length_187_cov_4.006579_g385084_i0 PRJNA558770 387089 187 4.006579 7.49230273 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 89 1.03e-19   NR HEX9893629.1 2448054 g385084 i0 75.4 0.978609625668449 61 14 97.9 1 3 185 14 73 HEX9893629.1 hypothetical protein [Gemmatimonadales bacterium] diamond 183 89 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29335087 29335087 PRJNA558770_P_NODE_357649_length_232_cov_9.401015_g355644_i0 PRJNA558770 357649 232 9.401015 21.8103548 FCB group 1783270 Bacteria Bacteria 45.1 0.00448   NR HSJ76453.1 2448054 g355644 i0 83.3 2.79310344827586 24 4 31 0 72 1 229 252 HSJ76453.1 HAD family acid phosphatase [Gemmatimonadales bacterium] diamond 648 45.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29650335 29650335 PRJNA558770_P_NODE_212890_length_234_cov_3.316583_g210885_i0 PRJNA558770 212890 234 3.316583 7.76080422 Longimicrobium 1804994 Bacteria Bacteria 48.5 2.89e-4   NR MBR9989390.1 2026742 g210885 i0 83.3 1.53846153846154 24 4 30.8 0 233 162 347 370 MBR9989390.1 IS3 family transposase [Gemmatimonadota bacterium] diamond 360 48.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29794483 29794483 PRJNA558770_P_NODE_388731_length_181_cov_5.280822_g386726_i0 PRJNA558770 388731 181 5.280822 9.55828782 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 61.2 4.91e-9   NR HXJ29556.1 2448054 g386726 i0 71.4 2.9171270718232 35 10 58 0 71 175 218 252 HXJ29556.1 family 78 glycoside hydrolase catalytic domain [Gemmatimonadales bacterium] diamond 528 61.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30219279 30219279 PRJNA558770_P_NODE_175052_length_234_cov_4.894472_g173047_i0 PRJNA558770 175052 234 4.894472 11.45306448 Longimicrobium 1804994 Bacteria Bacteria 53.1 6.86e-6   NR HYW09894.1 2029185 g173047 i0 96 3.84615384615385 25 1 32.1 0 233 159 348 372 HYW09894.1 M1 family aminopeptidase [Longimicrobium sp.] diamond 900 53.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30742423 30742423 PRJNA558770_P_NODE_393954_length_163_cov_7.039062_g391949_i0 PRJNA558770 393954 163 7.039062 11.47367106 Longimicrobium sp. 2029185 Bacteria Bacteria 56.2 7.28e-8   NR HEX8361881.1 2029185 g391949 i0 92.9 1.03067484662577 28 2 51.5 0 89 6 149 176 HEX8361881.1 GNAT family N-acetyltransferase [Longimicrobium sp.] diamond 168 56.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30868694 30868694 PRJNA558770_P_NODE_221294_length_234_cov_3.055276_g219289_i0 PRJNA558770 221294 234 3.055276 7.14934584 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 43.1 0.0232   NR MDB4952260.1 2026742 g219289 i0 73.9 0.294871794871795 23 6 29.5 0 71 3 294 316 MDB4952260.1 hypothetical protein [Gemmatimonadota bacterium] diamond 69 43.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30900523 30900523 PRJNA558770_P_NODE_250334_length_234_cov_2.301508_g248329_i0 PRJNA558770 250334 234 2.301508 5.38552872 Longimicrobium sp. 2029185 Bacteria Bacteria 48.1 4.14e-4   NR WP_331074367.1 2029185 g248329 i0 100 1.6025641025641 25 0 32.1 0 160 234 386 410 WP_331074367.1 hydroxymethylglutaryl-CoA reductase [Longimicrobium sp.] diamond 375 48.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30900560 30900560 PRJNA558770_P_NODE_66314_length_256_cov_2.004525_g64309_i0 PRJNA558770 66314 256 2.004525 5.131584 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 44.7 0.0023   NR HEV2736218.1 3047548 g64309 i0 84 0.5859375 25 4 29.3 0 222 148 8 32 HEV2736218.1 DUF3817 domain-containing protein [Longimicrobiaceae bacterium] diamond 150 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
30963713 30963713 PRJNA558770_P_NODE_203134_length_234_cov_3.663317_g201129_i0 PRJNA558770 203134 234 3.663317 8.57216178 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 44.3 0.00866   NR HET6762206.1 3047548 g201129 i0 83.3 0.615384615384615 24 4 30.8 0 162 233 138 161 HET6762206.1 hypothetical protein [Longimicrobiaceae bacterium] diamond 144 44.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
31041081 31041081 PRJNA558770_P_NODE_248615_length_234_cov_2.341709_g246610_i0 PRJNA558770 248615 234 2.341709 5.47959906 Longimicrobium 1804994 Bacteria Bacteria 43.1 0.00814   NR MBD0321307.1 2026742 g246610 i0 88 0.641025641025641 25 3 32.1 0 160 234 3 27 MBD0321307.1 hypothetical protein [Gemmatimonadota bacterium] diamond 150 43.5 0.990804597701149 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31089982 31089982 PRJNA558770_P_NODE_290095_length_234_cov_1.567839_g288090_i0 PRJNA558770 290095 234 1.567839 3.66874326 Longimicrobium sp. 2029185 Bacteria Bacteria 43.5 0.0176   NR HLL83829.1 2029185 g288090 i0 91.3 0.294871794871795 23 2 29.5 0 74 6 610 632 HLL83829.1 thioredoxin domain-containing protein [Longimicrobium sp.] diamond 69 43.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31215976 31215976 PRJNA558770_P_NODE_385855_length_192_cov_2.949045_g383850_i0 PRJNA558770 385855 192 2.949045 5.6621664 Longimicrobium sp. 2029185 Bacteria Bacteria 108 4.09e-29   NR WP_331052735.1 2029185 g383850 i0 87.1 0.96875 62 8 96.9 0 3 188 18 79 WP_331052735.1 transposase, partial [Longimicrobium sp.] diamond 186 108 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31325235 31325235 PRJNA558770_P_NODE_286575_length_234_cov_1.633166_g284570_i0 PRJNA558770 286575 234 1.633166 3.82160844 Bacteria 2 Bacteria Bacteria 46.2 0.00191   NR MEO7648723.1 2026741 g284570 i0 84 1.92307692307692 25 4 32.1 0 76 2 31 55 MEO7648723.1 amidohydrolase family protein [Gemmatimonadaceae bacterium] diamond 450 46.6 0.991416309012876 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31658998 31658998 PRJNA558770_P_NODE_261337_length_234_cov_2.070352_g259332_i0 PRJNA558770 261337 234 2.070352 4.84462368 Longimicrobium sp. 2029185 Bacteria Bacteria 55.1 1.5e-6   NR WP_331074480.1 2029185 g259332 i0 100 5.23076923076923 24 0 30.8 0 162 233 1470 1493 WP_331074480.1 RHS repeat-associated core domain-containing protein [Longimicrobium sp.] diamond 1224 55.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
32559354 32559354 PRJNA558770_P_NODE_178879_length_234_cov_4.698492_g176874_i0 PRJNA558770 178879 234 4.698492 10.99447128 Bacteria 2 Bacteria Bacteria 43.1 0.0231   NR HEY0995069.1 2026741 g176874 i0 76 1.28205128205128 25 6 32.1 0 160 234 223 247 HEY0995069.1 sulfite exporter TauE/SafE family protein [Gemmatimonadaceae bacterium] diamond 300 43.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae 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);;