contig_metadata
8 rows where bioproject = "PRJNA379145", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1675574 | 1675574 | PRJNA379145_P_NODE_39162_length_310_cov_2.837545_g37011_i0 | PRJNA379145 | 39162 | 310 | 2.837545 | 8.7963895 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 562 | 1.08e-155 | NTclustered | gi|2053223585|tpg|BK018547.1| | 2583949 | g37011 | i0 | 99.355 | 5 | 310 | 2 | 100 | 0 | 1 | 310 | 2135 | 2444 | MAG TPA_asm: Narnaviridae sp. isolate ctd2J1, partial genome | blastn | 1550 | 562 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 6778659 | 6778659 | PRJNA379145_P_NODE_44486_length_267_cov_8.884615_g42334_i0 | PRJNA379145 | 44486 | 267 | 8.884615 | 23.72192205 | Mitovirus sp. | 2587224 | Viruses | Viruses | 159 | 1.4e-34 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g42334 | i0 | 91.379 | 1.10861423220974 | 116 | 10 | 43 | 0 | 145 | 260 | 116 | 1 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 296 | 159 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 8054203 | 8054203 | PRJNA379145_P_NODE_48847_length_240_cov_1.797101_g46693_i0 | PRJNA379145 | 48847 | 240 | 1.797101 | 4.3130424 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 438 | 1.4199999999999995e-118 | NTclustered | gi|2053223585|tpg|BK018547.1| | 2583949 | g46693 | i0 | 99.583 | 4.825 | 240 | 1 | 100 | 0 | 1 | 240 | 343 | 104 | MAG TPA_asm: Narnaviridae sp. isolate ctd2J1, partial genome | blastn | 1158 | 438 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 9329033 | 9329033 | PRJNA379145_P_NODE_47928_length_245_cov_8.594340_g45775_i0 | PRJNA379145 | 47928 | 245 | 8.59434 | 21.056133 | Mitovirus sp. | 2587224 | Viruses | Viruses | 119 | 2.15e-22 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g45775 | i0 | 93.671 | 0.322448979591837 | 79 | 5 | 32 | 0 | 145 | 223 | 111 | 33 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 79 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 14429713 | 14429713 | PRJNA379145_P_NODE_48572_length_241_cov_15.865385_g46418_i0 | PRJNA379145 | 48572 | 241 | 15.865385 | 38.23557785 | Mitovirus sp. | 2587224 | Viruses | Viruses | 119 | 2.11e-22 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g46418 | i0 | 93.671 | 0.327800829875519 | 79 | 5 | 33 | 0 | 141 | 219 | 111 | 33 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 79 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 14429854 | 14429854 | PRJNA379145_P_NODE_64752_length_173_cov_1.928571_g62598_i0 | PRJNA379145 | 64752 | 173 | 1.928571 | 3.33642783 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 320 | 3.61e-83 | NTclustered | gi|2053223585|tpg|BK018547.1| | 2583949 | g62598 | i0 | 100 | 5 | 173 | 0 | 100 | 0 | 1 | 173 | 914 | 742 | MAG TPA_asm: Narnaviridae sp. isolate ctd2J1, partial genome | blastn | 865 | 320 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 15703800 | 15703800 | PRJNA379145_P_NODE_62113_length_181_cov_3.763514_g59959_i0 | PRJNA379145 | 62113 | 181 | 3.763514 | 6.81196034 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 329 | 6.340000000000001e-86 | NTclustered | gi|2053223585|tpg|BK018547.1| | 2583949 | g59959 | i0 | 99.448 | 4.97790055248619 | 181 | 1 | 100 | 0 | 1 | 181 | 1492 | 1312 | MAG TPA_asm: Narnaviridae sp. isolate ctd2J1, partial genome | blastn | 901 | 329 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 20802563 | 20802563 | PRJNA379145_P_NODE_67237_length_166_cov_2.052632_g65083_i0 | PRJNA379145 | 67237 | 166 | 2.052632 | 3.40736912 | Ripafren virus | 3130475 | Viruses | Viruses | 224 | 2.7799999999999995e-54 | NTclustered | gi|2717319844|gb|PP172777.1| | 3130475 | g65083 | i0 | 91.071 | 44.4939759036145 | 168 | 11 | 100 | 3 | 1 | 166 | 939 | 774 | MAG: Ripafren virus isolate KCAP1_k141_546482 genomic sequence | blastn | 7386 | 224 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripafren virus |
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);;