RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA835051" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 11 ✖

bioproject 1

  • PRJNA835051 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
5928698 5928698 PRJNA835051_S_NODE_126885_length_153_cov_0.872727_g126589_i0 PRJNA835051 126885 153 0.872727 1.33527231 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 283 4.0799999999999995e-72   NTclustered gi|1276718681|gb|CP024704.1| 2663009 g126589 i0 100 12 153 0 100 0 1 153 1509637 1509789 Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome blastn 1836 283 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
9753880 9753880 PRJNA835051_S_NODE_28228_length_254_cov_1.772512_g27932_i0 PRJNA835051 28228 254 1.772512 4.50218048 Leptotrichia hofstadii 157688 Bacteria Bacteria 370 5.61e-98   NTclustered gi|1708566027|dbj|AP019823.1| 157688 g27932 i0 92.913 151.877952755906 254 18 100 0 1 254 498031 497778 Leptotrichia hofstadii JCM16775 DNA, complete genome blastn 38577 370 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hofstadii
11029395 11029395 PRJNA835051_S_NODE_134269_length_150_cov_0.859813_g133973_i0 PRJNA835051 134269 150 0.859813 1.2897195 Fusobacterium nucleatum 851 Bacteria Bacteria 272 8.609999999999998e-69   NTclustered gi|2705028265|gb|CP084135.1| 851 g133973 i0 99.333 496.866666666667 150 1 100 0 1 150 158297 158148 Fusobacterium nucleatum strain KCOM3363 chromosome, complete genome blastn 74530 272 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
11433303 11433303 PRJNA835051_S_NODE_48249_length_219_cov_1.875000_g47953_i0 PRJNA835051 48249 219 1.875 4.10625 Fusobacterium 848 Bacteria Bacteria 405 1.29e-108   NTclustered gi|1370537877|gb|CP028108.1| 860 g47953 i0 100 472 219 0 100 0 1 219 462707 462489 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 103368 405 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
13579521 13579521 PRJNA835051_S_NODE_35091_length_240_cov_1.670051_g34795_i0 PRJNA835051 35091 240 1.670051 4.0081224 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 316 6.929999999999998e-82   NTclustered gi|922689899|gb|CP012410.1| 712357 g34795 i0 90.456 85.3458333333333 241 21 100 2 1 240 51779 52018 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 20483 316 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
16532058 16532058 PRJNA835051_S_NODE_20653_length_274_cov_2.177489_g20357_i0 PRJNA835051 20653 274 2.177489 5.96631986 Fusobacterium 848 Bacteria Bacteria 507 4.47e-139   NTclustered gi|1370537877|gb|CP028108.1| 860 g20357 i0 100 48.1313868613139 274 0 100 0 1 274 170775 171048 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 13188 507 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
17404779 17404779 PRJNA835051_S_NODE_79854_length_185_cov_1.154930_g79558_i0 PRJNA835051 79854 185 1.15493 2.1366205 Fusobacterium gastrosuis 1755100 Bacteria Bacteria 52.8 0.016   NTclustered gi|1795735174|emb|LT607734.1| 1755100 g79558 i0 100 0.151351351351351 28 0 15 0 145 172 466821 466848 Fusobacterium sp. P6 Po strain Fusobacterium gastrosuis sp. nov. CDW1, P6 Po genome assembly, chromosome: chr blastn 28 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium gastrosuis
18677750 18677750 PRJNA835051_S_NODE_71095_length_193_cov_0.980000_g70799_i0 PRJNA835051 71095 193 0.98 1.8914 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 346 6.82e-91   NTclustered gi|2704959642|gb|CP077196.1| 2663009 g70799 i0 98.969 16.0829015544041 194 1 100 1 1 193 1999062 1998869 Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome blastn 3104 346 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
19081179 19081179 PRJNA835051_S_NODE_60235_length_204_cov_1.757764_g59939_i0 PRJNA835051 60235 204 1.757764 3.58583856 Fusobacterium 848 Bacteria Bacteria 375 9.3e-100   NTclustered gi|2573686249|gb|CP133474.1| 851 g59939 i0 100 99.8872549019608 203 0 99 0 1 203 1548242 1548444 Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome blastn 20377 377 0.994694960212202 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
24181230 24181230 PRJNA835051_S_NODE_6899_length_356_cov_14.760383_g6603_i0 PRJNA835051 6899 356 14.760383 52.54696348 Fusobacterium 848 Bacteria Bacteria 52.8 0.034   NTclustered gi|2704996929|gb|CP077149.1| 851 g6603 i0 100 0.314606741573034 28 0 8 0 312 339 581516 581543 Fusobacterium nucleatum strain KCOM2013 chromosome, complete genome blastn 112 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
24181264 24181264 PRJNA835051_S_NODE_79339_length_185_cov_1.985915_g79043_i0 PRJNA835051 79339 185 1.985915 3.67394275 Fusobacterium 848 Bacteria Bacteria 52.8 0.016   NTclustered gi|2706407748|gb|CP077116.1| 76857 g79043 i0 96.774 4.61621621621622 31 1 17 0 77 107 2160452 2160422 Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome blastn 854 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum

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