contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA429937" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26663875 | 26663875 | PRJNA429937_P_NODE_106381_length_284_cov_2.678431_g83761_i0 | PRJNA429937 | 106381 | 284 | 2.678431 | 7.60674404 | Bombyx mori latent virus | 2065033 | Viruses | Viruses | 77.8 | 5.42e-15 | NR | YP_009505643.1 | 2065033 | g83761 | i0 | 53.3 | 0.792253521126761 | 75 | 32 | 79.2 | 1 | 60 | 284 | 151 | 222 | YP_009505643.1 coat protein [Bombyx mori latent virus] | diamond | 225 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Bombyx mori latent virus | |||
| 26997150 | 26997150 | PRJNA429937_P_NODE_149302_length_185_cov_2.051282_g126675_i0 | PRJNA429937 | 149302 | 185 | 2.051282 | 3.7948717 | Maculavirus | 249185 | Viruses | Viruses | 52.4 | 6.91e-6 | NR | YP_009551952.1 | 2094260 | g126675 | i0 | 56.3 | 1.52432432432432 | 48 | 19 | 74.6 | 1 | 26 | 163 | 713 | 760 | YP_009551952.1 polyprotein [Bee Macula-Like virus 2] | diamond | 282 | 52.8 | 0.992424242424242 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bee Macula-Like virus 2 | ||
| 28023365 | 28023365 | PRJNA429937_P_NODE_40965_length_562_cov_3.493433_g25973_i0 | PRJNA429937 | 40965 | 562 | 3.493433 | 19.63309346 | Wufeng shrew carmotetravirus 1 | 3077505 | Viruses | Viruses | 56.6 | 1.31e-5 | NR | WOK58419.1 | 3077505 | g25973 | i0 | 29.2 | 0.47508896797153 | 89 | 63 | 47.5 | 0 | 388 | 122 | 539 | 627 | WOK58419.1 MAG: RNA-dependent RNA polymerase [Wufeng shrew carmotetravirus 1] | diamond | 267 | 56.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Carmotetraviridae | Wufeng shrew carmotetravirus 1 | |||
| 28086322 | 28086322 | PRJNA429937_P_NODE_67805_length_412_cov_2.070496_g46622_i0 | PRJNA429937 | 67805 | 412 | 2.070496 | 8.53044352 | Tymovirales sp. | 1955157 | Viruses | Viruses | 58.2 | 1.04e-6 | NR | XCO49695.1 | 1955157 | g46622 | i0 | 43.1 | 1.05582524271845 | 72 | 41 | 52.4 | 0 | 282 | 67 | 1142 | 1213 | XCO49695.1 MAG: putative ORF1 protein [Tymovirales sp.] | diamond | 435 | 58.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. | ||||
| 28117887 | 28117887 | PRJNA429937_P_NODE_24745_length_738_cov_2.416079_g14787_i0 | PRJNA429937 | 24745 | 738 | 2.416079 | 17.83066302 | Tymovirales sp. | 1955157 | Viruses | Viruses | 77.8 | 3.77e-13 | NR | XCO49696.1 | 1955157 | g14787 | i0 | 65.5 | 0.443089430894309 | 55 | 19 | 22.4 | 0 | 524 | 688 | 150 | 204 | XCO49696.1 MAG: putative ORF2 protein [Tymovirales sp.] | diamond | 327 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. | ||||
| 28307494 | 28307494 | PRJNA429937_P_NODE_70386_length_401_cov_7.981183_g48811_i0 | PRJNA429937 | 70386 | 401 | 7.981183 | 32.00454383 | Bombyx mori Macula-like virus | 288456 | Viruses | Viruses | 85.9 | 1.9e-18 | NR | YP_004464932.1 | 288456 | g48811 | i0 | 40.6 | 0.718204488778055 | 96 | 57 | 71.8 | 0 | 357 | 70 | 39 | 134 | YP_004464932.1 unnamed protein product [Bombyx mori Macula-like virus] | diamond | 288 | 85.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-like virus | ||
| 28907123 | 28907123 | PRJNA429937_P_NODE_79528_length_367_cov_8.698225_g57161_i0 | PRJNA429937 | 79528 | 367 | 8.698225 | 31.92248575 | Bombyx mori Macula-like virus | 288456 | Viruses | Viruses | 85.9 | 1.31e-18 | NR | YP_004464932.1 | 288456 | g57161 | i0 | 40.6 | 0.784741144414169 | 96 | 57 | 78.5 | 0 | 11 | 298 | 39 | 134 | YP_004464932.1 unnamed protein product [Bombyx mori Macula-like virus] | diamond | 288 | 85.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-like virus | ||
| 29128629 | 29128629 | PRJNA429937_P_NODE_68229_length_410_cov_2.858268_g46971_i0 | PRJNA429937 | 68229 | 410 | 2.858268 | 11.7188988 | Drosophila-associated tymovirus | 2900522 | Viruses | Viruses | 110 | 5.01e-25 | NR | UFT26908.1 | 2900522 | g46971 | i0 | 61.4 | 1.90975609756098 | 83 | 32 | 60.7 | 0 | 65 | 313 | 13 | 95 | UFT26908.1 putative polyprotein [Drosophila-associated tymovirus] | diamond | 783 | 110 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Drosophila-associated tymovirus | ||||
| 29886330 | 29886330 | PRJNA429937_P_NODE_24891_length_736_cov_2.512023_g14870_i0 | PRJNA429937 | 24891 | 736 | 2.512023 | 18.48848928 | Tymovirales sp. | 1955157 | Viruses | Viruses | 77.8 | 3.7e-13 | NR | XCO49696.1 | 1955157 | g14870 | i0 | 65.5 | 0.44429347826087 | 55 | 19 | 22.4 | 0 | 215 | 51 | 150 | 204 | XCO49696.1 MAG: putative ORF2 protein [Tymovirales sp.] | diamond | 327 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. | ||||
| 31687550 | 31687550 | PRJNA429937_P_NODE_80297_length_365_cov_2.672619_g57897_i0 | PRJNA429937 | 80297 | 365 | 2.672619 | 9.75505935 | Tymovirales sp. | 1955157 | Viruses | Viruses | 77.8 | 1.42e-14 | NR | XCO49696.1 | 1955157 | g57897 | i0 | 65.5 | 0.895890410958904 | 55 | 19 | 45.2 | 0 | 151 | 315 | 150 | 204 | XCO49696.1 MAG: putative ORF2 protein [Tymovirales sp.] | diamond | 327 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. | ||||
| 32888172 | 32888172 | PRJNA429937_P_NODE_60060_length_447_cov_2.669856_g40376_i0 | PRJNA429937 | 60060 | 447 | 2.669856 | 11.93425632 | Tymovirales sp. | 1955157 | Viruses | Viruses | 77.8 | 2.17e-13 | NR | XCO49695.1 | 1955157 | g40376 | i0 | 51.3 | 0.536912751677852 | 80 | 26 | 52.3 | 2 | 211 | 444 | 60 | 128 | XCO49695.1 MAG: putative ORF1 protein [Tymovirales sp.] | diamond | 240 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. |
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);;