contig_metadata
5 rows where bioproject = "PRJNA758087" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2478155 | 2478155 | PRJNA758087_P_NODE_34322_length_346_cov_1.128205_g33002_i0 | PRJNA758087 | 34322 | 346 | 1.128205 | 3.9035893 | Mitovirus | 186768 | Viruses | Viruses | 394 | 4.72e-105 | NTclustered | gi|1826553873|gb|MN539764.1| | 2719445 | g33002 | i0 | 88.994 | 2.85838150289017 | 318 | 35 | 92 | 0 | 1 | 318 | 1717 | 2034 | Plasmopara viticola lesion associated mitovirus 2 isolate DMG-G_DN34676 RNA-dependent RNA polymerase gene, complete cds | blastn | 989 | 396 | 0.994949494949495 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Plasmopara viticola lesion associated mitovirus 2 | ||
| 7112019 | 7112019 | PRJNA758087_P_NODE_22946_length_545_cov_38.608051_g21629_i0 | PRJNA758087 | 22946 | 545 | 38.608051 | 210.41387795 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 245 | 2.09e-74 | NR | WAK77987.1 | 2808997 | g21629 | i0 | 71.6 | 2.77981651376147 | 169 | 46 | 91.9 | 1 | 37 | 537 | 414 | 582 | WAK77987.1 MAG: hypothetical protein [Botourmiaviridae sp.] | diamond | 1515 | 245 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 13487187 | 13487187 | PRJNA758087_P_NODE_26171_length_479_cov_5.541872_g24851_i0 | PRJNA758087 | 26171 | 479 | 5.541872 | 26.54556688 | Chrocagost virus | 3129398 | Viruses | Viruses | 496 | 1.79e-135 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g24851 | i0 | 87.443 | 397.281837160752 | 438 | 46 | 90 | 8 | 36 | 468 | 5862 | 5429 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 190298 | 496 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 22411035 | 22411035 | PRJNA758087_P_NODE_37298_length_305_cov_1.991379_g35978_i0 | PRJNA758087 | 37298 | 305 | 1.991379 | 6.07370595 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 82.4 | 3.63e-11 | NTclustered | gi|2396039834|gb|ON812955.1| | 2808997 | g35978 | i0 | 97.872 | 0.80655737704918 | 47 | 1 | 15 | 0 | 43 | 89 | 2427 | 2473 | MAG: Botourmiaviridae sp. isolate TIGMIC_13, complete genome | blastn | 246 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 24960145 | 24960145 | PRJNA758087_P_NODE_34220_length_347_cov_2.226277_g32900_i0 | PRJNA758087 | 34220 | 347 | 2.226277 | 7.72518119 | Plasmopara viticola lesion associated mitovirus 2 | 2719445 | Viruses | Viruses | 420 | 7.82e-113 | NTclustered | gi|1826553873|gb|MN539764.1| | 2719445 | g32900 | i0 | 88.506 | 3.01152737752161 | 348 | 38 | 100 | 2 | 1 | 347 | 1381 | 1727 | Plasmopara viticola lesion associated mitovirus 2 isolate DMG-G_DN34676 RNA-dependent RNA polymerase gene, complete cds | blastn | 1045 | 420 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Plasmopara viticola lesion associated mitovirus 2 |
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);;