contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Cossaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4350022 | 4350022 | PRJNA556992_P_NODE_1087004_length_216_cov_4.097902_g1084813_i0 | PRJNA556992 | 1087004 | 216 | 4.097902 | 8.85146832 | Gammapapillomavirus 8 | 1175850 | Viruses | Viruses | 372 | 1.29e-98 | NTclustered | gi|343411609|gb|HM999999.1| | 1070420 | g1084813 | i0 | 97.685 | 1 | 216 | 5 | 100 | 0 | 1 | 216 | 3666 | 3451 | Human papillomavirus type 147 isolate GH659, complete genome | blastn | 216 | 372 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 8 | ||
| 4354503 | 4354503 | PRJNA556992_P_NODE_329244_length_285_cov_1.132075_g327055_i0 | PRJNA556992 | 329244 | 285 | 1.132075 | 3.22641375 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 510 | 3.61e-140 | NTclustered | gi|58430757|dbj|AB201226.1| | 260717 | g327055 | i0 | 98.947 | 12.4771929824561 | 285 | 3 | 100 | 0 | 1 | 285 | 2295 | 2011 | Human papillomavirus type 94 DNA, nearly complete genome, Korean variant | blastn | 3556 | 510 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 10737229 | 10737229 | PRJNA556992_P_NODE_788169_length_246_cov_4.208092_g785979_i0 | PRJNA556992 | 788169 | 246 | 4.208092 | 10.35190632 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 433 | 6.79e-117 | NTclustered | gi|1273499042|gb|MF588683.1| | 333924 | g785979 | i0 | 98.374 | 2 | 246 | 4 | 100 | 0 | 1 | 246 | 4744 | 4499 | Betapapillomavirus 2 isolate Beta02_m292c88, complete genome | blastn | 492 | 433 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 12006821 | 12006821 | PRJNA556992_P_NODE_374410_length_279_cov_2.398058_g372221_i0 | PRJNA556992 | 374410 | 279 | 2.398058 | 6.69058182 | Betapapillomavirus 1 | 337051 | Viruses | Viruses | 503 | 5.9e-138 | NTclustered | gi|1273498994|gb|MF588677.1| | 337051 | g372221 | i0 | 99.281 | 2.89964157706093 | 278 | 2 | 99 | 0 | 1 | 278 | 5312 | 5589 | Betapapillomavirus 1 isolate Beta01_HIVGc36, complete genome | blastn | 809 | 503 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 1 | ||
| 13287639 | 13287639 | PRJNA556992_P_NODE_829451_length_244_cov_2.883041_g827261_i0 | PRJNA556992 | 829451 | 244 | 2.883041 | 7.03462004 | Betapapillomavirus 1 | 337051 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1200175664|gb|KY969593.1| | 31547 | g827261 | i0 | 100 | 0.245901639344262 | 30 | 0 | 12 | 0 | 23 | 52 | 5585 | 5556 | Human papillomavirus 20 strain HPV-20/Lancaster/2015, complete genome | blastn | 60 | 56.5 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 1 | ||
| 14557185 | 14557185 | PRJNA556992_P_NODE_396712_length_277_cov_1.446078_g394523_i0 | PRJNA556992 | 396712 | 277 | 1.446078 | 4.00563606 | Blatella germanica densoviruses-like virus 1 | 2776787 | Viruses | Viruses | 490 | 4.56e-134 | NTclustered | gi|1917254128|gb|MN851295.1| | 2776787 | g394523 | i0 | 98.556 | 30.8736462093863 | 277 | 4 | 100 | 0 | 1 | 277 | 131 | 407 | Blatella germanica densoviruses-like virus 1 isolate EuB-PV1 nonstructural protein genes, complete cds | blastn | 8552 | 490 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Blatella germanica densoviruses-like virus 1 | |||
| 18385995 | 18385995 | PRJNA556992_P_NODE_870755_length_242_cov_2.254438_g868565_i0 | PRJNA556992 | 870755 | 242 | 2.254438 | 5.45573996 | Epsilonpolyomavirus bovis | 1891754 | Viruses | Viruses | 58.4 | 4.69e-4 | NTclustered | gi|954182136|gb|KU170643.1| | 1561702 | g868565 | i0 | 100 | 0.128099173553719 | 31 | 0 | 13 | 0 | 115 | 145 | 138 | 108 | Bovine polyomavirus 1 isolate #7535, complete genome | blastn | 31 | 58.4 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Epsilonpolyomavirus | Epsilonpolyomavirus bovis |
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);;