contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA206070" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6158385 | 6158385 | PRJNA206070_S_NODE_24385_length_176_cov_3.755396_g22509_i0 | PRJNA206070 | 24385 | 176 | 3.755396 | 6.60949696 | Fusobacterium | 848 | Bacteria | Bacteria | 315 | 1.7199999999999996e-81 | NTclustered | gi|2705038125|gb|CP084158.1| | 851 | g22509 | i0 | 98.864 | 487.977272727273 | 176 | 2 | 100 | 0 | 1 | 176 | 1992424 | 1992249 | Fusobacterium nucleatum strain KCOM2312 chromosome, complete genome | blastn | 85884 | 315 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 8019895 | 8019895 | PRJNA206070_S_NODE_29147_length_157_cov_1.250000_g27271_i0 | PRJNA206070 | 29147 | 157 | 1.25 | 1.9625 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 246 | 5.54e-61 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g27271 | i0 | 94.904 | 32.1656050955414 | 157 | 8 | 100 | 0 | 1 | 157 | 53030 | 53186 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 5050 | 246 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 11258876 | 11258876 | PRJNA206070_S_NODE_22089_length_190_cov_2.176471_g20213_i0 | PRJNA206070 | 22089 | 190 | 2.176471 | 4.1352949 | Fusobacteriaceae | 203492 | Bacteria | Bacteria | 318 | 1.46e-82 | NTclustered | gi|2446175567|gb|CP117964.1| | 851 | g20213 | i0 | 96.842 | 478.936842105263 | 190 | 6 | 100 | 0 | 1 | 190 | 1739384 | 1739573 | Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome | blastn | 90998 | 318 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 13809057 | 13809057 | PRJNA206070_S_NODE_23851_length_179_cov_3.295775_g21975_i0 | PRJNA206070 | 23851 | 179 | 3.295775 | 5.89943725 | Fusobacterium | 848 | Bacteria | Bacteria | 315 | 1.75e-81 | NTclustered | gi|2705042081|gb|CP085192.1| | 856 | g21975 | i0 | 98.324 | 504.703910614525 | 179 | 3 | 100 | 0 | 1 | 179 | 3422602 | 3422424 | Fusobacterium varium strain SB069 chromosome | blastn | 90342 | 315 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium varium | ||
| 18217910 | 18217910 | PRJNA206070_S_NODE_16435_length_244_cov_2.637681_g14559_i0 | PRJNA206070 | 16435 | 244 | 2.637681 | 6.43594164 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 368 | 1.92e-97 | NTclustered | gi|2201062197|gb|CP092519.1| | 188913 | g14559 | i0 | 93.852 | 393.258196721311 | 244 | 15 | 100 | 0 | 1 | 244 | 49181 | 48938 | Cetobacterium somerae strain CS2105-BJ chromosome, complete genome | blastn | 95955 | 368 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 21457370 | 21457370 | PRJNA206070_S_NODE_19937_length_206_cov_3.331361_g18061_i0 | PRJNA206070 | 19937 | 206 | 3.331361 | 6.86260366 | Cetobacterium | 180162 | Bacteria | Bacteria | 375 | 9.41e-100 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g18061 | i0 | 99.515 | 492.970873786408 | 206 | 1 | 100 | 0 | 1 | 206 | 279413 | 279618 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 101552 | 375 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 22732559 | 22732559 | PRJNA206070_S_NODE_7858_length_473_cov_3.768349_g5989_i0 | PRJNA206070 | 7858 | 473 | 3.768349 | 17.82429077 | Cetobacterium | 180162 | Bacteria | Bacteria | 808 | 0 | NTclustered | gi|2666488225|gb|CP143319.1| | 188913 | g5989 | i0 | 97.463 | 496.067653276956 | 473 | 12 | 100 | 0 | 1 | 473 | 1317883 | 1317411 | Cetobacterium somerae strain ceto chromosome, complete genome | blastn | 234640 | 808 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae |
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);;