contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1249535" and tax_kingdom = "Fusobacteriati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1052446 | 1052446 | PRJNA1249535_S_NODE_157581_length_330_cov_4.435798_g154198_i0 | PRJNA1249535 | 157581 | 330 | 4.435798 | 14.6381334 | Fusobacterium | 848 | Bacteria | Bacteria | 54.7 | 0.009 | NTclustered | gi|2705042081|gb|CP085192.1| | 856 | g154198 | i0 | 100 | 0.351515151515152 | 29 | 0 | 9 | 0 | 200 | 228 | 1493364 | 1493336 | Fusobacterium varium strain SB069 chromosome | blastn | 116 | 54.7 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium varium | ||
| 1633391 | 1633391 | PRJNA1249535_S_NODE_57602_length_453_cov_3.294737_g54239_i0 | PRJNA1249535 | 57602 | 453 | 3.294737 | 14.92515861 | Fusobacterium canifelinum | 285729 | Bacteria | Bacteria | 52.8 | 0.044 | NTclustered | gi|1948622963|gb|CP066022.1| | 285729 | g54239 | i0 | 90 | 0.176600441501104 | 40 | 4 | 9 | 0 | 390 | 429 | 1502390 | 1502429 | Fusobacterium canifelinum strain FDAARGOS_999 chromosome, complete genome | blastn | 80 | 52.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium canifelinum | ||
| 4184284 | 4184284 | PRJNA1249535_S_NODE_257904_length_275_cov_11.336634_g254521_i0 | PRJNA1249535 | 257904 | 275 | 11.336634 | 31.1757435 | Sneathia sanguinegens | 40543 | Bacteria | Bacteria | 58.4 | 5.43e-4 | NTclustered | gi|2769805188|gb|CP160095.1| | 40543 | g254521 | i0 | 97.059 | 0.123636363636364 | 34 | 1 | 12 | 0 | 158 | 191 | 1025359 | 1025392 | Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome | blastn | 34 | 58.4 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Sneathia | Sneathia sanguinegens | ||
| 4880497 | 4880497 | PRJNA1249535_S_NODE_207884_length_302_cov_2.668122_g204501_i0 | PRJNA1249535 | 207884 | 302 | 2.668122 | 8.05772844 | Bacteria | 2 | Bacteria | Bacteria | 231 | 3.36e-56 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g204501 | i0 | 81.25 | 238.026490066225 | 304 | 42 | 98 | 14 | 1 | 297 | 53483 | 53188 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 71884 | 231 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 4880513 | 4880513 | PRJNA1249535_S_NODE_245704_length_282_cov_2.937799_g242321_i0 | PRJNA1249535 | 245704 | 282 | 2.937799 | 8.28459318 | Fusobacterium | 848 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2573686249|gb|CP133474.1| | 851 | g242321 | i0 | 94.595 | 3.02836879432624 | 37 | 1 | 13 | 1 | 218 | 253 | 1844764 | 1844728 | Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome | blastn | 854 | 56.5 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 6155245 | 6155245 | PRJNA1249535_S_NODE_80325_length_401_cov_2.295732_g76944_i0 | PRJNA1249535 | 80325 | 401 | 2.295732 | 9.20588532 | Fusobacterium | 848 | Bacteria | Bacteria | 54.7 | 0.011 | NTclustered | gi|2645859777|gb|CP141277.1| | 76857 | g76944 | i0 | 100 | 0.144638403990025 | 29 | 0 | 7 | 0 | 265 | 293 | 1550347 | 1550375 | Fusobacterium polymorphum strain C48P chromosome, complete genome | blastn | 58 | 54.7 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 9285029 | 9285029 | PRJNA1249535_S_NODE_23168_length_627_cov_5.492780_g20024_i0 | PRJNA1249535 | 23168 | 627 | 5.49278 | 34.4397306 | Pseudoleptotrichia goodfellowii | 157692 | Bacteria | Bacteria | 54.7 | 0.017 | NTclustered | gi|1708563796|dbj|AP019822.1| | 157692 | g20024 | i0 | 100 | 0.0462519936204147 | 29 | 0 | 5 | 0 | 33 | 61 | 2111554 | 2111526 | Leptotrichia goodfellowii JCM16774 DNA, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Pseudoleptotrichia | Pseudoleptotrichia goodfellowii | ||
| 13111247 | 13111247 | PRJNA1249535_S_NODE_281471_length_263_cov_1.863158_g278088_i0 | PRJNA1249535 | 281471 | 263 | 1.863158 | 4.90010554 | Leptotrichia alba | 3239304 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|2785244533|gb|CP165647.1| | 3239304 | g278088 | i0 | 100 | 0.106463878326996 | 28 | 0 | 11 | 0 | 115 | 142 | 2422996 | 2422969 | Leptotrichia sp. HSP-536 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia alba | ||
| 13805900 | 13805900 | PRJNA1249535_S_NODE_306551_length_249_cov_2.897727_g303168_i0 | PRJNA1249535 | 306551 | 249 | 2.897727 | 7.21534023 | Fusobacterium | 848 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2446175567|gb|CP117964.1| | 851 | g303168 | i0 | 100 | 2.36144578313253 | 28 | 0 | 11 | 0 | 32 | 59 | 1071262 | 1071289 | Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome | blastn | 588 | 52.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 14386630 | 14386630 | PRJNA1249535_S_NODE_29452_length_577_cov_7.208333_g26222_i0 | PRJNA1249535 | 29452 | 577 | 7.208333 | 41.59208141 | Fusobacterium hwasookii | 1583098 | Bacteria | Bacteria | 58.4 | 0.001 | NTclustered | gi|958162200|gb|CP013331.1| | 1307442 | g26222 | i0 | 100 | 0.0537261698440208 | 31 | 0 | 5 | 0 | 179 | 209 | 1020271 | 1020241 | Fusobacterium hwasookii ChDC F174, complete genome | blastn | 31 | 58.4 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium hwasookii | ||
| 15080025 | 15080025 | PRJNA1249535_S_NODE_110032_length_365_cov_3.140411_g106649_i0 | PRJNA1249535 | 110032 | 365 | 3.140411 | 11.46250015 | Fusobacterium | 848 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|2573686249|gb|CP133474.1| | 851 | g106649 | i0 | 100 | 0.493150684931507 | 30 | 0 | 8 | 0 | 137 | 166 | 907761 | 907732 | Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome | blastn | 180 | 56.5 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 16354856 | 16354856 | PRJNA1249535_S_NODE_220053_length_295_cov_7.085586_g216670_i0 | PRJNA1249535 | 220053 | 295 | 7.085586 | 20.9024787 | Leptotrichia | 32067 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|1708575239|dbj|AP019834.1| | 157687 | g216670 | i0 | 100 | 0.379661016949153 | 28 | 0 | 9 | 0 | 116 | 143 | 195717 | 195744 | Leptotrichia wadei JMUB3933 DNA, complete genome | blastn | 112 | 52.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 16354886 | 16354886 | PRJNA1249535_S_NODE_57353_length_454_cov_1.790026_g53990_i0 | PRJNA1249535 | 57353 | 454 | 1.790026 | 8.12671804 | Leptotrichia | 32067 | Bacteria | Bacteria | 54.7 | 0.012 | NTclustered | gi|1227268105|gb|CP016753.1| | 712368 | g53990 | i0 | 100 | 0.127753303964758 | 29 | 0 | 6 | 0 | 137 | 165 | 2127868 | 2127840 | Leptotrichia sp. oral taxon 498, complete genome | blastn | 58 | 54.7 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 498 | ||
| 18207232 | 18207232 | PRJNA1249535_S_NODE_135995_length_344_cov_6.416974_g132612_i0 | PRJNA1249535 | 135995 | 344 | 6.416974 | 22.07439056 | Pseudoleptotrichia goodfellowii | 157692 | Bacteria | Bacteria | 52.8 | 0.033 | NTclustered | gi|1708563796|dbj|AP019822.1| | 157692 | g132612 | i0 | 100 | 0.0813953488372093 | 28 | 0 | 8 | 0 | 100 | 127 | 1459855 | 1459828 | Leptotrichia goodfellowii JCM16774 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Pseudoleptotrichia | Pseudoleptotrichia goodfellowii | ||
| 21454278 | 21454278 | PRJNA1249535_S_NODE_188917_length_312_cov_3.786611_g185534_i0 | PRJNA1249535 | 188917 | 312 | 3.786611 | 11.81422632 | Fusobacterium | 848 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|1208657894|gb|CP021934.1| | 76857 | g185534 | i0 | 100 | 0.628205128205128 | 28 | 0 | 9 | 0 | 254 | 281 | 1727301 | 1727328 | Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome | blastn | 196 | 52.8 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 25278554 | 25278554 | PRJNA1249535_S_NODE_193120_length_310_cov_2.375527_g189737_i0 | PRJNA1249535 | 193120 | 310 | 2.375527 | 7.3641337 | Fusobacterium | 848 | Bacteria | Bacteria | 54.7 | 0.008 | NTclustered | gi|1519065922|gb|CP033837.1| | 859 | g189737 | i0 | 100 | 0.187096774193548 | 29 | 0 | 9 | 0 | 281 | 309 | 187078 | 187050 | Fusobacterium necrophorum strain FDAARGOS_565 chromosome, complete genome | blastn | 58 | 54.7 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium necrophorum |
Advanced export
JSON shape: default, array, newline-delimited
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);;