RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 12 ✖

bioproject 1

  • PRJNA946307 · 12 ✖

analysis 1

  • diamond · 12 ✖

tax_clade 0

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
25154414 25154414 PRJNA946307_P_NODE_97520_length_185_cov_2.169118_g96646_i0 PRJNA946307 97520 185 2.169118 4.0128683 Leptotrichia sp. oral taxon 223 712363 Bacteria Bacteria 105 8.02e-25   NR WP_178936806.1 712363 g96646 i0 100 0.908108108108108 56 0 90.8 0 15 182 123 178 WP_178936806.1 PTS sugar transporter subunit IIC [Leptotrichia sp. oral taxon 223] diamond 168 105 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 223
26842425 26842425 PRJNA946307_P_NODE_52881_length_210_cov_2.956522_g52007_i0 PRJNA946307 52881 210 2.956522 6.2086962 Bacteria 2 Bacteria Bacteria 58.5 5.64e-8   NR WP_078692710.1 180163 g52007 i0 96.4 4.85714285714286 28 1 40 0 112 195 171 198 WP_078692710.1 pseudouridine-5'-phosphate glycosidase [Cetobacterium ceti] diamond 1020 58.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium ceti
28572914 28572914 PRJNA946307_P_NODE_45087_length_210_cov_5.565217_g44213_i0 PRJNA946307 45087 210 5.565217 11.6869557 Fusobacterium mortiferum 850 Bacteria Bacteria 43.5 0.00198   NR MBM6691450.1 850 g44213 i0 64.3 0.4 28 9 38.6 1 17 97 42 69 MBM6691450.1 hypothetical protein [Fusobacterium mortiferum] diamond 84 43.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium mortiferum
28730861 28730861 PRJNA946307_P_NODE_172047_length_154_cov_2.695238_g171173_i0 PRJNA946307 172047 154 2.695238 4.15066652 Pseudostreptobacillus hongkongensis 1162717 Bacteria Bacteria 67 8.73e-12   NR WP_066895502.1 1162717 g171173 i0 76.1 0.896103896103896 46 11 89.6 0 140 3 73 118 WP_066895502.1 (d)CMP kinase [Pseudostreptobacillus hongkongensis] diamond 138 67 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Pseudostreptobacillus Pseudostreptobacillus hongkongensis
28888605 28888605 PRJNA946307_P_NODE_23928_length_262_cov_5.427230_g23054_i0 PRJNA946307 23928 262 5.42723 14.2193426 Leptotrichia hofstadii 157688 Bacteria Bacteria 159 1.48e-45   NR MFC2542598.1 157688 g23054 i0 100 0.938931297709924 82 0 93.9 0 14 259 42 123 MFC2542598.1 ABC transporter substrate-binding protein [Leptotrichia hofstadii] diamond 246 159 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hofstadii
29677656 29677656 PRJNA946307_P_NODE_168990_length_157_cov_2.500000_g168116_i0 PRJNA946307 168990 157 2.5 3.925 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 84.7 5.54e-20   NR WP_053392936.1 712357 g168116 i0 89.4 0.898089171974522 47 5 89.8 0 16 156 9 55 WP_053392936.1 hypothetical protein [Leptotrichia sp. oral taxon 212] diamond 141 84.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
29740871 29740871 PRJNA946307_P_NODE_156610_length_163_cov_1.701754_g155736_i0 PRJNA946307 156610 163 1.701754 2.77385902 Streptobacillus moniliformis 34105 Bacteria Bacteria 68.6 5.02e-12   NR WP_064579536.1 34105 g155736 i0 70 1.84049079754601 50 15 92 0 163 14 197 246 WP_064579536.1 undecaprenyl-diphosphate phosphatase [Streptobacillus moniliformis] diamond 300 68.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
30246862 30246862 PRJNA946307_P_NODE_73372_length_198_cov_3.463087_g72498_i0 PRJNA946307 73372 198 3.463087 6.85691226 Leptotrichia sp. 104608 Bacteria Bacteria 65.9 1.97e-11   NR MBF1334125.1 104608 g72498 i0 90.6 0.484848484848485 32 3 48.5 0 8 103 99 130 MBF1334125.1 carbamoylphosphate synthase large subunit [Leptotrichia sp.] diamond 96 65.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
30758863 30758863 PRJNA946307_P_NODE_136554_length_168_cov_2.302521_g135680_i0 PRJNA946307 136554 168 2.302521 3.86823528 Bacteria 2 Bacteria Bacteria 69.3 5.56e-12   NR WP_235246221.1 848 g135680 i0 89.5 5.66071428571429 38 4 67.9 0 48 161 461 498 WP_235246221.1 MULTISPECIES: gamma-glutamyltransferase [Fusobacterium] diamond 951 69.7 0.994261119081779 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium  
31542454 31542454 PRJNA946307_P_NODE_146756_length_165_cov_3.982759_g145882_i0 PRJNA946307 146756 165 3.982759 6.57155235 Fusobacterium hwasookii 1583098 Bacteria Bacteria 72.4 4.41e-13   NR WP_315284430.1 1583098 g145882 i0 97.4 0.709090909090909 39 1 70.9 0 35 151 230 268 WP_315284430.1 autotransporter-associated N-terminal domain-containing protein [Fusobacterium hwasookii] diamond 117 72.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium hwasookii
32245360 32245360 PRJNA946307_P_NODE_107838_length_180_cov_4.938931_g106964_i0 PRJNA946307 107838 180 4.938931 8.8900758 Fusobacterium 848 Bacteria Bacteria 97.1 1.18e-21   NR MBF1204772.1 860 g106964 i0 100 3.53333333333333 53 0 88.3 0 173 15 507 559 MBF1204772.1 autotransporter adhesin [Fusobacterium periodonticum] diamond 636 97.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
32901085 32901085 PRJNA946307_P_NODE_51200_length_210_cov_3.385093_g50326_i0 PRJNA946307 51200 210 3.385093 7.1086953 Fusobacterium sp. 68766 Bacteria Bacteria 64.7 4.3e-10   NR WP_410207774.1 68766 g50326 i0 81.3 5.94285714285714 32 6 45.7 0 4 99 229 260 WP_410207774.1 L-lysine 2,3-aminomutase [Fusobacterium sp.] diamond 1248 64.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium 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);;