RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA505329" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA505329 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
1110332 1110332 PRJNA505329_P_NODE_33641_length_182_cov_1.263158_g33170_i0 PRJNA505329 33641 182 1.263158 2.29894756 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 108 4.33e-27   NR MDQ3522939.1 2026742 g33170 i0 86.7 1.97802197802198 60 8 98.9 0 2 181 136 195 MDQ3522939.1 IS3 family transposase [Gemmatimonadota bacterium] diamond 360 108 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
2385841 2385841 PRJNA505329_P_NODE_29342_length_188_cov_2.208633_g28871_i0 PRJNA505329 29342 188 2.208633 4.15223004 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 82.8 7.65e-17   NR HEX6104385.1 2448054 g28871 i0 56.5 1.3563829787234 85 3 81.4 1 154 2 1 85 HEX6104385.1 XdhC family protein [Gemmatimonadales bacterium] diamond 255 82.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
9411628 9411628 PRJNA505329_P_NODE_44908_length_166_cov_2.564103_g44437_i0 PRJNA505329 44908 166 2.564103 4.25641098 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 87.4 9.94e-19   NR HSD33230.1 2448054 g44437 i0 80.4 5.25903614457831 51 10 92.2 0 155 3 19 69 HSD33230.1 IS481 family transposase [Gemmatimonadales bacterium] diamond 873 87.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28466808 28466808 PRJNA505329_P_NODE_14366_length_233_cov_2.766304_g13895_i0 PRJNA505329 14366 233 2.766304 6.44548832 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 66.2 1.68e-10   NR MBK8246937.1 2026742 g13895 i0 100 0.412017167381974 32 0 41.2 0 230 135 362 393 MBK8246937.1 PQQ-binding-like beta-propeller repeat protein [Gemmatimonadota bacterium] diamond 96 66.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28703227 28703227 PRJNA505329_P_NODE_44847_length_166_cov_2.632479_g44376_i0 PRJNA505329 44847 166 2.632479 4.36991514 Bacteria 2 Bacteria Bacteria 40.4 0.0246   NR HEU4565390.1 2026741 g44376 i0 44.4 4.1566265060241 45 25 81.3 0 6 140 41 85 HEU4565390.1 CPXCG motif-containing cysteine-rich protein [Gemmatimonadaceae bacterium] diamond 690 40.8 0.990196078431373 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29950759 29950759 PRJNA505329_P_NODE_24211_length_196_cov_3.857143_g23740_i0 PRJNA505329 24211 196 3.857143 7.56000028 Gemmatimonas sp. 1962908 Bacteria Bacteria 65.9 1.43e-10   NR MQA90924.1 1962908 g23740 i0 67.4 0.704081632653061 46 15 70.4 0 58 195 785 830 MQA90924.1 helicase [Gemmatimonas sp.] diamond 138 65.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
30361897 30361897 PRJNA505329_P_NODE_27492_length_191_cov_1.443662_g27021_i0 PRJNA505329 27492 191 1.443662 2.75739442 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 117 1.18e-28   NR MBP2646843.1 2026742 g27021 i0 95.2 0.989528795811518 63 3 99 0 1 189 1 63 MBP2646843.1 Threonyl-tRNA synthetase [Gemmatimonadota bacterium] diamond 189 117 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);;