RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1088503" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1088503 · 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
27478323 27478323 PRJNA1088503_P_NODE_10943_length_167_cov_2.471014_g10571_i0 PRJNA1088503 10943 167 2.471014 4.12659338 Bacteroidia bacterium 2044936 Bacteria Bacteria 108 1.53e-26   NR MFP5439710.1 2044936 g10571 i0 87.3 0.988023952095808 55 7 98.8 0 3 167 170 224 MFP5439710.1 WD40/YVTN/BNR-like repeat-containing protein [Bacteroidia bacterium] diamond 165 108 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
27510023 27510023 PRJNA1088503_P_NODE_9203_length_211_cov_58517.571429_g8831_i0 PRJNA1088503 9203 211 58517.571429 123472.07571519 Chryseobacterium sp. 1871047 Bacteria Bacteria 76.6 2.55e-14   NR MBO6200460.1 1871047 g8831 i0 88.6 1.25118483412322 44 5 62.6 0 80 211 26 69 MBO6200460.1 preprotein translocase subunit SecA [Chryseobacterium sp.] diamond 264 76.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium sp.
28109666 28109666 PRJNA1088503_P_NODE_5205_length_357_cov_2.012195_g4833_i0 PRJNA1088503 5205 357 2.012195 7.18353615 Sphingobacterium alkalisoli 1874115 Bacteria Bacteria 92.4 5.46e-19   NR WP_188876220.1 1874115 g4833 i0 79.3 0.487394957983193 58 12 48.7 0 355 182 1190 1247 WP_188876220.1 hypothetical protein [Sphingobacterium alkalisoli] diamond 174 92.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium alkalisoli
28267510 28267510 PRJNA1088503_P_NODE_9706_length_198_cov_56410.307692_g9334_i0 PRJNA1088503 9706 198 56410.307692 111692.40923016 Flavobacterium kayseriense 2764714 Bacteria Bacteria 92.8 4.350000000000001e-21   NR WP_187011251.1 2764714 g9334 i0 94.2 0.787878787878788 52 3 78.8 0 11 166 2 53 WP_187011251.1 Rossmann-like and DUF2520 domain-containing protein [Flavobacterium kayseriense] diamond 156 92.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium kayseriense
28615070 28615070 PRJNA1088503_P_NODE_7067_length_276_cov_43638.716599_g6695_i0 PRJNA1088503 7067 276 43638.716599 120442.85781324 Flavobacterium yafengii 3041253 Bacteria Bacteria 151 3.96e-40   NR WP_282731570.1 3041253 g6695 i0 93.8 2.64130434782609 81 5 88 0 276 34 395 475 WP_282731570.1 TonB-dependent receptor [Flavobacterium yafengii] diamond 729 151 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium yafengii
28709881 28709881 PRJNA1088503_P_NODE_10927_length_167_cov_1858.666667_g10555_i0 PRJNA1088503 10927 167 1858.666667 3103.97333389 Cloacibacterium normanense 237258 Bacteria Bacteria 90.5 1.98e-19   NR WP_104794462.1 237258 g10555 i0 97.8 0.826347305389222 46 1 82.6 0 140 3 868 913 WP_104794462.1 hypothetical protein [Cloacibacterium normanense] diamond 138 90.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium normanense
29341301 29341301 PRJNA1088503_P_NODE_11529_length_155_cov_1.634921_g11157_i0 PRJNA1088503 11529 155 1.634921 2.53412755 Flavobacterium rivuli 498301 Bacteria Bacteria 93.6 3.0600000000000003e-21   NR WP_035641797.1 498301 g11157 i0 88 2.92258064516129 50 6 96.8 0 1 150 135 184 WP_035641797.1 glycoside hydrolase family 43 protein [Flavobacterium rivuli] diamond 453 93.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium rivuli
29909723 29909723 PRJNA1088503_P_NODE_1891_length_669_cov_15001.240625_g1679_i0 PRJNA1088503 1891 669 15001.240625 100358.29978125 Flavobacterium sp. 239 Bacteria Bacteria 408 2.5e-142   NR MDO8316601.1 239 g1679 i0 94.9 0.959641255605381 214 11 96 0 644 3 43 256 MDO8316601.1 hypothetical protein [Flavobacterium sp.] diamond 642 408 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
30889046 30889046 PRJNA1088503_P_NODE_10714_length_172_cov_830.958042_g10342_i0 PRJNA1088503 10714 172 830.958042 1429.24783224 Cloacibacterium sp. 1913682 Bacteria Bacteria 60.1 2.1e-9   NR WP_374361274.1 1913682 g10342 i0 96.6 0.505813953488372 29 1 50.6 0 114 28 30 58 WP_374361274.1 lipocalin family protein [Cloacibacterium sp.] diamond 87 60.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium sp.
30983980 30983980 PRJNA1088503_P_NODE_7714_length_255_cov_1159.473451_g7342_i0 PRJNA1088503 7714 255 1159.473451 2956.65730005 Cloacibacterium sp. 1913682 Bacteria Bacteria 60.1 1.3e-9   NR MBP8085460.1 1913682 g7342 i0 86.7 0.352941176470588 30 4 35.3 0 210 121 40 69 MBP8085460.1 hypothetical protein [Cloacibacterium sp.] diamond 90 60.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium sp.
31394878 31394878 PRJNA1088503_P_NODE_11256_length_160_cov_2.351145_g10884_i0 PRJNA1088503 11256 160 2.351145 3.761832 Flavobacterium turcicum 2764718 Bacteria Bacteria 108 4.65e-26   NR WP_166137769.1 2764718 g10884 i0 98.1 0.975 52 1 97.5 0 3 158 100 151 WP_166137769.1 MauE/DoxX family redox-associated membrane protein [Flavobacterium turcicum] diamond 156 108 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium turcicum
31458138 31458138 PRJNA1088503_P_NODE_11816_length_150_cov_1.454545_g11444_i0 PRJNA1088503 11816 150 1.454545 2.1818175 Sphingobacteriaceae bacterium 2021370 Bacteria Bacteria 92 8.2e-21   NR MDF3077677.1 2021370 g11444 i0 88 3 50 6 100 0 150 1 136 185 MDF3077677.1 exo-alpha-sialidase [Sphingobacteriaceae bacterium] diamond 450 92 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae   Sphingobacteriaceae bacterium
31647603 31647603 PRJNA1088503_P_NODE_8777_length_222_cov_1223.761658_g8405_i0 PRJNA1088503 8777 222 1223.761658 2716.75088076 Segatella salivae 228604 Bacteria Bacteria 71.2 1.11e-14   NR MBF1530192.1 228604 g8405 i0 100 0.486486486486487 36 0 48.6 0 31 138 1 36 MBF1530192.1 thioredoxin [Segatella salivae] diamond 108 71.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Segatella Segatella salivae

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