RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA638138" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA638138 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
609330 609330 PRJNA638138_P_NODE_20921_length_250_cov_0.870056_g20706_i0 PRJNA638138 20921 250 0.870056 2.17514 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 132 2.1399999999999993e-34   NR HZO19555.1 2026741 g20706 i0 82.9 7.932 82 14 98.4 0 247 2 327 408 HZO19555.1 pitrilysin family protein [Gemmatimonadaceae bacterium] diamond 1983 132 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
6987908 6987908 PRJNA638138_P_NODE_25426_length_247_cov_0.885057_g25211_i0 PRJNA638138 25426 247 0.885057 2.18609079 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 151 3.14e-41   NR MBA3890630.1 2026741 g25211 i0 91.4 0.983805668016194 81 7 98.4 0 3 245 7 87 MBA3890630.1 iron ABC transporter permease [Gemmatimonadaceae bacterium] diamond 243 151 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
8262503 8262503 PRJNA638138_P_NODE_14887_length_283_cov_1.428571_g14672_i0 PRJNA638138 14887 283 1.428571 4.04285593 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 75.5 1.68e-13   NR HEX6535320.1 2026741 g14672 i0 69.8 0.561837455830389 53 16 56.2 0 161 3 3 55 HEX6535320.1 BatA domain-containing protein [Gemmatimonadaceae bacterium] diamond 159 75.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
11358665 11358665 PRJNA638138_P_NODE_29369_length_245_cov_0.895349_g29154_i0 PRJNA638138 29369 245 0.895349 2.19360505 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 121 4.09e-30   NR WP_025412835.1 861299 g29154 i0 76.3 0.930612244897959 76 17 93.1 1 229 2 81 155 WP_025412835.1 trypsin-like peptidase domain-containing protein [Gemmatirosa kalamazoonensis] diamond 228 121 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
15912369 15912369 PRJNA638138_P_NODE_34993_length_241_cov_0.916667_g34778_i0 PRJNA638138 34993 241 0.916667 2.20916747 Longimicrobium sp. 2029185 Bacteria Bacteria 154 5.5599999999999984e-43   NR WP_331025448.1 2029185 g34778 i0 90 2.98755186721992 80 8 99.6 0 2 241 161 240 WP_331025448.1 S8 family peptidase [Longimicrobium sp.] diamond 720 154 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
25381640 25381640 PRJNA638138_P_NODE_34360_length_242_cov_0.911243_g34145_i0 PRJNA638138 34360 242 0.911243 2.20520806 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 142 1.76e-38   NR MEX2582015.1 2026742 g34145 i0 82.5 4.95867768595041 80 14 99.2 0 240 1 287 366 MEX2582015.1 sigma-54 dependent transcriptional regulator [Gemmatimonadota bacterium] diamond 1200 142 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27334047 27334047 PRJNA638138_P_NODE_36083_length_241_cov_0.892857_g35868_i0 PRJNA638138 36083 241 0.892857 2.15178537 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 120 5.09e-33   NR HEX5577783.1 2026741 g35868 i0 71.3 0.995850622406639 80 23 99.6 0 2 241 18 97 HEX5577783.1 glycosyltransferase family A protein [Gemmatimonadaceae bacterium] diamond 240 120 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28375795 28375795 PRJNA638138_P_NODE_20186_length_251_cov_0.865169_g19971_i0 PRJNA638138 20186 251 0.865169 2.17157419 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 111 4.95e-27   NR HUF25670.1 2026741 g19971 i0 61.4 0.99203187250996006 83 32 99.2 0 250 2 50 132 HUF25670.1 tetratricopeptide repeat protein [Gemmatimonadaceae bacterium] diamond 249 111 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28407505 28407505 PRJNA638138_P_NODE_27966_length_246_cov_0.890173_g27751_i0 PRJNA638138 27966 246 0.890173 2.18982558 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 56.2 6.9e-7   NR HET7623416.1 2026741 g27751 i0 80 0.365853658536585 30 6 36.6 0 1 90 552 581 HET7623416.1 histone deacetylase family protein [Gemmatimonadaceae bacterium] diamond 90 56.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28565292 28565292 PRJNA638138_P_NODE_22447_length_249_cov_0.875000_g22232_i0 PRJNA638138 22447 249 0.875 2.17875 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 53.9 4.73e-7   NR MBW3630238.1 2026742 g22232 i0 70.4 0.325301204819277 27 8 32.5 0 83 3 1 27 MBW3630238.1 hypothetical protein [Gemmatimonadota bacterium] diamond 81 53.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29954659 29954659 PRJNA638138_P_NODE_20931_length_250_cov_0.870056_g20716_i0 PRJNA638138 20931 250 0.870056 2.17514 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 48.1 4.34e-4   NR HLB82263.1 2448054 g20716 i0 62.2 1.272 37 14 44.4 0 6 116 200 236 HLB82263.1 (5-formylfuran-3-yl)methyl phosphate synthase [Gemmatimonadales bacterium] diamond 318 48.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30649470 30649470 PRJNA638138_P_NODE_32273_length_243_cov_0.905882_g32058_i0 PRJNA638138 32273 243 0.905882 2.20129326 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 143 3.55e-41   NR HEY0970788.1 2448054 g32058 i0 84.8 0.975308641975309 79 12 97.5 0 237 1 32 110 HEY0970788.1 gluconate 2-dehydrogenase subunit 3 family protein [Gemmatimonadales bacterium] diamond 237 143 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30712877 30712877 PRJNA638138_P_NODE_27014_length_246_cov_0.890173_g26799_i0 PRJNA638138 27014 246 0.890173 2.18982558 Longimicrobiales bacterium 2910168 Bacteria Bacteria 101 2.6599999999999998e-24   NR HEX7051000.1 2910168 g26799 i0 62.4 3.07317073170732 85 28 98.8 1 3 245 36 120 HEX7051000.1 methyltransferase domain-containing protein [Longimicrobiales bacterium] diamond 756 101 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales 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);;