RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA577226" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 30 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA577226 · 30 ✖

analysis 1

  • diamond · 30 ✖
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
12041088 12041088 PRJNA577226_S_NODE_4370_length_690_cov_2.500766_g3493_i0 PRJNA577226 4370 690 2.500766 17.255285400000002 Saprospirales bacterium 2026790 Bacteria Bacteria 100 1.79e-23   NR HAW06185.1 2026790 g3493 i0 51 0.434782608695652 100 48 43.5 1 541 242 1 99 HAW06185.1 hypothetical protein [Saprospirales bacterium] diamond 300 100 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales     Saprospirales bacterium
13315539 13315539 PRJNA577226_S_NODE_26251_length_244_cov_3.140097_g25312_i0 PRJNA577226 26251 244 3.140097 7.66183668 Marnyiella aurantia 2758037 Bacteria Bacteria 79.7 3.33e-15   NR WP_209815364.1 2758037 g25312 i0 58.5 0.799180327868853 65 27 79.9 0 49 243 49 113 WP_209815364.1 RtcB family protein [Marnyiella aurantia] diamond 195 79.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Marnyiella Marnyiella aurantia
24788796 24788796 PRJNA577226_S_NODE_69960_length_152_cov_1.017391_g69021_i0 PRJNA577226 69960 152 1.017391 1.54643432 unclassified Chryseobacterium 2593645 Bacteria Bacteria 99.8 2.34e-25   NR WP_066677147.1 2593645 g69021 i0 98 0.967105263157895 49 1 96.7 0 151 5 82 130 WP_066677147.1 MULTISPECIES: hypothetical protein [unclassified Chryseobacterium] diamond 147 99.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium  
26649783 26649783 PRJNA577226_S_NODE_65641_length_156_cov_1.285714_g64702_i0 PRJNA577226 65641 156 1.285714 2.00571384 Pseudomonadati 3379134 Bacteria Bacteria 99.8 1.62e-23   NR RYF47128.1 2026729 g64702 i0 96.1 1.96153846153846 51 2 98.1 0 154 2 61 111 RYF47128.1 MAG: PAS domain-containing protein, partial [Cytophagaceae bacterium] diamond 306 99.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae   Cytophagaceae bacterium
27048038 27048038 PRJNA577226_S_NODE_37662_length_203_cov_1.156627_g36723_i0 PRJNA577226 37662 203 1.156627 2.34795281 Bacteroidales bacterium 2030927 Bacteria Bacteria 54.3 1.81e-6   NR MBQ8461937.1 2030927 g36723 i0 42.4 2.77832512315271 66 38 97.5 0 203 6 299 364 MBQ8461937.1 Eco57I restriction-modification methylase domain-containing protein [Bacteroidales bacterium] diamond 564 54.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27174200 27174200 PRJNA577226_S_NODE_16242_length_319_cov_1.659574_g15303_i0 PRJNA577226 16242 319 1.659574 5.29404106 Bacteroidales bacterium 2030927 Bacteria Bacteria 75.9 4.39e-14   NR MFA5768361.1 2030927 g15303 i0 45.9 1.85266457680251 98 48 87.5 2 41 319 80 177 MFA5768361.1 hypothetical protein [Bacteroidales bacterium] diamond 591 75.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27332658 27332658 PRJNA577226_S_NODE_42083_length_192_cov_1.232258_g41144_i0 PRJNA577226 42083 192 1.232258 2.36593536 Cytophagaceae bacterium 2026729 Bacteria Bacteria 47.8 4.43e-5   NR RYF49082.1 2026729 g41144 i0 95.7 0.359375 23 1 35.9 0 1 69 67 89 RYF49082.1 MAG: hypothetical protein EOO38_08715 [Cytophagaceae bacterium] diamond 69 47.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae   Cytophagaceae bacterium
27395879 27395879 PRJNA577226_S_NODE_29663_length_229_cov_2.739583_g28724_i0 PRJNA577226 29663 229 2.739583 6.27364507 Flavisolibacter sp. 1954249 Bacteria Bacteria 63.2 1.88e-9   NR HYH16808.1 1954249 g28724 i0 44.6 0.96943231441048 74 41 96.9 0 6 227 343 416 HYH16808.1 hypothetical protein [Flavisolibacter sp.] diamond 222 63.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Flavisolibacter Flavisolibacter sp.
27616825 27616825 PRJNA577226_S_NODE_43884_length_188_cov_1.278146_g42945_i0 PRJNA577226 43884 188 1.278146 2.40291448 Rufibacter roseolus 2817375 Bacteria Bacteria 73.2 2.71e-13   NR WP_210466869.1 2817375 g42945 i0 55 2.87234042553191 60 27 95.7 0 182 3 2 61 WP_210466869.1 Fic family protein [Rufibacter roseolus] diamond 540 73.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Rufibacter Rufibacter roseolus
27648443 27648443 PRJNA577226_S_NODE_3384_length_836_cov_2.435544_g2560_i0 PRJNA577226 3384 836 2.435544 20.36114784 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 48.5 0.0125   NR MDI9405142.1 1869212 g2560 i0 41.5 0.294258373205742 82 46 29.4 1 404 159 27 106 MDI9405142.1 helix-turn-helix domain-containing protein [Chitinophagaceae bacterium] diamond 246 48.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
27693657 27693657 PRJNA577226_S_NODE_31324_length_223_cov_1.881720_g30385_i0 PRJNA577226 31324 223 1.88172 4.1962356 Pseudomonadati 3379134 Bacteria Bacteria 63.9 4.74e-11   NR PDP72243.1 837 g30385 i0 100 0.834080717488789 31 0 41.7 0 1 93 80 110 PDP72243.1 peptidase, partial [Porphyromonas gingivalis] diamond 186 63.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas gingivalis
27806333 27806333 PRJNA577226_S_NODE_27364_length_239_cov_2.054455_g26425_i0 PRJNA577226 27364 239 2.054455 4.91014745 Hymenobacter psoromatis 1484116 Bacteria Bacteria 115 5.04e-28   NR WP_223649433.1 1484116 g26425 i0 68.8 1.00418410041841 80 24 99.2 1 3 239 178 257 WP_223649433.1 RtcB family protein [Hymenobacter psoromatis] diamond 240 115 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter psoromatis
28184785 28184785 PRJNA577226_S_NODE_28786_length_233_cov_1.892857_g27847_i0 PRJNA577226 28786 233 1.892857 4.41035681 Bacteroidales bacterium 2030927 Bacteria Bacteria 42.4 0.0452   NR MCG8578703.1 2030927 g27847 i0 39.7 0.875536480686695 68 40 87.6 1 226 23 67 133 MCG8578703.1 glycosyltransferase [Bacteroidales bacterium] diamond 204 42.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
28753362 28753362 PRJNA577226_S_NODE_7747_length_484_cov_3.304251_g6816_i0 PRJNA577226 7747 484 3.304251 15.99257484 Phaeodactylibacter sp. 1940289 Bacteria Bacteria 125 5.2899999999999995e-30   NR MCB0597961.1 1940289 g6816 i0 44 3.68181818181818 150 84 93 0 451 2 382 531 MCB0597961.1 DEAD/DEAH box helicase [Phaeodactylibacter sp.] diamond 1782 125 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Haliscomenobacteraceae Phaeodactylibacter Phaeodactylibacter sp.
28816255 28816255 PRJNA577226_S_NODE_58968_length_163_cov_1.896825_g58029_i0 PRJNA577226 58968 163 1.896825 3.09182475 Bacteroides sp. CAG:144 1262736 Bacteria Bacteria 40.8 0.0413   NR CDA21509.1 1262736 g58029 i0 38.2 1.01226993865031 55 26 86.5 1 159 19 60 114 CDA21509.1 putative uncharacterized protein [Bacteroides sp. CAG:144] diamond 165 40.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Bacteroides Bacteroides sp. CAG:144
29037764 29037764 PRJNA577226_S_NODE_3448_length_824_cov_2.494282_g2620_i0 PRJNA577226 3448 824 2.494282 20.55288368 Prolixibacteraceae bacterium 2053594 Bacteria Bacteria 115 3.9600000000000006e-27   NR MBN2262638.1 2053594 g2620 i0 40.1 0.608009708737864 167 99 60.8 1 722 222 58 223 MBN2262638.1 hypothetical protein [Prolixibacteraceae bacterium] diamond 501 115 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Marinilabiliales Prolixibacteraceae   Prolixibacteraceae bacterium
29335238 29335238 PRJNA577226_S_NODE_34769_length_211_cov_2.183908_g33830_i0 PRJNA577226 34769 211 2.183908 4.60804588 Bacteria 2 Bacteria Bacteria 94 2.08e-20   NR MFA5768342.1 2030927 g33830 i0 62.9 1.99052132701422 70 26 99.5 0 1 210 93 162 MFA5768342.1 hypothetical protein [Bacteroidales bacterium] diamond 420 94.7 0.992608236536431 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
29574085 29574085 PRJNA577226_S_NODE_63390_length_158_cov_1.611570_g62451_i0 PRJNA577226 63390 158 1.61157 2.5462806 Bacteroidota bacterium 1898104 Bacteria Bacteria 57 8.47e-8   NR MFN9114615.1 1898104 g62451 i0 40.4 0.987341772151899 52 31 98.7 0 1 156 118 169 MFN9114615.1 restriction endonuclease [Bacteroidota bacterium] diamond 156 57 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30047849 30047849 PRJNA577226_S_NODE_66451_length_155_cov_1.406780_g65512_i0 PRJNA577226 66451 155 1.40678 2.180509 Flavisolibacter ginsenosidimutans 661481 Bacteria Bacteria 66.2 5.69e-11   NR WP_146787647.1 661481 g65512 i0 58.8 0.987096774193548 51 21 98.7 0 154 2 425 475 WP_146787647.1 hypothetical protein [Flavisolibacter ginsenosidimutans] diamond 153 66.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Flavisolibacter Flavisolibacter ginsenosidimutans
30205726 30205726 PRJNA577226_S_NODE_44572_length_186_cov_2.436242_g43633_i0 PRJNA577226 44572 186 2.436242 4.53141012 Bacteroidales bacterium Barb4 1633200 Bacteria Bacteria 114 4.61e-30   NR OAV63575.1 1633200 g43633 i0 86.9 0.983870967741935 61 8 98.4 0 1 183 102 162 OAV63575.1 hypothetical protein Barb4_04981 [Bacteroidales bacterium Barb4] diamond 183 114 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium Barb4
30269463 30269463 PRJNA577226_S_NODE_51852_length_173_cov_2.294118_g50913_i0 PRJNA577226 51852 173 2.294118 3.96882414 Bacteroidales bacterium 2030927 Bacteria Bacteria 65.9 1.01e-10   NR MFA5768342.1 2030927 g50913 i0 64.6 1.66473988439306 48 17 83.2 0 144 1 248 295 MFA5768342.1 hypothetical protein [Bacteroidales bacterium] diamond 288 65.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
30332845 30332845 PRJNA577226_S_NODE_36532_length_206_cov_1.384615_g35593_i0 PRJNA577226 36532 206 1.384615 2.8523069 Bacteroidales bacterium 2030927 Bacteria Bacteria 72.8 5.76e-13   NR MFA5768343.1 2030927 g35593 i0 47.8 1.90776699029126 67 35 97.6 0 206 6 69 135 MFA5768343.1 phage portal protein [Bacteroidales bacterium] diamond 393 72.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
30616617 30616617 PRJNA577226_S_NODE_12613_length_365_cov_2.652439_g11674_i0 PRJNA577226 12613 365 2.652439 9.68140235 Bacteroidota bacterium 1898104 Bacteria Bacteria 58.2 4.77e-7   NR REK51744.1 1898104 g11674 i0 42.9 0.575342465753425 70 34 57.5 1 250 41 130 193 REK51744.1 MAG: hypothetical protein DWQ49_14135 [Bacteroidota bacterium] diamond 210 58.2 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30648103 30648103 PRJNA577226_S_NODE_72393_length_150_cov_1.008850_g71454_i0 PRJNA577226 72393 150 1.00885 1.513275 Bacteroidota bacterium 1898104 Bacteria Bacteria 109 1.5800000000000002e-27   NR MDQ2769634.1 1898104 g71454 i0 93.9 0.98 49 3 98 0 148 2 142 190 MDQ2769634.1 TssN family type VI secretion system protein [Bacteroidota bacterium] diamond 147 109 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30743128 30743128 PRJNA577226_S_NODE_6394_length_543_cov_2.484190_g5469_i0 PRJNA577226 6394 543 2.48419 13.4891517 Hymenobacter sp. CRA2 1955620 Bacteria Bacteria 66.2 4.56e-9   NR WP_078012634.1 1955620 g5469 i0 61.4 2.15469613259669 44 17 24.3 0 8 139 419 462 WP_078012634.1 RtcB family protein [Hymenobacter sp. CRA2] diamond 1170 66.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter sp. CRA2
31912914 31912914 PRJNA577226_S_NODE_21177_length_275_cov_1.907563_g20238_i0 PRJNA577226 21177 275 1.907563 5.24579825 Prolixibacteraceae bacterium 2053594 Bacteria Bacteria 70.5 3.5e-13   NR MBN2263074.1 2053594 g20238 i0 45.6 0.981818181818182 90 38 98.2 2 2 271 42 120 MBN2263074.1 hypothetical protein [Prolixibacteraceae bacterium] diamond 270 70.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Marinilabiliales Prolixibacteraceae   Prolixibacteraceae bacterium
32007886 32007886 PRJNA577226_S_NODE_48178_length_180_cov_1.090909_g47239_i0 PRJNA577226 48178 180 1.090909 1.9636362 Marivirga sp. 2018662 Bacteria Bacteria 75.9 1.38e-14   NR MBA4053223.1 2018662 g47239 i0 72.4 0.966666666666667 58 16 96.7 0 180 7 137 194 MBA4053223.1 hypothetical protein [Marivirga sp.] diamond 174 75.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Marivirgaceae Marivirga Marivirga sp.
32084653 32084653 PRJNA577226_S_NODE_67778_length_154_cov_1.000000_g66839_i0 PRJNA577226 67778 154 1 1.54 Cytophagales 768507 Bacteria Bacteria 73.9 3.61e-15   NR RZK23619.1 1898978 g66839 i0 88.4 2.51298701298701 43 5 83.8 0 25 153 2 44 RZK23619.1 MAG: 3-deoxy-D-manno-octulosonic acid transferase, partial [Hymenobacter sp.] diamond 387 73.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter sp.
32451105 32451105 PRJNA577226_S_NODE_67339_length_154_cov_1.666667_g66400_i0 PRJNA577226 67339 154 1.666667 2.56666718 Bacteroidota bacterium 1898104 Bacteria Bacteria 52.4 2e-6   NR RLD76449.1 1898104 g66400 i0 53.1 0.954545454545455 49 22 95.5 1 148 2 41 88 RLD76449.1 MAG: hypothetical protein DRJ15_15320 [Bacteroidota bacterium] diamond 147 52.4 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32766171 32766171 PRJNA577226_S_NODE_43940_length_188_cov_1.033113_g43001_i0 PRJNA577226 43940 188 1.033113 1.94225244 Taibaiella sp. 1869185 Bacteria Bacteria 128 7.22e-35   NR MBZ0098177.1 1869185 g43001 i0 100 2.90425531914894 62 0 98.9 0 187 2 120 181 MBZ0098177.1 1,4-dihydroxy-2-naphthoyl-CoA synthase [Taibaiella sp.] diamond 546 128 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Taibaiella Taibaiella 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);;