RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB49404 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
5201021 5201021 PRJEB49404_P_NODE_248185_length_302_cov_1.840304_g234384_i0 PRJEB49404 248185 302 1.840304 5.55771808 Chitinophagaceae 563835 Bacteria Bacteria 168 6.749999999999999e-47   NR WP_325587243.1 2045100 g234384 i0 75 2.98013245033113 100 25 99.3 0 3 302 275 374 WP_325587243.1 glycoside hydrolase family 2 protein [Puia sp.] diamond 900 168 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Puia Puia sp.
15407793 15407793 PRJEB49404_P_NODE_391473_length_217_cov_2.022472_g377672_i0 PRJEB49404 391473 217 2.022472 4.38876424 Chitinophaga sp. 1869181 Bacteria Bacteria 92.4 8.79e-20   NR WP_325535649.1 1869181 g377672 i0 59.7 0.995391705069124 72 29 99.5 0 216 1 3024 3095 WP_325535649.1 non-ribosomal peptide synthetase [Chitinophaga sp.] diamond 216 92.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Chitinophaga Chitinophaga sp.
27222976 27222976 PRJEB49404_P_NODE_359963_length_231_cov_1.708333_g346162_i0 PRJEB49404 359963 231 1.708333 3.94624923 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 50.1 3.71e-5   NR RYY83660.1 1869212 g346162 i0 46.2 1.35064935064935 52 27 67.5 1 229 74 121 171 RYY83660.1 MAG: hypothetical protein EOO15_20955 [Chitinophagaceae bacterium] diamond 312 50.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
27286354 27286354 PRJEB49404_P_NODE_334143_length_244_cov_1.678049_g320342_i0 PRJEB49404 334143 244 1.678049 4.09443956 Bacteroidota bacterium 1898104 Bacteria Bacteria 48.9 2.39e-4   NR MEM1318645.1 1898104 g320342 i0 47.8 0.565573770491803 46 24 56.6 0 146 9 367 412 MEM1318645.1 polysaccharide deacetylase family protein [Bacteroidota bacterium] diamond 138 48.9 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28391575 28391575 PRJEB49404_P_NODE_614866_length_156_cov_2.581197_g601065_i0 PRJEB49404 614866 156 2.581197 4.02666732 Bacteroidota bacterium 1898104 Bacteria Bacteria 91.7 6.53e-20   NR MDE3056427.1 1898104 g601065 i0 84.3 2.94230769230769 51 8 98.1 0 2 154 649 699 MDE3056427.1 efflux RND transporter permease subunit [Bacteroidota bacterium] diamond 459 91.7 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28448207 28448207 PRJEB49404_P_NODE_370606_length_226_cov_1.754011_g356805_i0 PRJEB49404 370606 226 1.754011 3.96406486 Bacteria 2 Bacteria Bacteria 92 5.95e-21   NR WP_016274504.1 820 g356805 i0 100 1.71238938053097 43 0 57.1 0 224 96 177 219 WP_016274504.1 hypothetical protein, partial [Bacteroides uniformis] diamond 387 92 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Bacteroides Bacteroides uniformis
29016686 29016686 PRJEB49404_P_NODE_589548_length_161_cov_2.016393_g575747_i0 PRJEB49404 589548 161 2.016393 3.24639273 Polaribacter 52959 Bacteria Bacteria 44.3 0.00353   NR WP_105022673.1 102 g575747 i0 55.6 2.01242236024845 36 16 67.1 0 9 116 378 413 WP_105022673.1 TonB-dependent receptor [Polaribacter glomeratus] diamond 324 44.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Polaribacter Polaribacter glomeratus
29433206 29433206 PRJEB49404_P_NODE_430290_length_203_cov_1.054878_g416489_i0 PRJEB49404 430290 203 1.054878 2.14140234 Sphingobacteriales bacterium 2044944 Bacteria Bacteria 142 5.469999999999999e-40   NR MBN8856689.1 2044944 g416489 i0 100 0.990147783251232 67 0 99 0 3 203 78 144 MBN8856689.1 DNA polymerase III subunit epsilon [Sphingobacteriales bacterium] diamond 201 142 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales     Sphingobacteriales bacterium
29489806 29489806 PRJEB49404_P_NODE_532530_length_174_cov_0.911111_g518729_i0 PRJEB49404 532530 174 0.911111 1.58533314 Pseudomonadati 3379134 Bacteria Bacteria 45.8 0.00119   NR WP_040005850.1 663275 g518729 i0 44.2 5.1551724137931 52 27 86.2 1 17 166 546 597 WP_040005850.1 S9 family peptidase [Fibrisoma limi] diamond 897 45.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Fibrisoma Fibrisoma limi
29528332 29528332 PRJEB49404_P_NODE_463430_length_192_cov_1.607843_g449629_i0 PRJEB49404 463430 192 1.607843 3.08705856 Lacibacter cauensis 510947 Bacteria Bacteria 124 1.7299999999999999e-34   NR WP_144888756.1 510947 g449629 i0 95.3 1 64 3 100 0 192 1 7 70 WP_144888756.1 JAB domain-containing protein [Lacibacter cauensis] diamond 192 124 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Lacibacter Lacibacter cauensis
30096609 30096609 PRJEB49404_P_NODE_643072_length_151_cov_2.169643_g629271_i0 PRJEB49404 643072 151 2.169643 3.27616093 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 104 4.63e-26   NR MCA6440760.1 1869212 g629271 i0 100 0.973509933774834 49 0 97.4 0 149 3 22 70 MCA6440760.1 cupin domain-containing protein [Chitinophagaceae bacterium] diamond 147 104 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
30791795 30791795 PRJEB49404_P_NODE_541074_length_172_cov_1.007519_g527273_i0 PRJEB49404 541074 172 1.007519 1.73293268 Flavobacteriales bacterium 2021391 Bacteria Bacteria 42 0.0276   NR MFO0359999.1 2021391 g527273 i0 36.4 0.959302325581395 55 27 85.5 2 7 153 223 275 MFO0359999.1 hypothetical protein [Flavobacteriales bacterium] diamond 165 42 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales bacterium
30974806 30974806 PRJEB49404_P_NODE_377394_length_223_cov_1.885870_g363593_i0 PRJEB49404 377394 223 1.88587 4.2054901 Bacteria 2 Bacteria Bacteria 63.2 1.77e-9   NR MCC6395586.1 1898104 g363593 i0 61 2.23318385650224 41 16 55.2 0 3 125 430 470 MCC6395586.1 tetratricopeptide repeat protein [Bacteroidota bacterium] diamond 498 63.5 0.995275590551181 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31961633 31961633 PRJEB49404_P_NODE_580838_length_163_cov_1.637097_g567037_i0 PRJEB49404 580838 163 1.637097 2.66846811 Olivibacter sitiensis 376470 Bacteria Bacteria 62 1.94e-9   NR WP_281169879.1 376470 g567037 i0 64 2.79754601226994 50 18 92 0 155 6 582 631 WP_281169879.1 Ig-like domain-containing protein [Olivibacter sitiensis] diamond 456 62 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Olivibacter Olivibacter sitiensis
32025038 32025038 PRJEB49404_P_NODE_473898_length_189_cov_1.580000_g460097_i0 PRJEB49404 473898 189 1.58 2.9862 Hydrobacter penzbergensis 1235997 Bacteria Bacteria 77.4 5.61e-15   NR WP_092723688.1 1235997 g460097 i0 97.4 0.619047619047619 39 1 61.9 0 189 73 274 312 WP_092723688.1 efflux RND transporter periplasmic adaptor subunit [Hydrobacter penzbergensis] diamond 117 77.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Hydrobacter Hydrobacter penzbergensis
32056582 32056582 PRJEB49404_P_NODE_269078_length_285_cov_1.878049_g255277_i0 PRJEB49404 269078 285 1.878049 5.35243965 Sphingobacteriales bacterium 2044944 Bacteria Bacteria 182 5.73e-57   NR MBN8856722.1 2044944 g255277 i0 100 1 95 0 100 0 1 285 31 125 MBN8856722.1 hypothetical protein [Sphingobacteriales bacterium] diamond 285 182 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales     Sphingobacteriales bacterium
32246815 32246815 PRJEB49404_P_NODE_447638_length_197_cov_1.550633_g433837_i0 PRJEB49404 447638 197 1.550633 3.05474701 Hydrobacter penzbergensis 1235997 Bacteria Bacteria 137 2.56e-39   NR WP_092722684.1 1235997 g433837 i0 100 0.989847715736041 65 0 99 0 1 195 89 153 WP_092722684.1 GNAT family N-acetyltransferase [Hydrobacter penzbergensis] diamond 195 137 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Hydrobacter Hydrobacter penzbergensis

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