RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJEB30004", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 18 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 18 ✖

bioproject 1

  • PRJEB30004 · 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
2595270 2595270 PRJEB30004_P_NODE_497823_length_192_cov_1.660131_g482196_i0 PRJEB30004 497823 192 1.660131 3.18745152 Bacteria 2 Bacteria Bacteria 117 1.3199999999999999e-28   NR MBV9110632.1 2026742 g482196 i0 88.9 27.5625 63 7 98.4 0 3 191 861 923 MBV9110632.1 heavy metal translocating P-type ATPase [Gemmatimonadota bacterium] diamond 5292 118 0.991525423728814 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
11192033 11192033 PRJEB30004_P_NODE_564269_length_175_cov_0.904412_g548642_i0 PRJEB30004 564269 175 0.904412 1.582721 Gemmatimonas 173479 Bacteria Bacteria 235 1.36e-57   NTclustered gi|470475286|ref|NR_076270.1| 173480 g548642 i0 90.857 43.2857142857143 175 16 100 0 1 175 673 499 Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence blastn 7575 235 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
25214835 25214835 PRJEB30004_P_NODE_613640_length_164_cov_1.312000_g598013_i0 PRJEB30004 613640 164 1.312 2.15168 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 93.6 1.57e-20   NR HET6763538.1 3047548 g598013 i0 81.5 8.85365853658537 54 10 98.8 0 2 163 702 755 HET6763538.1 heavy metal translocating P-type ATPase [Longimicrobiaceae bacterium] diamond 1452 93.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
26741466 26741466 PRJEB30004_P_NODE_297581_length_283_cov_2.434426_g281954_i0 PRJEB30004 297581 283 2.434426 6.88942558 Bacteria 2 Bacteria Bacteria 47.4 0.00129   NR MBA3406070.1 2026741 g281954 i0 46.3 0.795053003533569 41 22 43.5 0 131 9 1 41 MBA3406070.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 225 47.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27317910 27317910 PRJEB30004_P_NODE_312523_length_273_cov_2.303419_g296896_i0 PRJEB30004 312523 273 2.303419 6.28833387 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 43.5 0.0266   NR HEY9515683.1 2026741 g296896 i0 76.9 0.549450549450549 26 6 28.6 0 1 78 253 278 HEY9515683.1 methyltransferase domain-containing protein [Gemmatimonadaceae bacterium] diamond 150 43.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27412764 27412764 PRJEB30004_P_NODE_538083_length_181_cov_1.591549_g522456_i0 PRJEB30004 538083 181 1.591549 2.88070369 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 60.5 9.08e-9   NR MCC6430334.1 2026741 g522456 i0 56.7 1.95580110497238 60 26 99.4 0 2 181 56 115 MCC6430334.1 IS66 family transposase [Gemmatimonadaceae bacterium] diamond 354 60.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27538920 27538920 PRJEB30004_P_NODE_654484_length_156_cov_1.589744_g638857_i0 PRJEB30004 654484 156 1.589744 2.48000064 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 92 1.14e-22   NR HZD84984.1 2026741 g638857 i0 90.2 0.980769230769231 51 5 98.1 0 2 154 43 93 HZD84984.1 SDR family oxidoreductase [Gemmatimonadaceae bacterium] diamond 153 92 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27570385 27570385 PRJEB30004_P_NODE_650724_length_157_cov_1.322034_g635097_i0 PRJEB30004 650724 157 1.322034 2.07559338 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 53.1 2.47e-6   NR HXI32920.1 2448054 g635097 i0 50 1.98726114649682 52 26 99.4 0 157 2 444 495 HXI32920.1 hypothetical protein [Gemmatimonadales bacterium] diamond 312 53.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
27823187 27823187 PRJEB30004_P_NODE_429924_length_215_cov_1.375000_g414297_i0 PRJEB30004 429924 215 1.375 2.95625 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 43.1 0.0192   NR HZI99644.1 2026741 g414297 i0 43.4 0.73953488372093 53 26 72.6 2 207 52 720 769 HZI99644.1 TonB-dependent receptor [Gemmatimonadaceae bacterium] diamond 159 43.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29111130 29111130 PRJEB30004_P_NODE_521028_length_185_cov_3.486301_g505401_i0 PRJEB30004 521028 185 3.486301 6.44965685 Pseudomonadati 3379134 Bacteria Bacteria 99.8 6.9899999999999995e-25   NR HKC81846.1 2026741 g505401 i0 82 1.97837837837838 61 11 98.9 0 2 184 61 121 HKC81846.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Gemmatimonadaceae bacterium] diamond 366 100 0.998 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29212437 29212437 PRJEB30004_P_NODE_412789_length_221_cov_2.653846_g397162_i0 PRJEB30004 412789 221 2.653846 5.86499966 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 79.3 2.69e-15   NR HEX6535207.1 2026741 g397162 i0 66.1 0.841628959276018 62 20 84.2 1 189 4 168 228 HEX6535207.1 OmpA family protein [Gemmatimonadaceae bacterium] diamond 186 79.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29995311 29995311 PRJEB30004_P_NODE_670011_length_153_cov_1.894737_g654384_i0 PRJEB30004 670011 153 1.894737 2.89894761 Pseudomonadati 3379134 Bacteria Bacteria 78.2 3.39e-15   NR MBK7351604.1 2026742 g654384 i0 72 8.80392156862745 50 14 98 0 152 3 394 443 MBK7351604.1 cation/acetate symporter ActP [Gemmatimonadota bacterium] diamond 1347 78.6 0.994910941475827 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31923257 31923257 PRJEB30004_P_NODE_526737_length_184_cov_1.586207_g511110_i0 PRJEB30004 526737 184 1.586207 2.91862088 Pseudomonadati 3379134 Bacteria Bacteria 69.3 7.3e-12   NR HEX8360313.1 2029185 g511110 i0 56.6 11.5760869565217 53 23 86.4 0 1 159 2586 2638 HEX8360313.1 amino acid adenylation domain-containing protein [Longimicrobium sp.] diamond 2130 69.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
32024791 32024791 PRJEB30004_P_NODE_430858_length_214_cov_2.554286_g415231_i0 PRJEB30004 430858 214 2.554286 5.46617204 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 72 6.43e-13   NR HXW96391.1 2448054 g415231 i0 54.7 0.897196261682243 64 29 89.7 0 198 7 57 120 HXW96391.1 class I SAM-dependent methyltransferase [Gemmatimonadales bacterium] diamond 192 72 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32056355 32056355 PRJEB30004_P_NODE_567538_length_174_cov_1.214815_g551911_i0 PRJEB30004 567538 174 1.214815 2.1137781 Longimicrobium sp. 2029185 Bacteria Bacteria 59.7 6.1e-9   NR HVG43977.1 2029185 g551911 i0 52.4 2.20689655172414 63 21 93.1 2 166 5 85 147 HVG43977.1 NYN domain-containing protein [Longimicrobium sp.] diamond 384 59.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
32088006 32088006 PRJEB30004_P_NODE_313438_length_273_cov_1.299145_g297811_i0 PRJEB30004 313438 273 1.299145 3.54666585 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 75.9 1.15e-13   NR HTI06878.1 2448054 g297811 i0 58.3 0.659340659340659 60 24 65.9 1 272 93 323 381 HTI06878.1 hypothetical protein [Gemmatimonadales bacterium] diamond 180 75.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32499591 32499591 PRJEB30004_P_NODE_432679_length_214_cov_1.171429_g417052_i0 PRJEB30004 432679 214 1.171429 2.50685806 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 108 9.05e-27   NR MBC7843561.1 2026741 g417052 i0 66.7 1.00934579439252 72 23 99.5 1 2 214 9 80 MBC7843561.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 216 108 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32531159 32531159 PRJEB30004_P_NODE_367279_length_242_cov_2.142857_g351652_i0 PRJEB30004 367279 242 2.142857 5.18571394 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 140 6.56e-38   NR HTR21421.1 2448054 g351652 i0 77.5 4.94628099173554 80 18 99.2 0 3 242 178 257 HTR21421.1 acyl-CoA dehydrogenase [Gemmatimonadales bacterium] diamond 1197 140 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);;