RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA734348" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 5 ✖

bioproject 1

  • PRJNA734348 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
4546884 4546884 PRJNA734348_P_NODE_51264_length_289_cov_0.814815_g50567_i0 PRJNA734348 51264 289 0.814815 2.35481535 Fusobacterium massiliense 1852365 Bacteria Bacteria 174 3.98e-50   NR WP_074016353.1 1852365 g50567 i0 96.6 0.913494809688581 88 3 91.3 0 24 287 1 88 WP_074016353.1 cysteine--tRNA ligase [Fusobacterium massiliense] diamond 264 174 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium massiliense
15225366 15225366 PRJNA734348_P_NODE_106952_length_247_cov_1.477011_g106254_i0 PRJNA734348 106952 247 1.477011 3.64821717 Pseudostreptobacillus hongkongensis 1162717 Bacteria Bacteria 150 1.86e-44   NR WP_314011638.1 1162717 g106254 i0 91.5 0.995951417004049 82 7 99.6 0 247 2 54 135 WP_314011638.1 hypothetical protein, partial [Pseudostreptobacillus hongkongensis] diamond 246 150 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Pseudostreptobacillus Pseudostreptobacillus hongkongensis
27873683 27873683 PRJNA734348_P_NODE_130385_length_241_cov_3.220238_g129687_i0 PRJNA734348 130385 241 3.220238 7.76077358 uncultured Fusobacterium sp. 159267 Bacteria Bacteria 136 1.0899999999999998e-37   NR WP_293958059.1 159267 g129687 i0 95.9 0.921161825726141 74 3 92.1 0 240 19 199 272 WP_293958059.1 dihydropteroate synthase [uncultured Fusobacterium sp.] diamond 222 136 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium uncultured Fusobacterium sp.
32339127 32339127 PRJNA734348_P_NODE_122199_length_243_cov_2.670588_g121501_i0 PRJNA734348 122199 243 2.670588 6.48952884 Leptotrichia 32067 Bacteria Bacteria 174 7.870000000000002e-51   NR MBF1333389.1 104608 g121501 i0 98.8 1.97530864197531 80 1 98.8 0 242 3 61 140 MBF1333389.1 ShlB/FhaC/HecB family hemolysin secretion/activation protein [Leptotrichia sp.] diamond 480 174 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
32518832 32518832 PRJNA734348_P_NODE_97379_length_250_cov_0.870056_g96681_i0 PRJNA734348 97379 250 0.870056 2.17514 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 144 2.44e-39   NR WP_053393504.1 712357 g96681 i0 88.9 0.972 81 9 97.2 0 3 245 177 257 WP_053393504.1 exopolysaccharide biosynthesis polyprenyl glycosylphosphotransferase [Leptotrichia sp. oral taxon 212] diamond 243 144 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);;