RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA630162 · 18 ✖

analysis 1

  • diamond · 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
26637382 26637382 PRJNA630162_P_NODE_106781_length_181_cov_2.939394_g105258_i0 PRJNA630162 106781 181 2.939394 5.32030314 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 64.7 5.16e-12   NR HEX5726428.1 3047548 g105258 i0 86.1 0.596685082872928 36 5 59.7 0 109 2 6 41 HEX5726428.1 hypothetical protein [Longimicrobiaceae bacterium] diamond 108 64.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
26637575 26637575 PRJNA630162_P_NODE_71101_length_212_cov_2.503067_g69578_i0 PRJNA630162 71101 212 2.503067 5.30650204 Longimicrobiales bacterium 2910168 Bacteria Bacteria 50.4 4.71e-5   NR HUG01012.1 2910168 g69578 i0 47.2 0.75 53 26 75 1 166 8 381 431 HUG01012.1 leishmanolysin-related zinc metalloendopeptidase [Longimicrobiales bacterium] diamond 159 50.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
26891232 26891232 PRJNA630162_P_NODE_7481_length_701_cov_2.983129_g6210_i0 PRJNA630162 7481 701 2.983129 20.91173429 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 89.4 1.39e-16   NR MYF17025.1 2026742 g6210 i0 36.7 0.641940085592011 150 88 63.3 3 134 577 280 424 MYF17025.1 hypothetical protein [Gemmatimonadota bacterium] diamond 450 89.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
26985630 26985630 PRJNA630162_P_NODE_113002_length_178_cov_1.550388_g111479_i0 PRJNA630162 113002 178 1.550388 2.75969064 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 69.3 6.59e-12   NR HUL70248.1 2448054 g111479 i0 66.1 2.8314606741573 56 19 94.4 0 10 177 241 296 HUL70248.1 NAD(P)/FAD-dependent oxidoreductase [Gemmatimonadales bacterium] diamond 504 69.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
27302168 27302168 PRJNA630162_P_NODE_59583_length_228_cov_5.497207_g58060_i0 PRJNA630162 59583 228 5.497207 12.53363196 Longimicrobiales bacterium 2910168 Bacteria Bacteria 44.7 0.00635   NR MDX1494577.1 2910168 g58060 i0 31.5 1.77631578947368 73 47 94.7 2 12 227 305 375 MDX1494577.1 acetate--CoA ligase [Longimicrobiales bacterium] diamond 405 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
27346454 27346454 PRJNA630162_P_NODE_18083_length_438_cov_1.917738_g16575_i0 PRJNA630162 18083 438 1.917738 8.39969244 Pseudomonadati 3379134 Bacteria Bacteria 131 1.76e-33   NR MCU0646485.1 2026741 g16575 i0 61.7 6.43150684931507 133 46 91.1 2 7 405 271 398 MCU0646485.1 S8 family peptidase [Gemmatimonadaceae bacterium] diamond 2817 132 0.992424242424242 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27378163 27378163 PRJNA630162_P_NODE_90603_length_191_cov_2.352113_g89080_i0 PRJNA630162 90603 191 2.352113 4.49253583 Bacteria 2 Bacteria Bacteria 45.1 0.00214   NR HEX4934428.1 2026741 g89080 i0 46.3 2.13612565445026 41 22 64.4 0 47 169 85 125 HEX4934428.1 protease inhibitor I9 family protein [Gemmatimonadaceae bacterium] diamond 408 45.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28343905 28343905 PRJNA630162_P_NODE_112866_length_178_cov_1.604651_g111343_i0 PRJNA630162 112866 178 1.604651 2.85627878 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 77 7.18e-15   NR MEO8227655.1 2026742 g111343 i0 54.4 0.960674157303371 57 26 96.1 0 174 4 33 89 MEO8227655.1 amino acid--[acyl-carrier-protein] ligase [Gemmatimonadota bacterium] diamond 171 77 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29007352 29007352 PRJNA630162_P_NODE_133668_length_168_cov_2.487395_g132145_i0 PRJNA630162 133668 168 2.487395 4.1788236 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 62.8 1.13e-9   NR MDX2183821.1 2026741 g132145 i0 65.2 0.821428571428571 46 15 80.4 1 2 136 454 499 MDX2183821.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadaceae bacterium] diamond 138 62.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29196599 29196599 PRJNA630162_P_NODE_129309_length_170_cov_1.049587_g127786_i0 PRJNA630162 129309 170 1.049587 1.7842979 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 69.3 1.6e-12   NR MBL8960655.1 2026742 g127786 i0 63 1.90588235294118 54 20 95.3 0 164 3 76 129 MBL8960655.1 hypothetical protein [Gemmatimonadota bacterium] diamond 324 69.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29733131 29733131 PRJNA630162_P_NODE_85930_length_195_cov_1.924658_g84407_i0 PRJNA630162 85930 195 1.924658 3.7530831 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 60.5 1.09e-8   NR MBC8087251.1 2026741 g84407 i0 53.7 1.75384615384615 54 25 83.1 0 188 27 132 185 MBC8087251.1 DNA/RNA non-specific endonuclease [Gemmatimonadaceae bacterium] diamond 342 60.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29954294 29954294 PRJNA630162_P_NODE_106571_length_181_cov_5.575758_g105048_i0 PRJNA630162 106571 181 5.575758 10.09212198 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 42 0.0294   NR HKP30204.1 2448054 g105048 i0 40.4 0.861878453038674 52 26 77.9 2 179 39 39 90 HKP30204.1 hypothetical protein [Gemmatimonadales bacterium] diamond 156 42 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30080473 30080473 PRJNA630162_P_NODE_136032_length_168_cov_0.873950_g134509_i0 PRJNA630162 136032 168 0.87395 1.468236 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 77.4 8.32e-17   NR MEX2584196.1 2026742 g134509 i0 81.8 0.785714285714286 44 8 78.6 0 168 37 55 98 MEX2584196.1 PAAR domain-containing protein [Gemmatimonadota bacterium] diamond 132 77.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30175533 30175533 PRJNA630162_P_NODE_86792_length_194_cov_2.248276_g85269_i0 PRJNA630162 86792 194 2.248276 4.36165544 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 48.5 1.43e-4   NR HEX9248111.1 2026741 g85269 i0 74.1 0.417525773195876 27 7 41.8 0 109 189 1 27 HEX9248111.1 pirin family protein [Gemmatimonadaceae bacterium] diamond 81 48.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32262390 32262390 PRJNA630162_P_NODE_162718_length_161_cov_2.919643_g161195_i0 PRJNA630162 162718 161 2.919643 4.70062523 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 83.2 1.86e-17   NR MBC7563806.1 2026741 g161195 i0 92.7 2.29192546583851 41 3 76.4 0 5 127 244 284 MBC7563806.1 ABC transporter substrate-binding protein [Gemmatimonadaceae bacterium] diamond 369 83.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32294108 32294108 PRJNA630162_P_NODE_23719_length_376_cov_8.984709_g22200_i0 PRJNA630162 23719 376 8.984709 33.78250584 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 44.3 0.044   NR HEY2378349.1 2026741 g22200 i0 38.3 0.646276595744681 81 43 59.8 3 21 245 228 307 HEY2378349.1 chloride channel protein [Gemmatimonadaceae bacterium] diamond 243 44.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32433192 32433192 PRJNA630162_P_NODE_117139_length_176_cov_1.370079_g115616_i0 PRJNA630162 117139 176 1.370079 2.41133904 Pseudomonadati 3379134 Bacteria Bacteria 47 4.87e-4   NR HEY7235705.1 2026741 g115616 i0 42.5 2.23295454545455 40 23 68.2 0 161 42 219 258 HEY7235705.1 CRTAC1 family protein [Gemmatimonadaceae bacterium] diamond 393 47 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32748537 32748537 PRJNA630162_P_NODE_99460_length_186_cov_1.343066_g97937_i0 PRJNA630162 99460 186 1.343066 2.49810276 Gemmatimonas 173479 Bacteria Bacteria 40.8 0.0412   NR HCT55640.1 173480 g97937 i0 43.1 2.46774193548387 51 27 79 1 23 169 74 124 HCT55640.1 hypothetical protein [Gemmatimonas aurantiaca] diamond 459 40.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca

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);;