RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA316313" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 16 ✖

bioproject 1

  • PRJNA316313 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
2343915 2343915 PRJNA316313_P_NODE_57122_length_250_cov_2.248826_g55736_i0 PRJNA316313 57122 250 2.248826 5.622065 Bacteria 2 Bacteria Bacteria 73.2 2.06e-14   NR WP_196762291.1 34105 g55736 i0 100 0.912 38 0 45.6 0 1 114 84 121 WP_196762291.1 terminase gpA endonuclease subunit, partial [Streptobacillus moniliformis] diamond 228 73.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
6765476 6765476 PRJNA316313_P_NODE_423606_length_151_cov_4.719298_g422220_i0 PRJNA316313 423606 151 4.719298 7.12613998 Leptotrichia 32067 Bacteria Bacteria 82 1.51e-16   NR WP_012806659.1 40542 g422220 i0 75.4 9.6953642384106 61 4 99.3 1 151 2 177 237 WP_012806659.1 PTS fructose transporter subunit IIABC [Leptotrichia buccalis] diamond 1464 82 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia buccalis
27408190 27408190 PRJNA316313_P_NODE_249323_length_187_cov_2.860000_g247937_i0 PRJNA316313 249323 187 2.86 5.3482 Leptotrichia 32067 Bacteria Bacteria 48.1 2.21e-4   NR WP_299574766.1 159271 g247937 i0 92 0.802139037433155 25 2 40.1 0 75 1 369 393 WP_299574766.1 subtype B tannase, partial [uncultured Leptotrichia sp.] diamond 150 48.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia uncultured Leptotrichia sp.
27516932 27516932 PRJNA316313_P_NODE_431843_length_151_cov_4.263158_g430457_i0 PRJNA316313 431843 151 4.263158 6.43736858 Fusobacterium perfoetens 852 Bacteria Bacteria 50.8 1.42e-5   NR WP_176828913.1 852 g430457 i0 80 1.19205298013245 30 5 59.6 1 60 149 251 279 WP_176828913.1 sodium/pantothenate symporter [Fusobacterium perfoetens] diamond 180 50.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium perfoetens
28874533 28874533 PRJNA316313_P_NODE_336608_length_185_cov_5.398649_g335222_i0 PRJNA316313 336608 185 5.398649 9.98750065 Fusobacterium russii 854 Bacteria Bacteria 51.2 1.74e-5   NR WP_022819206.1 854 g335222 i0 100 0.405405405405405 25 0 40.5 0 75 1 551 575 WP_022819206.1 TRAP transporter permease [Fusobacterium russii] diamond 75 51.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium russii
29001248 29001248 PRJNA316313_P_NODE_252068_length_187_cov_2.833333_g250682_i0 PRJNA316313 252068 187 2.833333 5.29833271 Fusobacterium russii 854 Bacteria Bacteria 49.3 8.84e-5   NR WP_022820025.1 854 g250682 i0 100 0.802139037433155 25 0 40.1 0 1 75 1408 1432 WP_022820025.1 PolC-type DNA polymerase III [Fusobacterium russii] diamond 150 49.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium russii
29018538 29018538 PRJNA316313_P_NODE_213128_length_187_cov_3.246667_g211742_i0 PRJNA316313 213128 187 3.246667 6.07126729 Leptotrichia 32067 Bacteria Bacteria 43.1 0.013   NR WP_374123782.1 554406 g211742 i0 72 0.802139037433155 25 7 40.1 0 187 113 32 56 WP_374123782.1 restriction endonuclease [Leptotrichia hongkongensis] diamond 150 43.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
29113051 29113051 PRJNA316313_P_NODE_402308_length_151_cov_8.052632_g400922_i0 PRJNA316313 402308 151 8.052632 12.15947432 FCB group 1783270 Bacteria Bacteria 47.8 1.83e-4   NR WP_078694576.1 180163 g400922 i0 92 13.4105960264901 25 2 49.7 0 75 1 579 603 WP_078694576.1 preprotein translocase subunit SecA [Cetobacterium ceti] diamond 2025 48.1 0.993762993762994 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium ceti
29885100 29885100 PRJNA316313_P_NODE_176171_length_187_cov_3.880000_g174785_i0 PRJNA316313 176171 187 3.88 7.2556 Fusobacterium hwasookii 1583098 Bacteria Bacteria 47.8 2.96e-4   NR WP_005918703.1 1583098 g174785 i0 33.3 1.39572192513369 87 29 93 1 6 179 773 859 WP_005918703.1 type I restriction-modification system endonuclease [Fusobacterium hwasookii] diamond 261 47.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium hwasookii
30123343 30123343 PRJNA316313_P_NODE_226852_length_187_cov_3.093333_g225466_i0 PRJNA316313 226852 187 3.093333 5.78453271 Bacteria 2 Bacteria Bacteria 47.4 1.93e-4   NR MBF1197983.1 860 g225466 i0 91.7 16.1711229946524 24 2 38.5 0 114 185 42 65 MBF1197983.1 tryptophanase [Fusobacterium periodonticum] diamond 3024 47.8 0.99163179916318 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
30169190 30169190 PRJNA316313_P_NODE_80172_length_222_cov_3.270270_g78786_i0 PRJNA316313 80172 222 3.27027 7.2599994 Streptobacillus moniliformis 34105 Bacteria Bacteria 64.3 2.16e-11   NR WP_196760930.1 34105 g78786 i0 100 0.418918918918919 31 0 41.9 0 93 1 36 66 WP_196760930.1 hypothetical protein, partial [Streptobacillus moniliformis] diamond 93 64.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
30264391 30264391 PRJNA316313_P_NODE_197352_length_187_cov_3.486667_g195966_i0 PRJNA316313 197352 187 3.486667 6.52006729 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 47 5.58e-4   NR WP_083437053.1 712357 g195966 i0 84 0.401069518716578 25 4 40.1 0 187 113 188 212 WP_083437053.1 YiiG family protein [Leptotrichia sp. oral taxon 212] diamond 75 47 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
30327775 30327775 PRJNA316313_P_NODE_258572_length_187_cov_2.753333_g257186_i0 PRJNA316313 258572 187 2.753333 5.14873271 Fusobacterium animalis 76859 Bacteria Bacteria 61.6 3.74e-9   NR WP_151198191.1 76859 g257186 i0 45.6 1.26737967914438 79 23 94.7 2 9 185 150 228 WP_151198191.1 autotransporter outer membrane beta-barrel domain-containing protein, partial [Fusobacterium animalis] diamond 237 61.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium animalis
31116894 31116894 PRJNA316313_P_NODE_179195_length_187_cov_3.813333_g177809_i0 PRJNA316313 179195 187 3.813333 7.13093271 Fusobacterium russii 854 Bacteria Bacteria 47.8 2.34e-4   NR WP_022818708.1 854 g177809 i0 96 0.401069518716578 25 1 40.1 0 113 187 30 54 WP_022818708.1 XRE family transcriptional regulator [Fusobacterium russii] diamond 75 47.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium russii
31306849 31306849 PRJNA316313_P_NODE_503935_length_150_cov_3.238938_g502549_i0 PRJNA316313 503935 150 3.238938 4.858407 Fusobacterium massiliense 1852365 Bacteria Bacteria 75.9 2.12e-14   NR WP_315523685.1 1852365 g502549 i0 54.9 1.42 71 10 98 1 148 2 421 491 WP_315523685.1 autotransporter-associated N-terminal domain-containing protein [Fusobacterium massiliense] diamond 213 75.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium massiliense
32603764 32603764 PRJNA316313_P_NODE_259780_length_187_cov_2.733333_g258394_i0 PRJNA316313 259780 187 2.733333 5.11133271 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 48.5 1.59e-4   NR WP_172673336.1 712357 g258394 i0 96 0.401069518716578 25 1 40.1 0 187 113 192 216 WP_172673336.1 DUF3829 domain-containing protein [Leptotrichia sp. oral taxon 212] diamond 75 48.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212

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