RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1123309" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1123309 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
13032171 13032171 PRJNA1123309_P_NODE_55591_length_248_cov_0.891429_g55211_i0 PRJNA1123309 55591 248 0.891429 2.21074392 Gemmatirosa sp. 2510638 Bacteria Bacteria 122 3.5899999999999995e-32   NR HEY0780140.1 2510638 g55211 i0 71.6 0.979838709677419 81 23 98 0 246 4 42 122 HEY0780140.1 CheB methylesterase domain-containing protein [Gemmatirosa sp.] diamond 243 122 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
26679327 26679327 PRJNA1123309_P_NODE_47981_length_253_cov_0.866667_g47601_i0 PRJNA1123309 47981 253 0.866667 2.19266751 Gemmatirosa 1706036 Bacteria Bacteria 136 5.08e-36   NR WP_025415014.1 861299 g47601 i0 81 3.77075098814229 79 15 93.7 0 251 15 339 417 WP_025415014.1 acetylxylan esterase [Gemmatirosa kalamazoonensis] diamond 954 136 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
27059411 27059411 PRJNA1123309_P_NODE_65722_length_242_cov_0.923077_g65342_i0 PRJNA1123309 65722 242 0.923077 2.23384634 Gemmatimonas 173479 Bacteria Bacteria 42 0.0426   NR WP_291162412.1 1946568 g65342 i0 57.6 1.22727272727273 33 14 40.9 0 20 118 134 166 WP_291162412.1 hypothetical protein [Gemmatimonas sp. UBA7669] diamond 297 42 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp. UBA7669
27639046 27639046 PRJNA1123309_P_NODE_50524_length_251_cov_0.876404_g50144_i0 PRJNA1123309 50524 251 0.876404 2.19977404 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 61.6 3.53e-9   NR MBI3792292.1 2026742 g50144 i0 56.5 3.1792828685259 62 22 71.7 2 186 7 13 71 MBI3792292.1 SCO family protein [Gemmatimonadota bacterium] diamond 798 61.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27765367 27765367 PRJNA1123309_P_NODE_38104_length_275_cov_1.534653_g37724_i0 PRJNA1123309 38104 275 1.534653 4.22029575 Longimicrobiales bacterium 2910168 Bacteria Bacteria 171 1.07e-47   NR HEX6559043.1 2910168 g37724 i0 85.6 1.96363636363636 90 13 98.2 0 2 271 561 650 HEX6559043.1 outer membrane protein assembly factor BamA [Longimicrobiales bacterium] diamond 540 171 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
28396626 28396626 PRJNA1123309_P_NODE_62566_length_244_cov_0.912281_g62186_i0 PRJNA1123309 62566 244 0.912281 2.22596564 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 117 2.7000000000000003e-28   NR HEX2779855.1 2026741 g62186 i0 66.7 0.959016393442623 78 26 95.9 0 236 3 735 812 HEX2779855.1 carboxypeptidase regulatory-like domain-containing protein [Gemmatimonadaceae bacterium] diamond 234 117 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28543946 28543946 PRJNA1123309_P_NODE_57807_length_247_cov_0.896552_g57427_i0 PRJNA1123309 57807 247 0.896552 2.21448344 Bacteria 2 Bacteria Bacteria 116 6.91e-30   NR MDQ3208438.1 2026742 g57427 i0 90 1.7004048582996 70 7 85 0 38 247 1 70 MDQ3208438.1 cytochrome c [Gemmatimonadota bacterium] diamond 420 116 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28870174 28870174 PRJNA1123309_P_NODE_38968_length_273_cov_1.475000_g38588_i0 PRJNA1123309 38968 273 1.475 4.02675 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 48.1 3.96e-4   NR HEX9705446.1 2448054 g38588 i0 38.8 0.934065934065934 85 48 89 1 28 270 20 104 HEX9705446.1 hypothetical protein [Gemmatimonadales bacterium] diamond 255 48.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28901640 28901640 PRJNA1123309_P_NODE_5688_length_614_cov_0.955638_g5339_i0 PRJNA1123309 5688 614 0.955638 5.86761732 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 47.8 0.0154   NR HEY4130013.1 2026741 g5339 i0 34 0.503257328990228 103 60 47.4 3 372 82 169 269 HEY4130013.1 DNA recombination protein RmuC [Gemmatimonadaceae bacterium] diamond 309 47.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29406963 29406963 PRJNA1123309_P_NODE_64689_length_243_cov_0.917647_g64309_i0 PRJNA1123309 64689 243 0.917647 2.22988221 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 56.6 4.95e-7   NR HEY7611715.1 2448054 g64309 i0 54.3 0.567901234567901 46 20 55.6 1 31 165 430 475 HEY7611715.1 PAS domain S-box protein [Gemmatimonadales bacterium] diamond 138 56.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29533321 29533321 PRJNA1123309_P_NODE_6990_length_562_cov_1.196319_g6629_i0 PRJNA1123309 6990 562 1.196319 6.72331278 Gemmatimonadetes bacterium T265 2839016 Bacteria Bacteria 46.2 0.0415   NR GJG88030.1 2839016 g6629 i0 35.2 0.469750889679715 88 48 47 2 165 428 58 136 GJG88030.1 penicillin-binding protein [Gemmatimonadetes bacterium T265] diamond 264 46.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium T265
30291780 30291780 PRJNA1123309_P_NODE_64692_length_243_cov_0.917647_g64312_i0 PRJNA1123309 64692 243 0.917647 2.22988221 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 118 1.08e-29   NR HJR15400.1 2448054 g64312 i0 76.6 1.88888888888889 77 16 95.1 1 234 4 263 337 HJR15400.1 hypothetical protein [Gemmatimonadales bacterium] diamond 459 118 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30575471 30575471 PRJNA1123309_P_NODE_42973_length_263_cov_1.410526_g42593_i0 PRJNA1123309 42973 263 1.410526 3.70968338 Longimicrobium sp. 2029185 Bacteria Bacteria 42.7 0.0443   NR HVH13180.1 2029185 g42593 i0 37.3 0.855513307984791 75 42 82.1 2 253 38 141 213 HVH13180.1 diguanylate cyclase [Longimicrobium sp.] diamond 225 42.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30891839 30891839 PRJNA1123309_P_NODE_60634_length_245_cov_0.906977_g60254_i0 PRJNA1123309 60634 245 0.906977 2.22209365 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 165 2.7399999999999997e-48   NR MFL5562939.1 2026741 g60254 i0 93.6 0.955102040816327 78 5 95.5 0 6 239 227 304 MFL5562939.1 lipoate--protein ligase [Gemmatimonadaceae bacterium] diamond 234 165 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31966643 31966643 PRJNA1123309_P_NODE_48078_length_253_cov_0.866667_g47698_i0 PRJNA1123309 48078 253 0.866667 2.19266751 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 56.2 2.25e-7   NR MBK7786953.1 2026742 g47698 i0 40.5 0.936758893280632 79 37 92.5 2 237 4 101 170 MBK7786953.1 hypothetical protein [Gemmatimonadota bacterium] diamond 237 56.2 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);;