RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA1113956" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 33 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1113956 · 33 ✖

analysis 1

  • diamond · 33 ✖
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
221919 221919 PRJNA1113956_P_NODE_21521_length_245_cov_0.895349_g21181_i0 PRJNA1113956 21521 245 0.895349 2.19360505 Bacteroidia bacterium 2044936 Bacteria Bacteria 95.9 7.550000000000001e-21   NR MCS7077385.1 2044936 g21181 i0 64.2 0.991836734693878 81 29 99.2 0 1 243 70 150 MCS7077385.1 sodium-translocating pyrophosphatase [Bacteroidia bacterium] diamond 243 95.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
11700720 11700720 PRJNA1113956_P_NODE_19930_length_250_cov_0.870056_g19590_i0 PRJNA1113956 19930 250 0.870056 2.17514 Bacteroidia bacterium 2044936 Bacteria Bacteria 136 2.79e-36   NR MCS7084790.1 2044936 g19590 i0 73.5 1.992 83 22 99.6 0 2 250 302 384 MCS7084790.1 RluA family pseudouridine synthase [Bacteroidia bacterium] diamond 498 136 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
12975837 12975837 PRJNA1113956_P_NODE_22271_length_243_cov_0.888235_g21931_i0 PRJNA1113956 22271 243 0.888235 2.15841105 Riemerella sp. 2382126 Bacteria Bacteria 94.7 9.48e-21   NR RKW59094.1 2382126 g21931 i0 100 0.580246913580247 47 0 58 0 143 3 1 47 RKW59094.1 MAG: NAD(P)/FAD-dependent oxidoreductase [Riemerella sp.] diamond 141 94.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Riemerella Riemerella sp.
26941299 26941299 PRJNA1113956_P_NODE_20322_length_249_cov_0.875000_g19982_i0 PRJNA1113956 20322 249 0.875 2.17875 Bacteroidota bacterium 1898104 Bacteria Bacteria 61.2 1.15e-8   NR RMG87391.1 1898104 g19982 i0 37 1.91566265060241 81 51 97.6 0 5 247 53 133 RMG87391.1 MAG: tetratricopeptide repeat protein [Bacteroidota bacterium] diamond 477 61.2 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
26972996 26972996 PRJNA1113956_P_NODE_20342_length_249_cov_0.875000_g20002_i0 PRJNA1113956 20342 249 0.875 2.17875 Prevotellaceae bacterium 2049047 Bacteria Bacteria 164 6.17e-49   NR MBF1069528.1 2049047 g20002 i0 98.8 1 83 1 100 0 249 1 145 227 MBF1069528.1 UDP-3-O-acyl-N-acetylglucosamine deacetylase [Prevotellaceae bacterium] diamond 249 164 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae   Prevotellaceae bacterium
27067891 27067891 PRJNA1113956_P_NODE_18562_length_265_cov_1.463542_g18222_i0 PRJNA1113956 18562 265 1.463542 3.8783863 Fluviicola sp. 1917219 Bacteria Bacteria 148 4.4399999999999997e-39   NR WP_300663444.1 1917219 g18222 i0 83.9 2.96603773584906 87 14 98.5 0 264 4 893 979 WP_300663444.1 ATP-binding cassette domain-containing protein [Fluviicola sp.] diamond 786 148 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Crocinitomicaceae Fluviicola Fluviicola sp.
27384160 27384160 PRJNA1113956_P_NODE_22363_length_242_cov_0.911243_g22023_i0 PRJNA1113956 22363 242 0.911243 2.20520806 Bacteroidia bacterium 2044936 Bacteria Bacteria 44.3 0.0102   NR MFN8394437.1 2044936 g22023 i0 37.5 1.78512396694215 64 40 79.3 0 194 3 259 322 MFN8394437.1 O-antigen ligase family protein [Bacteroidia bacterium] diamond 432 44.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
27415885 27415885 PRJNA1113956_P_NODE_19263_length_256_cov_1.398907_g18923_i0 PRJNA1113956 19263 256 1.398907 3.58120192 Alloprevotella tannerae 76122 Bacteria Bacteria 173 1.82e-50   NR MBF0962021.1 76122 g18923 i0 97.6 0.984375 84 2 98.4 0 3 254 67 150 MBF0962021.1 NADH-quinone oxidoreductase subunit D [Alloprevotella tannerae] diamond 252 173 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Alloprevotella Alloprevotella tannerae
27438565 27438565 PRJNA1113956_P_NODE_22383_length_242_cov_0.911243_g22043_i0 PRJNA1113956 22383 242 0.911243 2.20520806 Bacteria 2 Bacteria Bacteria 169 3.32e-50   NR MDN5297284.1 1898104 g22043 i0 100 2.96280991735537 80 0 99.2 0 2 241 13 92 MDN5297284.1 hypothetical protein [Bacteroidota bacterium] diamond 717 169 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27731660 27731660 PRJNA1113956_P_NODE_22544_length_242_cov_0.911243_g22204_i0 PRJNA1113956 22544 242 0.911243 2.20520806 Marinilongibacter aquaticus 2975157 Bacteria Bacteria 105 6.92e-26   NR WP_261449973.1 2975157 g22204 i0 57.5 4.92148760330578 80 34 99.2 0 1 240 156 235 WP_261449973.1 bacillithiol biosynthesis deacetylase BshB1 [Marinilongibacter aquaticus] diamond 1191 105 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Leadbetterellaceae Marinilongibacter Marinilongibacter aquaticus
28006845 28006845 PRJNA1113956_P_NODE_20125_length_250_cov_0.870056_g19785_i0 PRJNA1113956 20125 250 0.870056 2.17514 Bacteroidota 976 Bacteria Bacteria 52.4 1.61e-5   NR NBV13875.1 2035813 g19785 i0 41.9 1.932 86 47 99.6 2 2 250 89 174 NBV13875.1 sugar transferase [Sphingobacteriia bacterium] diamond 483 52.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia       Sphingobacteriia bacterium
28015664 28015664 PRJNA1113956_P_NODE_13025_length_354_cov_1.370107_g12685_i0 PRJNA1113956 13025 354 1.370107 4.85017878 Bacteroidales bacterium 2030927 Bacteria Bacteria 43.5 0.0375   NR MCQ2263943.1 2030927 g12685 i0 37.5 0.474576271186441 56 35 47.5 0 126 293 1 56 MCQ2263943.1 HAD family hydrolase [Bacteroidales bacterium] diamond 168 43.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
28267940 28267940 PRJNA1113956_P_NODE_20106_length_250_cov_0.870056_g19766_i0 PRJNA1113956 20106 250 0.870056 2.17514 Mucilaginibacter ginkgonis 2682091 Bacteria Bacteria 116 5.6399999999999995e-30   NR WP_200231104.1 2682091 g19766 i0 89.7 0.696 58 6 69.6 0 2 175 184 241 WP_200231104.1 RluA family pseudouridine synthase [Mucilaginibacter ginkgonis] diamond 174 116 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Mucilaginibacter Mucilaginibacter ginkgonis
28394362 28394362 PRJNA1113956_P_NODE_21006_length_247_cov_0.867816_g20666_i0 PRJNA1113956 21006 247 0.867816 2.14350552 Mucilaginibacter sp. KACC 22 1882438 Bacteria Bacteria 169 3.4099999999999996e-47   NR WP_274205731.1 3025666 g20666 i0 93.8 3.93522267206478 81 5 98.4 0 3 245 454 534 WP_274205731.1 S9 family peptidase [Mucilaginibacter sp. KACC 22063] diamond 972 169 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Mucilaginibacter Mucilaginibacter sp. KACC 22063
28552454 28552454 PRJNA1113956_P_NODE_20387_length_249_cov_0.875000_g20047_i0 PRJNA1113956 20387 249 0.875 2.17875 Alloprevotella tannerae 76122 Bacteria Bacteria 169 1.85e-50   NR WP_006253981.1 76122 g20047 i0 98.8 0.987951807228916 82 1 98.8 0 3 248 31 112 WP_006253981.1 TatD family hydrolase [Alloprevotella tannerae] diamond 246 169 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Alloprevotella Alloprevotella tannerae
29026222 29026222 PRJNA1113956_P_NODE_21448_length_245_cov_0.895349_g21108_i0 PRJNA1113956 21448 245 0.895349 2.19360505 Cytophagales bacterium 2053541 Bacteria Bacteria 52.8 7.6e-6   NR MBC8110190.1 2053541 g21108 i0 38.7 0.918367346938776 75 45 90.6 1 7 228 158 232 MBC8110190.1 hypothetical protein [Cytophagales bacterium] diamond 225 52.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales     Cytophagales bacterium
29183954 29183954 PRJNA1113956_P_NODE_16049_length_300_cov_5.568282_g15709_i0 PRJNA1113956 16049 300 5.568282 16.704846 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 65.9 1.02e-11   NR HKJ06409.1 1871037 g15709 i0 44.6 3.31 83 43 83 2 10 258 1 80 HKJ06409.1 molybdopterin converting factor subunit 1 [Flavobacteriaceae bacterium] diamond 993 65.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
29278333 29278333 PRJNA1113956_P_NODE_4769_length_789_cov_3.138268_g4474_i0 PRJNA1113956 4769 789 3.138268 24.76093452 Lacihabitans sp. LS3-19 2487335 Bacteria Bacteria 52.4 5.95e-4   NR WP_255069505.1 2487335 g4474 i0 29.8 1.90494296577947 161 78 60.5 9 657 181 80 207 WP_255069505.1 SDR family NAD(P)-dependent oxidoreductase [Lacihabitans sp. LS3-19] diamond 1503 52.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Leadbetterellaceae Lacihabitans Lacihabitans sp. LS3-19
29373258 29373258 PRJNA1113956_P_NODE_22569_length_242_cov_0.911243_g22229_i0 PRJNA1113956 22569 242 0.911243 2.20520806 Pontibacter kalidii 2592049 Bacteria Bacteria 95.5 2.2e-21   NR WP_266205351.1 2592049 g22229 i0 57.1 1.90909090909091 77 33 95.5 0 242 12 248 324 WP_266205351.1 alpha/beta fold hydrolase [Pontibacter kalidii] diamond 462 95.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Pontibacter Pontibacter kalidii
29656998 29656998 PRJNA1113956_P_NODE_6370_length_643_cov_2.529825_g6047_i0 PRJNA1113956 6370 643 2.529825 16.26677475 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 48.1 0.0136   NR RYG08447.1 1869212 g6047 i0 31.8 0.765163297045101 85 58 39.7 0 306 52 20 104 RYG08447.1 MAG: ribonuclease R, partial [Chitinophagaceae bacterium] diamond 492 48.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
29910167 29910167 PRJNA1113956_P_NODE_20351_length_249_cov_0.875000_g20011_i0 PRJNA1113956 20351 249 0.875 2.17875 Bacteroidia bacterium 2044936 Bacteria Bacteria 125 1.6699999999999999e-31   NR MDX2061882.1 2044936 g20011 i0 65.9 0.987951807228916 82 28 98.8 0 4 249 390 471 MDX2061882.1 lysophospholipid acyltransferase family protein [Bacteroidia bacterium] diamond 246 125 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
30122091 30122091 PRJNA1113956_P_NODE_20492_length_248_cov_1.668571_g20152_i0 PRJNA1113956 20492 248 1.668571 4.13805608 Pseudomonadati 3379134 Bacteria Bacteria 91.7 4.33e-20   NR HLP95511.1 2202734 g20152 i0 56.8 1.95967741935484 81 35 98 0 244 2 184 264 HLP95511.1 NAD(P)H-binding protein [Saprospiraceae bacterium] diamond 486 92 0.996739130434783 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
30447294 30447294 PRJNA1113956_P_NODE_16993_length_286_cov_1.723005_g16653_i0 PRJNA1113956 16993 286 1.723005 4.9277943 Seramator thermalis 2496270 Bacteria Bacteria 73.9 3.22e-14   NR WP_129593830.1 2496270 g16653 i0 100 1.05944055944056 37 0 38.8 0 111 1 1 37 WP_129593830.1 aspartate carbamoyltransferase regulatory subunit [Seramator thermalis] diamond 303 73.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Dysgonomonadaceae Seramator Seramator thermalis
30469999 30469999 PRJNA1113956_P_NODE_20853_length_247_cov_0.885057_g20513_i0 PRJNA1113956 20853 247 0.885057 2.18609079 Bacteroidota 976 Bacteria Bacteria 134 3.1e-34   NR WP_132434434.1 682526 g20513 i0 73.2 16.9311740890688 82 22 99.6 0 1 246 477 558 WP_132434434.1 aconitate hydratase [Natronoflexus pectinivorans] diamond 4182 135 0.992592592592593 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Marinilabiliales Marinilabiliaceae Natronoflexus Natronoflexus pectinivorans
30636530 30636530 PRJNA1113956_P_NODE_20533_length_248_cov_0.880000_g20193_i0 PRJNA1113956 20533 248 0.88 2.1824 Alloprevotella tannerae 76122 Bacteria Bacteria 167 6.49e-49   NR MBF0956907.1 76122 g20193 i0 100 1.98387096774194 82 0 99.2 0 2 247 207 288 MBF0956907.1 DEAD/DEAH box helicase [Alloprevotella tannerae] diamond 492 167 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Alloprevotella Alloprevotella tannerae
30921239 30921239 PRJNA1113956_P_NODE_20094_length_250_cov_0.870056_g19754_i0 PRJNA1113956 20094 250 0.870056 2.17514 Bacteroidota bacterium 1898104 Bacteria Bacteria 111 2.2399999999999993e-28   NR MBI2275206.1 1898104 g19754 i0 81 2.268 63 12 75.6 0 248 60 150 212 MBI2275206.1 rhomboid family intramembrane serine protease [Bacteroidota bacterium] diamond 567 111 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30984416 30984416 PRJNA1113956_P_NODE_15994_length_301_cov_2.688596_g15654_i0 PRJNA1113956 15994 301 2.688596 8.09267396 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 45.4 0.00851   NR MDA8588908.1 1871037 g15654 i0 34 0.966777408637874 97 50 85.7 4 270 13 633 726 MDA8588908.1 PD-(D/E)XK nuclease family protein [Flavobacteriaceae bacterium] diamond 291 45.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
31300313 31300313 PRJNA1113956_P_NODE_6555_length_628_cov_7.976577_g6231_i0 PRJNA1113956 6555 628 7.976577 50.09290356 Lacibacter sp. 1915409 Bacteria Bacteria 47 0.017   NR WP_324232586.1 1915409 g6231 i0 31.9 0.449044585987261 94 63 44.4 1 120 398 3 96 WP_324232586.1 hypothetical protein [Lacibacter sp.] diamond 282 47 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Lacibacter Lacibacter sp.
31426778 31426778 PRJNA1113956_P_NODE_4276_length_850_cov_2.138996_g3993_i0 PRJNA1113956 4276 850 2.138996 18.181466 Phocaeicola coprocola 310298 Bacteria Bacteria 48.9 0.0172   NR WP_270230392.1 310298 g3993 i0 24 0.603529411764706 171 108 55.4 5 362 832 149 311 WP_270230392.1 hypothetical protein [Phocaeicola coprocola] diamond 513 48.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Phocaeicola Phocaeicola coprocola
31711497 31711497 PRJNA1113956_P_NODE_22197_length_243_cov_0.905882_g21857_i0 PRJNA1113956 22197 243 0.905882 2.20129326 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 161 6.94e-46   NR TXJ25479.1 1869212 g21857 i0 98.8 0.987654320987654 80 1 98.8 0 242 3 345 424 TXJ25479.1 MAG: aminotransferase class V-fold PLP-dependent enzyme [Chitinophagaceae bacterium] diamond 240 161 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
31932832 31932832 PRJNA1113956_P_NODE_17157_length_284_cov_1.459716_g16817_i0 PRJNA1113956 17157 284 1.459716 4.14559344 Alloprevotella tannerae 76122 Bacteria Bacteria 206 9.28e-61   NR WP_315510484.1 76122 g16817 i0 98.9 1.98591549295775 94 1 99.3 0 1 282 369 462 WP_315510484.1 T9SS C-terminal target domain-containing protein [Alloprevotella tannerae] diamond 564 206 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Alloprevotella Alloprevotella tannerae
31932837 31932837 PRJNA1113956_P_NODE_21897_length_244_cov_0.900585_g21557_i0 PRJNA1113956 21897 244 0.900585 2.1974274 Bacteroidota bacterium 1898104 Bacteria Bacteria 76.6 4.26e-14   NR TNE58123.1 1898104 g21557 i0 50.6 0.94672131147541 77 38 94.7 0 233 3 679 755 TNE58123.1 MAG: TonB-dependent receptor [Bacteroidota bacterium] diamond 231 76.6 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32082117 32082117 PRJNA1113956_P_NODE_2778_length_1111_cov_3.952794_g2567_i0 PRJNA1113956 2778 1111 3.952794 43.91554134 Bacteria 2 Bacteria Bacteria 118 6.3499999999999995e-25   NR MBK43271.1 1871037 g2567 i0 36 4.04500450045005 178 110 47.8 2 533 3 200 374 MBK43271.1 ribonuclease R [Flavobacteriaceae bacterium] diamond 4494 119 0.991596638655462 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae 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);;