contig_metadata
10 rows where bioproject = "PRJNA949785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28952180 | 28952180 | PRJNA949785_P_NODE_9608_length_336_cov_1.171103_g9411_i0 | PRJNA949785 | 9608 | 336 | 1.171103 | 3.93490608 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 68.9 | 8.76e-12 | NR | BCT22600.1 | RQ14 | g9411 | i0 | 35.1 | 0.991071428571429 | 111 | 69 | 97.3 | 2 | 6 | 332 | 44 | 153 | BCT22600.1 hypothetical protein [Carp edema virus] | diamond | 333 | 68.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 29141593 | 29141593 | PRJNA949785_P_NODE_3269_length_648_cov_3.059130_g3088_i0 | PRJNA949785 | 3269 | 648 | 3.05913 | 19.8231624 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 60.1 | 1.07e-6 | NR | BCT22626.1 | RQ14 | g3088 | i0 | 36.9 | 0.388888888888889 | 84 | 43 | 34.3 | 1 | 645 | 424 | 229 | 312 | BCT22626.1 putative DNA-binding virion core protein [Carp edema virus] | diamond | 252 | 60.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30373492 | 30373492 | PRJNA949785_P_NODE_15712_length_251_cov_0.865169_g15515_i0 | PRJNA949785 | 15712 | 251 | 0.865169 | 2.17157419 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 88.6 | 2.17e-18 | NR | BCT22672.1 | RQ14 | g15515 | i0 | 51.8 | 0.99203187250996006 | 83 | 40 | 99.2 | 0 | 1 | 249 | 330 | 412 | BCT22672.1 sialidase [Carp edema virus] | diamond | 249 | 88.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30530976 | 30530976 | PRJNA949785_P_NODE_4633_length_526_cov_2.039735_g4437_i0 | PRJNA949785 | 4633 | 526 | 2.039735 | 10.7290061 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 101 | 1.66e-22 | NR | BCT22606.1 | RQ14 | g4437 | i0 | 44.8 | 0.496197718631179 | 87 | 48 | 49.6 | 0 | 99 | 359 | 177 | 263 | BCT22606.1 hypothetical protein AL387_gp060 [Carp edema virus] | diamond | 261 | 101 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30594143 | 30594143 | PRJNA949785_P_NODE_1733_length_904_cov_6.815884_g1587_i0 | PRJNA949785 | 1733 | 904 | 6.815884 | 61.61559136 | Nucleocytoviricota sp. | 2809609 | Viruses | Viruses | 59.3 | 4.57e-6 | NR | UZT28929.1 | 2809609 | g1587 | i0 | 41.9 | 0.245575221238938 | 74 | 38 | 24.6 | 1 | 207 | 428 | 1 | 69 | UZT28929.1 hypothetical protein [Nucleocytoviricota sp.] | diamond | 222 | 59.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Nucleocytoviricota sp. | ||||||
| 30657391 | 30657391 | PRJNA949785_P_NODE_17693_length_245_cov_0.895349_g17496_i0 | PRJNA949785 | 17693 | 245 | 0.895349 | 2.19360505 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 73.2 | 2.88e-14 | NR | UZH43396.1 | RQ14 | g17496 | i0 | 50 | 1.61632653061224 | 66 | 33 | 80.8 | 0 | 46 | 243 | 33 | 98 | UZH43396.1 uracil DNA glycosylase, partial [Carp edema virus] | diamond | 396 | 73.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31131098 | 31131098 | PRJNA949785_P_NODE_12255_length_291_cov_0.908257_g12058_i0 | PRJNA949785 | 12255 | 291 | 0.908257 | 2.64302787 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 68.6 | 5.71e-11 | NR | BCT22678.1 | RQ14 | g12058 | i0 | 36.7 | 0.927835051546392 | 90 | 57 | 92.8 | 0 | 277 | 8 | 1875 | 1964 | BCT22678.1 B22R protein [Carp edema virus] | diamond | 270 | 68.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31289317 | 31289317 | PRJNA949785_P_NODE_8055_length_375_cov_1.529801_g7858_i0 | PRJNA949785 | 8055 | 375 | 1.529801 | 5.73675375 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 123 | 1.11e-29 | NR | BCT22673.1 | RQ14 | g7858 | i0 | 77.9 | 0.544 | 68 | 15 | 54.4 | 0 | 3 | 206 | 1103 | 1170 | BCT22673.1 DNA-dependent RNA polymerase subunit rpo132 [Carp edema virus] | diamond | 204 | 123 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31352771 | 31352771 | PRJNA949785_P_NODE_11796_length_297_cov_1.375000_g11599_i0 | PRJNA949785 | 11796 | 297 | 1.375 | 4.08375 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 70.9 | 1.01e-13 | NR | BCT22645.1 | RQ14 | g11599 | i0 | 50 | 0.707070707070707 | 70 | 35 | 70.7 | 0 | 13 | 222 | 5 | 74 | BCT22645.1 S-S bond formation pathway protein [Carp edema virus] | diamond | 210 | 70.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 32016929 | 32016929 | PRJNA949785_P_NODE_14558_length_261_cov_2.457447_g14361_i0 | PRJNA949785 | 14558 | 261 | 2.457447 | 6.41393667 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 48.5 | 5.44e-5 | NR | BCT22656.1 | RQ14 | g14361 | i0 | 40 | 0.977011494252874 | 85 | 42 | 96.6 | 3 | 3 | 254 | 12 | 88 | BCT22656.1 hypothetical protein [Carp edema virus] | diamond | 255 | 48.5 | 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);;