RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA900028" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA900028 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
12353846 12353846 PRJNA900028_P_NODE_16930_length_287_cov_1.567227_g16181_i0 PRJNA900028 16930 287 1.567227 4.49794149 Pseudomonadati 3379134 Bacteria Bacteria 131 2.55e-33   NR MBQ35824.1 2026741 g16181 i0 66.3 8.85365853658537 95 32 99.3 0 3 287 166 260 MBQ35824.1 dihydroxy-acid dehydratase [Gemmatimonadaceae bacterium] diamond 2541 131 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
13628941 13628941 PRJNA900028_P_NODE_189511_length_161_cov_0.910714_g188762_i0 PRJNA900028 189511 161 0.910714 1.46624954 Pseudomonadati 3379134 Bacteria Bacteria 74.7 6.32e-14   NR MBB29862.1 2026742 g188762 i0 75.5 4.93788819875776 53 13 98.8 0 160 2 227 279 MBB29862.1 pyruvate kinase [Gemmatimonadota bacterium] diamond 795 75.1 0.994673768308922 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
24197302 24197302 PRJNA900028_P_NODE_96899_length_177_cov_1.593750_g96150_i0 PRJNA900028 96899 177 1.59375 2.8209375 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 73.2 2.8e-13   NR WP_104023539.1 861299 g96150 i0 72.4 0.983050847457627 58 16 98.3 0 2 175 823 880 WP_104023539.1 ABC transporter permease [Gemmatirosa kalamazoonensis] diamond 174 73.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
27277159 27277159 PRJNA900028_P_NODE_160803_length_164_cov_0.886957_g160054_i0 PRJNA900028 160803 164 0.886957 1.45460948 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 86.3 1e-19   NR MES2525233.1 2026742 g160054 i0 83.3 0.98780487804878 54 9 98.8 0 164 3 20 73 MES2525233.1 complex I subunit 1 family protein [Gemmatimonadota bacterium] diamond 162 86.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27277167 27277167 PRJNA900028_P_NODE_187063_length_161_cov_1.821429_g186314_i0 PRJNA900028 187063 161 1.821429 2.93250069 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 110 2.86e-27   NR HEX6313415.1 2026741 g186314 i0 90.6 0.987577639751553 53 5 98.8 0 3 161 283 335 HEX6313415.1 serine hydrolase domain-containing protein [Gemmatimonadaceae bacterium] diamond 159 110 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28035054 28035054 PRJNA900028_P_NODE_174465_length_163_cov_0.894737_g173716_i0 PRJNA900028 174465 163 0.894737 1.45842131 Gemmatimonas sp. 1962908 Bacteria Bacteria 96.3 1.7700000000000003e-21   NR MEQ1693096.1 1962908 g173716 i0 79.2 0.975460122699387 53 11 97.5 0 159 1 315 367 MEQ1693096.1 GWxTD domain-containing protein [Gemmatimonas sp.] diamond 159 96.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
28137458 28137458 PRJNA900028_P_NODE_105025_length_173_cov_1.645161_g104276_i0 PRJNA900028 105025 173 1.645161 2.84612853 root 1 Root_unresolved Root_unresolved 95.1 4.72e-21   NR WP_284351207.1 2014610 g104276 i0 84.2 4.8728323699422 57 9 98.8 0 171 1 383 439 WP_284351207.1 serine hydrolase domain-containing protein [Roseisolibacter agri] diamond 843 95.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter agri
28326586 28326586 PRJNA900028_P_NODE_91946_length_179_cov_1.838462_g91197_i0 PRJNA900028 91946 179 1.838462 3.29084698 Bacteria 2 Bacteria Bacteria 72 2.12e-13   NR MDX1493239.1 2910168 g91197 i0 60.4 5.27932960893855 53 21 88.8 0 163 5 1 53 MDX1493239.1 GAF domain-containing protein [Longimicrobiales bacterium] diamond 945 72 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
28382222 28382222 PRJNA900028_P_NODE_128146_length_167_cov_0.864407_g127397_i0 PRJNA900028 128146 167 0.864407 1.44355969 Gemmatimonadetes bacterium T265 2839016 Bacteria Bacteria 50.1 3.39e-5   NR GJG88314.1 2839016 g127397 i0 74.3 1.79640718562874 35 9 62.9 0 2 106 300 334 GJG88314.1 peptide ABC transporter permease [Gemmatimonadetes bacterium T265] diamond 300 50.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium T265
28579442 28579442 PRJNA900028_P_NODE_153067_length_164_cov_1.469565_g152318_i0 PRJNA900028 153067 164 1.469565 2.4100866 Pseudomonadati 3379134 Bacteria Bacteria 47.4 2.98e-4   NR HET7424587.1 2448054 g152318 i0 63.4 5.45121951219512 41 15 75 0 37 159 603 643 HET7424587.1 ATP-binding protein [Gemmatimonadales bacterium] diamond 894 47.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28823984 28823984 PRJNA900028_P_NODE_147188_length_165_cov_0.879310_g146439_i0 PRJNA900028 147188 165 0.87931 1.4508615 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 92 1.42e-20   NR MBC8086975.1 2026741 g146439 i0 90.9 1 55 5 100 0 1 165 205 259 MBC8086975.1 MoxR family ATPase [Gemmatimonadaceae bacterium] diamond 165 92 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29423956 29423956 PRJNA900028_P_NODE_137369_length_166_cov_0.871795_g136620_i0 PRJNA900028 137369 166 0.871795 1.4471797 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 72 3.82e-13   NR HEV7990230.1 2026741 g136620 i0 83.3 1.51807228915663 42 7 75.9 0 165 40 205 246 HEV7990230.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 252 72 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29707914 29707914 PRJNA900028_P_NODE_161630_length_164_cov_0.886957_g160881_i0 PRJNA900028 161630 164 0.886957 1.45460948 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 103 3.87e-24   NR MEP7383908.1 2026742 g160881 i0 83.3 0.98780487804878 54 9 98.8 0 2 163 357 410 MEP7383908.1 aryl-sulfate sulfotransferase [Gemmatimonadota bacterium] diamond 162 103 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29739676 29739676 PRJNA900028_P_NODE_79890_length_185_cov_1.308824_g79141_i0 PRJNA900028 79890 185 1.308824 2.4213244 Longimicrobium sp. 2029185 Bacteria Bacteria 60.8 6.81e-9   NR WP_414682982.1 2029185 g79141 i0 53.3 0.972972972972973 60 27 95.7 1 185 9 88 147 WP_414682982.1 surface-adhesin E family protein [Longimicrobium sp.] diamond 180 60.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30094864 30094864 PRJNA900028_P_NODE_18812_length_277_cov_1.565789_g18063_i0 PRJNA900028 18812 277 1.565789 4.33723553 Pseudomonadati 3379134 Bacteria Bacteria 102 3.09e-23   NR MFL5578038.1 2026741 g18063 i0 57.8 7.96028880866426 83 29 83.4 1 8 238 42 124 MFL5578038.1 amidohydrolase family protein [Gemmatimonadaceae bacterium] diamond 2205 102 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30213598 30213598 PRJNA900028_P_NODE_195632_length_161_cov_0.910714_g194883_i0 PRJNA900028 195632 161 0.910714 1.46624954 Gemmatirosa sp. 2510638 Bacteria Bacteria 52.4 1.71e-6   NR HZF68490.1 2510638 g194883 i0 57.7 0.968944099378882 52 22 96.9 0 2 157 28 79 HZF68490.1 chemotaxis protein CheW [Gemmatirosa sp.] diamond 156 52.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
30309013 30309013 PRJNA900028_P_NODE_123092_length_167_cov_0.864407_g122343_i0 PRJNA900028 123092 167 0.864407 1.44355969 Roseisolibacter agri 2014610 Bacteria Bacteria 69.7 4.08e-12   NR WP_284349966.1 2014610 g122343 i0 77.1 0.862275449101796 48 11 86.2 0 19 162 310 357 WP_284349966.1 fused MFS/spermidine synthase [Roseisolibacter agri] diamond 144 69.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter agri
30592796 30592796 PRJNA900028_P_NODE_166753_length_163_cov_0.894737_g166004_i0 PRJNA900028 166753 163 0.894737 1.45842131 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 92.4 1.79e-20   NR HKP29542.1 2448054 g166004 i0 92.5 0.975460122699387 53 4 97.5 0 4 162 120 172 HKP29542.1 DNA-processing protein DprA [Gemmatimonadales bacterium] diamond 159 92.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30877226 30877226 PRJNA900028_P_NODE_163114_length_164_cov_0.886957_g162365_i0 PRJNA900028 163114 164 0.886957 1.45460948 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 65.5 1.16e-10   NR HBV05382.1 2026742 g162365 i0 51 0.932926829268293 51 25 93.3 0 162 10 210 260 HBV05382.1 hypothetical protein [Gemmatimonadota bacterium] diamond 153 65.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31319692 31319692 PRJNA900028_P_NODE_82195_length_184_cov_1.200000_g81446_i0 PRJNA900028 82195 184 1.2 2.208 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 110 1.05e-27   NR MFN8665730.1 2026741 g81446 i0 85.2 0.994565217391304 61 9 99.5 0 2 184 156 216 MFN8665730.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 183 110 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31604441 31604441 PRJNA900028_P_NODE_103276_length_174_cov_1.632000_g102527_i0 PRJNA900028 103276 174 1.632 2.83968 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 62.4 1.58e-9   NR MES2524806.1 2026742 g102527 i0 63 0.931034482758621 54 20 93.1 0 12 173 5 58 MES2524806.1 AI-2E family transporter [Gemmatimonadota bacterium] diamond 162 62.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31706913 31706913 PRJNA900028_P_NODE_122937_length_167_cov_0.864407_g122188_i0 PRJNA900028 122937 167 0.864407 1.44355969 Bacteria 2 Bacteria Bacteria 95.1 4.64e-21   NR HEX5438310.1 2026741 g122188 i0 82.7 4.83233532934132 52 9 93.4 0 1 156 359 410 HEX5438310.1 amidase [Gemmatimonadaceae bacterium] diamond 807 95.9 0.991657977059437 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31730782 31730782 PRJNA900028_P_NODE_161577_length_164_cov_0.886957_g160828_i0 PRJNA900028 161577 164 0.886957 1.45460948 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 41.6 0.0242   NR MDP9348265.1 2026742 g160828 i0 44.7 0.859756097560976 47 26 86 0 2 142 12 58 MDP9348265.1 sugar phosphate isomerase/epimerase [Gemmatimonadota bacterium] diamond 141 41.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32237475 32237475 PRJNA900028_P_NODE_138118_length_166_cov_0.871795_g137369_i0 PRJNA900028 138118 166 0.871795 1.4471797 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 73.6 1.65e-13   NR HUX35171.1 2026741 g137369 i0 60.4 2.89156626506024 53 21 95.8 0 166 8 315 367 HUX35171.1 diguanylate cyclase [Gemmatimonadaceae bacterium] diamond 480 73.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32553818 32553818 PRJNA900028_P_NODE_156159_length_164_cov_0.886957_g155410_i0 PRJNA900028 156159 164 0.886957 1.45460948 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 99 2e-22   NR HEY5086232.1 2026741 g155410 i0 87 8.89024390243902 54 7 98.8 0 163 2 48 101 HEY5086232.1 transketolase C-terminal domain-containing protein [Gemmatimonadaceae bacterium] diamond 1458 99 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32773907 32773907 PRJNA900028_P_NODE_197660_length_161_cov_0.910714_g196911_i0 PRJNA900028 197660 161 0.910714 1.46624954 Gemmatimonadetes bacterium T265 2839016 Bacteria Bacteria 80.1 8.21e-16   NR GJG85458.1 2839016 g196911 i0 76 0.93167701863354 50 12 93.2 0 154 5 245 294 GJG85458.1 hypothetical protein tb265_06390 [Gemmatimonadetes bacterium T265] diamond 150 80.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium T265
32805433 32805433 PRJNA900028_P_NODE_164000_length_163_cov_1.789474_g163251_i0 PRJNA900028 164000 163 1.789474 2.91684262 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 62 2.02e-9   NR MEX2177853.1 2026741 g163251 i0 44.2 0.957055214723926 52 29 95.7 0 8 163 584 635 MEX2177853.1 ADOP family duplicated permease [Gemmatimonadaceae bacterium] diamond 156 62 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);;