contig_metadata
4 rows where bioproject = "PRJEB48872" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8643951 | 8643951 | PRJEB48872_P_NODE_680827_length_153_cov_1.131579_g665015_i0 | PRJEB48872 | 680827 | 153 | 1.131579 | 1.73131587 | Fusobacterium | 848 | Bacteria | Bacteria | 278 | 1.9e-70 | NTclustered | gi|2706069597|gb|CP077108.1| | 76857 | g665015 | i0 | 99.346 | 87.9542483660131 | 153 | 1 | 100 | 0 | 1 | 153 | 1185157 | 1185005 | Fusobacterium polymorphum strain KCOM1281 chromosome, complete genome | blastn | 13457 | 278 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 9918950 | 9918950 | PRJEB48872_P_NODE_534308_length_184_cov_1.531034_g518496_i0 | PRJEB48872 | 534308 | 184 | 1.531034 | 2.81710256 | Fusobacterium | 848 | Bacteria | Bacteria | 329 | 6.47e-86 | NTclustered | gi|2706433495|gb|CP077153.1| | 76857 | g518496 | i0 | 98.913 | 476.646739130435 | 184 | 2 | 100 | 0 | 1 | 184 | 2421269 | 2421452 | Fusobacterium polymorphum strain KCOM1274 chromosome, complete genome | blastn | 87703 | 329 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 16661986 | 16661986 | PRJEB48872_P_NODE_579114_length_173_cov_1.447761_g563302_i0 | PRJEB48872 | 579114 | 173 | 1.447761 | 2.50462653 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 320 | 3.61e-83 | NTclustered | gi|1276705688|gb|CP024698.1| | 2663009 | g563302 | i0 | 100 | 468.606936416185 | 173 | 0 | 100 | 0 | 1 | 173 | 508737 | 508909 | Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome | blastn | 81069 | 320 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 21392655 | 21392655 | PRJEB48872_P_NODE_242257_length_337_cov_2.348993_g226445_i0 | PRJEB48872 | 242257 | 337 | 2.348993 | 7.91610641 | Fusobacterium | 848 | Bacteria | Bacteria | 623 | 5.369999999999999e-174 | NTclustered | gi|2445153921|gb|CP117797.1| | 851 | g226445 | i0 | 100 | 495.961424332344 | 337 | 0 | 100 | 0 | 1 | 337 | 470097 | 469761 | Fusobacterium nucleatum strain FNA chromosome, complete genome | blastn | 167139 | 623 | 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);;