RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA473824" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 7 ✖

bioproject 1

  • PRJNA473824 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
26918083 26918083 PRJNA473824_P_NODE_89282_length_173_cov_3.095588_g88644_i0 PRJNA473824 89282 173 3.095588 5.35536724 Fusobacterium 848 Bacteria Bacteria 83.2 7.93e-17   NR WP_291281464.1 848 g88644 i0 63.2 3.95375722543353 76 9 98.8 1 172 2 376 451 WP_291281464.1 MULTISPECIES: HsdM family class I SAM-dependent methyltransferase [Fusobacterium] diamond 684 83.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium  
29570808 29570808 PRJNA473824_P_NODE_99670_length_173_cov_2.779412_g99032_i0 PRJNA473824 99670 173 2.779412 4.80838276 Fusobacterium hwasookii 1583098 Bacteria Bacteria 53.9 1.25e-6   NR WP_220281115.1 1583098 g99032 i0 91.7 1.2485549132948 24 2 41.6 0 1 72 55 78 WP_220281115.1 hypothetical protein [Fusobacterium hwasookii] diamond 216 53.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium hwasookii
30676414 30676414 PRJNA473824_P_NODE_59113_length_173_cov_4.977941_g58475_i0 PRJNA473824 59113 173 4.977941 8.61183793 Fusobacterium perfoetens 852 Bacteria Bacteria 53.1 3.06e-6   NR WP_235245633.1 852 g58475 i0 96 0.433526011560694 25 1 43.4 0 98 172 251 275 WP_235245633.1 ClC family H(+)/Cl(-) exchange transporter [Fusobacterium perfoetens] diamond 75 53.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium perfoetens
32337262 32337262 PRJNA473824_P_NODE_7999_length_481_cov_2.574324_g7413_i0 PRJNA473824 7999 481 2.574324 12.38249844 Bacteria 2 Bacteria Bacteria 126 1.99e-34   NR WP_196758639.1 34105 g7413 i0 98.5 1.81496881496882 67 1 41.8 0 481 281 29 95 WP_196758639.1 hypothetical protein, partial [Streptobacillus moniliformis] diamond 873 127 0.992125984251969 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
32495370 32495370 PRJNA473824_P_NODE_135979_length_152_cov_3.278261_g135341_i0 PRJNA473824 135979 152 3.278261 4.98295672 root 1 Root_unresolved Root_unresolved 41.6 0.00713   NR WP_187105728.1 859 g135341 i0 57.1 2.17105263157895 56 12 86.8 2 2 133 37 92 WP_187105728.1 hypothetical protein, partial [Fusobacterium necrophorum] diamond 330 41.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
32857311 32857311 PRJNA473824_P_NODE_166740_length_150_cov_3.991150_g166102_i0 PRJNA473824 166740 150 3.99115 5.986725 Leptotrichia wadei 157687 Bacteria Bacteria 97.1 7.61e-22   NR WP_314014586.1 157687 g166102 i0 100 0.98 49 0 98 0 149 3 2867 2915 WP_314014586.1 filamentous hemagglutinin N-terminal domain-containing protein [Leptotrichia wadei] diamond 147 97.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
32873335 32873335 PRJNA473824_P_NODE_60680_length_173_cov_4.764706_g60042_i0 PRJNA473824 60680 173 4.764706 8.24294138 Bacteria 2 Bacteria Bacteria 46.2 8.63e-4   NR KAB0578726.1 77917 g60042 i0 56.1 1.1271676300578 41 10 71.1 1 51 173 222 254 KAB0578726.1 aspartate ammonia-lyase [Fusobacterium naviforme] diamond 195 46.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium naviforme

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