RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1031674" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 10 ✖

bioproject 1

  • PRJNA1031674 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
166503 166503 PRJNA1031674_P_NODE_10181_length_295_cov_1.513514_g9970_i0 PRJNA1031674 10181 295 1.513514 4.4648663 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 540 4.79e-149   NTclustered gi|922689899|gb|CP012410.1| 712357 g9970 i0 99.661 144.386440677966 295 1 100 0 1 295 51887 51593 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 42594 540 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
1006671 1006671 PRJNA1031674_P_NODE_10061_length_296_cov_2.591928_g9850_i0 PRJNA1031674 10061 296 2.591928 7.67210688 Fusobacterium 848 Bacteria Bacteria 542 1.34e-149   NTclustered gi|2706496642|gb|CP084152.1| 76857 g9850 i0 99.662 490.530405405405 296 1 100 0 1 296 626256 626551 Fusobacterium polymorphum strain KCOM2594 chromosome, complete genome blastn 145197 547 0.990859232175503 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
3993139 3993139 PRJNA1031674_P_NODE_1584_length_591_cov_3.783784_g1378_i0 PRJNA1031674 1584 591 3.783784 22.36216344 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 1092 0   NTclustered gi|1276709865|gb|CP024700.1| 2663009 g1378 i0 100 478.527918781726 591 0 100 0 1 591 258885 259475 Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome blastn 282810 1092 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
3993225 3993225 PRJNA1031674_P_NODE_21184_length_254_cov_1.701657_g20973_i0 PRJNA1031674 21184 254 1.701657 4.32220878 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 375 1.2e-99   NTclustered gi|922689899|gb|CP012410.1| 712357 g20973 i0 93.333 194.03937007874 255 16 100 1 1 254 52905 53159 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 49286 375 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
3993295 3993295 PRJNA1031674_P_NODE_25244_length_246_cov_0.890173_g25033_i0 PRJNA1031674 25244 246 0.890173 2.18982558 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 375 1.16e-99   NTclustered gi|922689899|gb|CP012410.1| 712357 g25033 i0 95.339 0.959349593495935 236 11 96 0 11 246 2404673 2404438 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 236 375 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
6544618 6544618 PRJNA1031674_P_NODE_11266_length_289_cov_1.421296_g11055_i0 PRJNA1031674 11266 289 1.421296 4.10754544 Leptotrichia sp. SK-5 3075818 Bacteria Bacteria 490 4.78e-134   NTclustered gi|2899356158|dbj|AP028931.1| 3075818 g11055 i0 97.232 3.97923875432526 289 8 100 0 1 289 1304122 1303834 Leptotrichia sp. SK-5 DNA, complete genome blastn 1150 490 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. SK-5
7819562 7819562 PRJNA1031674_P_NODE_8107_length_312_cov_1.493724_g7896_i0 PRJNA1031674 8107 312 1.493724 4.66041888 Leptotrichia wadei 157687 Bacteria Bacteria 577 3.89e-160   NTclustered gi|1708582457|dbj|AP019841.1| 157687 g7896 i0 100 237.403846153846 312 0 100 0 1 312 1756413 1756724 Leptotrichia wadei JMUB3936 DNA, complete genome blastn 74070 577 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
9094099 9094099 PRJNA1031674_P_NODE_10808_length_290_cov_2.073733_g10597_i0 PRJNA1031674 10808 290 2.073733 6.0138257 Leptotrichia trevisanii 109328 Bacteria Bacteria 267 8.81e-67   NTclustered gi|1708584775|dbj|AP019845.1| 109328 g10597 i0 98.667 10.1310344827586 150 2 99 0 1 150 1457614 1457465 Leptotrichia trevisanii JMUB4039 DNA, complete genome blastn 2938 267 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia trevisanii
15469464 15469464 PRJNA1031674_P_NODE_17213_length_269_cov_2.545918_g17002_i0 PRJNA1031674 17213 269 2.545918 6.84851942 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 464 2.67e-126   NTclustered gi|922689899|gb|CP012410.1| 712357 g17002 i0 97.77 23.4014869888476 269 6 100 0 1 269 51817 52085 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 6295 464 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
23959197 23959197 PRJNA1031674_P_NODE_25439_length_245_cov_1.633721_g25228_i0 PRJNA1031674 25439 245 1.633721 4.00261645 Fusobacterium 848 Bacteria Bacteria 448 2.41e-121   NTclustered gi|2704977725|gb|CP077125.1| 851 g25228 i0 99.592 99.8612244897959 245 1 100 0 1 245 476218 475974 Fusobacterium nucleatum strain KCOM3714 chromosome, complete genome blastn 24466 448 1 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);;