RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA758088" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA758088 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
27210828 27210828 PRJNA758088_P_NODE_326342_length_246_cov_0.890173_g319371_i0 PRJNA758088 326342 246 0.890173 2.18982558 Lentisphaeria bacterium 2053569 Bacteria Bacteria 64.7 6.92e-10   NR MBO5762075.1 2053569 g319371 i0 45.1 0.865853658536585 71 39 86.6 0 32 244 1 71 MBO5762075.1 DUF5107 domain-containing protein [Lentisphaeria bacterium] diamond 213 64.7 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
27526908 27526908 PRJNA758088_P_NODE_305863_length_248_cov_0.880000_g298892_i0 PRJNA758088 305863 248 0.88 2.1824 Lentisphaeraceae bacterium 2461380 Bacteria Bacteria 65.1 4.81e-10   NR MCM8527079.1 2461380 g298892 i0 51.9 2.11693548387097 54 26 65.3 0 187 26 162 215 MCM8527079.1 replication initiation protein [Lentisphaeraceae bacterium] diamond 525 65.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales Lentisphaeraceae   Lentisphaeraceae bacterium
27653419 27653419 PRJNA758088_P_NODE_365104_length_241_cov_0.916667_g358133_i0 PRJNA758088 365104 241 0.916667 2.20916747 uncultured Victivallis sp. 354118 Bacteria Bacteria 123 1.38e-30   NR WP_294479691.1 354118 g358133 i0 74.4 1.96680497925311 78 20 97.1 0 8 241 92 169 WP_294479691.1 hypothetical protein [uncultured Victivallis sp.] diamond 474 123 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales Victivallaceae Victivallis uncultured Victivallis sp.
28537526 28537526 PRJNA758088_P_NODE_353147_length_242_cov_0.911243_g346176_i0 PRJNA758088 353147 242 0.911243 2.20520806 Victivallis vadensis 172901 Bacteria Bacteria 115 4.78e-28   NR WP_277201914.1 172901 g346176 i0 70.4 1.00413223140496 81 23 99.2 1 240 1 172 252 WP_277201914.1 phosphoethanolamine transferase [Victivallis vadensis] diamond 243 115 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales Victivallaceae Victivallis Victivallis vadensis
28632257 28632257 PRJNA758088_P_NODE_317527_length_247_cov_0.885057_g310556_i0 PRJNA758088 317527 247 0.885057 2.18609079 Lentisphaeria bacterium 2053569 Bacteria Bacteria 178 8.11e-50   NR HCG24454.1 2053569 g310556 i0 100 0.995951417004049 82 0 99.6 0 247 2 68 149 HCG24454.1 hypothetical protein [Lentisphaeria bacterium] diamond 246 178 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
29926774 29926774 PRJNA758088_P_NODE_366311_length_241_cov_0.916667_g359340_i0 PRJNA758088 366311 241 0.916667 2.20916747 Lentisphaeria bacterium 2053569 Bacteria Bacteria 85.1 2.91e-18   NR MBP3394103.1 2053569 g359340 i0 100 0.460580912863071 37 0 46.1 0 129 239 1 37 MBP3394103.1 hypothetical protein [Lentisphaeria bacterium] diamond 111 85.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
31000970 31000970 PRJNA758088_P_NODE_361214_length_241_cov_0.916667_g354243_i0 PRJNA758088 361214 241 0.916667 2.20916747 uncultured Victivallis sp. 354118 Bacteria Bacteria 79 3.56e-15   NR WP_288614047.1 354118 g354243 i0 100 0.995850622406639 44 0 54.8 0 133 2 1 44 WP_288614047.1 type II secretion system protein GspK [uncultured Victivallis sp.] diamond 240 79 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales Victivallaceae Victivallis uncultured Victivallis sp.
31759716 31759716 PRJNA758088_P_NODE_296557_length_249_cov_0.875000_g289586_i0 PRJNA758088 296557 249 0.875 2.17875 Lentisphaeria bacterium 2053569 Bacteria Bacteria 169 2.6e-50   NR MCI6287492.1 2053569 g289586 i0 100 1 83 0 100 0 1 249 158 240 MCI6287492.1 LacI family DNA-binding transcriptional regulator [Lentisphaeria bacterium] diamond 249 169 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria 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);;