RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA853203" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 13 ✖

bioproject 1

  • PRJNA853203 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
2116831 2116831 PRJNA853203_P_NODE_33002_length_250_cov_0.881356_g32853_i0 PRJNA853203 33002 250 0.881356 2.20339 Leptotrichia sp. oral taxon 847 1785996 Bacteria Bacteria 394 3.27e-105   NTclustered gi|987458696|gb|CP014231.1| 1785996 g32853 i0 95.528 10.968 246 11 98 0 1 246 1894378 1894133 Leptotrichia sp. oral taxon 847 strain F0260 chromosome, complete genome blastn 2742 394 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 847
5944624 5944624 PRJNA853203_P_NODE_30425_length_251_cov_0.876404_g30276_i0 PRJNA853203 30425 251 0.876404 2.19977404 Leptotrichia sp. HMT-225 3058373 Bacteria Bacteria 449 6.899999999999999e-122   NTclustered gi|2557559843|gb|CP130323.1| 3058373 g30276 i0 99.197 229.737051792829 249 2 99 0 3 251 196930 196682 Leptotrichia sp. HMT-225 chromosome, complete genome blastn 57664 449 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. HMT-225
7612696 7612696 PRJNA853203_P_NODE_27646_length_253_cov_0.866667_g27497_i0 PRJNA853203 27646 253 0.866667 2.19266751 Fusobacterium 848 Bacteria Bacteria 435 1.95e-117   NTclustered gi|2704998788|gb|CP077147.1| 851 g27497 i0 97.628 99.3359683794466 253 6 100 0 1 253 1567810 1567558 Fusobacterium nucleatum strain KCOM2373 chromosome, complete genome blastn 25132 435 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
11045123 11045123 PRJNA853203_P_NODE_32209_length_250_cov_0.881356_g32060_i0 PRJNA853203 32209 250 0.881356 2.20339 Fusobacterium polymorphum 76857 Bacteria Bacteria 457 4.1099999999999985e-124   NTclustered gi|2707716151|gb|CP077166.1| 76857 g32060 i0 99.6 27.38 250 1 100 0 1 250 847551 847800 Fusobacterium polymorphum strain SB047 chromosome blastn 6845 457 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
11045198 11045198 PRJNA853203_P_NODE_42069_length_245_cov_0.906977_g41920_i0 PRJNA853203 42069 245 0.906977 2.22209365 Fusobacterium polymorphum 76857 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2078816781|gb|CP071094.1| 76857 g41920 i0 100 99.9551020408163 245 0 100 0 1 245 360933 361177 Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome blastn 24489 453 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
13595169 13595169 PRJNA853203_P_NODE_27831_length_252_cov_2.134078_g27682_i0 PRJNA853203 27831 252 2.134078 5.37787656 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 442 1.1599999999999995e-119   NTclustered gi|922689899|gb|CP012410.1| 712357 g27682 i0 98.413 90.6865079365079 252 3 100 1 1 252 49734 49984 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 22853 442 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
14869575 14869575 PRJNA853203_P_NODE_9732_length_290_cov_1.101382_g9583_i0 PRJNA853203 9732 290 1.101382 3.1940078 Fusobacterium polymorphum 76857 Bacteria Bacteria 508 1.33e-139   NTclustered gi|2645859777|gb|CP141277.1| 76857 g9583 i0 98.276 65.0344827586207 290 5 100 0 1 290 1296571 1296860 Fusobacterium polymorphum strain C48P chromosome, complete genome blastn 18860 508 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
16144363 16144363 PRJNA853203_P_NODE_8753_length_292_cov_1.401826_g8604_i0 PRJNA853203 8753 292 1.401826 4.09333192 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 462 1.06e-125   NTclustered gi|922689899|gb|CP012410.1| 712357 g8604 i0 95.804 0.979452054794521 286 12 98 0 1 286 2283866 2284151 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 286 462 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
18692789 18692789 PRJNA853203_P_NODE_34435_length_249_cov_0.886364_g34286_i0 PRJNA853203 34435 249 0.886364 2.20704636 Leptotrichia sp. HMT-225 3058373 Bacteria Bacteria 455 1.47e-123   NTclustered gi|2557559843|gb|CP130323.1| 3058373 g34286 i0 99.598 2 249 1 100 0 1 249 1629250 1629498 Leptotrichia sp. HMT-225 chromosome, complete genome blastn 498 455 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. HMT-225
21243655 21243655 PRJNA853203_P_NODE_47477_length_242_cov_0.923077_g47328_i0 PRJNA853203 47477 242 0.923077 2.23384634 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 420 5.19e-113   NTclustered gi|922689899|gb|CP012410.1| 712357 g47328 i0 97.934 1 242 5 100 0 1 242 2150079 2149838 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 242 420 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
22518139 22518139 PRJNA853203_P_NODE_25718_length_254_cov_1.723757_g25569_i0 PRJNA853203 25718 254 1.723757 4.37834278 Leptotrichia wadei 157687 Bacteria Bacteria 470 5.37e-128   NTclustered gi|1708577445|dbj|AP019835.1| 157687 g25569 i0 100 17.3661417322835 254 0 100 0 1 254 361157 360904 Leptotrichia wadei JMUB3934 DNA, complete genome blastn 4411 470 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
23793653 23793653 PRJNA853203_P_NODE_29679_length_251_cov_1.752809_g29530_i0 PRJNA853203 29679 251 1.752809 4.39955059 Leptotrichia sp. oral taxon 221 712362 Bacteria Bacteria 442 1.1599999999999995e-119   NTclustered gi|2028889048|gb|CP072378.1| 712362 g29530 i0 98.406 57.0358565737052 251 4 100 0 1 251 1420682 1420932 Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome blastn 14316 442 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 221
25067554 25067554 PRJNA853203_P_NODE_29440_length_252_cov_0.871508_g29291_i0 PRJNA853203 29440 252 0.871508 2.19620016 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 446 8.969999999999998e-121   NTclustered gi|922689899|gb|CP012410.1| 712357 g29291 i0 98.8 0.992063492063492 250 3 99 0 1 250 2321711 2321960 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 250 446 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);;