RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA520845 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
17067018 17067018 PRJNA520845_P_NODE_198194_length_263_cov_1.473684_g196695_i0 PRJNA520845 198194 263 1.473684 3.87578892 Longimicrobium sp. 2029185 Bacteria Bacteria 167 5.35e-51   NR HEX5871167.1 2029185 g196695 i0 97.7 1.98479087452471 87 2 99.2 0 261 1 41 127 HEX5871167.1 MFS transporter [Longimicrobium sp.] diamond 522 167 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
24063612 24063612 PRJNA520845_P_NODE_242119_length_246_cov_0.890173_g240620_i0 PRJNA520845 242119 246 0.890173 2.18982558 Longimicrobium sp. 2029185 Bacteria Bacteria 161 3.32e-44   NR WP_331127422.1 2029185 g240620 i0 90.1 1.96341463414634 81 8 98.8 0 2 244 556 636 WP_331127422.1 NAD(+) synthase [Longimicrobium sp.] diamond 483 161 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
27772492 27772492 PRJNA520845_P_NODE_260764_length_242_cov_0.911243_g259265_i0 PRJNA520845 260764 242 0.911243 2.20520806 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 48.1 4.46e-4   NR HEU5050591.1 2448054 g259265 i0 53.7 1.00413223140496 41 19 50.8 0 3 125 320 360 HEU5050591.1 ankyrin repeat domain-containing protein [Gemmatimonadales bacterium] diamond 243 48.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28040231 28040231 PRJNA520845_P_NODE_205265_length_257_cov_1.673913_g203766_i0 PRJNA520845 205265 257 1.673913 4.30195641 FCB group 1783270 Bacteria Bacteria 119 4.29e-29   NR GMV06378.1 2026742 g203766 i0 64.3 6.84046692607004 84 30 98.1 0 254 3 364 447 GMV06378.1 MAG: hypothetical protein AMXMBFR53_26540 [Gemmatimonadota bacterium] diamond 1758 120 0.991666666666667 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28245580 28245580 PRJNA520845_P_NODE_140746_length_315_cov_1.268595_g139247_i0 PRJNA520845 140746 315 1.268595 3.99607425 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 100 1.42e-22   NR MCA0375630.1 2026742 g139247 i0 45.2 1.98095238095238 104 57 99 0 2 313 229 332 MCA0375630.1 PLP-dependent aminotransferase family protein [Gemmatimonadota bacterium] diamond 624 100 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28277215 28277215 PRJNA520845_P_NODE_126566_length_332_cov_1.189189_g125067_i0 PRJNA520845 126566 332 1.189189 3.94810748 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 157 1.89e-42   NR HVM43017.1 2448054 g125067 i0 58.2 4.94277108433735 110 46 99.4 0 332 3 8 117 HVM43017.1 phosphoenolpyruvate carboxykinase (GTP) [Gemmatimonadales bacterium] diamond 1641 157 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28972089 28972089 PRJNA520845_P_NODE_109348_length_356_cov_1.088339_g107849_i0 PRJNA520845 109348 356 1.088339 3.87448684 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 43.9 0.0258   NR HET6639885.1 2026742 g107849 i0 34.2 0.615168539325843 73 46 59.8 1 300 88 94 166 HET6639885.1 hypothetical protein [Gemmatimonadota bacterium] diamond 219 43.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29066918 29066918 PRJNA520845_P_NODE_244348_length_245_cov_0.895349_g242849_i0 PRJNA520845 244348 245 0.895349 2.19360505 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 60.1 2.98e-8   NR HYW50704.1 2026741 g242849 i0 41.9 0.759183673469388 62 36 75.9 0 48 233 104 165 HYW50704.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium] diamond 186 60.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29982430 29982430 PRJNA520845_P_NODE_142231_length_313_cov_1.458333_g140732_i0 PRJNA520845 142231 313 1.458333 4.56458229 Gemmatimonas sp. 1962908 Bacteria Bacteria 44.7 0.018   NR MEP6833624.1 1962908 g140732 i0 38.5 1.5814696485623 65 39 61.3 1 87 278 1400 1464 MEP6833624.1 SdrD B-like domain-containing protein [Gemmatimonas sp.] diamond 495 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
29982469 29982469 PRJNA520845_P_NODE_206591_length_256_cov_1.601093_g205092_i0 PRJNA520845 206591 256 1.601093 4.09879808 Longimicrobium sp. 2029185 Bacteria Bacteria 57.8 4.32e-9   NR HEU4885710.1 2029185 g205092 i0 70 1.1484375 50 13 56.3 1 230 87 1 50 HEU4885710.1 hypothetical protein [Longimicrobium sp.] diamond 294 57.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31025242 31025242 PRJNA520845_P_NODE_237795_length_247_cov_0.885057_g236296_i0 PRJNA520845 237795 247 0.885057 2.18609079 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 44.7 0.0045   NR HMA23754.1 2026741 g236296 i0 43.8 0.88663967611336 73 36 88.7 2 29 247 4 71 HMA23754.1 carboxypeptidase-like regulatory domain-containing protein [Gemmatimonadaceae bacterium] diamond 219 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31057055 31057055 PRJNA520845_P_NODE_185895_length_273_cov_1.350000_g184396_i0 PRJNA520845 185895 273 1.35 3.6855 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 44.7 0.0076   NR MDB4900408.1 2026742 g184396 i0 41.2 1 51 30 56 0 68 220 49 99 MDB4900408.1 cyclase/dehydrase [Gemmatimonadota bacterium] diamond 273 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31103504 31103504 PRJNA520845_P_NODE_250095_length_244_cov_0.900585_g248596_i0 PRJNA520845 250095 244 0.900585 2.1974274 Candidatus Palauibacter 3056650 Bacteria Bacteria 43.5 0.0192   NR MCY3700757.1 2026742 g248596 i0 31.9 1.69672131147541 69 44 84.8 1 215 9 208 273 MCY3700757.1 Ig-like domain-containing protein [Gemmatimonadota bacterium] diamond 414 43.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31277915 31277915 PRJNA520845_P_NODE_260975_length_242_cov_0.911243_g259476_i0 PRJNA520845 260975 242 0.911243 2.20520806 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 42 0.0216   NR MCU0647382.1 2026741 g259476 i0 35.6 0.90495867768595 73 46 89.3 1 240 25 24 96 MCU0647382.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 219 42 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31404650 31404650 PRJNA520845_P_NODE_217796_length_250_cov_1.723164_g216297_i0 PRJNA520845 217796 250 1.723164 4.30791 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 42.7 0.0416   NR HTD59871.1 2026741 g216297 i0 39.1 0.768 64 38 75.6 1 34 222 527 590 HTD59871.1 ABC transporter permease [Gemmatimonadaceae bacterium] diamond 192 42.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31704489 31704489 PRJNA520845_P_NODE_84517_length_404_cov_1.138973_g83018_i0 PRJNA520845 84517 404 1.138973 4.6014509200000004 Pseudomonadati 3379134 Bacteria Bacteria 88.6 2.07e-17   NR MYA22637.1 2026742 g83018 i0 39.3 4.18069306930693 112 67 83.2 1 5 340 438 548 MYA22637.1 acylase [Gemmatimonadota bacterium] diamond 1689 88.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31752332 31752332 PRJNA520845_P_NODE_30837_length_686_cov_1.732463_g29402_i0 PRJNA520845 30837 686 1.732463 11.88469618 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 87.8 7.8e-16   NR MDE2773337.1 2026742 g29402 i0 29.8 2.8731778425656 242 145 99.3 7 4 684 2105 2336 MDE2773337.1 SDR family NAD(P)-dependent oxidoreductase [Gemmatimonadota bacterium] diamond 1971 87.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32227145 32227145 PRJNA520845_P_NODE_171378_length_284_cov_2.151659_g169879_i0 PRJNA520845 171378 284 2.151659 6.11071156 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 45.1 0.00923   NR HEY3280413.1 2448054 g169879 i0 39.3 0.644366197183099 61 35 62.3 1 102 278 224 284 HEY3280413.1 hypothetical protein [Gemmatimonadales bacterium] diamond 183 45.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales 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);;