contig_metadata
9 rows where bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28593618 | 28593618 | PRJNA533114_P_NODE_12347_length_643_cov_2.121053_g12107_i0 | PRJNA533114 | 12347 | 643 | 2.121053 | 13.63837079 | Solumvirus sp. | 2487773 | Viruses | Viruses | 197 | 8.97e-60 | NR | AYV86227.1 | 2487773 | g12107 | i0 | 63.7 | 0.732503888024883 | 157 | 52 | 70.9 | 1 | 114 | 569 | 31 | 187 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 471 | 197 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 28751453 | 28751453 | PRJNA533114_P_NODE_7687_length_805_cov_1.819672_g7485_i0 | PRJNA533114 | 7687 | 805 | 1.819672 | 14.6483596 | Solumvirus sp. | 2487773 | Viruses | Viruses | 140 | 4.0899999999999995e-35 | NR | AYV86402.1 | 2487773 | g7485 | i0 | 32.5 | 1.00993788819876 | 271 | 167 | 99.1 | 7 | 800 | 3 | 30 | 289 | AYV86402.1 MAG: hypothetical protein Solumvirus9_2 [Solumvirus sp.] | diamond | 813 | 140 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 28908980 | 28908980 | PRJNA533114_P_NODE_40248_length_366_cov_1.037543_g39996_i0 | PRJNA533114 | 40248 | 366 | 1.037543 | 3.79740738 | Cedratvirus Zaza IHUMI | 2126979 | Viruses | Viruses | 120 | 1.08e-30 | NR | SPN79546.1 | 2126979 | g39996 | i0 | 50.8 | 2.95081967213115 | 122 | 55 | 95.9 | 2 | 355 | 5 | 14 | 135 | SPN79546.1 2OF-Fe(II) oxygenase [Cedratvirus Zaza IHUMI] | diamond | 1080 | 120 | 1 | Viruses | Pithoviruses | Cedratvirus Zaza IHUMI | |||||||
| 30330907 | 30330907 | PRJNA533114_P_NODE_31992_length_405_cov_1.391566_g31740_i0 | PRJNA533114 | 31992 | 405 | 1.391566 | 5.6358423 | Solumvirus sp. | 2487773 | Viruses | Viruses | 50.4 | 3.92e-4 | NR | AYV86402.1 | 2487773 | g31740 | i0 | 36.8 | 0.503703703703704 | 68 | 38 | 50.4 | 1 | 206 | 3 | 25 | 87 | AYV86402.1 MAG: hypothetical protein Solumvirus9_2 [Solumvirus sp.] | diamond | 204 | 50.4 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 30362394 | 30362394 | PRJNA533114_P_NODE_109672_length_245_cov_0.895349_g109420_i0 | PRJNA533114 | 109672 | 245 | 0.895349 | 2.19360505 | Solumvirus sp. | 2487773 | Viruses | Viruses | 104 | 1.41e-25 | NR | AYV86227.1 | 2487773 | g109420 | i0 | 65 | 0.979591836734694 | 80 | 27 | 98 | 1 | 240 | 1 | 69 | 147 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 240 | 104 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 30582966 | 30582966 | PRJNA533114_P_NODE_22413_length_479_cov_1.517241_g22163_i0 | PRJNA533114 | 22413 | 479 | 1.517241 | 7.26758439 | Solumvirus sp. | 2487773 | Viruses | Viruses | 150 | 2.4499999999999994e-42 | NR | AYV86227.1 | 2487773 | g22163 | i0 | 81.4 | 0.538622129436326 | 86 | 16 | 53.9 | 0 | 2 | 259 | 92 | 177 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 258 | 150 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 31862527 | 31862527 | PRJNA533114_P_NODE_110657_length_245_cov_0.895349_g110405_i0 | PRJNA533114 | 110657 | 245 | 0.895349 | 2.19360505 | Alphacedratvirus | 3152632 | Viruses | Viruses | 47 | 0.00119 | NR | QIN54556.1 | 2716914 | g110405 | i0 | 40 | 2.37551020408163 | 65 | 35 | 77.1 | 2 | 21 | 209 | 327 | 389 | QIN54556.1 nucleoside phosphorylase [Cedratvirus kamchatka] | diamond | 582 | 47.4 | 0.991561181434599 | Viruses | Pithoviruses | Alphacedratvirus | Alphacedratvirus rossiense | ||||||
| 32449100 | 32449100 | PRJNA533114_P_NODE_34599_length_391_cov_1.377358_g34347_i0 | PRJNA533114 | 34599 | 391 | 1.377358 | 5.38546978 | Solumvirus sp. | 2487773 | Viruses | Viruses | 180 | 1.2699999999999999e-54 | NR | AYV86227.1 | 2487773 | g34347 | i0 | 69.5 | 0.982097186700767 | 128 | 39 | 98.2 | 0 | 7 | 390 | 42 | 169 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 384 | 180 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 32449137 | 32449137 | PRJNA533114_P_NODE_59799_length_308_cov_1.310638_g59547_i0 | PRJNA533114 | 59799 | 308 | 1.310638 | 4.03676504 | Solumvirus sp. | 2487773 | Viruses | Viruses | 67.8 | 3.69e-11 | NR | AYV86227.1 | 2487773 | g59547 | i0 | 50.9 | 0.555194805194805 | 57 | 28 | 55.5 | 0 | 172 | 2 | 42 | 98 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 171 | 67.8 | 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);;