RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA661142" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 26 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA661142 · 26 ✖

analysis 1

  • diamond · 26 ✖
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
8281346 8281346 PRJNA661142_P_NODE_5327_length_336_cov_3.198606_g5262_i0 PRJNA661142 5327 336 3.198606 10.74731616 Cytophagaceae bacterium 2026729 Bacteria Bacteria 117 9.66e-28   NR MCY7349550.1 2026729 g5262 i0 86.6 0.598214285714286 67 9 59.8 0 203 3 1 67 MCY7349550.1 DNA-directed RNA polymerase subunit beta [Cytophagaceae bacterium] diamond 201 117 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae   Cytophagaceae bacterium
14657068 14657068 PRJNA661142_P_NODE_12812_length_161_cov_0.901786_g12747_i0 PRJNA661142 12812 161 0.901786 1.45187546 Pseudomonadati 3379134 Bacteria Bacteria 95.9 3.2299999999999997e-24   NR MBN2862707.1 2030927 g12747 i0 100 3.65217391304348 49 0 91.3 0 2 148 46 94 MBN2862707.1 sigma-70 family RNA polymerase sigma factor [Bacteroidales bacterium] diamond 588 95.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
15930958 15930958 PRJNA661142_P_NODE_11813_length_165_cov_0.879310_g11748_i0 PRJNA661142 11813 165 0.87931 1.4508615 Mariniphaga 1573806 Bacteria Bacteria 108 1.14e-25   NR WP_073002820.1 1484053 g11748 i0 79.6 7.85454545454545 54 11 98.2 0 2 163 157 210 WP_073002820.1 S9 family peptidase [Mariniphaga anaerophila] diamond 1296 109 0.990825688073395 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Marinilabiliales Prolixibacteraceae Mariniphaga Mariniphaga anaerophila
17206145 17206145 PRJNA661142_P_NODE_2874_length_464_cov_32.091566_g2811_i0 PRJNA661142 2874 464 32.091566 148.90486624 Cytophagaceae bacterium 2026729 Bacteria Bacteria 238 4.34e-76   NR MCY7349237.1 2026729 g2811 i0 80 1.92025862068966 145 29 93.8 0 30 464 126 270 MCY7349237.1 DUF58 domain-containing protein [Cytophagaceae bacterium] diamond 891 238 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae   Cytophagaceae bacterium
20288235 20288235 PRJNA661142_P_NODE_9276_length_234_cov_1.654054_g9211_i0 PRJNA661142 9276 234 1.654054 3.87048636 Flavobacterium sp. 239 Bacteria Bacteria 119 4.03e-32   NR WP_291275097.1 239 g9211 i0 100 0.769230769230769 60 0 76.9 0 31 210 97 156 WP_291275097.1 hypothetical protein [Flavobacterium sp.] diamond 180 119 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
27334442 27334442 PRJNA661142_P_NODE_12563_length_162_cov_0.902655_g12498_i0 PRJNA661142 12563 162 0.902655 1.4623011 Bacteroidales bacterium 2030927 Bacteria Bacteria 114 7.48e-28   NR MBK7713321.1 2030927 g12498 i0 98.1 0.981481481481482 53 1 98.1 0 3 161 377 429 MBK7713321.1 GH92 family glycosyl hydrolase [Bacteroidales bacterium] diamond 159 114 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27997512 27997512 PRJNA661142_P_NODE_11405_length_167_cov_0.864407_g11340_i0 PRJNA661142 11405 167 0.864407 1.44355969 Bacteroidales bacterium 2030927 Bacteria Bacteria 111 1.51e-27   NR MFN8207644.1 2030927 g11340 i0 94.5 1.97604790419162 55 3 98.8 0 166 2 42 96 MFN8207644.1 hydrogenase small subunit [Bacteroidales bacterium] diamond 330 111 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
28072633 28072633 PRJNA661142_P_NODE_11485_length_167_cov_0.864407_g11420_i0 PRJNA661142 11485 167 0.864407 1.44355969 Bacteria 2 Bacteria Bacteria 88.6 9.38e-19   NR MDP4224471.1 1898104 g11420 i0 81.8 2.96407185628743 55 10 98.8 0 165 1 455 509 MDP4224471.1 fumarate reductase/succinate dehydrogenase flavoprotein subunit [Bacteroidota bacterium] diamond 495 89.4 0.991051454138702 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28092053 28092053 PRJNA661142_P_NODE_11505_length_167_cov_0.864407_g11440_i0 PRJNA661142 11505 167 0.864407 1.44355969 Bacteroidales bacterium 2030927 Bacteria Bacteria 84.7 6.86e-18   NR HVN57689.1 2030927 g11440 i0 67.3 2.92814371257485 55 18 98.8 0 167 3 133 187 HVN57689.1 glycosyltransferase family 2 protein [Bacteroidales bacterium] diamond 489 84.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
28629059 28629059 PRJNA661142_P_NODE_2347_length_514_cov_19.406452_g2284_i0 PRJNA661142 2347 514 19.406452 99.74916328 Prevotellaceae bacterium 2049047 Bacteria Bacteria 299 3.2e-101   NR MDO4195568.1 2049047 g2284 i0 98.6 0.840466926070039 144 2 84 0 31 462 58 201 MDO4195568.1 peptidoglycan editing factor PgeF [Prevotellaceae bacterium] diamond 432 299 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae   Prevotellaceae bacterium
28692216 28692216 PRJNA661142_P_NODE_11047_length_181_cov_1.159091_g10982_i0 PRJNA661142 11047 181 1.159091 2.09795471 Tenuifilaceae bacterium 2952975 Bacteria Bacteria 110 6.63e-29   NR HPX06961.1 2952975 g10982 i0 84.7 0.977900552486188 59 9 97.8 0 3 179 33 91 HPX06961.1 helix-turn-helix domain-containing protein [Tenuifilaceae bacterium] diamond 177 110 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Tenuifilaceae   Tenuifilaceae bacterium
28944882 28944882 PRJNA661142_P_NODE_11388_length_167_cov_0.864407_g11323_i0 PRJNA661142 11388 167 0.864407 1.44355969 Bacteroidota bacterium 1898104 Bacteria Bacteria 77 1.08e-14   NR MDP4207277.1 1898104 g11323 i0 63.8 3 58 18 98.8 1 3 167 21 78 MDP4207277.1 restriction endonuclease subunit S [Bacteroidota bacterium] diamond 501 77 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29134249 29134249 PRJNA661142_P_NODE_7989_length_266_cov_2.350230_g7924_i0 PRJNA661142 7989 266 2.35023 6.2516118 Alloprevotella sp. oral taxon 473 712469 Bacteria Bacteria 181 6.629999999999999e-52   NR WP_009437093.1 712469 g7924 i0 96.6 0.992481203007519 88 3 99.2 0 266 3 358 445 WP_009437093.1 biosynthetic arginine decarboxylase [Alloprevotella sp. oral taxon 473] diamond 264 181 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Alloprevotella Alloprevotella sp. oral taxon 473
29165821 29165821 PRJNA661142_P_NODE_11889_length_165_cov_0.879310_g11824_i0 PRJNA661142 11889 165 0.87931 1.4508615 Chryseobacterium lacus 2058346 Bacteria Bacteria 107 8.07e-27   NR WP_114303105.1 2058346 g11824 i0 100 0.981818181818182 54 0 98.2 0 2 163 111 164 WP_114303105.1 enoyl-CoA hydratase/isomerase family protein [Chryseobacterium lacus] diamond 162 107 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium lacus
29418068 29418068 PRJNA661142_P_NODE_6289_length_306_cov_2.381323_g6224_i0 PRJNA661142 6289 306 2.381323 7.28684838 Salinivirgaceae bacterium 2053305 Bacteria Bacteria 56.6 3.79e-8   NR MFO7863651.1 2053305 g6224 i0 85.3 0.333333333333333 34 5 33.3 0 125 226 40 73 MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium] diamond 102 56.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Salinivirgaceae   Salinivirgaceae bacterium
29575823 29575823 PRJNA661142_P_NODE_12410_length_162_cov_0.902655_g12345_i0 PRJNA661142 12410 162 0.902655 1.4623011 Bacteroidia bacterium 2044936 Bacteria Bacteria 81.6 2.37e-16   NR MCX6259887.1 2044936 g12345 i0 72.2 4 54 15 100 0 1 162 227 280 MCX6259887.1 SLC13 family permease [Bacteroidia bacterium] diamond 648 81.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
29860215 29860215 PRJNA661142_P_NODE_3731_length_406_cov_22.352941_g3667_i0 PRJNA661142 3731 406 22.352941 90.75294046 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 58.2 3.3e-7   NR MDX1470936.1 1871037 g3667 i0 32.1 2.96305418719212 137 80 95.3 5 6 392 65 196 MDX1470936.1 hypothetical protein [Flavobacteriaceae bacterium] diamond 1203 58.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
30144239 30144239 PRJNA661142_P_NODE_11472_length_167_cov_0.864407_g11407_i0 PRJNA661142 11472 167 0.864407 1.44355969 Bacteroidota bacterium 1898104 Bacteria Bacteria 54.3 1.09e-6   NR MEI6684414.1 1898104 g11407 i0 41.8 2.91017964071856 55 32 98.8 0 3 167 63 117 MEI6684414.1 HAMP domain-containing sensor histidine kinase [Bacteroidota bacterium] diamond 486 54.3 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30366157 30366157 PRJNA661142_P_NODE_3732_length_406_cov_11.596639_g3668_i0 PRJNA661142 3732 406 11.596639 47.08235434 Sphingobacteriales bacterium 2044944 Bacteria Bacteria 264 8.599999999999998e-82   NR RYD51931.1 2044944 g3668 i0 96.3 0.990147783251232 134 5 99 0 404 3 142 275 RYD51931.1 MAG: PASTA domain-containing protein [Sphingobacteriales bacterium] diamond 402 264 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales     Sphingobacteriales bacterium
30429349 30429349 PRJNA661142_P_NODE_9373_length_232_cov_0.836066_g9308_i0 PRJNA661142 9373 232 0.836066 1.93967312 Sphingobacteriia bacterium 2035813 Bacteria Bacteria 71.6 1.74e-12   NR NCA73025.1 2035813 g9308 i0 50.7 0.969827586206897 75 35 94.4 1 228 10 111 185 NCA73025.1 hypothetical protein [Sphingobacteriia bacterium] diamond 225 71.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia       Sphingobacteriia bacterium
31218448 31218448 PRJNA661142_P_NODE_2795_length_472_cov_32.262411_g2732_i0 PRJNA661142 2795 472 32.262411 152.27857992 Flavobacterium arcticum 1784713 Bacteria Bacteria 87.4 1.18e-16   NR WP_114678018.1 1784713 g2732 i0 48.4 0.591101694915254 93 45 57.2 1 1 270 12 104 WP_114678018.1 T9SS type A sorting domain-containing protein [Flavobacterium arcticum] diamond 279 87.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium arcticum
31472060 31472060 PRJNA661142_P_NODE_9576_length_226_cov_1.440678_g9511_i0 PRJNA661142 9576 226 1.440678 3.25593228 Flavobacterium sp. 239 Bacteria Bacteria 168 1.91e-50   NR WP_374552115.1 239 g9511 i0 98.7 0.995575221238938 75 1 99.6 0 1 225 62 136 WP_374552115.1 DNA-methyltransferase [Flavobacterium sp.] diamond 225 168 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
31503668 31503668 PRJNA661142_P_NODE_10936_length_185_cov_1.500000_g10871_i0 PRJNA661142 10936 185 1.5 2.775 Chryseobacterium oryzae 2929799 Bacteria Bacteria 95.9 3.3e-21   NR WP_243576690.1 2929799 g10871 i0 73.8 0.989189189189189 61 16 98.9 0 183 1 1071 1131 WP_243576690.1 translocation/assembly module TamB domain-containing protein [Chryseobacterium oryzae] diamond 183 95.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium oryzae
31819698 31819698 PRJNA661142_P_NODE_5937_length_316_cov_4.228464_g5872_i0 PRJNA661142 5937 316 4.228464 13.36194624 Bacteroidota bacterium 1898104 Bacteria Bacteria 187 3.7599999999999986e-55   NR MBU1821030.1 1898104 g5872 i0 92.3 0.987341772151899 104 8 98.7 0 3 314 334 437 MBU1821030.1 RagB/SusD family nutrient uptake outer membrane protein [Bacteroidota bacterium] diamond 312 187 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31977929 31977929 PRJNA661142_P_NODE_11618_length_166_cov_0.871795_g11553_i0 PRJNA661142 11618 166 0.871795 1.4471797 Bacteroidales bacterium 2030927 Bacteria Bacteria 82.4 1.38e-16   NR MDY0099278.1 2030927 g11553 i0 68.5 1.89759036144578 54 17 97.6 0 5 166 769 822 MDY0099278.1 DUF5107 domain-containing protein [Bacteroidales bacterium] diamond 315 82.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
32704934 32704934 PRJNA661142_P_NODE_12220_length_163_cov_0.894737_g12155_i0 PRJNA661142 12220 163 0.894737 1.45842131 Bacteroidota bacterium 1898104 Bacteria Bacteria 101 1.68e-23   NR MDP4223160.1 1898104 g12155 i0 92.6 0.993865030674847 54 4 99.4 0 1 162 212 265 MDP4223160.1 RagB/SusD family nutrient uptake outer membrane protein [Bacteroidota bacterium] diamond 162 101 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota 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);;