RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA720429" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA720429 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
8363327 8363327 PRJNA720429_P_NODE_4927_length_242_cov_0.911243_g4870_i0 PRJNA720429 4927 242 0.911243 2.20520806 Siphonobacter aquaeclarae 563176 Bacteria Bacteria 160 2.92e-47   NR WP_176785431.1 563176 g4870 i0 95 0.991735537190083 80 4 99.2 0 240 1 98 177 WP_176785431.1 glucosamine-6-phosphate deaminase [Siphonobacter aquaeclarae] diamond 240 160 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae Siphonobacter Siphonobacter aquaeclarae
27115073 27115073 PRJNA720429_P_NODE_3042_length_256_cov_2.087432_g2985_i0 PRJNA720429 3042 256 2.087432 5.34382592 Bacteroidia bacterium 2044936 Bacteria Bacteria 107 1.4e-27   NR MDX2061503.1 2044936 g2985 i0 83.6 0.64453125 55 9 64.5 0 90 254 1 55 MDX2061503.1 6-carboxytetrahydropterin synthase [Bacteroidia bacterium] diamond 165 107 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
27347169 27347169 PRJNA720429_P_NODE_4583_length_244_cov_0.900585_g4526_i0 PRJNA720429 4583 244 0.900585 2.1974274 Chryseobacterium 59732 Bacteria Bacteria 117 1.93e-30   NR WP_228428164.1 741074 g4526 i0 96.7 5.9016393442623 60 2 73.8 0 64 243 26 85 WP_228428164.1 sensor histidine kinase [Chryseobacterium oncorhynchi] diamond 1440 118 0.991525423728814 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium oncorhynchi
27505107 27505107 PRJNA720429_P_NODE_4263_length_246_cov_0.890173_g4206_i0 PRJNA720429 4263 246 0.890173 2.18982558 Bacteria 2 Bacteria Bacteria 101 1.02e-22   NR MCR5658874.1 2030927 g4206 i0 66.7 5.97560975609756 81 26 98.8 1 1 243 775 854 MCR5658874.1 DNA translocase FtsK [Bacteroidales bacterium] diamond 1470 101 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
28188813 28188813 PRJNA720429_P_NODE_2446_length_279_cov_1.126214_g2389_i0 PRJNA720429 2446 279 1.126214 3.14213706 Siphonobacter aquaeclarae 563176 Bacteria Bacteria 195 1.16e-59   NR WP_093208119.1 563176 g2389 i0 98.9 0.989247311827957 92 1 98.9 0 277 2 161 252 WP_093208119.1 toxin-antitoxin system YwqK family antitoxin [Siphonobacter aquaeclarae] diamond 276 195 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae Siphonobacter Siphonobacter aquaeclarae
28220441 28220441 PRJNA720429_P_NODE_3766_length_248_cov_0.880000_g3709_i0 PRJNA720429 3766 248 0.88 2.1824 Flavobacterium sp. RNTU_13 3375145 Bacteria Bacteria 157 1.46e-42   NR WP_411428376.1 3375145 g3709 i0 100 0.991935483870968 82 0 99.2 0 2 247 772 853 WP_411428376.1 efflux RND transporter permease subunit [Flavobacterium sp. RNTU_13] diamond 246 157 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. RNTU_13
28788800 28788800 PRJNA720429_P_NODE_2627_length_271_cov_2.070707_g2570_i0 PRJNA720429 2627 271 2.070707 5.61161597 Flavobacterium sp. HMWF 239 Bacteria Bacteria 97.8 1.17e-22   NR PTT15786.1 2056864 g2570 i0 65.1 0.952029520295203 86 30 95.2 0 2 259 12 97 PTT15786.1 NAD(P)-dependent oxidoreductase [Flavobacterium sp. HMWF030] diamond 258 97.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. HMWF030
28799218 28799218 PRJNA720429_P_NODE_4527_length_244_cov_0.900585_g4470_i0 PRJNA720429 4527 244 0.900585 2.1974274 Saccharicrinis 1618113 Bacteria Bacteria 51.2 3.9e-5   NR MDX2063289.1 2044936 g4470 i0 47.1 4.16803278688525 68 33 79.9 2 195 1 479 546 MDX2063289.1 (E)-4-hydroxy-3-methylbut-2-enyl-diphosphate synthase [Bacteroidia bacterium] diamond 1017 51.6 0.992248062015504 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
28914986 28914986 PRJNA720429_P_NODE_3268_length_251_cov_0.865169_g3211_i0 PRJNA720429 3268 251 0.865169 2.17157419 Chryseobacterium aurantiacum 2116499 Bacteria Bacteria 90.1 2.92e-19   NR WP_106917962.1 2116499 g3211 i0 93.5 0.549800796812749 46 3 55 0 249 112 260 305 WP_106917962.1 hypothetical protein [Chryseobacterium aurantiacum] diamond 138 90.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium aurantiacum
29799221 29799221 PRJNA720429_P_NODE_2831_length_264_cov_1.371728_g2774_i0 PRJNA720429 2831 264 1.371728 3.62136192 Flavobacterium suzhouense 1529638 Bacteria Bacteria 129 5.7699999999999995e-37   NR WP_379819463.1 1529638 g2774 i0 100 0.704545454545455 62 0 70.5 0 77 262 1 62 WP_379819463.1 hypothetical protein [Flavobacterium suzhouense] diamond 186 129 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium suzhouense
30030998 30030998 PRJNA720429_P_NODE_4771_length_243_cov_0.905882_g4714_i0 PRJNA720429 4771 243 0.905882 2.20129326 Flavobacterium 237 Bacteria Bacteria 154 6.059999999999998e-43   NR WP_293890085.1 239 g4714 i0 96.3 3 81 3 100 0 1 243 259 339 WP_293890085.1 hemolysin family protein [Flavobacterium sp.] diamond 729 155 0.993548387096774 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
30305281 30305281 PRJNA720429_P_NODE_4832_length_242_cov_0.911243_g4775_i0 PRJNA720429 4832 242 0.911243 2.20520806 Bacteroidota bacterium 1898104 Bacteria Bacteria 87 4.98e-18   NR MES2132722.1 1898104 g4775 i0 52.5 0.991735537190083 80 38 99.2 0 241 2 45 124 MES2132722.1 anthranilate synthase component I family protein [Bacteroidota bacterium] diamond 240 87 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31790240 31790240 PRJNA720429_P_NODE_3957_length_247_cov_0.885057_g3900_i0 PRJNA720429 3957 247 0.885057 2.18609079 Siphonobacter aquaeclarae 563176 Bacteria Bacteria 135 6.07e-36   NR WP_093197873.1 563176 g3900 i0 98.5 0.813765182186235 67 1 81.4 0 202 2 1 67 WP_093197873.1 MFS transporter [Siphonobacter aquaeclarae] diamond 201 135 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae Siphonobacter Siphonobacter aquaeclarae
31790241 31790241 PRJNA720429_P_NODE_4777_length_243_cov_0.905882_g4720_i0 PRJNA720429 4777 243 0.905882 2.20129326 Phnomibacter sp. 2836217 Bacteria Bacteria 103 1.03e-23   NR HSR37331.1 2836217 g4720 i0 66.3 2.95061728395062 80 27 98.8 0 242 3 9 88 HSR37331.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Phnomibacter sp.] diamond 717 103 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Phnomibacter Phnomibacter sp.
32360240 32360240 PRJNA720429_P_NODE_4799_length_242_cov_1.822485_g4742_i0 PRJNA720429 4799 242 1.822485 4.4104137 Pontibacter harenae 2894083 Bacteria Bacteria 148 4.85e-43   NR WP_229970633.1 2894083 g4742 i0 90 0.991735537190083 80 8 99.2 0 241 2 63 142 WP_229970633.1 nitroreductase family protein [Pontibacter harenae] diamond 240 148 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Pontibacter Pontibacter harenae
32360241 32360241 PRJNA720429_P_NODE_5099_length_241_cov_0.916667_g5042_i0 PRJNA720429 5099 241 0.916667 2.20916747 Prevotella sp. 59823 Bacteria Bacteria 59.7 2.69e-8   NR MBM6993954.1 59823 g5042 i0 90 1.12033195020747 30 3 37.3 0 152 241 1 30 MBM6993954.1 AMP-binding protein [Prevotella sp.] diamond 270 59.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp.
32518417 32518417 PRJNA720429_P_NODE_4339_length_245_cov_0.895349_g4282_i0 PRJNA720429 4339 245 0.895349 2.19360505 Siphonobacter aquaeclarae 563176 Bacteria Bacteria 162 7.64e-48   NR MBO9636807.1 563176 g4282 i0 100 0.991836734693878 81 0 99.2 0 244 2 13 93 MBO9636807.1 ABC transporter permease [Siphonobacter aquaeclarae] diamond 243 162 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae Siphonobacter Siphonobacter aquaeclarae
32623185 32623185 PRJNA720429_P_NODE_2800_length_265_cov_1.208333_g2743_i0 PRJNA720429 2800 265 1.208333 3.20208245 Bacteroidota 976 Bacteria Bacteria 153 5.82e-41   NR WP_095165802.1 1509483 g2743 i0 98.6 1.60754716981132 71 1 80.4 0 265 53 348 418 WP_095165802.1 cellulose binding domain-containing protein [Flectobacillus sp. BAB-3569] diamond 426 153 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569

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