RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA881257" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA881257 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
23810807 23810807 PRJNA881257_P_NODE_16559_length_165_cov_0.896552_g16314_i0 PRJNA881257 16559 165 0.896552 1.4793108 Flavobacterium proteolyticum 2911683 Bacteria Bacteria 104 1.3299999999999999e-24   NR WP_194096597.1 2911683 g16314 i0 96.3 1.96363636363636 54 2 98.2 0 164 3 128 181 WP_194096597.1 DEAD/DEAH box helicase [Flavobacterium proteolyticum] diamond 324 104 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium proteolyticum
26897271 26897271 PRJNA881257_P_NODE_14561_length_169_cov_0.866667_g14316_i0 PRJNA881257 14561 169 0.866667 1.46466723 Porphyromonas sp. COT-29 1924944 Bacteria Bacteria 122 4.32e-31   NR WP_044231637.1 1515617 g14316 i0 100 0.994082840236686 56 0 99.4 0 2 169 41 96 WP_044231637.1 glycoside hydrolase family 10 protein [Porphyromonas sp. COT-290 OH3588] diamond 168 122 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas sp. COT-290 OH3588
27339940 27339940 PRJNA881257_P_NODE_18263_length_162_cov_0.920354_g18018_i0 PRJNA881257 18263 162 0.920354 1.49097348 Flavobacterium rivuli 498301 Bacteria Bacteria 93.6 3.3800000000000003e-21   NR WP_020213169.1 498301 g18018 i0 81.1 0.981481481481482 53 10 98.1 0 160 2 174 226 WP_020213169.1 DUF3078 domain-containing protein [Flavobacterium rivuli] diamond 159 93.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium rivuli
27434772 27434772 PRJNA881257_P_NODE_16123_length_166_cov_0.888889_g15878_i0 PRJNA881257 16123 166 0.888889 1.47555574 Bacteroidota bacterium 1898104 Bacteria Bacteria 54.7 2.52e-8   NR MES2240467.1 1898104 g15878 i0 54.9 0.921686746987952 51 23 92.2 0 164 12 1 51 MES2240467.1 hypothetical protein [Bacteroidota bacterium] diamond 153 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27466287 27466287 PRJNA881257_P_NODE_13803_length_171_cov_1.704918_g13558_i0 PRJNA881257 13803 171 1.704918 2.91540978 Hydrobacter penzbergensis 1235997 Bacteria Bacteria 125 7.169999999999999e-32   NR WP_092723735.1 1235997 g13558 i0 100 0.982456140350877 56 0 98.2 0 169 2 462 517 WP_092723735.1 S9 family peptidase [Hydrobacter penzbergensis] diamond 168 125 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Hydrobacter Hydrobacter penzbergensis
27497794 27497794 PRJNA881257_P_NODE_13823_length_171_cov_1.672131_g13578_i0 PRJNA881257 13823 171 1.672131 2.85934401 Asinibacterium sp. OR53 925409 Bacteria Bacteria 118 5.9399999999999995e-30   NR WP_037360596.1 925409 g13578 i0 100 1 57 0 100 0 171 1 226 282 WP_037360596.1 hypothetical protein [Asinibacterium sp. OR53] diamond 171 118 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Asinibacterium Asinibacterium sp. OR53
27979310 27979310 PRJNA881257_P_NODE_16825_length_164_cov_0.904348_g16580_i0 PRJNA881257 16825 164 0.904348 1.48313072 Prevotellaceae 171552 Bacteria Bacteria 104 5.48e-25   NR WP_412305605.1 28127 g16580 i0 98 2.79878048780488 51 1 93.3 0 163 11 338 388 WP_412305605.1 HAD-IIIA family hydrolase [Hoylesella buccalis] diamond 459 104 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Hoylesella Hoylesella buccalis
28097559 28097559 PRJNA881257_P_NODE_10305_length_206_cov_1.140127_g10060_i0 PRJNA881257 10305 206 1.140127 2.34866162 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 65.1 3e-10   NR MAR43667.1 1871037 g10060 i0 51.6 0.902912621359223 62 28 90.3 1 7 192 363 422 MAR43667.1 acetate--CoA ligase [Flavobacteriaceae bacterium] diamond 186 65.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
28286851 28286851 PRJNA881257_P_NODE_14366_length_169_cov_0.866667_g14121_i0 PRJNA881257 14366 169 0.866667 1.46466723 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 120 2.3099999999999997e-31   NR MCA6440422.1 1869212 g14121 i0 100 0.994082840236686 56 0 99.4 0 1 168 166 221 MCA6440422.1 hypothetical protein [Chitinophagaceae bacterium] diamond 168 120 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
28792072 28792072 PRJNA881257_P_NODE_16567_length_165_cov_0.896552_g16322_i0 PRJNA881257 16567 165 0.896552 1.4793108 Bacteroidales bacterium Barb4 1633200 Bacteria Bacteria 107 8.94e-26   NR OAV67094.1 1633200 g16322 i0 100 0.981818181818182 54 0 98.2 0 3 164 159 212 OAV67094.1 Replicative DNA helicase [Bacteroidales bacterium Barb4] diamond 162 107 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium Barb4
28823518 28823518 PRJNA881257_P_NODE_15508_length_167_cov_0.881356_g15263_i0 PRJNA881257 15508 167 0.881356 1.47186452 Bacteroidota bacterium 1898104 Bacteria Bacteria 42.7 0.0132   NR NBC09905.1 1898104 g15263 i0 36.5 0.934131736526946 52 32 91.6 1 156 4 238 289 NBC09905.1 SDR family NAD(P)-dependent oxidoreductase [Bacteroidota bacterium] diamond 156 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28894808 28894808 PRJNA881257_P_NODE_12028_length_187_cov_1.485507_g11783_i0 PRJNA881257 12028 187 1.485507 2.77789809 Bacteroidota 976 Bacteria Bacteria 97.4 4.6e-25   NR WP_009085751.1 308865 g11783 i0 90.6 15.3048128342246 53 5 85 0 186 28 8 60 WP_009085751.1 MULTISPECIES: 50S ribosomal protein L33 [Elizabethkingia] diamond 2862 97.8 0.995910020449898 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Elizabethkingia  
29202842 29202842 PRJNA881257_P_NODE_8609_length_234_cov_0.843243_g8364_i0 PRJNA881257 8609 234 0.843243 1.97318862 Bacteroidota bacterium 1898104 Bacteria Bacteria 60.1 2.54e-8   NR MEY3159670.1 1898104 g8364 i0 62.5 0.512820512820513 40 15 51.3 0 229 110 208 247 MEY3159670.1 hypothetical protein [Bacteroidota bacterium] diamond 120 60.1 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29265655 29265655 PRJNA881257_P_NODE_14529_length_169_cov_0.866667_g14284_i0 PRJNA881257 14529 169 0.866667 1.46466723 Hydrobacter penzbergensis 1235997 Bacteria Bacteria 117 6.849999999999999e-31   NR WP_092724452.1 1235997 g14284 i0 100 0.994082840236686 56 0 99.4 0 168 1 28 83 WP_092724452.1 DUF3823 domain-containing protein [Hydrobacter penzbergensis] diamond 168 117 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Hydrobacter Hydrobacter penzbergensis
29265660 29265660 PRJNA881257_P_NODE_18249_length_162_cov_0.920354_g18004_i0 PRJNA881257 18249 162 0.920354 1.49097348 Cloacibacterium sp. 1913682 Bacteria Bacteria 44.7 2.65e-4   NR WP_374365004.1 1913682 g18004 i0 56.9 0.944444444444444 51 18 94.4 2 160 8 1 47 WP_374365004.1 hypothetical protein [Cloacibacterium sp.] diamond 153 44.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium sp.
29960515 29960515 PRJNA881257_P_NODE_16731_length_164_cov_1.626087_g16486_i0 PRJNA881257 16731 164 1.626087 2.66678268 Asinibacterium sp. OR53 925409 Bacteria Bacteria 87.8 1.68e-18   NR WP_026769508.1 925409 g16486 i0 100 1.84756097560976 50 0 91.5 0 13 162 57 106 WP_026769508.1 bifunctional SulP family inorganic anion transporter/carbonic anhydrase [Asinibacterium sp. OR53] diamond 303 87.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Asinibacterium Asinibacterium sp. OR53
30023904 30023904 PRJNA881257_P_NODE_14431_length_169_cov_0.866667_g14186_i0 PRJNA881257 14431 169 0.866667 1.46466723 Chryseobacterium herbae 2976476 Bacteria Bacteria 116 2.95e-30   NR WP_259841809.1 2976476 g14186 i0 96.4 5.96449704142012 56 2 99.4 0 2 169 194 249 WP_259841809.1 IS256 family transposase, variant Zn-binding type [Chryseobacterium herbae] diamond 1008 116 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium herbae
30592349 30592349 PRJNA881257_P_NODE_16513_length_165_cov_0.896552_g16268_i0 PRJNA881257 16513 165 0.896552 1.4793108 Asinibacterium sp. OR53 925409 Bacteria Bacteria 104 1.88e-24   NR WP_026767867.1 925409 g16268 i0 92.6 0.981818181818182 54 4 98.2 0 163 2 230 283 WP_026767867.1 T9SS type A sorting domain-containing protein [Asinibacterium sp. OR53] diamond 162 104 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Asinibacterium Asinibacterium sp. OR53
30750505 30750505 PRJNA881257_P_NODE_16574_length_165_cov_0.896552_g16329_i0 PRJNA881257 16574 165 0.896552 1.4793108 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 99 2.01e-22   NR HRE37651.1 1869212 g16329 i0 88.9 0.981818181818182 54 6 98.2 0 163 2 645 698 HRE37651.1 metallophosphoesterase [Chitinophagaceae bacterium] diamond 162 99 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
30971727 30971727 PRJNA881257_P_NODE_17654_length_163_cov_0.912281_g17409_i0 PRJNA881257 17654 163 0.912281 1.48701803 Asinibacterium sp. OR53 925409 Bacteria Bacteria 102 6.45e-24   NR WP_084220424.1 925409 g17409 i0 100 1.98773006134969 54 0 99.4 0 2 163 121 174 WP_084220424.1 pyruvate kinase [Asinibacterium sp. OR53] diamond 324 102 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Asinibacterium Asinibacterium sp. OR53
31129203 31129203 PRJNA881257_P_NODE_15515_length_167_cov_0.881356_g15270_i0 PRJNA881257 15515 167 0.881356 1.47186452 Cloacibacterium sp. 1913682 Bacteria Bacteria 48.5 1.17e-4   NR WP_374363476.1 1913682 g15270 i0 100 0.431137724550898 24 0 43.1 0 1 72 118 141 WP_374363476.1 bile acid:sodium symporter family protein [Cloacibacterium sp.] diamond 72 48.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium sp.
31129204 31129204 PRJNA881257_P_NODE_17655_length_163_cov_0.912281_g17410_i0 PRJNA881257 17655 163 0.912281 1.48701803 Bacteroidales bacterium 2030927 Bacteria Bacteria 60.8 2.17e-9   NR MCE5331312.1 2030927 g17410 i0 65.3 0.901840490797546 49 17 90.2 0 1 147 22 70 MCE5331312.1 hemolysin III family protein [Bacteroidales bacterium] diamond 147 60.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
31224201 31224201 PRJNA881257_P_NODE_17735_length_163_cov_0.912281_g17490_i0 PRJNA881257 17735 163 0.912281 1.48701803 Bacteroides muris (ex Fokt et al. 2 2516960 Bacteria Bacteria 85.5 1.05e-17   NR WP_257940143.1 2937417 g17490 i0 77.8 0.993865030674847 54 12 99.4 0 1 162 428 481 WP_257940143.1 hypothetical protein [Bacteroides muris (ex Fokt et al. 2023)] diamond 162 85.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Bacteroides Bacteroides muris (ex Fokt et al. 2023)
31572483 31572483 PRJNA881257_P_NODE_14436_length_169_cov_0.866667_g14191_i0 PRJNA881257 14436 169 0.866667 1.46466723 Cytophagales bacterium 2053541 Bacteria Bacteria 48.5 1.27e-4   NR MBC7391555.1 2053541 g14191 i0 39.6 0.940828402366864 53 32 94.1 0 168 10 945 997 MBC7391555.1 hypothetical protein [Cytophagales bacterium] diamond 159 48.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales     Cytophagales bacterium
32110097 32110097 PRJNA881257_P_NODE_11458_length_192_cov_1.454545_g11213_i0 PRJNA881257 11458 192 1.454545 2.7927264 Bacteroidota bacterium 1898104 Bacteria Bacteria 125 7.55e-33   NR MEN9570866.1 1898104 g11213 i0 88.9 0.984375 63 7 98.4 0 2 190 29 91 MEN9570866.1 hypothetical protein [Bacteroidota bacterium] diamond 189 125 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32458294 32458294 PRJNA881257_P_NODE_699_length_1014_cov_2.317098_g559_i0 PRJNA881257 699 1014 2.317098 23.49537372 Bacteroidota bacterium 1898104 Bacteria Bacteria 67.4 3.58e-8   NR MEL0183846.1 1898104 g559 i0 48.8 0.707100591715976 80 34 23.7 2 351 112 662 734 MEL0183846.1 alanine--tRNA ligase [Bacteroidota bacterium] diamond 717 67.4 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32466374 32466374 PRJNA881257_P_NODE_15299_length_167_cov_0.881356_g15054_i0 PRJNA881257 15299 167 0.881356 1.47186452 Flavisolibacter 398041 Bacteria Bacteria 114 6.019999999999999e-28   NR WP_072833240.1 462367 g15054 i0 96.4 1.97604790419162 55 2 98.8 0 167 3 178 232 WP_072833240.1 phosphoenolpyruvate carboxylase [Flavisolibacter ginsengisoli] diamond 330 114 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Flavisolibacter Flavisolibacter ginsengisoli

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