contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 372008 | 372008 | PRJNA285816_S_NODE_22541_length_173_cov_0.927419_g22439_i0 | PRJNA285816 | 22541 | 173 | 0.927419 | 1.60443487 | Fusobacterium gastrosuis | 1755100 | Bacteria | Bacteria | 248 | 1.73e-61 | NTclustered | gi|1795735174|emb|LT607734.1| | 1755100 | g22439 | i0 | 92.571 | 497.086705202312 | 175 | 9 | 100 | 4 | 1 | 173 | 344470 | 344298 | Fusobacterium sp. P6 Po strain Fusobacterium gastrosuis sp. nov. CDW1, P6 Po genome assembly, chromosome: chr | blastn | 85996 | 248 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium gastrosuis | ||
| 3609668 | 3609668 | PRJNA285816_S_NODE_14503_length_202_cov_1.490196_g14401_i0 | PRJNA285816 | 14503 | 202 | 1.490196 | 3.01019592 | Fusobacterium | 848 | Bacteria | Bacteria | 335 | 1.5599999999999993e-87 | NTclustered | gi|2704973964|gb|CP077133.1| | 851 | g14401 | i0 | 96.985 | 438.777227722772 | 199 | 6 | 99 | 0 | 1 | 199 | 2004906 | 2005104 | Fusobacterium nucleatum strain KCOM3205 chromosome, complete genome | blastn | 88633 | 335 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 7437077 | 7437077 | PRJNA285816_S_NODE_28446_length_163_cov_1.254386_g28344_i0 | PRJNA285816 | 28446 | 163 | 1.254386 | 2.04464918 | Leptotrichia | 32067 | Bacteria | Bacteria | 274 | 2.66e-69 | NTclustered | gi|631253196|ref|NR_114394.1| | 40542 | g28344 | i0 | 96.933 | 100 | 163 | 5 | 100 | 0 | 1 | 163 | 587 | 749 | Leptotrichia buccalis strain C-1013-b 16S ribosomal RNA, partial sequence | blastn | 16300 | 276 | 0.992753623188406 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis | ||
| 18910613 | 18910613 | PRJNA285816_S_NODE_9495_length_235_cov_1.580645_g9393_i0 | PRJNA285816 | 9495 | 235 | 1.580645 | 3.71451575 | Fusobacterium | 848 | Bacteria | Bacteria | 424 | 3.87e-114 | NTclustered | gi|2444100754|gb|CP117525.1| | 851 | g9393 | i0 | 99.149 | 488.83829787234 | 235 | 2 | 100 | 0 | 1 | 235 | 177240 | 177006 | Fusobacterium nucleatum strain FNV chromosome, complete genome | blastn | 114877 | 427 | 0.992974238875878 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 24011047 | 24011047 | PRJNA285816_S_NODE_20319_length_179_cov_1.992308_g20217_i0 | PRJNA285816 | 20319 | 179 | 1.992308 | 3.56623132 | Fusobacterium | 848 | Bacteria | Bacteria | 331 | 1.74e-86 | NTclustered | gi|2705003210|gb|CP084117.1| | 851 | g20217 | i0 | 100 | 487.463687150838 | 179 | 0 | 100 | 0 | 1 | 179 | 1488502 | 1488680 | Fusobacterium nucleatum strain KCOM3486 chromosome, complete genome | blastn | 87256 | 331 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 25285232 | 25285232 | PRJNA285816_S_NODE_27560_length_164_cov_1.339130_g27458_i0 | PRJNA285816 | 27560 | 164 | 1.33913 | 2.1961732 | Fusobacterium | 848 | Bacteria | Bacteria | 298 | 1.59e-76 | NTclustered | gi|2705032171|gb|CP084140.1| | 851 | g27458 | i0 | 99.39 | 488.993902439024 | 164 | 1 | 100 | 0 | 1 | 164 | 62996 | 62833 | Fusobacterium nucleatum strain KCOM3187 chromosome, complete genome | blastn | 80195 | 298 | 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);;