contig_metadata
7 rows where bioproject = "PRJNA760976", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27053216 | 27053216 | PRJNA760976_P_NODE_14562_length_390_cov_1.637224_g14242_i0 | PRJNA760976 | 14562 | 390 | 1.637224 | 6.3851736 | Cryphonectria naterciae splipalmivirus 1 | 2841740 | Viruses | Viruses | 73.6 | 3.22e-12 | NR | BCX55510.1 | 2841740 | g14242 | i0 | 32.3 | 1 | 130 | 84 | 96.9 | 2 | 378 | 1 | 108 | 237 | BCX55510.1 putative RNA-dependent RNA polymerase [Cryphonectria naterciae splipalmivirus 1] | diamond | 390 | 73.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Divipalmivirus | Divipalmivirus cryphonectriae | ||
| 27116129 | 27116129 | PRJNA760976_P_NODE_1322_length_1082_cov_3.175421_g1113_i0 | PRJNA760976 | 1322 | 1082 | 3.175421 | 34.35805522 | Downy mildew lesion associated splipalmivirus 46 | 3065434 | Viruses | Viruses | 63.9 | 5.23e-7 | NR | WLJ60693.1 | 3065434 | g1113 | i0 | 32.1 | 0.371534195933457 | 134 | 80 | 36.3 | 3 | 13 | 405 | 415 | 540 | WLJ60693.1 MAG: putative RdRp [Downy mildew lesion associated splipalmivirus 46] | diamond | 402 | 63.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 46 | ||
| 29683472 | 29683472 | PRJNA760976_P_NODE_770_length_1365_cov_2.842105_g629_i0 | PRJNA760976 | 770 | 1365 | 2.842105 | 38.79473325 | Wolframvirales | 2732502 | Viruses | Viruses | 116 | 7.48e-24 | NR | BCH36628.1 | 2250450 | g629 | i0 | 26.6 | 2.05934065934066 | 305 | 213 | 65.9 | 6 | 1029 | 130 | 56 | 354 | BCH36628.1 hypothetical protein [Aspergillus fumigatus narnavirus 2] | diamond | 2811 | 116 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Divipalmivirus | Divipalmivirus aspergilli | ||
| 29926916 | 29926916 | PRJNA760976_P_NODE_2471_length_814_cov_2.979757_g2190_i0 | PRJNA760976 | 2471 | 814 | 2.979757 | 24.25522198 | Downy mildew lesion associated splipalmivirus 3 | 2719514 | Viruses | Viruses | 86.3 | 4.9e-16 | NR | WNA22210.1 | 2719514 | g2190 | i0 | 31.6 | 0.77027027027027 | 209 | 123 | 73.3 | 7 | 688 | 92 | 40 | 238 | WNA22210.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 3] | diamond | 627 | 86.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus ibericum | ||
| 30779833 | 30779833 | PRJNA760976_P_NODE_674_length_1436_cov_2.030081_g543_i0 | PRJNA760976 | 674 | 1436 | 2.030081 | 29.15196316 | Penaeus vannamei narna-like virus 2 | 3132560 | Viruses | Viruses | 387 | 1.4e-123 | NR | WWZ85650.1 | 3132560 | g543 | i0 | 44.7 | 0.981894150417827 | 470 | 247 | 97.6 | 10 | 33 | 1433 | 2 | 461 | WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2] | diamond | 1410 | 387 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Penaeus vannamei narna-like virus 2 | |||
| 31990926 | 31990926 | PRJNA760976_P_NODE_6918_length_518_cov_1.375281_g6600_i0 | PRJNA760976 | 6918 | 518 | 1.375281 | 7.12395558 | Narnavirus | 186767 | Viruses | Viruses | 62.4 | 3.34e-8 | NR | WNA22207.1 | 2719503 | g6600 | i0 | 34.5 | 1.28571428571429 | 113 | 73 | 65.4 | 1 | 376 | 38 | 5 | 116 | WNA22207.1 MAG: hypothetical protein, partial [Downy mildew lesion associated splipalmivirus 2] | diamond | 666 | 62.8 | 0.993630573248408 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 2 | ||
| 32107871 | 32107871 | PRJNA760976_P_NODE_15498_length_381_cov_2.032468_g15177_i0 | PRJNA760976 | 15498 | 381 | 2.032468 | 7.74370308 | Penaeus vannamei narna-like virus 2 | 3132560 | Viruses | Viruses | 76.3 | 3.35e-13 | NR | WWZ85650.1 | 3132560 | g15177 | i0 | 40.4 | 0.740157480314961 | 94 | 56 | 74 | 0 | 1 | 282 | 558 | 651 | WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2] | diamond | 282 | 76.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Penaeus vannamei narna-like virus 2 |
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);;