RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA888821" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA888821 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
27245094 27245094 PRJNA888821_P_NODE_45883_length_218_cov_8.448276_g45800_i0 PRJNA888821 45883 218 8.448276 18.41724168 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 95.1 8.050000000000001e-21   NR HEY4306869.1 2026741 g45800 i0 63.9 1.87155963302752 72 25 97.7 1 5 217 322 393 HEY4306869.1 pitrilysin family protein [Gemmatimonadaceae bacterium] diamond 408 95.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28161102 28161102 PRJNA888821_P_NODE_11045_length_310_cov_9.932489_g10963_i0 PRJNA888821 11045 310 9.932489 30.7907159 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 91.3 7.27e-19   NR HET6778985.1 2448054 g10963 i0 92 3 50 4 48.4 0 1 150 505 554 HET6778985.1 3-deoxy-7-phosphoheptulonate synthase [Gemmatimonadales bacterium] diamond 930 91.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28823694 28823694 PRJNA888821_P_NODE_38248_length_243_cov_6.547059_g38165_i0 PRJNA888821 38248 243 6.547059 15.90935337 Gemmatimonas sp. 1962908 Bacteria Bacteria 142 2.62e-41   NR WP_331050585.1 1962908 g38165 i0 87.7 1 81 10 100 0 243 1 20 100 WP_331050585.1 hypothetical protein [Gemmatimonas sp.] diamond 243 142 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
29644489 29644489 PRJNA888821_P_NODE_42230_length_231_cov_4.094937_g42147_i0 PRJNA888821 42230 231 4.094937 9.45930447 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 152 9.67e-44   NR HZN98768.1 2448054 g42147 i0 92.1 2.96103896103896 76 6 98.7 0 2 229 119 194 HZN98768.1 PHP domain-containing protein [Gemmatimonadales bacterium] diamond 684 152 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29652412 29652412 PRJNA888821_P_NODE_2990_length_392_cov_12.542320_g2909_i0 PRJNA888821 2990 392 12.54232 49.1658944 Pseudomonadati 3379134 Bacteria Bacteria 138 7.729999999999998e-35   NR MBV9108362.1 2026742 g2909 i0 77.3 2.34183673469388 75 17 57.4 0 392 168 673 747 MBV9108362.1 hypothetical protein [Gemmatimonadota bacterium] diamond 918 138 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29842195 29842195 PRJNA888821_P_NODE_22631_length_307_cov_10.115385_g22549_i0 PRJNA888821 22631 307 10.115385 31.05423195 Pseudomonadati 3379134 Bacteria Bacteria 62.4 7.17e-9   NR WP_337172358.1 173480 g22549 i0 59.6 0.928338762214984 47 19 45.9 0 1 141 128 174 WP_337172358.1 SRPBCC domain-containing protein [Gemmatimonas aurantiaca] diamond 285 62.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
30442636 30442636 PRJNA888821_P_NODE_31433_length_264_cov_1.246073_g31350_i0 PRJNA888821 31433 264 1.246073 3.28963272 Gemmatimonas 173479 Bacteria Bacteria 130 6.7999999999999995e-35   NR WP_291261215.1 1962908 g31350 i0 80.2 8.76136363636364 86 17 97.7 0 259 2 161 246 WP_291261215.1 prohibitin family protein [Gemmatimonas sp.] diamond 2313 130 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
30782171 30782171 PRJNA888821_P_NODE_40494_length_237_cov_5.152439_g40411_i0 PRJNA888821 40494 237 5.152439 12.21128043 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 106 1.16e-24   NR MBV9108362.1 2026742 g40411 i0 67.6 0.936708860759494 74 24 93.7 0 225 4 927 1000 MBV9108362.1 hypothetical protein [Gemmatimonadota bacterium] diamond 222 106 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31224364 31224364 PRJNA888821_P_NODE_19195_length_310_cov_3.388186_g19113_i0 PRJNA888821 19195 310 3.388186 10.5033766 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 93.6 8.719999999999999e-23   NR HEY4132494.1 2026741 g19113 i0 89.8 1.42258064516129 49 5 47.4 0 164 310 1 49 HEY4132494.1 pyruvate kinase [Gemmatimonadaceae bacterium] diamond 441 93.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32015296 32015296 PRJNA888821_P_NODE_10398_length_310_cov_10.611814_g10316_i0 PRJNA888821 10398 310 10.611814 32.8966234 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 74.3 5.59e-13   NR MEO7367026.1 2026741 g10316 i0 48.2 2.92258064516129 85 42 82.3 1 292 38 151 233 MEO7367026.1 M20/M25/M40 family metallo-hydrolase [Gemmatimonadaceae bacterium] diamond 906 74.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32023253 32023253 PRJNA888821_P_NODE_14378_length_310_cov_7.021097_g14296_i0 PRJNA888821 14378 310 7.021097 21.7654007 FCB group 1783270 Bacteria Bacteria 92 2.76e-20   NR MCC6771627.1 2026741 g14296 i0 91.8 0.948387096774194 49 4 47.4 0 162 308 46 94 MCC6771627.1 ceramidase domain-containing protein [Gemmatimonadaceae bacterium] diamond 294 92.8 0.991379310344828 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae 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);;