contig_metadata
6 rows where bioproject = "PRJNA1247234", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1626013 | 1626013 | PRJNA1247234_P_NODE_14862_length_291_cov_1.431193_g14706_i0 | PRJNA1247234 | 14862 | 291 | 1.431193 | 4.16477163 | Erysiphe necator associated mitovirus 35 | 2950447 | Viruses | Viruses | 494 | 3.7299999999999996e-135 | NTclustered | gi|2250491993|gb|ON605605.1| | 2950447 | g14706 | i0 | 97.251 | 9.43642611683849 | 291 | 8 | 100 | 0 | 1 | 291 | 1948 | 2238 | Erysiphe necator associated mitovirus 35 RNA-dependent RNA polymerase gene, complete cds | blastn | 2746 | 494 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Erysiphe necator associated mitovirus 35 | ||
| 16928720 | 16928720 | PRJNA1247234_P_NODE_24794_length_246_cov_0.901734_g24638_i0 | PRJNA1247234 | 24794 | 246 | 0.901734 | 2.21826564 | Sclerotinia sclerotiorum mitovirus 3-WX | 2822885 | Viruses | Viruses | 425 | 1.14e-114 | NTclustered | gi|2029278333|gb|MT646425.1| | 2822885 | g24638 | i0 | 97.959 | 9.89024390243902 | 245 | 5 | 99 | 0 | 1 | 245 | 1601 | 1845 | MAG: Sclerotinia sclerotiorum mitovirus 3-WX, partial genome | blastn | 2433 | 425 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sclerotinia sclerotiorum mitovirus 3-WX | ||
| 20752938 | 20752938 | PRJNA1247234_P_NODE_21557_length_251_cov_0.876404_g21401_i0 | PRJNA1247234 | 21557 | 251 | 0.876404 | 2.19977404 | Sclerotinia sclerotiorum mitovirus 3-WX | 2822885 | Viruses | Viruses | 440 | 4.149999999999998e-119 | NTclustered | gi|2029278333|gb|MT646425.1| | 2822885 | g21401 | i0 | 98.4 | 8.93227091633466 | 250 | 4 | 99 | 0 | 2 | 251 | 1512 | 1263 | MAG: Sclerotinia sclerotiorum mitovirus 3-WX, partial genome | blastn | 2242 | 440 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sclerotinia sclerotiorum mitovirus 3-WX | ||
| 20753164 | 20753164 | PRJNA1247234_P_NODE_7497_length_383_cov_1.458065_g7341_i0 | PRJNA1247234 | 7497 | 383 | 1.458065 | 5.58438895 | Duamitovirus boci1 | 2955769 | Viruses | Viruses | 656 | 0 | NTclustered | gi|955660101|emb|LN827944.1| | 444193 | g7341 | i0 | 97.65 | 6.25065274151436 | 383 | 8 | 100 | 1 | 1 | 383 | 398 | 17 | Botrytis cinerea mitovirus 1 RdRp gene for RNA dependent RNA polymerase, isolate HAZ3-1 | blastn | 2394 | 656 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Duamitovirus | Duamitovirus boci1 | ||
| 22028055 | 22028055 | PRJNA1247234_P_NODE_15358_length_287_cov_2.028037_g15202_i0 | PRJNA1247234 | 15358 | 287 | 2.028037 | 5.82046619 | Sclerotinia sclerotiorum mitovirus 3-WX | 2822885 | Viruses | Viruses | 497 | 2.84e-136 | NTclustered | gi|2029278333|gb|MT646425.1| | 2822885 | g15202 | i0 | 97.909 | 13.191637630662 | 287 | 6 | 100 | 0 | 1 | 287 | 1296 | 1010 | MAG: Sclerotinia sclerotiorum mitovirus 3-WX, partial genome | blastn | 3786 | 497 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sclerotinia sclerotiorum mitovirus 3-WX | ||
| 22028081 | 22028081 | PRJNA1247234_P_NODE_16558_length_278_cov_1.502439_g16402_i0 | PRJNA1247234 | 16558 | 278 | 1.502439 | 4.17678042 | Duamitovirus scsc3 | 2955836 | Viruses | Viruses | 448 | 2.79e-121 | NTclustered | gi|1838367559|gb|MN954876.1| | 1279099 | g16402 | i0 | 95.683 | 1 | 278 | 12 | 100 | 0 | 1 | 278 | 2960 | 2683 | Sclerotinia sclerotiorum mitovirus 3 isolate BCI2_DN28, complete genome | blastn | 278 | 448 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Duamitovirus | Duamitovirus scsc3 |
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);;