RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA1218816" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 31 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1218816 · 31 ✖

analysis 1

  • diamond · 31 ✖
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
4874417 4874417 PRJNA1218816_P_NODE_61184_length_243_cov_0.905882_g60751_i0 PRJNA1218816 61184 243 0.905882 2.20129326 Bacteria 2 Bacteria Bacteria 170 2.56e-50   NR MCD6067675.1 1898104 g60751 i0 95.1 3 81 4 100 0 243 1 98 178 MCD6067675.1 short-chain dehydrogenase [Bacteroidota bacterium] diamond 729 171 0.994152046783626 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
7986817 7986817 PRJNA1218816_P_NODE_46507_length_277_cov_1.607843_g46074_i0 PRJNA1218816 46507 277 1.607843 4.45372511 Flavobacterium sp. H122 2529860 Bacteria Bacteria 66.2 3.43e-12   NR WP_136666713.1 2529860 g46074 i0 81 0.682310469314079 63 12 68.2 0 30 218 1 63 WP_136666713.1 hypothetical protein [Flavobacterium sp. H122] diamond 189 66.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. H122
7986958 7986958 PRJNA1218816_P_NODE_61067_length_243_cov_0.905882_g60634_i0 PRJNA1218816 61067 243 0.905882 2.20129326 Saprospiraceae bacterium 2202734 Bacteria Bacteria 144 3.1899999999999993e-40   NR MBL7817221.1 2202734 g60634 i0 89.9 0.975308641975309 79 8 97.5 0 238 2 128 206 MBL7817221.1 type I glyceraldehyde-3-phosphate dehydrogenase [Saprospiraceae bacterium] diamond 237 144 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
14362576 14362576 PRJNA1218816_P_NODE_60132_length_244_cov_0.900585_g59699_i0 PRJNA1218816 60132 244 0.900585 2.1974274 Flavobacterium sp. 9R 2653143 Bacteria Bacteria 170 4.46e-53   NR WP_159688278.1 2653143 g59699 i0 100 0.995901639344262 81 0 99.6 0 244 2 7 87 WP_159688278.1 single-stranded DNA-binding protein [Flavobacterium sp. 9R] diamond 243 170 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. 9R
18184953 18184953 PRJNA1218816_P_NODE_44375_length_286_cov_1.427230_g43942_i0 PRJNA1218816 44375 286 1.42723 4.0818778 Flavobacterium sp. NRK F7 2954930 Bacteria Bacteria 167 1.47e-49   NR WP_252764915.1 2954930 g43942 i0 98.9 0.986013986013986 94 1 98.6 0 284 3 10 103 WP_252764915.1 OmpA/MotB family protein [Flavobacterium sp. NRK F7] diamond 282 167 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. NRK F7
18185113 18185113 PRJNA1218816_P_NODE_59175_length_245_cov_0.895349_g58742_i0 PRJNA1218816 59175 245 0.895349 2.19360505 Pseudomonadati 3379134 Bacteria Bacteria 157 1.12e-42   NR HOY08203.1 2202734 g58742 i0 91.3 5.9265306122449 80 7 98 0 4 243 303 382 HOY08203.1 glycoside hydrolase family 127 protein [Saprospiraceae bacterium] diamond 1452 158 0.993670886075949 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
19459543 19459543 PRJNA1218816_P_NODE_57356_length_247_cov_0.885057_g56923_i0 PRJNA1218816 57356 247 0.885057 2.18609079 Seramator 2919400 Bacteria Bacteria 175 1.01e-52   NR HRS41172.1 2065189 g56923 i0 100 1.9919028340081 82 0 99.6 0 247 2 45 126 HRS41172.1 phosphoenolpyruvate carboxykinase (ATP) [Dysgonamonadaceae bacterium] diamond 492 175 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Dysgonomonadaceae   Dysgonamonadaceae bacterium
23998404 23998404 PRJNA1218816_P_NODE_61879_length_242_cov_0.911243_g61446_i0 PRJNA1218816 61879 242 0.911243 2.20520806 Prevotella sp. 59823 Bacteria Bacteria 162 7.129999999999998e-48   NR MBP7767491.1 59823 g61446 i0 100 0.991735537190083 80 0 99.2 0 240 1 157 236 MBP7767491.1 diaminopimelate epimerase [Prevotella sp.] diamond 240 162 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp.
24559722 24559722 PRJNA1218816_P_NODE_61300_length_243_cov_0.905882_g60867_i0 PRJNA1218816 61300 243 0.905882 2.20129326 Taibaiella sp. KBW1 1869185 Bacteria Bacteria 135 8.63e-38   NR WP_124635375.1 2153357 g60867 i0 76.3 3.95061728395062 80 19 98.8 0 242 3 36 115 WP_124635375.1 carbonic anhydrase family protein [Taibaiella sp. KBW10] diamond 960 135 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Taibaiella Taibaiella sp. KBW10
26742953 26742953 PRJNA1218816_P_NODE_47621_length_273_cov_0.985000_g47188_i0 PRJNA1218816 47621 273 0.985 2.68905 root 1 Root_unresolved Root_unresolved 95.1 7.200000000000001e-22   NR MDP2061423.1 1871037 g47188 i0 69.7 2.35164835164835 76 20 80.2 1 221 3 75 150 MDP2061423.1 30S ribosomal protein S8e [Flavobacteriaceae bacterium] diamond 642 95.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
26946051 26946051 PRJNA1218816_P_NODE_36802_length_322_cov_1.236948_g36369_i0 PRJNA1218816 36802 322 1.236948 3.98297256 Flavobacterium sp. H122 2529860 Bacteria Bacteria 159 1.5799999999999998e-47   NR WP_136666609.1 2529860 g36369 i0 69.9 0.959627329192547 103 30 95 1 306 1 1 103 WP_136666609.1 DinB family protein [Flavobacterium sp. H122] diamond 309 159 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. H122
27028254 27028254 PRJNA1218816_P_NODE_46222_length_278_cov_2.092683_g45789_i0 PRJNA1218816 46222 278 2.092683 5.81765874 Flavobacterium 237 Bacteria Bacteria 189 2.08e-54   NR WP_023571508.1 510946 g45789 i0 100 5.9568345323741 92 0 99.3 0 1 276 571 662 WP_023571508.1 ArdC family protein [Flavobacterium cauense] diamond 1656 189 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium cauense
27041124 27041124 PRJNA1218816_P_NODE_64402_length_200_cov_5.062992_g63969_i0 PRJNA1218816 64402 200 5.062992 10.125984 Flavobacterium sp. J27 2060419 Bacteria Bacteria 98.2 1.23e-24   NR WP_130733203.1 2060419 g63969 i0 74.2 0.99 66 17 99 0 199 2 1 66 WP_130733203.1 hypothetical protein [Flavobacterium sp. J27] diamond 198 98.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. J27
27388965 27388965 PRJNA1218816_P_NODE_54723_length_250_cov_0.870056_g54290_i0 PRJNA1218816 54723 250 0.870056 2.17514 Cloacibacterium normanense 237258 Bacteria Bacteria 139 8.97e-40   NR WP_104794465.1 237258 g54290 i0 90.4 0.996 83 7 99.6 1 1 249 29 110 WP_104794465.1 hypothetical protein [Cloacibacterium normanense] diamond 249 139 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium normanense
27452159 27452159 PRJNA1218816_P_NODE_54823_length_250_cov_0.870056_g54390_i0 PRJNA1218816 54823 250 0.870056 2.17514 Saprospiraceae bacterium 2202734 Bacteria Bacteria 50.1 1.07e-4   NR MFM9947806.1 2202734 g54390 i0 46.7 0.54 45 24 54 0 136 2 537 581 MFM9947806.1 ATP-binding protein [Saprospiraceae bacterium] diamond 135 50.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
27483511 27483511 PRJNA1218816_P_NODE_55323_length_249_cov_1.534091_g54890_i0 PRJNA1218816 55323 249 1.534091 3.81988659 Flavobacteriales bacterium 2021391 Bacteria Bacteria 103 1.2799999999999999e-23   NR MBL8010365.1 2021391 g54890 i0 71.4 0.759036144578313 63 18 75.9 0 245 57 369 431 MBL8010365.1 hypothetical protein [Flavobacteriales bacterium] diamond 189 103 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales bacterium
28841076 28841076 PRJNA1218816_P_NODE_59708_length_244_cov_1.801170_g59275_i0 PRJNA1218816 59708 244 1.80117 4.3948548 Phocaeicola vulgatus 821 Bacteria Bacteria 40 0.0454   NR WP_227238842.1 821 g59275 i0 40 0.491803278688525 40 22 46.7 1 97 210 11 50 WP_227238842.1 hypothetical protein, partial [Phocaeicola vulgatus] diamond 120 40 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Phocaeicola Phocaeicola vulgatus
29062362 29062362 PRJNA1218816_P_NODE_28948_length_377_cov_1.753289_g28515_i0 PRJNA1218816 28948 377 1.753289 6.60989953 Flavobacterium humi 2562683 Bacteria Bacteria 70.5 9.49e-13   NR WP_135525607.1 2562683 g28515 i0 80.5 0.652519893899204 41 8 32.6 0 355 233 1 41 WP_135525607.1 YtxH domain-containing protein [Flavobacterium humi] diamond 246 70.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium humi
29220226 29220226 PRJNA1218816_P_NODE_46569_length_277_cov_1.426471_g46136_i0 PRJNA1218816 46569 277 1.426471 3.95132467 Prevotella 838 Bacteria Bacteria 184 1.71e-57   NR WP_107581661.1 838 g46136 i0 97.8 1.9927797833935 92 2 99.6 0 1 276 26 117 WP_107581661.1 MULTISPECIES: helix-turn-helix domain-containing protein [Prevotella] diamond 552 184 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella  
29220228 29220228 PRJNA1218816_P_NODE_56869_length_248_cov_0.880000_g56436_i0 PRJNA1218816 56869 248 0.88 2.1824 Bacteroidales bacterium 2030927 Bacteria Bacteria 131 5.31e-35   NR MFO7939826.1 2030927 g56436 i0 74.4 5.95161290322581 82 21 99.2 0 2 247 245 326 MFO7939826.1 GMP reductase [Bacteroidales bacterium] diamond 1476 131 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
29598691 29598691 PRJNA1218816_P_NODE_60110_length_244_cov_0.900585_g59677_i0 PRJNA1218816 60110 244 0.900585 2.1974274 Bacteroidota bacterium 1898104 Bacteria Bacteria 160 5.88e-45   NR MDM8002762.1 1898104 g59677 i0 97.5 0.995901639344262 81 2 99.6 0 1 243 23 103 MDM8002762.1 KamA family radical SAM protein [Bacteroidota bacterium] diamond 243 160 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29870352 29870352 PRJNA1218816_P_NODE_60831_length_243_cov_0.905882_g60398_i0 PRJNA1218816 60831 243 0.905882 2.20129326 Prevotella 838 Bacteria Bacteria 150 2.52e-41   NR MDD4534943.1 59823 g60398 i0 90 6.91358024691358 80 8 98.8 0 241 2 351 430 MDD4534943.1 NADP-specific glutamate dehydrogenase [Prevotella sp.] diamond 1680 150 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp.
30230656 30230656 PRJNA1218816_P_NODE_38712_length_312_cov_0.966527_g38279_i0 PRJNA1218816 38712 312 0.966527 3.01556424 Crocinitomicaceae bacterium 2026728 Bacteria Bacteria 50.4 1.07e-5   NR TXI80130.1 2026728 g38279 i0 51.1 0.451923076923077 47 23 45.2 0 158 18 19 65 TXI80130.1 MAG: hypothetical protein E6Q39_03005 [Crocinitomicaceae bacterium] diamond 141 50.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Crocinitomicaceae   Crocinitomicaceae bacterium
30262562 30262562 PRJNA1218816_P_NODE_47232_length_274_cov_1.676617_g46799_i0 PRJNA1218816 47232 274 1.676617 4.59393058 Flavobacterium sp. 239 Bacteria Bacteria 169 5.89e-51   NR MFN3909155.1 239 g46799 i0 95.6 0.996350364963504 91 4 99.6 0 273 1 55 145 MFN3909155.1 HmuY family protein [Flavobacterium sp.] diamond 273 169 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
30376303 30376303 PRJNA1218816_P_NODE_64392_length_201_cov_30.250000_g63959_i0 PRJNA1218816 64392 201 30.25 60.8025 Flavobacterium 237 Bacteria Bacteria 46.6 8.68e-5   NR HLN94350.1 239 g63959 i0 49.1 1.70149253731343 57 28 83.6 1 186 19 8 64 HLN94350.1 hypothetical protein [Flavobacterium sp.] diamond 342 46.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
30452105 30452105 PRJNA1218816_P_NODE_58533_length_246_cov_0.890173_g58100_i0 PRJNA1218816 58533 246 0.890173 2.18982558 Prevotella sp. 59823 Bacteria Bacteria 95.1 1.4e-20   NR MCH3981410.1 59823 g58100 i0 64.2 0.98780487804878 81 28 98.8 1 2 244 16 95 MCH3981410.1 protein O-GlcNAcase [Prevotella sp.] diamond 243 95.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp.
31640061 31640061 PRJNA1218816_P_NODE_36616_length_323_cov_1.520000_g36183_i0 PRJNA1218816 36616 323 1.52 4.9096 root 1 Root_unresolved Root_unresolved 204 7.39e-65   NR MBR2888471.1 2030927 g36183 i0 86.9 8.91640866873065 107 14 99.4 0 321 1 27 133 MBR2888471.1 xylose isomerase [Bacteroidales bacterium] diamond 2880 204 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
31779331 31779331 PRJNA1218816_P_NODE_29017_length_376_cov_3.623762_g28584_i0 PRJNA1218816 29017 376 3.623762 13.62534512 Flavobacterium 237 Bacteria Bacteria 62 1.02e-8   NR WP_264544359.1 237 g28584 i0 80 0.837765957446808 35 7 27.9 0 107 3 167 201 WP_264544359.1 MULTISPECIES: hypothetical protein [Flavobacterium] diamond 315 62 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium  
31905992 31905992 PRJNA1218816_P_NODE_53837_length_251_cov_0.865169_g53404_i0 PRJNA1218816 53837 251 0.865169 2.17157419 Fulvivirga ligni 2904246 Bacteria Bacteria 74.7 2.26e-13   NR WP_233769696.1 2904246 g53404 i0 46.5 0.848605577689243 71 37 84.9 1 214 2 339 408 WP_233769696.1 family 43 glycosylhydrolase [Fulvivirga ligni] diamond 213 74.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Fulvivirgaceae Fulvivirga Fulvivirga ligni
31969208 31969208 PRJNA1218816_P_NODE_61138_length_243_cov_0.905882_g60705_i0 PRJNA1218816 61138 243 0.905882 2.20129326 Niabella sp. 1962976 Bacteria Bacteria 54.7 4.68e-8   NR TXI35545.1 1962976 g60705 i0 66.7 0.37037037037037 30 10 37 0 240 151 1 30 TXI35545.1 MAG: hypothetical protein E6Q58_00070 [Niabella sp.] diamond 90 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Niabella Niabella sp.
32412390 32412390 PRJNA1218816_P_NODE_55979_length_249_cov_0.875000_g55546_i0 PRJNA1218816 55979 249 0.875 2.17875 Flavisolibacter sp. 1954249 Bacteria Bacteria 154 5.09e-46   NR MFL5811887.1 1954249 g55546 i0 91.5 0.987951807228916 82 7 98.8 0 3 248 46 127 MFL5811887.1 hypothetical protein [Flavisolibacter sp.] diamond 246 154 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Flavisolibacter Flavisolibacter 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);;