RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA446034" and tax_phylum = "Fusobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fusobacteriota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA446034 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
1713088 1713088 PRJNA446034_S_NODE_47902_length_185_cov_4.695946_g47865_i0 PRJNA446034 47902 185 4.695946 8.6875001 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 107 2.62e-25   NR WP_021767204.1 712359 g47865 i0 98.3 0.972972972972973 60 1 97.3 0 180 1 32 91 WP_021767204.1 ShlB/FhaC/HecB family hemolysin secretion/activation protein [Leptotrichia sp. oral taxon 215] diamond 180 107 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
2989115 2989115 PRJNA446034_S_NODE_97783_length_156_cov_3.025210_g97746_i0 PRJNA446034 97783 156 3.02521 4.7193276 Fusobacterium massiliense 1852365 Bacteria Bacteria 102 5.91e-24   NR WP_074016034.1 1852365 g97746 i0 100 1 52 0 100 0 156 1 162 213 WP_074016034.1 cobyric acid synthase [Fusobacterium massiliense] diamond 156 102 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium massiliense
26696048 26696048 PRJNA446034_S_NODE_11161_length_256_cov_3.625571_g11124_i0 PRJNA446034 11161 256 3.625571 9.28146176 Fusobacterium periodonticum 860 Bacteria Bacteria 134 3.9e-34   NR WP_008794588.1 860 g11124 i0 80.7 4.86328125 83 16 97.3 0 255 7 1245 1327 WP_008794588.1 autotransporter-associated N-terminal domain-containing protein [Fusobacterium periodonticum] diamond 1245 134 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
26949377 26949377 PRJNA446034_S_NODE_42482_length_190_cov_7.228758_g42445_i0 PRJNA446034 42482 190 7.228758 13.7346402 Leptotrichia sp. 104608 Bacteria Bacteria 121 1.2399999999999998e-31   NR MBF1333528.1 104608 g42445 i0 100 0.978947368421053 62 0 97.9 0 188 3 117 178 MBF1333528.1 GTP cyclohydrolase II [Leptotrichia sp.] diamond 186 121 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
27012701 27012701 PRJNA446034_S_NODE_45162_length_188_cov_1.966887_g45125_i0 PRJNA446034 45162 188 1.966887 3.69774756 Leptotrichia sp. 104608 Bacteria Bacteria 122 1.24e-32   NR MBF1333943.1 104608 g45125 i0 93.5 1.97872340425532 62 4 98.9 0 3 188 147 208 MBF1333943.1 hypothetical protein [Leptotrichia sp.] diamond 372 122 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
27455456 27455456 PRJNA446034_S_NODE_90223_length_159_cov_3.393443_g90186_i0 PRJNA446034 90223 159 3.393443 5.39557437 uncultured Fusobacterium sp. 159267 Bacteria Bacteria 97.8 7.399999999999998e-25   NR WP_177161494.1 159267 g90186 i0 94.2 0.981132075471698 52 3 98.1 0 4 159 13 64 WP_177161494.1 PTS sugar transporter subunit IIB [uncultured Fusobacterium sp.] diamond 156 97.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium uncultured Fusobacterium sp.
27518416 27518416 PRJNA446034_S_NODE_106763_length_153_cov_1.646552_g106726_i0 PRJNA446034 106763 153 1.646552 2.51922456 Leptotrichia sp. 104608 Bacteria Bacteria 58.5 3.13e-9   NR MBF1337657.1 104608 g106726 i0 100 0.490196078431373 25 0 49 0 77 3 1 25 MBF1337657.1 transporter [Leptotrichia sp.] diamond 75 58.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
27518441 27518441 PRJNA446034_S_NODE_96383_length_157_cov_0.900000_g96346_i0 PRJNA446034 96383 157 0.9 1.413 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 84.7 1.86e-17   NR WP_053392952.1 712357 g96346 i0 90.7 1.79617834394904 43 4 82.2 0 129 1 311 353 WP_053392952.1 LptA/OstA family protein [Leptotrichia sp. oral taxon 212] diamond 282 84.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
27708281 27708281 PRJNA446034_S_NODE_1584_length_404_cov_7.076294_g1547_i0 PRJNA446034 1584 404 7.076294 28.58822776 Fusobacteriota bacterium 2060921 Bacteria Bacteria 56.2 1.11e-6   NR MEN9439199.1 2060921 g1547 i0 46.6 0.430693069306931 58 30 43.1 1 387 214 107 163 MEN9439199.1 hypothetical protein [Fusobacteriota bacterium] diamond 174 56.2 1 Bacteria   Fusobacteriati Fusobacteriota         Fusobacteriota bacterium
27865583 27865583 PRJNA446034_S_NODE_98325_length_156_cov_2.067227_g98288_i0 PRJNA446034 98325 156 2.067227 3.22487412 Pseudoleptotrichia goodfellowii 157692 Bacteria Bacteria 85.9 5.45e-18   NR WP_026737640.1 157692 g98288 i0 82.4 1.96153846153846 51 9 98.1 0 154 2 295 345 WP_026737640.1 TolC family protein [Pseudoleptotrichia goodfellowii] diamond 306 85.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Pseudoleptotrichia Pseudoleptotrichia goodfellowii
28560472 28560472 PRJNA446034_S_NODE_77987_length_165_cov_2.335938_g77950_i0 PRJNA446034 77987 165 2.335938 3.8542977 Fusobacterium nucleatum 851 Bacteria Bacteria 100 6.22e-24   NR WP_338983488.1 851 g77950 i0 87 0.981818181818182 54 7 98.2 0 3 164 84 137 WP_338983488.1 hypothetical protein [Fusobacterium nucleatum] diamond 162 100 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
29176713 29176713 PRJNA446034_S_NODE_109969_length_152_cov_1.339130_g109932_i0 PRJNA446034 109969 152 1.33913 2.0354776 Leptotrichiaceae 1129771 Bacteria Bacteria 90.1 4.48e-20   NR WP_196758486.1 34105 g109932 i0 80 3.92763157894737 50 10 98.7 0 151 2 196 245 WP_196758486.1 tRNA 2-thiocytidine biosynthesis TtcA family protein [Streptobacillus moniliformis] diamond 597 90.9 0.991199119911991 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
30802702 30802702 PRJNA446034_S_NODE_113854_length_150_cov_6.371681_g113817_i0 PRJNA446034 113854 150 6.371681 9.5575215 Pseudostreptobacillus hongkongensis 1162717 Bacteria Bacteria 99 1.68e-22   NR WP_314010915.1 1162717 g113817 i0 94 1.98 50 3 100 0 150 1 318 367 WP_314010915.1 DNA-directed RNA polymerase subunit beta, partial [Pseudostreptobacillus hongkongensis] diamond 297 99 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Pseudostreptobacillus Pseudostreptobacillus hongkongensis

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