RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1111448" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1111448 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
4044387 4044387 PRJNA1111448_S_NODE_129884_length_246_cov_0.890173_g129061_i0 PRJNA1111448 129884 246 0.890173 2.18982558 Bacteroidota bacterium 1898104 Bacteria Bacteria 103 2.0499999999999999e-23   NR MES2763100.1 1898104 g129061 i0 83.3 2.92682926829268 60 10 73.2 0 66 245 93 152 MES2763100.1 penicillin-binding protein 1C [Bacteroidota bacterium] diamond 720 103 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
11226373 11226373 PRJNA1111448_S_NODE_84429_length_290_cov_1.419355_g83606_i0 PRJNA1111448 84429 290 1.419355 4.1161295 Pseudomonadati 3379134 Bacteria Bacteria 181 2.83e-53   NR MFM8280804.1 1898104 g83606 i0 89.6 5.95862068965517 96 10 99.3 0 3 290 284 379 MFM8280804.1 elongation factor Tu [Bacteroidota bacterium] diamond 1728 181 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
23170398 23170398 PRJNA1111448_S_NODE_52739_length_342_cov_1.412639_g51916_i0 PRJNA1111448 52739 342 1.412639 4.83122538 Bacteroidota bacterium 1898104 Bacteria Bacteria 181 6.36e-57   NR MFO0467982.1 1898104 g51916 i0 92.7 0.842105263157895 96 7 84.2 0 2 289 4 99 MFO0467982.1 ADP-ribosylation factor-like protein [Bacteroidota bacterium] diamond 288 181 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
24443370 24443370 PRJNA1111448_S_NODE_112760_length_258_cov_1.664865_g111937_i0 PRJNA1111448 112760 258 1.664865 4.2953517 Luteibaculaceae bacterium 3050382 Bacteria Bacteria 169 1.04e-48   NR HEX4887269.1 3050382 g111937 i0 94.1 0.988372093023256 85 5 98.8 0 256 2 222 306 HEX4887269.1 beta-ketoacyl-ACP synthase II [Luteibaculaceae bacterium] diamond 255 169 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Luteibaculaceae   Luteibaculaceae bacterium
26750957 26750957 PRJNA1111448_S_NODE_82341_length_293_cov_1.000000_g81518_i0 PRJNA1111448 82341 293 1 2.93 Bacteroidales bacterium 2030927 Bacteria Bacteria 42 0.0287   NR MFN8255617.1 2030927 g81518 i0 35.4 0.665529010238908 65 31 61.4 2 36 215 19 77 MFN8255617.1 thioredoxin [Bacteroidales bacterium] diamond 195 42 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27130625 27130625 PRJNA1111448_S_NODE_37742_length_381_cov_1.746753_g36919_i0 PRJNA1111448 37742 381 1.746753 6.65512893 Bacteroidota bacterium 1898104 Bacteria Bacteria 187 5.06e-56   NR MFO0468276.1 1898104 g36919 i0 74.1 0.913385826771654 116 27 89 1 379 41 233 348 MFO0468276.1 fatty acid desaturase [Bacteroidota bacterium] diamond 348 187 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27478629 27478629 PRJNA1111448_S_NODE_138263_length_241_cov_1.636905_g137440_i0 PRJNA1111448 138263 241 1.636905 3.94494105 Bacteroidota bacterium 1898104 Bacteria Bacteria 41.6 0.0442   NR TAE16050.1 1898104 g137440 i0 57.9 0.473029045643154 38 16 47.3 0 114 1 81 118 TAE16050.1 MAG: hypothetical protein EAZ95_08090 [Bacteroidota bacterium] diamond 114 41.6 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27975010 27975010 PRJNA1111448_S_NODE_107825_length_263_cov_1.621053_g107002_i0 PRJNA1111448 107825 263 1.621053 4.26336939 Bacteria 2 Bacteria Bacteria 102 4.9199999999999987e-23   NR MBI1224913.1 1898104 g107002 i0 59.7 2.4638783269962 72 29 82.1 0 48 263 340 411 MBI1224913.1 PAS domain S-box protein [Bacteroidota bacterium] diamond 648 102 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28267815 28267815 PRJNA1111448_S_NODE_122726_length_250_cov_0.870056_g121903_i0 PRJNA1111448 122726 250 0.870056 2.17514 Flavobacterium sp. 239 Bacteria Bacteria 157 1.19e-44   NR WP_374542739.1 239 g121903 i0 98.8 0.984 82 1 98.4 0 248 3 161 242 WP_374542739.1 N-acetylmuramoyl-L-alanine amidase family protein [Flavobacterium sp.] diamond 246 157 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
29183811 29183811 PRJNA1111448_S_NODE_132789_length_244_cov_1.350877_g131966_i0 PRJNA1111448 132789 244 1.350877 3.29613988 Bacteroidota bacterium 1898104 Bacteria Bacteria 65.1 4.96e-10   NR MEM6286920.1 1898104 g131966 i0 80 0.860655737704918 35 7 43 0 140 244 396 430 MEM6286920.1 S41 family peptidase [Bacteroidota bacterium] diamond 210 65.1 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29562391 29562391 PRJNA1111448_S_NODE_100610_length_271_cov_1.166667_g99787_i0 PRJNA1111448 100610 271 1.166667 3.16166757 Bacteroidia bacterium 2044936 Bacteria Bacteria 49.7 1.91e-4   NR MBX7240925.1 2044936 g99787 i0 43.8 0.531365313653137 48 27 53.1 0 192 49 463 510 MBX7240925.1 M48 family metallopeptidase [Bacteroidia bacterium] diamond 144 49.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
29562397 29562397 PRJNA1111448_S_NODE_74950_length_303_cov_1.208696_g74127_i0 PRJNA1111448 74950 303 1.208696 3.66234888 Bacteroidota bacterium 1898104 Bacteria Bacteria 166 3.13e-46   NR MBS1611375.1 1898104 g74127 i0 82 2.97029702970297 100 18 99 0 302 3 487 586 MBS1611375.1 acyl-CoA dehydrogenase [Bacteroidota bacterium] diamond 900 166 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29679698 29679698 PRJNA1111448_S_NODE_127950_length_247_cov_0.885057_g127127_i0 PRJNA1111448 127950 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 43.5 0.0189   NR WP_026994825.1 103 g127127 i0 51.1 1.05668016194332 45 18 49.8 1 230 108 79 123 WP_026994825.1 ABC transporter permease [Flectobacillus major] diamond 261 43.9 0.990888382687927 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus major
30099271 30099271 PRJNA1111448_S_NODE_115952_length_255_cov_1.516484_g115129_i0 PRJNA1111448 115952 255 1.516484 3.8670342 Saprospiraceae bacterium 2202734 Bacteria Bacteria 53.1 9.44e-6   NR MCH2043036.1 2202734 g115129 i0 32.1 0.988235294117647 84 54 98.8 2 2 253 1150 1230 MCH2043036.1 C25 family cysteine peptidase [Saprospiraceae bacterium] diamond 252 53.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
30321150 30321150 PRJNA1111448_S_NODE_49592_length_349_cov_1.260870_g48769_i0 PRJNA1111448 49592 349 1.26087 4.4004363 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 173 9.56e-52   NR MBE2231404.1 1869212 g48769 i0 68.9 4.55587392550143 106 33 91.1 0 347 30 138 243 MBE2231404.1 serine/threonine protein phosphatase [Chitinophagaceae bacterium] diamond 1590 173 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
30943852 30943852 PRJNA1111448_S_NODE_122974_length_250_cov_0.870056_g122151_i0 PRJNA1111448 122974 250 0.870056 2.17514 Cytophagales 768507 Bacteria Bacteria 128 2.69e-35   NR MES2629295.1 1898104 g122151 i0 85.9 5.184 71 10 85.2 0 234 22 126 196 MES2629295.1 nucleoside triphosphate pyrophosphohydrolase [Bacteroidota bacterium] diamond 1296 129 0.992248062015504 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31426636 31426636 PRJNA1111448_S_NODE_124516_length_249_cov_0.875000_g123693_i0 PRJNA1111448 124516 249 0.875 2.17875 Luteibaculaceae bacterium 3050382 Bacteria Bacteria 144 1.2899999999999999e-38   NR HEX4887775.1 3050382 g123693 i0 78.3 2.02409638554217 83 18 100 0 1 249 168 250 HEX4887775.1 signal peptidase I [Luteibaculaceae bacterium] diamond 504 144 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Luteibaculaceae   Luteibaculaceae bacterium
31616420 31616420 PRJNA1111448_S_NODE_138056_length_241_cov_2.071429_g137233_i0 PRJNA1111448 138056 241 2.071429 4.99214389 Bacteroidia bacterium 2044936 Bacteria Bacteria 53.9 2.3e-6   NR MCX6335279.1 2044936 g137233 i0 44.4 0.672199170124481 54 28 67.2 1 239 78 162 213 MCX6335279.1 carbonic anhydrase [Bacteroidia bacterium] diamond 162 53.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
31679562 31679562 PRJNA1111448_S_NODE_104417_length_267_cov_1.108247_g103594_i0 PRJNA1111448 104417 267 1.108247 2.95901949 Bacteroidota bacterium 1898104 Bacteria Bacteria 54.7 3.18e-6   NR MEM8964820.1 1898104 g103594 i0 38.2 0.764044943820225 68 42 76.4 0 29 232 1058 1125 MEM8964820.1 Ig-like domain-containing protein [Bacteroidota bacterium] diamond 204 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31679563 31679563 PRJNA1111448_S_NODE_107337_length_264_cov_0.905759_g106514_i0 PRJNA1111448 107337 264 0.905759 2.39120376 Aridibaculum aurantiacum 2810307 Bacteria Bacteria 43.9 0.0186   NR WP_207493178.1 2810307 g106514 i0 35.8 0.602272727272727 53 29 60.2 1 256 98 307 354 WP_207493178.1 Piwi domain-containing protein [Aridibaculum aurantiacum] diamond 159 43.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Aridibaculum Aridibaculum aurantiacum
31711352 31711352 PRJNA1111448_S_NODE_62677_length_323_cov_1.088000_g61854_i0 PRJNA1111448 62677 323 1.088 3.51424 Sphingobacteriales bacterium 2044944 Bacteria Bacteria 146 4.4e-41   NR MCF8283611.1 2044944 g61854 i0 61.7 2.97213622291022 107 41 99.4 0 1 321 103 209 MCF8283611.1 LexA family transcriptional regulator [Sphingobacteriales bacterium] diamond 960 146 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales     Sphingobacteriales bacterium
32154297 32154297 PRJNA1111448_S_NODE_131598_length_245_cov_0.895349_g130775_i0 PRJNA1111448 131598 245 0.895349 2.19360505 Bacteroidia bacterium 2044936 Bacteria Bacteria 78.6 8.92e-15   NR MFN8144008.1 2044936 g130775 i0 49.4 3.93061224489796 77 39 94.3 0 15 245 93 169 MFN8144008.1 T9SS type A sorting domain-containing protein [Bacteroidia bacterium] diamond 963 78.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
32817456 32817456 PRJNA1111448_S_NODE_59700_length_328_cov_1.788235_g58877_i0 PRJNA1111448 59700 328 1.788235 5.8654108 Sediminibacterium sp. 1917865 Bacteria Bacteria 145 3.56e-43   NR MDI9339833.1 1917865 g58877 i0 95.1 0.75 82 4 75 0 247 2 1 82 MDI9339833.1 hypothetical protein [Sediminibacterium sp.] diamond 246 145 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Sediminibacterium Sediminibacterium sp.

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