contig_metadata
5 rows where bioproject = "PRJEB48218" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15365065 | 15365065 | PRJEB48218_S_NODE_8313_length_326_cov_4.764310_g7351_i0 | PRJEB48218 | 8313 | 326 | 4.76431 | 15.5316506 | Orthopoxvirus | 10242 | Viruses | Viruses | 189 | 1.23e-58 | NR | ATB55171.1 | 10243 | g7351 | i0 | 100 | 21.3957055214724 | 93 | 0 | 85.6 | 0 | 281 | 3 | 1 | 93 | ATB55171.1 CPXV129 protein [Cowpox virus] | diamond | 6975 | 189 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus cowpox | ||
| 23942770 | 23942770 | PRJEB48218_S_NODE_4399_length_551_cov_9.268199_g3477_i0 | PRJEB48218 | 4399 | 551 | 9.268199 | 51.06777649 | Orthopoxvirus | 10242 | Viruses | Viruses | 366 | 4.269999999999998e-119 | NR | WBA78916.1 | 10244 | g3477 | i0 | 100 | 10.9491833030853 | 183 | 0 | 99.6 | 0 | 550 | 2 | 573 | 755 | WBA78916.1 mRNA capping enzyme large subunit [Monkeypox virus] | diamond | 6033 | 366 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 29496645 | 29496645 | PRJEB48218_S_NODE_27630_length_161_cov_5.356061_g26668_i0 | PRJEB48218 | 27630 | 161 | 5.356061 | 8.62325821 | Ectromelia virus | 12643 | Viruses | Viruses | 103 | 4.58e-25 | NR | NP_671619.1 | 12643 | g26668 | i0 | 96.2 | 0.987577639751553 | 53 | 2 | 98.8 | 0 | 160 | 2 | 190 | 242 | NP_671619.1 EVM101 [Ectromelia virus] | diamond | 159 | 103 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus ectromelia | ||
| 29590995 | 29590995 | PRJEB48218_S_NODE_7790_length_342_cov_6.076677_g6828_i0 | PRJEB48218 | 7790 | 342 | 6.076677 | 20.78223534 | Camelpox virus | 28873 | Viruses | Viruses | 219 | 2.9300000000000003e-64 | NR | NP_570494.1 | 28873 | g6828 | i0 | 96.5 | 7.99122807017544 | 113 | 4 | 99.1 | 0 | 1 | 339 | 470 | 582 | NP_570494.1 CMLV104 [Camelpox virus] | diamond | 2733 | 219 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus camelpox | ||
| 32398077 | 32398077 | PRJEB48218_S_NODE_8799_length_313_cov_3.799296_g7837_i0 | PRJEB48218 | 8799 | 313 | 3.799296 | 11.89179648 | Orthopoxvirus | 10242 | Viruses | Viruses | 208 | 5.08e-66 | NR | ATB55171.1 | 10243 | g7837 | i0 | 100 | 11.8370607028754 | 103 | 0 | 98.7 | 0 | 3 | 311 | 95 | 197 | ATB55171.1 CPXV129 protein [Cowpox virus] | diamond | 3705 | 208 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus cowpox |
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);;