RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA864829" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA864829 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
3398033 3398033 PRJNA864829_S_NODE_6443_length_240_cov_1.366492_g6357_i0 PRJNA864829 6443 240 1.366492 3.2795808 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 164 1.24e-48   NR MBL8984445.1 2026742 g6357 i0 98.8 1 80 1 100 0 1 240 113 192 MBL8984445.1 VOC family protein [Gemmatimonadota bacterium] diamond 240 164 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27466072 27466072 PRJNA864829_S_NODE_14283_length_171_cov_0.885246_g14197_i0 PRJNA864829 14283 171 0.885246 1.51377066 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 103 5e-24   NR MBL8982387.1 2026742 g14197 i0 96.4 0.964912280701754 55 2 96.5 0 166 2 340 394 MBL8982387.1 HAMP domain-containing histidine kinase [Gemmatimonadota bacterium] diamond 165 103 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27687324 27687324 PRJNA864829_S_NODE_10024_length_199_cov_1.853333_g9938_i0 PRJNA864829 10024 199 1.853333 3.68813267 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 101 2.2799999999999994e-23   NR MBL8958933.1 2026742 g9938 i0 94.6 0.844221105527638 56 3 84.4 0 2 169 358 413 MBL8958933.1 dipeptidase [Gemmatimonadota bacterium] diamond 168 101 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27844635 27844635 PRJNA864829_S_NODE_16764_length_156_cov_3.046729_g16678_i0 PRJNA864829 16764 156 3.046729 4.75289724 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 100 2.4699999999999994e-23   NR MBL8960032.1 2026742 g16678 i0 98 0.980769230769231 51 1 98.1 0 154 2 177 227 MBL8960032.1 signal recognition particle protein [Gemmatimonadota bacterium] diamond 153 100 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28539679 28539679 PRJNA864829_S_NODE_13647_length_174_cov_1.216000_g13561_i0 PRJNA864829 13647 174 1.216 2.11584 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 94.4 3.73e-22   NR MBL8960095.1 2026742 g13561 i0 94.3 1.77586206896552 53 3 91.4 0 16 174 161 213 MBL8960095.1 hypothetical protein [Gemmatimonadota bacterium] diamond 309 94.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28791849 28791849 PRJNA864829_S_NODE_3047_length_315_cov_2.007519_g2961_i0 PRJNA864829 3047 315 2.007519 6.32368485 Longimicrobium sp. 2029185 Bacteria Bacteria 116 4.6e-30   NR HEU4561987.1 2029185 g2961 i0 51.9 0.990476190476191 104 48 99 1 314 3 50 151 HEU4561987.1 hypothetical protein [Longimicrobium sp.] diamond 312 116 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
28981700 28981700 PRJNA864829_S_NODE_10808_length_193_cov_1.486111_g10722_i0 PRJNA864829 10808 193 1.486111 2.86819423 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 46.2 6.47e-4   NR MFL5383662.1 3047548 g10722 i0 37.7 0.948186528497409 61 38 94.8 0 185 3 37 97 MFL5383662.1 hypothetical protein [Longimicrobiaceae bacterium] diamond 183 46.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
29518152 29518152 PRJNA864829_S_NODE_2310_length_347_cov_1.416107_g2224_i0 PRJNA864829 2310 347 1.416107 4.91389129 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 164 5.3799999999999997e-48   NR MBK8248449.1 2026742 g2224 i0 89 0.864553314121037 100 11 86.5 0 345 46 5 104 MBK8248449.1 hypothetical protein [Gemmatimonadota bacterium] diamond 300 164 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29802330 29802330 PRJNA864829_S_NODE_13251_length_176_cov_2.157480_g13165_i0 PRJNA864829 13251 176 2.15748 3.7971648 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 106 1.15e-25   NR MBK8249762.1 2026742 g13165 i0 78.9 0.971590909090909 57 12 97.2 0 3 173 182 238 MBK8249762.1 mannose-1-phosphate guanylyltransferase [Gemmatimonadota bacterium] diamond 171 106 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30126223 30126223 PRJNA864829_S_NODE_3192_length_310_cov_1.210728_g3106_i0 PRJNA864829 3192 310 1.210728 3.7532568 Pseudomonadati 3379134 Bacteria Bacteria 151 3.3699999999999993e-43   NR MFN8580605.1 2026741 g3106 i0 75.5 4.93548387096774 102 25 98.7 0 308 3 14 115 MFN8580605.1 amidohydrolase family protein [Gemmatimonadaceae bacterium] diamond 1530 152 0.993421052631579 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30466154 30466154 PRJNA864829_S_NODE_15473_length_166_cov_1.376068_g15387_i0 PRJNA864829 15473 166 1.376068 2.28427288 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 103 3.35e-24   NR MBL8982387.1 2026742 g15387 i0 96.3 0.975903614457831 54 2 97.6 0 3 164 297 350 MBL8982387.1 HAMP domain-containing histidine kinase [Gemmatimonadota bacterium] diamond 162 103 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30821573 30821573 PRJNA864829_S_NODE_5094_length_262_cov_2.187793_g5008_i0 PRJNA864829 5094 262 2.187793 5.73201766 FCB group 1783270 Bacteria Bacteria 111 1.15e-26   NR HEY0153095.1 2029185 g5008 i0 67.1 2.90839694656489 82 27 93.9 0 247 2 29 110 HEY0153095.1 AAA family ATPase [Longimicrobium sp.] diamond 762 112 0.991071428571429 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31034900 31034900 PRJNA864829_S_NODE_2775_length_325_cov_2.590580_g2689_i0 PRJNA864829 2775 325 2.59058 8.419385 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 203 2.52e-60   NR MBL8981345.1 2026742 g2689 i0 96.2 0.978461538461538 106 4 97.8 0 323 6 20 125 MBL8981345.1 B12-binding domain-containing radical SAM protein [Gemmatimonadota bacterium] diamond 318 203 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31635281 31635281 PRJNA864829_S_NODE_12396_length_182_cov_1.007519_g12310_i0 PRJNA864829 12396 182 1.007519 1.83368458 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 115 4.17e-29   NR MBL8959946.1 2026742 g12310 i0 95 0.989010989010989 60 3 98.9 0 182 3 83 142 MBL8959946.1 cysteine synthase family protein [Gemmatimonadota bacterium] diamond 180 115 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31888301 31888301 PRJNA864829_S_NODE_13477_length_175_cov_1.277778_g13391_i0 PRJNA864829 13477 175 1.277778 2.2361115 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 89.4 4.53e-19   NR MEP7381231.1 2026742 g13391 i0 73.2 0.96 56 15 96 0 3 170 349 404 MEP7381231.1 ethylbenzene dehydrogenase-related protein [Gemmatimonadota bacterium] diamond 168 89.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31888302 31888302 PRJNA864829_S_NODE_14917_length_168_cov_1.798319_g14831_i0 PRJNA864829 14917 168 1.798319 3.02117592 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 66.2 7.09e-11   NR HEU4523665.1 2448054 g14831 i0 66 1.78571428571429 50 17 89.3 0 10 159 716 765 HEU4523665.1 hypothetical protein [Gemmatimonadales bacterium] diamond 300 66.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32141587 32141587 PRJNA864829_S_NODE_12058_length_184_cov_1.992593_g11972_i0 PRJNA864829 12058 184 1.992593 3.66637112 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 137 3.67e-39   NR MBL8984271.1 2026742 g11972 i0 100 0.994565217391304 61 0 99.5 0 1 183 28 88 MBL8984271.1 cytochrome c3 family protein [Gemmatimonadota bacterium] diamond 183 137 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);;