contig_metadata
8 rows where bioproject = "PRJNA724011" and tax_clade = "Pithoviruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5813933 | 5813933 | PRJNA724011_P_NODE_103205_length_245_cov_0.895349_g102182_i0 | PRJNA724011 | 103205 | 245 | 0.895349 | 2.19360505 | Solumvirus sp. | 2487773 | Viruses | Viruses | 109 | 1.12e-27 | NR | AYV86227.1 | 2487773 | g102182 | i0 | 86.7 | 0.73469387755102 | 60 | 8 | 73.5 | 0 | 244 | 65 | 125 | 184 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 180 | 109 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 10914595 | 10914595 | PRJNA724011_P_NODE_34049_length_467_cov_1.847716_g33030_i0 | PRJNA724011 | 34049 | 467 | 1.847716 | 8.62883372 | Solumvirus sp. | 2487773 | Viruses | Viruses | 190 | 5.46e-58 | NR | AYV86227.1 | 2487773 | g33030 | i0 | 71.5 | 0.880085653104925 | 137 | 38 | 88 | 1 | 454 | 44 | 42 | 177 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 411 | 190 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 27083781 | 27083781 | PRJNA724011_P_NODE_322_length_3833_cov_5.155585_g249_i0 | PRJNA724011 | 322 | 3833 | 5.155585 | 197.61357305 | Solumvirus sp. | 2487773 | Viruses | Viruses | 160 | 3.31e-38 | NR | AYV86402.1 | 2487773 | g249 | i0 | 31.9 | 0.242629793895121 | 310 | 209 | 24.2 | 2 | 1984 | 1058 | 38 | 346 | AYV86402.1 MAG: hypothetical protein Solumvirus9_2 [Solumvirus sp.] | diamond | 930 | 160 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 28788951 | 28788951 | PRJNA724011_P_NODE_86747_length_264_cov_1.209424_g85724_i0 | PRJNA724011 | 86747 | 264 | 1.209424 | 3.19287936 | Pithovirus LCDPAC | 2506600 | Viruses | Viruses | 53.5 | 4.1e-6 | NR | QBK84707.1 | 2506600 | g85724 | i0 | 34.2 | 0.897727272727273 | 79 | 50 | 88.6 | 2 | 262 | 29 | 21 | 98 | QBK84707.1 MAG: hypothetical protein LCDPAC01_01880 [Pithovirus LCDPAC01] | diamond | 237 | 53.5 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC01 | |||||||
| 29767787 | 29767787 | PRJNA724011_P_NODE_7551_length_1153_cov_8.466667_g6875_i0 | PRJNA724011 | 7551 | 1153 | 8.466667 | 97.62067051 | Pithovirus LCPAC1 | 2506586 | Viruses | Viruses | 194 | 2.0899999999999994e-54 | NR | QBK89990.1 | 2506586 | g6875 | i0 | 32.1 | 1.0225498699046 | 393 | 221 | 91.6 | 10 | 1094 | 39 | 5 | 392 | QBK89990.1 MAG: phosphoribosyl transferase domain protein [Pithovirus LCPAC101] | diamond | 1179 | 194 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC101 | |||||||
| 30115204 | 30115204 | PRJNA724011_P_NODE_14332_length_807_cov_15.138965_g13398_i0 | PRJNA724011 | 14332 | 807 | 15.138965 | 122.17144755 | Solumvirus sp. | 2487773 | Viruses | Viruses | 201 | 1.33e-60 | NR | AYV86227.1 | 2487773 | g13398 | i0 | 70 | 0.520446096654275 | 140 | 42 | 52 | 0 | 203 | 622 | 41 | 180 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 420 | 201 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 30589129 | 30589129 | PRJNA724011_P_NODE_16813_length_732_cov_2.449165_g15834_i0 | PRJNA724011 | 16813 | 732 | 2.449165 | 17.9278878 | Solumvirus sp. | 2487773 | Viruses | Viruses | 116 | 2.22e-26 | NR | AYV86402.1 | 2487773 | g15834 | i0 | 33.7 | 0.80327868852459 | 196 | 126 | 78.7 | 4 | 152 | 727 | 11 | 206 | AYV86402.1 MAG: hypothetical protein Solumvirus9_2 [Solumvirus sp.] | diamond | 588 | 116 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 31917117 | 31917117 | PRJNA724011_P_NODE_79477_length_278_cov_2.326829_g78454_i0 | PRJNA724011 | 79477 | 278 | 2.326829 | 6.46858462 | Solumvirus sp. | 2487773 | Viruses | Viruses | 53.1 | 1.18e-5 | NR | AYV86402.1 | 2487773 | g78454 | i0 | 32.3 | 1.03597122302158 | 96 | 56 | 98.2 | 2 | 2 | 274 | 209 | 300 | AYV86402.1 MAG: hypothetical protein Solumvirus9_2 [Solumvirus sp.] | diamond | 288 | 53.1 | 1 | Viruses | Pithoviruses | Solumvirus 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);;