contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA287283" and tax_phylum = "Nucleocytoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15674908 | 15674908 | PRJNA287283_P_NODE_4273_length_303_cov_1.344000_g4049_i0 | PRJNA287283 | 4273 | 303 | 1.344 | 4.07232 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 179 | 9.16e-50 | NR | BCT22673.1 | RQ14 | g4049 | i0 | 79.2 | 1 | 101 | 21 | 100 | 0 | 1 | 303 | 1060 | 1160 | BCT22673.1 DNA-dependent RNA polymerase subunit rpo132 [Carp edema virus] | diamond | 303 | 179 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 27105571 | 27105571 | PRJNA287283_P_NODE_2442_length_421_cov_1.521739_g2219_i0 | PRJNA287283 | 2442 | 421 | 1.521739 | 6.40652119 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 79.7 | 4.77e-15 | NR | BCT22683.1 | RQ14 | g2219 | i0 | 33.3 | 0.961995249406176 | 135 | 88 | 94.8 | 1 | 412 | 14 | 29 | 163 | BCT22683.1 hypothetical protein [Carp edema virus] | diamond | 405 | 79.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 27327077 | 27327077 | PRJNA287283_P_NODE_8863_length_181_cov_1.312500_g8639_i0 | PRJNA287283 | 8863 | 181 | 1.3125 | 2.375625 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 54.3 | 1.37e-6 | NR | BCT22635.1 | RQ14 | g8639 | i0 | 64.7 | 0.56353591160221 | 34 | 12 | 56.4 | 0 | 103 | 2 | 181 | 214 | BCT22635.1 NTPase [Carp edema virus] | diamond | 102 | 54.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 27422016 | 27422016 | PRJNA287283_P_NODE_4803_length_279_cov_0.991150_g4579_i0 | PRJNA287283 | 4803 | 279 | 0.99115 | 2.7653085 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 57.8 | 2.41e-7 | NR | BCT22575.1 | RQ14 | g4579 | i0 | 33 | 0.946236559139785 | 88 | 57 | 94.6 | 1 | 266 | 3 | 215 | 300 | BCT22575.1 thymidine kinase [Carp edema virus] | diamond | 264 | 57.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 27516521 | 27516521 | PRJNA287283_P_NODE_483_length_1055_cov_4.129741_g361_i0 | PRJNA287283 | 483 | 1055 | 4.129741 | 43.56876755 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 181 | 3.27e-50 | NR | BCT22626.1 | RQ14 | g361 | i0 | 36.4 | 0.890047393364929 | 313 | 182 | 85 | 6 | 965 | 69 | 3 | 312 | BCT22626.1 putative DNA-binding virion core protein [Carp edema virus] | diamond | 939 | 181 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 28779341 | 28779341 | PRJNA287283_P_NODE_9007_length_181_cov_0.875000_g8783_i0 | PRJNA287283 | 9007 | 181 | 0.875 | 1.58375 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 95.1 | 5.6200000000000006e-21 | NR | BCT22721.1 | RQ14 | g8783 | i0 | 76.3 | 0.977900552486188 | 59 | 14 | 97.8 | 0 | 179 | 3 | 914 | 972 | BCT22721.1 RNA polymerase subunit RPO147 [Carp edema virus] | diamond | 177 | 95.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30642722 | 30642722 | PRJNA287283_P_NODE_1813_length_504_cov_3.155211_g1594_i0 | PRJNA287283 | 1813 | 504 | 3.155211 | 15.90226344 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 68.9 | 9.44e-11 | NR | BCT22707.1 | RQ14 | g1594 | i0 | 30.5 | 0.976190476190476 | 164 | 93 | 94.6 | 7 | 20 | 496 | 1 | 148 | BCT22707.1 hypothetical protein [Carp edema virus] | diamond | 492 | 68.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30990570 | 30990570 | PRJNA287283_P_NODE_5654_length_246_cov_1.160622_g5430_i0 | PRJNA287283 | 5654 | 246 | 1.160622 | 2.85513012 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 105 | 6.57e-25 | NR | BCT22728.1 | RQ14 | g5430 | i0 | 61.7 | 0.98780487804878 | 81 | 31 | 98.8 | 0 | 4 | 246 | 14 | 94 | BCT22728.1 DNA topoisomerase I [Carp edema virus] | diamond | 243 | 105 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31085230 | 31085230 | PRJNA287283_P_NODE_8175_length_186_cov_1.263158_g7951_i0 | PRJNA287283 | 8175 | 186 | 1.263158 | 2.34947388 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 90.9 | 1.87e-19 | NR | BCT22616.1 | RQ14 | g7951 | i0 | 70 | 0.967741935483871 | 60 | 18 | 96.8 | 0 | 184 | 5 | 322 | 381 | BCT22616.1 poly(A)-polymerase catalytic subunit PAPL [Carp edema virus] | diamond | 180 | 90.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 32634598 | 32634598 | PRJNA287283_P_NODE_8240_length_185_cov_1.272727_g8016_i0 | PRJNA287283 | 8240 | 185 | 1.272727 | 2.35454495 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 78.2 | 5.52e-15 | NR | BCT22635.1 | RQ14 | g8016 | i0 | 58.3 | 0.972972972972973 | 60 | 25 | 97.3 | 0 | 185 | 6 | 723 | 782 | BCT22635.1 NTPase [Carp edema virus] | diamond | 180 | 78.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus |
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);;