RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA554794" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA554794 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
27219014 27219014 PRJNA554794_P_NODE_23182_length_165_cov_0.879310_g19253_i0 PRJNA554794 23182 165 0.87931 1.4508615 Flavobacteriaceae 49546 Bacteria Bacteria 57.4 8.97e-8   NR WP_387964419.1 1268269 g19253 i0 60.5 3.12727272727273 43 17 78.2 0 1 129 441 483 WP_387964419.1 flavin-containing monooxygenase [Geojedonia litorea] diamond 516 57.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Geojedonia Geojedonia litorea
27661629 27661629 PRJNA554794_P_NODE_24244_length_162_cov_0.902655_g20315_i0 PRJNA554794 24244 162 0.902655 1.4623011 Fluviicola 332102 Bacteria Bacteria 106 3.61e-25   NR WP_309281040.1 1917219 g20315 i0 96.2 1.96296296296296 53 2 98.1 0 160 2 236 288 WP_309281040.1 penicillin-binding transpeptidase domain-containing protein [Fluviicola sp.] diamond 318 106 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Crocinitomicaceae Fluviicola Fluviicola sp.
28152290 28152290 PRJNA554794_P_NODE_23105_length_165_cov_0.879310_g19176_i0 PRJNA554794 23105 165 0.87931 1.4508615 Bacteroidales bacterium 2030927 Bacteria Bacteria 45.1 0.00205   NR MCK9302953.1 2030927 g19176 i0 41.5 1.76363636363636 53 29 92.7 1 165 13 133 185 MCK9302953.1 protein kinase [Bacteroidales bacterium] diamond 291 45.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
28531142 28531142 PRJNA554794_P_NODE_13607_length_241_cov_1.041667_g9678_i0 PRJNA554794 13607 241 1.041667 2.51041747 Bacteroidota 976 Bacteria Bacteria 139 8.08e-39   NR WP_093366774.1 976 g9678 i0 89.7 1.94190871369295 78 8 97.1 0 6 239 6 83 WP_093366774.1 MULTISPECIES: SDR family NAD(P)-dependent oxidoreductase [Bacteroidota] diamond 468 139 1 Bacteria FCB group Pseudomonadati Bacteroidota          
28689075 28689075 PRJNA554794_P_NODE_23327_length_165_cov_0.862069_g19398_i0 PRJNA554794 23327 165 0.862069 1.42241385 unclassified Sediminibacterium 2635961 Bacteria Bacteria 85.5 5.53e-19   NR WP_178886443.1 2635961 g19398 i0 95.3 0.781818181818182 43 2 78.2 0 164 36 154 196 WP_178886443.1 MULTISPECIES: Crp/Fnr family transcriptional regulator [unclassified Sediminibacterium] diamond 129 85.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Sediminibacterium  
28909580 28909580 PRJNA554794_P_NODE_21308_length_182_cov_1.075188_g17379_i0 PRJNA554794 21308 182 1.075188 1.95684216 Flavobacteriales bacterium 2021391 Bacteria Bacteria 94.4 1.1e-20   NR MCI5055020.1 2021391 g17379 i0 74.5 3.75824175824176 55 14 90.7 0 182 18 360 414 MCI5055020.1 T9SS type A sorting domain-containing protein [Flavobacteriales bacterium] diamond 684 94.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales bacterium
29762203 29762203 PRJNA554794_P_NODE_13891_length_233_cov_1.923913_g9962_i0 PRJNA554794 13891 233 1.923913 4.48271729 Flavobacterium sp. 239 Bacteria Bacteria 54.3 7.29e-7   NR WP_298178503.1 239 g9962 i0 56.6 1.36480686695279 53 22 68.2 1 233 75 101 152 WP_298178503.1 hypothetical protein [Flavobacterium sp.] diamond 318 54.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
31072375 31072375 PRJNA554794_P_NODE_24175_length_162_cov_0.902655_g20246_i0 PRJNA554794 24175 162 0.902655 1.4623011 Flavobacterium 237 Bacteria Bacteria 63.9 4.05e-10   NR WP_077370672.1 1945862 g20246 i0 71.8 5.31481481481481 39 11 72.2 0 154 38 543 581 WP_077370672.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Flavobacterium sp. A45] diamond 861 63.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. A45
31356911 31356911 PRJNA554794_P_NODE_21236_length_183_cov_0.589552_g17307_i0 PRJNA554794 21236 183 0.589552 1.07888016 Pseudomonadati 3379134 Bacteria Bacteria 45.8 0.00144   NR MEX0275484.1 1871037 g17307 i0 43.6 2.62295081967213 55 31 90.2 0 4 168 2662 2716 MEX0275484.1 PKD domain-containing protein [Flavobacteriaceae bacterium] diamond 480 45.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
31451821 31451821 PRJNA554794_P_NODE_22656_length_167_cov_0.864407_g18727_i0 PRJNA554794 22656 167 0.864407 1.44355969 Bacteria 2 Bacteria Bacteria 100 5.94e-23   NR MBC7485868.1 2026729 g18727 i0 89.1 2.96407185628743 55 6 98.8 0 2 166 332 386 MBC7485868.1 efflux RND transporter permease subunit [Cytophagaceae bacterium] diamond 495 100 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae   Cytophagaceae bacterium
31862669 31862669 PRJNA554794_P_NODE_23457_length_164_cov_0.886957_g19528_i0 PRJNA554794 23457 164 0.886957 1.45460948 Bacteroidota 976 Bacteria Bacteria 81.6 2.46e-16   NR WP_334246817.1 466084 g19528 i0 72.2 7.84756097560976 54 14 97 1 161 3 324 377 WP_334246817.1 fibronectin type III domain-containing protein [Limibacter armeniacum] diamond 1287 81.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flammeovirgaceae Limibacter Limibacter armeniacum
31974840 31974840 PRJNA554794_P_NODE_23818_length_163_cov_0.894737_g19889_i0 PRJNA554794 23818 163 0.894737 1.45842131 Bacteroidales bacterium KA 2030927 Bacteria Bacteria 105 5.02e-25   NR KXB35439.1 1497953 g19889 i0 100 0.975460122699387 53 0 97.5 0 3 161 263 315 KXB35439.1 peptidase Do [Bacteroidales bacterium KA00251] diamond 159 105 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium KA00251

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);;