RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB81463" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB81463 · 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
1415085 1415085 PRJEB81463_P_NODE_21502_length_251_cov_0.876404_g21230_i0 PRJEB81463 21502 251 0.876404 2.19977404 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 164 3.21e-47   NR HET9386643.1 2448054 g21230 i0 92.8 0.99203187250996006 83 6 99.2 0 249 1 215 297 HET9386643.1 epoxide hydrolase [Gemmatimonadales bacterium] diamond 249 164 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
17991921 17991921 PRJEB81463_P_NODE_16215_length_271_cov_1.217172_g15943_i0 PRJEB81463 16215 271 1.217172 3.29853612 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 174 9.28e-49   NR MES3034284.1 2026742 g15943 i0 98.9 3.98523985239852 90 1 99.6 0 2 271 449 538 MES3034284.1 Tex family protein [Gemmatimonadota bacterium] diamond 1080 174 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
20541351 20541351 PRJEB81463_P_NODE_17357_length_265_cov_1.625000_g17085_i0 PRJEB81463 17357 265 1.625 4.30625 Gemmatimonas sp. 1962908 Bacteria Bacteria 125 2.69e-33   NR HYW30994.1 1962908 g17085 i0 87.1 0.792452830188679 70 9 79.2 0 265 56 179 248 HYW30994.1 TerC family protein [Gemmatimonas sp.] diamond 210 125 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
27343306 27343306 PRJEB81463_P_NODE_28383_length_242_cov_0.923077_g28111_i0 PRJEB81463 28383 242 0.923077 2.23384634 Pseudomonadati 3379134 Bacteria Bacteria 131 1.58e-33   NR HEV8445199.1 2026741 g28111 i0 75 12.8925619834711 80 20 99.2 0 241 2 233 312 HEV8445199.1 aminomethyl-transferring glycine dehydrogenase [Gemmatimonadaceae bacterium] diamond 3120 131 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27382063 27382063 PRJEB81463_P_NODE_12063_length_293_cov_2.522727_g11791_i0 PRJEB81463 12063 293 2.522727 7.39159011 Longimicrobium sp. 2029185 Bacteria Bacteria 43.1 0.0446   NR HEU4884980.1 2029185 g11791 i0 31.5 0.9419795221843 92 58 89.1 1 277 17 179 270 HEU4884980.1 helix-turn-helix domain-containing protein [Longimicrobium sp.] diamond 276 43.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
27918644 27918644 PRJEB81463_P_NODE_18525_length_260_cov_1.390374_g18253_i0 PRJEB81463 18525 260 1.390374 3.6149724 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 156 2.14e-44   NR MES3033435.1 2026742 g18253 i0 94.2 0.992307692307692 86 5 99.2 0 1 258 78 163 MES3033435.1 adenosine deaminase [Gemmatimonadota bacterium] diamond 258 156 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28424058 28424058 PRJEB81463_P_NODE_22146_length_250_cov_0.881356_g21874_i0 PRJEB81463 22146 250 0.881356 2.20339 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 112 3.81e-27   NR MFI5311974.1 2448054 g21874 i0 72.6 1.008 84 22 99.6 1 1 249 268 351 MFI5311974.1 sigma-54-dependent transcriptional regulator [Gemmatimonadales bacterium] diamond 252 112 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28700900 28700900 PRJEB81463_P_NODE_24567_length_247_cov_0.896552_g24295_i0 PRJEB81463 24567 247 0.896552 2.21448344 Gemmatimonas 173479 Bacteria Bacteria 124 8.95e-31   NR WP_012683638.1 173480 g24295 i0 76.6 5.76923076923077 77 18 93.5 0 231 1 460 536 WP_012683638.1 BatA domain-containing protein [Gemmatimonas aurantiaca] diamond 1425 124 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
28897413 28897413 PRJEB81463_P_NODE_28388_length_242_cov_0.923077_g28116_i0 PRJEB81463 28388 242 0.923077 2.23384634 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 100 2.38e-22   NR MEO8194242.1 2448054 g28116 i0 70.4 0.880165289256198 71 21 88 0 25 237 692 762 MEO8194242.1 PAS domain S-box protein [Gemmatimonadales bacterium] diamond 213 100 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29244862 29244862 PRJEB81463_P_NODE_10109_length_317_cov_2.008197_g9837_i0 PRJEB81463 10109 317 2.008197 6.36598449 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 73.6 1.29e-12   NR MDB4884640.1 2026742 g9837 i0 40.4 1.78864353312303 94 52 87.1 2 27 302 202 293 MDB4884640.1 motif putative anchor domain protein [Gemmatimonadota bacterium] diamond 567 73.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29276269 29276269 PRJEB81463_P_NODE_12709_length_289_cov_1.958333_g12437_i0 PRJEB81463 12709 289 1.958333 5.65958237 Gemmatimonas sp. 1962908 Bacteria Bacteria 178 2.82e-51   NR MEO7520649.1 1962908 g12437 i0 91.5 0.975778546712803 94 8 97.6 0 287 6 410 503 MEO7520649.1 sodium:solute symporter [Gemmatimonas sp.] diamond 282 178 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
29908103 29908103 PRJEB81463_P_NODE_28111_length_242_cov_0.923077_g27839_i0 PRJEB81463 28111 242 0.923077 2.23384634 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 83.2 9.18e-18   NR MEN9507746.1 2026742 g27839 i0 57.5 0.90495867768595 73 31 90.5 0 4 222 107 179 MEN9507746.1 hypothetical protein [Gemmatimonadota bacterium] diamond 219 83.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30280163 30280163 PRJEB81463_P_NODE_22452_length_250_cov_0.881356_g22180_i0 PRJEB81463 22452 250 0.881356 2.20339 Gemmatimonas 173479 Bacteria Bacteria 118 9.589999999999999e-30   NR WP_396224700.1 1962908 g22180 i0 80.5 2.916 82 16 98.4 0 247 2 141 222 WP_396224700.1 GGDEF domain-containing protein [Gemmatimonas sp.] diamond 729 119 0.991596638655462 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
30792544 30792544 PRJEB81463_P_NODE_8014_length_355_cov_1.017730_g7742_i0 PRJEB81463 8014 355 1.01773 3.6129415 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 145 8.1e-38   NR NNE08319.1 2026742 g7742 i0 54.3 0.980281690140845 116 51 98 1 6 353 207 320 NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] diamond 348 145 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30887382 30887382 PRJEB81463_P_NODE_25694_length_245_cov_0.906977_g25422_i0 PRJEB81463 25694 245 0.906977 2.22209365 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 159 4.9099999999999996e-43   NR HVF39535.1 2026741 g25422 i0 93.8 1.98367346938776 81 5 99.2 0 2 244 545 625 HVF39535.1 tetratricopeptide repeat protein [Gemmatimonadaceae bacterium] diamond 486 159 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30982328 30982328 PRJEB81463_P_NODE_25494_length_245_cov_2.087209_g25222_i0 PRJEB81463 25494 245 2.087209 5.11366205 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 50.1 1.99e-5   NR HEY4648782.1 2448054 g25222 i0 46.7 0.551020408163265 45 24 55.1 0 143 9 5 49 HEY4648782.1 response regulator [Gemmatimonadales bacterium] diamond 135 50.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31645973 31645973 PRJEB81463_P_NODE_13597_length_284_cov_2.123223_g13325_i0 PRJEB81463 13597 284 2.123223 6.02995332 Longimicrobium sp. 2029185 Bacteria Bacteria 79.7 5.75e-15   NR WP_331127009.1 2029185 g13325 i0 50 0.866197183098592 82 30 83.5 3 240 4 110 183 WP_331127009.1 hypothetical protein [Longimicrobium sp.] diamond 246 79.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31740883 31740883 PRJEB81463_P_NODE_23157_length_249_cov_0.886364_g22885_i0 PRJEB81463 23157 249 0.886364 2.20704636 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 120 1.94e-29   NR WP_025412854.1 861299 g22885 i0 74.4 0.987951807228916 82 21 98.8 0 1 246 328 409 WP_025412854.1 FHA domain-containing protein [Gemmatirosa kalamazoonensis] diamond 246 120 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
32461512 32461512 PRJEB81463_P_NODE_20979_length_252_cov_0.871508_g20707_i0 PRJEB81463 20979 252 0.871508 2.19620016 Bacteria 2 Bacteria Bacteria 64.3 1.07e-9   NR MFC1540090.1 2026742 g20707 i0 47.8 5.02380952380952 69 33 78.6 1 10 207 107 175 MFC1540090.1 tetratricopeptide repeat protein [Gemmatimonadota bacterium] diamond 1266 64.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32745388 32745388 PRJEB81463_P_NODE_20820_length_252_cov_0.871508_g20548_i0 PRJEB81463 20820 252 0.871508 2.19620016 Bacteria 2 Bacteria Bacteria 73.9 4.25e-13   NR MBX9929902.1 2026741 g20548 i0 53.3 9.73809523809524 75 34 89.3 1 251 27 763 836 MBX9929902.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium] diamond 2454 73.9 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);;