RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1013345" and tax_phylum = "Fusobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fusobacteriota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1013345 · 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
6536531 6536531 PRJNA1013345_P_NODE_25366_length_163_cov_0.879310_g25236_i0 PRJNA1013345 25366 163 0.87931 1.4332753 Fusobacterium periodonticum 860 Bacteria Bacteria 95.9 2.42e-21   NR WP_008820706.1 860 g25236 i0 94.2 0.957055214723926 52 3 95.7 0 156 1 271 322 WP_008820706.1 autotransporter-associated N-terminal domain-containing protein [Fusobacterium periodonticum] diamond 156 95.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
27319465 27319465 PRJNA1013345_P_NODE_16703_length_179_cov_0.901515_g16573_i0 PRJNA1013345 16703 179 0.901515 1.61371185 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 108 1.93e-26   NR WP_099986492.1 2663009 g16573 i0 94.9 0.988826815642458 59 3 98.9 0 177 1 201 259 WP_099986492.1 macro domain-containing protein [Fusobacterium pseudoperiodonticum] diamond 177 108 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
29340256 29340256 PRJNA1013345_P_NODE_9729_length_206_cov_3.371069_g9599_i0 PRJNA1013345 9729 206 3.371069 6.94440214 uncultured Leptotrichia sp. 159271 Bacteria Bacteria 44.7 0.00192   NR WP_299573009.1 159271 g9599 i0 66.7 0.436893203883495 30 10 43.7 0 203 114 99 128 WP_299573009.1 hypothetical protein [uncultured Leptotrichia sp.] diamond 90 44.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia uncultured Leptotrichia sp.
29592349 29592349 PRJNA1013345_P_NODE_23350_length_165_cov_0.864407_g23220_i0 PRJNA1013345 23350 165 0.864407 1.42627155 Fusobacterium polymorphum 76857 Bacteria Bacteria 90.5 1.23e-19   NR WP_324284442.1 76857 g23220 i0 98.1 0.981818181818182 54 1 98.2 0 3 164 152 205 WP_324284442.1 murein hydrolase activator EnvC [Fusobacterium polymorphum] diamond 162 90.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
30540372 30540372 PRJNA1013345_P_NODE_15313_length_182_cov_1.162963_g15183_i0 PRJNA1013345 15313 182 1.162963 2.11659266 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 43.5 0.00829   NR WP_021767952.1 712359 g15183 i0 56.8 0.725274725274725 44 18 70.9 1 130 2 5 48 WP_021767952.1 hypothetical protein [Leptotrichia sp. oral taxon 215] diamond 132 43.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
31290886 31290886 PRJNA1013345_P_NODE_16415_length_179_cov_1.833333_g16285_i0 PRJNA1013345 16415 179 1.833333 3.28166607 Leptotrichia 32067 Bacteria Bacteria 101 1.05e-24   NR WP_146996107.1 109328 g16285 i0 81.4 1.9608938547486 59 11 98.9 0 177 1 40 98 WP_146996107.1 class I SAM-dependent methyltransferase [Leptotrichia trevisanii] diamond 351 101 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia trevisanii
31457078 31457078 PRJNA1013345_P_NODE_26296_length_162_cov_1.330435_g26166_i0 PRJNA1013345 26296 162 1.330435 2.1553047 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 69.3 4.72e-13   NR WP_053392652.1 712357 g26166 i0 82.4 0.944444444444444 51 7 94.4 2 160 8 25 73 WP_053392652.1 FAD-I family protein [Leptotrichia sp. oral taxon 212] diamond 153 69.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
31804779 31804779 PRJNA1013345_P_NODE_13357_length_186_cov_1.827338_g13227_i0 PRJNA1013345 13357 186 1.827338 3.39884868 Leptotrichia wadei 157687 Bacteria Bacteria 121 6.32e-31   NR WP_196805541.1 157687 g13227 i0 98.4 0.983870967741935 61 1 98.4 0 184 2 128 188 WP_196805541.1 hypothetical protein [Leptotrichia wadei] diamond 183 121 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
31962986 31962986 PRJNA1013345_P_NODE_8178_length_221_cov_1.436782_g8048_i0 PRJNA1013345 8178 221 1.436782 3.17528822 Leptotrichia sp. oral taxon 218 712361 Bacteria Bacteria 55.8 1.06e-7   NR WP_211615455.1 712361 g8048 i0 36.1 0.97737556561086 72 39 88.2 2 216 22 60 131 WP_211615455.1 hypothetical protein [Leptotrichia sp. oral taxon 218] diamond 216 55.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 218
32374539 32374539 PRJNA1013345_P_NODE_33959_length_151_cov_2.701923_g33829_i0 PRJNA1013345 33959 151 2.701923 4.07990373 Leptotrichia sp. OH362 104608 Bacteria Bacteria 79.3 1.29e-15   NR WP_125236420.1 2491048 g33829 i0 74 1.98675496688742 50 13 99.3 0 151 2 339 388 WP_125236420.1 TrbI/VirB10 family protein [Leptotrichia sp. OH3620_COT-345] diamond 300 79.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. OH3620_COT-345
32398361 32398361 PRJNA1013345_P_NODE_29739_length_159_cov_0.910714_g29609_i0 PRJNA1013345 29739 159 0.910714 1.44803526 Leptotrichia 32067 Bacteria Bacteria 106 3.63e-25   NR MBF1333656.1 104608 g29609 i0 96.2 1.9622641509434 52 2 98.1 0 157 2 450 501 MBF1333656.1 single-stranded-DNA-specific exonuclease RecJ [Leptotrichia sp.] diamond 312 106 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
32493309 32493309 PRJNA1013345_P_NODE_23259_length_165_cov_1.296610_g23129_i0 PRJNA1013345 23259 165 1.29661 2.1394065 Fusobacterium 848 Bacteria Bacteria 105 7.73e-25   NR WP_008820706.1 860 g23129 i0 94.5 5 55 3 100 0 165 1 1839 1893 WP_008820706.1 autotransporter-associated N-terminal domain-containing protein [Fusobacterium periodonticum] diamond 825 105 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum

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