contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA274362" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2921085 | 2921085 | PRJNA274362_S_NODE_18363_length_213_cov_1.884146_g18243_i0 | PRJNA274362 | 18363 | 213 | 1.884146 | 4.01323098 | Leptotrichia rugosa | 3239302 | Bacteria | Bacteria | 388 | 1.26e-103 | NTclustered | gi|2785246835|gb|CP165644.1| | 3239302 | g18243 | i0 | 99.531 | 407.323943661972 | 213 | 1 | 100 | 0 | 1 | 213 | 1958367 | 1958579 | Leptotrichia sp. HSP-334 chromosome, complete genome | blastn | 86760 | 388 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia rugosa | ||
| 9298511 | 9298511 | PRJNA274362_S_NODE_18888_length_211_cov_1.135802_g18768_i0 | PRJNA274362 | 18888 | 211 | 1.135802 | 2.39654222 | Leptotrichia sp. oral taxon 498 | 712368 | Bacteria | Bacteria | 390 | 3.459999999999999e-104 | NTclustered | gi|1227268105|gb|CP016753.1| | 712368 | g18768 | i0 | 100 | 98.3601895734597 | 211 | 0 | 100 | 0 | 1 | 211 | 594048 | 593838 | Leptotrichia sp. oral taxon 498, complete genome | blastn | 20754 | 390 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 498 | ||
| 10574949 | 10574949 | PRJNA274362_S_NODE_9209_length_284_cov_11.570213_g9089_i0 | PRJNA274362 | 9209 | 284 | 11.570213 | 32.85940492 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 514 | 2.78e-141 | NTclustered | gi|2201062197|gb|CP092519.1| | 188913 | g9089 | i0 | 99.296 | 466.56338028169 | 284 | 2 | 100 | 0 | 1 | 284 | 49167 | 48884 | Cetobacterium somerae strain CS2105-BJ chromosome, complete genome | blastn | 132504 | 514 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 16361044 | 16361044 | PRJNA274362_S_NODE_14253_length_237_cov_1.382979_g14133_i0 | PRJNA274362 | 14253 | 237 | 1.382979 | 3.27766023 | Leptotrichia | 32067 | Bacteria | Bacteria | 438 | 1.4e-118 | NTclustered | gi|1227268105|gb|CP016753.1| | 712368 | g14133 | i0 | 100 | 382.362869198312 | 237 | 0 | 100 | 0 | 1 | 237 | 593855 | 593619 | Leptotrichia sp. oral taxon 498, complete genome | blastn | 90620 | 438 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 498 | ||
| 24596765 | 24596765 | PRJNA274362_S_NODE_28100_length_179_cov_1.023077_g27980_i0 | PRJNA274362 | 28100 | 179 | 1.023077 | 1.83130783 | Fusobacterium gastrosuis | 1755100 | Bacteria | Bacteria | 320 | 3.76e-83 | NTclustered | gi|1795735174|emb|LT607734.1| | 1755100 | g27980 | i0 | 98.883 | 490.994413407821 | 179 | 2 | 100 | 0 | 1 | 179 | 345403 | 345581 | Fusobacterium sp. P6 Po strain Fusobacterium gastrosuis sp. nov. CDW1, P6 Po genome assembly, chromosome: chr | blastn | 87888 | 320 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium gastrosuis | ||
| 25284740 | 25284740 | PRJNA274362_S_NODE_37000_length_163_cov_0.807018_g36880_i0 | PRJNA274362 | 37000 | 163 | 0.807018 | 1.31543934 | root | 1 | Root_unresolved | Root_unresolved | 302 | 1.22e-77 | NTclustered | gi|1973571794|gb|MW567136.1| | 851 | g36880 | i0 | 100 | 107.858895705521 | 163 | 0 | 100 | 0 | 1 | 163 | 479 | 641 | Fusobacterium nucleatum strain c15Ua_6_AN 16S ribosomal RNA gene, partial sequence | blastn | 17581 | 302 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum |
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);;