RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA546018" 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

  • PRJNA546018 · 7 ✖

analysis 1

  • blastn · 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
5614931 5614931 PRJNA546018_S_NODE_4265_length_892_cov_13.102286_g4044_i0 PRJNA546018 4265 892 13.102286 116.87239112 Leptotrichia hongkongensis 554406 Bacteria Bacteria 1594 0   NTclustered gi|1708587163|dbj|AP019846.1| 554406 g4044 i0 99.77 481.816143497758 870 1 98 1 1 870 1994077 1994945 Leptotrichia hongkongensis JMUB5056 DNA, complete genome blastn 429780 1594 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
9439109 9439109 PRJNA546018_S_NODE_21148_length_350_cov_7.273356_g20823_i0 PRJNA546018 21148 350 7.273356 25.456746 Leptotrichia sp. HMT-225 3058373 Bacteria Bacteria 575 1.5899999999999994e-159   NTclustered gi|2557559843|gb|CP130323.1| 3058373 g20823 i0 98.182 136.714285714286 330 4 94 1 23 350 196846 197175 Leptotrichia sp. HMT-225 chromosome, complete genome blastn 47850 575 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. HMT-225
13873054 13873054 PRJNA546018_S_NODE_26451_length_309_cov_1.302419_g26126_i0 PRJNA546018 26451 309 1.302419 4.02447471 Leptotrichia 32067 Bacteria Bacteria 531 3.0399999999999998e-146   NTclustered gi|1708575239|dbj|AP019834.1| 157687 g26126 i0 100 8.83495145631068 287 0 93 0 1 287 1522704 1522418 Leptotrichia wadei JMUB3933 DNA, complete genome blastn 2730 531 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
18362274 18362274 PRJNA546018_S_NODE_16995_length_399_cov_1.923077_g16670_i0 PRJNA546018 16995 399 1.923077 7.67307723 Leptotrichia hofstadii 157688 Bacteria Bacteria 680 0   NTclustered gi|1708566027|dbj|AP019823.1| 157688 g16670 i0 99.204 5.70927318295739 377 3 94 0 23 399 1078762 1078386 Leptotrichia hofstadii JCM16775 DNA, complete genome blastn 2278 680 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hofstadii
18362940 18362940 PRJNA546018_S_NODE_57155_length_202_cov_2.702128_g56830_i0 PRJNA546018 57155 202 2.702128 5.45829856 Leptotrichia sp. oral taxon 221 712362 Bacteria Bacteria 350 5.57e-92   NTclustered gi|2028889048|gb|CP072378.1| 712362 g56830 i0 100 378.30198019802 189 0 94 0 14 202 25509 25321 Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome blastn 76417 350 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 221
21521233 21521233 PRJNA546018_S_NODE_25597_length_314_cov_4.063241_g25272_i0 PRJNA546018 25597 314 4.063241 12.75857674 Fusobacterium 848 Bacteria Bacteria 544 3.98e-150   NTclustered gi|2444100754|gb|CP117525.1| 851 g25272 i0 100 93.6337579617834 294 0 94 0 1 294 954149 954442 Fusobacterium nucleatum strain FNV chromosome, complete genome blastn 29401 544 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
22796557 22796557 PRJNA546018_S_NODE_57958_length_200_cov_5.230216_g57633_i0 PRJNA546018 57958 200 5.230216 10.460432 Fusobacterium 848 Bacteria Bacteria 342 9.209999999999999e-90   NTclustered gi|2704983719|gb|CP077132.1| 851 g57633 i0 100 429.265 185 0 96 0 7 191 91816 91632 Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome blastn 85853 344 0.994186046511628 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum

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