contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA695273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26829654 | 26829654 | PRJNA695273_P_NODE_99261_length_280_cov_2.956522_g98503_i0 | PRJNA695273 | 99261 | 280 | 2.956522 | 8.2782616 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 54.7 | 3.56e-6 | NR | YP_009448336.1 | 2023057 | g98503 | i0 | 35.2 | 1.875 | 88 | 55 | 93.2 | 2 | 3 | 263 | 651 | 737 | YP_009448336.1 Immunoglobulin-like fold protein [Orpheovirus IHUMI-LCC2] | diamond | 525 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 27746284 | 27746284 | PRJNA695273_P_NODE_73804_length_321_cov_1.552419_g73046_i0 | PRJNA695273 | 73804 | 321 | 1.552419 | 4.98326499 | Melanoplus sanguinipes entomopoxvirus | 83191 | Viruses | Viruses | 100 | 2.04e-25 | NR | NP_048125.1 | 83191 | g73046 | i0 | 84.8 | 0.738317757009346 | 79 | 12 | 73.8 | 0 | 238 | 2 | 1 | 79 | NP_048125.1 ORF MSV054 hypothetical protein [Melanoplus sanguinipes entomopoxvirus] | diamond | 237 | 100 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Deltaentomopoxvirus | Deltaentomopoxvirus msanguinipes | ||
| 27935561 | 27935561 | PRJNA695273_P_NODE_148245_length_244_cov_1.777778_g147487_i0 | PRJNA695273 | 148245 | 244 | 1.777778 | 4.33777832 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 45.4 | 0.00127 | NR | YP_010803065.1 | 3060017 | g147487 | i0 | 48.4 | 0.786885245901639 | 64 | 27 | 78.7 | 2 | 220 | 29 | 1 | 58 | YP_010803065.1 Cro/C1 type helix-turn-helix protein [Fadolivirus algeromassiliense] | diamond | 192 | 45.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 28598702 | 28598702 | PRJNA695273_P_NODE_155027_length_242_cov_1.668639_g154269_i0 | PRJNA695273 | 155027 | 242 | 1.668639 | 4.03810638 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 72.8 | 9.28e-13 | NR | YP_010782467.1 | 2126985 | g154269 | i0 | 47.4 | 1.95867768595041 | 78 | 38 | 94.2 | 2 | 239 | 12 | 339 | 415 | YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake] | diamond | 474 | 72.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 28914073 | 28914073 | PRJNA695273_P_NODE_79408_length_310_cov_1.299578_g78650_i0 | PRJNA695273 | 79408 | 310 | 1.299578 | 4.0286918 | Melanoplus sanguinipes entomopoxvirus | 83191 | Viruses | Viruses | 58.2 | 9.6e-8 | NR | NP_048243.1 | 83191 | g78650 | i0 | 49.4 | 0.764516129032258 | 79 | 31 | 76.5 | 4 | 243 | 7 | 39 | 108 | NP_048243.1 ORF MSV172 hypothetical protein [Melanoplus sanguinipes entomopoxvirus] | diamond | 237 | 58.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Deltaentomopoxvirus | Deltaentomopoxvirus msanguinipes | ||
| 29450777 | 29450777 | PRJNA695273_P_NODE_75490_length_318_cov_1.032653_g74732_i0 | PRJNA695273 | 75490 | 318 | 1.032653 | 3.28383654 | Melanoplus sanguinipes entomopoxvirus | 83191 | Viruses | Viruses | 189 | 3.56e-53 | NR | NP_048113.1 | 83191 | g74732 | i0 | 87.7 | 1 | 106 | 13 | 100 | 0 | 318 | 1 | 295 | 400 | NP_048113.1 ORF MSV043 putative RNA polymerase largest subunit RPO147 homolog (vaccinia J6R), similar to SW:P20504 [Melanoplus sanguinipes entomopoxvirus] | diamond | 318 | 189 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Deltaentomopoxvirus | Deltaentomopoxvirus msanguinipes | ||
| 29893292 | 29893292 | PRJNA695273_P_NODE_129371_length_250_cov_0.870056_g128613_i0 | PRJNA695273 | 129371 | 250 | 0.870056 | 2.17514 | Melanoplus sanguinipes entomopoxvirus | 83191 | Viruses | Viruses | 112 | 4.35e-30 | NR | NP_048232.1 | 83191 | g128613 | i0 | 81.2 | 0.828 | 69 | 13 | 82.8 | 0 | 19 | 225 | 15 | 83 | NP_048232.1 ORF MSV161 putative Helothis armigera EPV ORF F2 protein, similar to GB:AF019224 [Melanoplus sanguinipes entomopoxvirus] | diamond | 207 | 112 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Deltaentomopoxvirus | Deltaentomopoxvirus msanguinipes | ||
| 30240708 | 30240708 | PRJNA695273_P_NODE_68112_length_333_cov_1.642308_g67354_i0 | PRJNA695273 | 68112 | 333 | 1.642308 | 5.46888564 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 66.6 | 4.49e-10 | NR | YP_009449258.1 | 2023057 | g67354 | i0 | 43.1 | 0.918918918918919 | 102 | 49 | 91.9 | 3 | 332 | 27 | 865 | 957 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 306 | 66.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 30493484 | 30493484 | PRJNA695273_P_NODE_23153_length_578_cov_6.564356_g22401_i0 | PRJNA695273 | 23153 | 578 | 6.564356 | 37.94197768 | Melanoplus sanguinipes entomopoxvirus | 83191 | Viruses | Viruses | 191 | 1.72e-53 | NR | NP_048124.1 | 83191 | g22401 | i0 | 90.9 | 0.513840830449827 | 99 | 9 | 51.4 | 0 | 280 | 576 | 1 | 99 | NP_048124.1 ORF MSV053 putative nucleoside triphosphate phosphohydrolase, Choristoneura biennis entomopox virus NPH-1 (vaccinia D11L) homolog, similar to SW:P24486 [Melanoplus sanguinipes entomopoxvirus] | diamond | 297 | 191 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Deltaentomopoxvirus | Deltaentomopoxvirus msanguinipes | ||
| 30493492 | 30493492 | PRJNA695273_P_NODE_59133_length_355_cov_5.702128_g58375_i0 | PRJNA695273 | 59133 | 355 | 5.702128 | 20.2425544 | Melanoplus sanguinipes entomopoxvirus | 83191 | Viruses | Viruses | 111 | 3.06e-29 | NR | NP_048073.1 | 83191 | g58375 | i0 | 67.9 | 0.709859154929578 | 84 | 27 | 71 | 0 | 345 | 94 | 5 | 88 | NP_048073.1 ORF MSV002 89 amino acid repeat gene family protein [Melanoplus sanguinipes entomopoxvirus] | diamond | 252 | 111 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Deltaentomopoxvirus | Deltaentomopoxvirus msanguinipes | ||
| 31631258 | 31631258 | PRJNA695273_P_NODE_58276_length_358_cov_1.347368_g57518_i0 | PRJNA695273 | 58276 | 358 | 1.347368 | 4.82357744 | Melanoplus sanguinipes entomopoxvirus | 83191 | Viruses | Viruses | 137 | 3.67e-39 | NR | NP_048128.1 | 83191 | g57518 | i0 | 63.8 | 0.972067039106145 | 116 | 36 | 92.2 | 2 | 1 | 330 | 17 | 132 | NP_048128.1 ORF MSV057 hypothetical protein [Melanoplus sanguinipes entomopoxvirus] | diamond | 348 | 137 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Deltaentomopoxvirus | Deltaentomopoxvirus msanguinipes |
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);;