RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA414225" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA414225 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
1693819 1693819 PRJNA414225_P_NODE_77622_length_163_cov_0.894737_g77535_i0 PRJNA414225 77622 163 0.894737 1.45842131 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 99.4 5.94e-23   NR MEZ0335919.1 2448054 g77535 i0 88.9 4.96932515337423 54 6 99.4 0 1 162 105 158 MEZ0335919.1 CCA tRNA nucleotidyltransferase [Gemmatimonadales bacterium] diamond 810 99.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
5522810 5522810 PRJNA414225_P_NODE_9185_length_215_cov_0.915663_g9098_i0 PRJNA414225 9185 215 0.915663 1.96867545 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 105 4.51e-25   NR MDQ3556893.1 2026742 g9098 i0 70.4 0.990697674418605 71 21 99.1 0 214 2 179 249 MDQ3556893.1 aldehyde dehydrogenase family protein [Gemmatimonadota bacterium] diamond 213 105 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
14447855 14447855 PRJNA414225_P_NODE_68592_length_164_cov_1.773913_g68505_i0 PRJNA414225 68592 164 1.773913 2.90921732 Bacteria 2 Bacteria Bacteria 103 3.86e-26   NR PYP31035.1 2026742 g68505 i0 83.3 6.91463414634146 54 9 98.8 0 1 162 48 101 PYP31035.1 MAG: 3-isopropylmalate dehydratase small subunit [Gemmatimonadota bacterium] diamond 1134 103 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
18270597 18270597 PRJNA414225_P_NODE_66515_length_165_cov_0.879310_g66428_i0 PRJNA414225 66515 165 0.87931 1.4508615 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 82 7.8e-18   NR HEV2735676.1 3047548 g66428 i0 74.5 6.52727272727273 55 14 100 0 1 165 90 144 HEV2735676.1 ATP-binding protein [Longimicrobiaceae bacterium] diamond 1077 82 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
18934607 18934607 PRJNA414225_P_NODE_52875_length_167_cov_0.864407_g52788_i0 PRJNA414225 52875 167 0.864407 1.44355969 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 105 9.1e-26   NR HXE57227.1 2448054 g52788 i0 87.3 1.97604790419162 55 7 98.8 0 3 167 189 243 HXE57227.1 phosphoribosylaminoimidazolesuccinocarboxamide synthase [Gemmatimonadales bacterium] diamond 330 105 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
26822557 26822557 PRJNA414225_P_NODE_49081_length_167_cov_0.864407_g48994_i0 PRJNA414225 49081 167 0.864407 1.44355969 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 86.7 4.47e-18   NR HEX5387984.1 2448054 g48994 i0 77.4 3.77245508982036 53 12 95.2 0 162 4 544 596 HEX5387984.1 hypothetical protein [Gemmatimonadales bacterium] diamond 630 86.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
27250228 27250228 PRJNA414225_P_NODE_74903_length_164_cov_0.886957_g74816_i0 PRJNA414225 74903 164 0.886957 1.45460948 Longimicrobium 1804994 Bacteria Bacteria 77.8 5.56e-15   NR HEX2203675.1 2029185 g74816 i0 69.2 3.91463414634146 52 16 95.1 0 3 158 341 392 HEX2203675.1 malto-oligosyltrehalose trehalohydrolase [Longimicrobium sp.] diamond 642 77.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
27423458 27423458 PRJNA414225_P_NODE_75563_length_164_cov_0.886957_g75476_i0 PRJNA414225 75563 164 0.886957 1.45460948 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 97.1 9.48e-22   NR NUQ21249.1 2026741 g75476 i0 83.3 5.92682926829268 54 9 98.8 0 164 3 48 101 NUQ21249.1 S9 family peptidase [Gemmatimonadaceae bacterium] diamond 972 97.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27991675 27991675 PRJNA414225_P_NODE_77285_length_163_cov_0.894737_g77198_i0 PRJNA414225 77285 163 0.894737 1.45842131 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 80.1 8.16e-16   NR MBV9109866.1 2026742 g77198 i0 71.2 0.957055214723926 52 14 93.9 1 9 161 24 75 MBV9109866.1 methylmalonyl-CoA mutase family protein [Gemmatimonadota bacterium] diamond 156 80.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28023194 28023194 PRJNA414225_P_NODE_72645_length_164_cov_0.886957_g72558_i0 PRJNA414225 72645 164 0.886957 1.45460948 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 57.8 4.5e-8   NR HEV2146451.1 3047548 g72558 i0 48.1 10.2439024390244 52 27 95.1 0 4 159 192 243 HEV2146451.1 energy transducer TonB [Longimicrobiaceae bacterium] diamond 1680 57.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
28275600 28275600 PRJNA414225_P_NODE_5026_length_243_cov_1.051546_g4939_i0 PRJNA414225 5026 243 1.051546 2.55525678 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 81.3 1.01e-15   NR HEX6926313.1 3047548 g4939 i0 51.9 4.87654320987654 79 38 97.5 0 5 241 115 193 HEX6926313.1 endonuclease MutS2 [Longimicrobiaceae bacterium] diamond 1185 81.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
28481812 28481812 PRJNA414225_P_NODE_42506_length_170_cov_1.677686_g42419_i0 PRJNA414225 42506 170 1.677686 2.8520662 Gemmatimonadota 142182 Bacteria Bacteria 55.5 4.16e-7   NR HEX8211019.1 2029185 g42419 i0 81.3 9.03529411764706 32 6 56.5 0 96 1 279 310 HEX8211019.1 tyrosine recombinase XerC [Longimicrobium sp.] diamond 1536 55.8 0.99462365591397806 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
28528503 28528503 PRJNA414225_P_NODE_89407_length_162_cov_0.902655_g89320_i0 PRJNA414225 89407 162 0.902655 1.4623011 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 51.6 6.37e-7   NR MCY4399926.1 2026742 g89320 i0 61.1 2.40740740740741 36 14 66.7 0 53 160 1 36 MCY4399926.1 DUF3343 domain-containing protein [Gemmatimonadota bacterium] diamond 390 51.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28591547 28591547 PRJNA414225_P_NODE_14887_length_192_cov_1.426573_g14800_i0 PRJNA414225 14887 192 1.426573 2.73902016 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 109 5.25e-26   NR MDQ3556451.1 2026742 g14800 i0 73.4 2.96875 64 17 100 0 192 1 124 187 MDQ3556451.1 phosphoenolpyruvate carboxykinase (ATP) [Gemmatimonadota bacterium] diamond 570 109 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30012533 30012533 PRJNA414225_P_NODE_65191_length_165_cov_0.879310_g65104_i0 PRJNA414225 65191 165 0.87931 1.4508615 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 74.3 4.46e-14   NR MBA3445504.1 2448054 g65104 i0 57.7 2.83636363636364 52 22 94.5 0 5 160 157 208 MBA3445504.1 sulfotransferase [Gemmatimonadales bacterium] diamond 468 74.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30138359 30138359 PRJNA414225_P_NODE_74592_length_164_cov_0.886957_g74505_i0 PRJNA414225 74592 164 0.886957 1.45460948 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 63.2 1.65e-10   NR MDP9347657.1 2026742 g74505 i0 53.7 1.97560975609756 54 25 98.8 0 163 2 63 116 MDP9347657.1 hypothetical protein [Gemmatimonadota bacterium] diamond 324 63.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30265439 30265439 PRJNA414225_P_NODE_89612_length_162_cov_0.902655_g89525_i0 PRJNA414225 89612 162 0.902655 1.4623011 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 68.6 8.98e-12   NR MDQ3555834.1 2026742 g89525 i0 62.3 3.92592592592593 53 20 98.1 0 2 160 48 100 MDQ3555834.1 PilT/PilU family type 4a pilus ATPase [Gemmatimonadota bacterium] diamond 636 68.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30455068 30455068 PRJNA414225_P_NODE_11013_length_206_cov_1.656051_g10926_i0 PRJNA414225 11013 206 1.656051 3.41146506 Longimicrobium sp. 2029185 Bacteria Bacteria 97.8 2.4399999999999999e-23   NR WP_331127437.1 2029185 g10926 i0 70.1 7.64563106796117 67 20 97.6 0 205 5 44 110 WP_331127437.1 ATP phosphoribosyltransferase [Longimicrobium sp.] diamond 1575 97.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30707417 30707417 PRJNA414225_P_NODE_52434_length_167_cov_0.864407_g52347_i0 PRJNA414225 52434 167 0.864407 1.44355969 Longimicrobiales bacterium 2910168 Bacteria Bacteria 58.2 4.77e-8   NR HEY8484935.1 2910168 g52347 i0 61.8 1.94011976047904 55 21 98.8 0 2 166 150 204 HEY8484935.1 adenylosuccinate synthase [Longimicrobiales bacterium] diamond 324 58.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
30897230 30897230 PRJNA414225_P_NODE_11094_length_206_cov_1.299363_g11007_i0 PRJNA414225 11094 206 1.299363 2.67668778 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 104 1.51e-24   NR MDP9347900.1 2026742 g11007 i0 74.6 0.975728155339806 67 17 97.6 0 201 1 97 163 MDP9347900.1 hypothetical protein [Gemmatimonadota bacterium] diamond 201 104 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30991945 30991945 PRJNA414225_P_NODE_63474_length_165_cov_0.879310_g63387_i0 PRJNA414225 63474 165 0.87931 1.4508615 Longimicrobiales bacterium 2910168 Bacteria Bacteria 77.8 3.41e-15   NR HSJ09945.1 2910168 g63387 i0 72.2 0.981818181818182 54 15 98.2 0 162 1 37 90 HSJ09945.1 aspartate-semialdehyde dehydrogenase [Longimicrobiales bacterium] diamond 162 77.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
31276181 31276181 PRJNA414225_P_NODE_39615_length_172_cov_1.650407_g39528_i0 PRJNA414225 39615 172 1.650407 2.83870004 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 42.7 0.00571   NR HET7598699.1 2448054 g39528 i0 48 2.40697674418605 50 26 87.2 0 2 151 73 122 HET7598699.1 hypothetical protein [Gemmatimonadales bacterium] diamond 414 42.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31529449 31529449 PRJNA414225_P_NODE_6196_length_233_cov_0.951087_g6109_i0 PRJNA414225 6196 233 0.951087 2.21603271 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 96.7 2.32e-21   NR MBC7841720.1 2026741 g6109 i0 63 2.57510729613734 73 21 94 1 13 231 1 67 MBC7841720.1 insulinase family protein [Gemmatimonadaceae bacterium] diamond 600 96.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31624124 31624124 PRJNA414225_P_NODE_12516_length_200_cov_1.350993_g12429_i0 PRJNA414225 12516 200 1.350993 2.701986 Longimicrobium sp. 2029185 Bacteria Bacteria 72 1.02e-13   NR HYW07088.1 2029185 g12429 i0 50 1.935 66 33 99 0 198 1 77 142 HYW07088.1 chemotaxis protein CheW [Longimicrobium sp.] diamond 387 72 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31672387 31672387 PRJNA414225_P_NODE_73077_length_164_cov_0.886957_g72990_i0 PRJNA414225 73077 164 0.886957 1.45460948 Bacteria 2 Bacteria Bacteria 47 1.99e-5   NR MBI4540905.1 2026742 g72990 i0 77.8 2.17682926829268 27 6 49.4 0 1 81 4 30 MBI4540905.1 30S ribosomal protein THX [Gemmatimonadota bacterium] diamond 357 47.4 0.991561181434599 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31687380 31687380 PRJNA414225_P_NODE_65537_length_165_cov_0.879310_g65450_i0 PRJNA414225 65537 165 0.87931 1.4508615 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 104 1.17e-26   NR HSE65666.1 2448054 g65450 i0 87.3 2 55 7 100 0 165 1 33 87 HSE65666.1 class I tRNA ligase family protein [Gemmatimonadales bacterium] diamond 330 104 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32083690 32083690 PRJNA414225_P_NODE_84838_length_162_cov_0.902655_g84751_i0 PRJNA414225 84838 162 0.902655 1.4623011 Bacteria 2 Bacteria Bacteria 58.9 2.37e-8   NR OLC70678.1 1805193 g84751 i0 63.5 5.48148148148148 52 19 96.3 0 5 160 721 772 OLC70678.1 MAG: DNA-directed RNA polymerase subunit beta [Gemmatimonadetes bacterium 13_1_40CM_4_69_8] diamond 888 58.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium 13_1_40CM_4_69_8
32541937 32541937 PRJNA414225_P_NODE_55679_length_166_cov_0.871795_g55592_i0 PRJNA414225 55679 166 0.871795 1.4471797 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 77.4 2.28e-15   NR MBP2648267.1 2026742 g55592 i0 75.6 5.85542168674699 45 11 81.3 0 1 135 16 60 MBP2648267.1 Fibronectin type domain protein [Gemmatimonadota bacterium] diamond 972 77.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota 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);;