contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA760976" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26799898 | 26799898 | PRJNA760976_P_NODE_4461_length_622_cov_2.060109_g4152_i0 | PRJNA760976 | 4461 | 622 | 2.060109 | 12.813877979999999 | Durnavirales sp. | 2809355 | Viruses | Viruses | 155 | 5.31e-41 | NR | WRQ64726.1 | 2809355 | g4152 | i0 | 39.3 | 0.993569131832797 | 206 | 124 | 98.9 | 1 | 621 | 7 | 238 | 443 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 618 | 155 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 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 | ||
| 28642013 | 28642013 | PRJNA760976_P_NODE_16947_length_370_cov_0.989899_g16626_i0 | PRJNA760976 | 16947 | 370 | 0.989899 | 3.6626263 | Wolframvirales | 2732502 | Viruses | Viruses | 102 | 1.45e-22 | NR | UTQ48830.1 | 2964624 | g16626 | i0 | 39.5 | 4.67837837837838 | 114 | 69 | 92.4 | 0 | 343 | 2 | 158 | 271 | UTQ48830.1 RNA-dependent RNA polymerase [Monilinia fructicola binarnavirus 1] | diamond | 1731 | 102 | 1 | Viruses | Orthornavirae | Birnaviridae | Monilinia fructicola binarnavirus 1 | ||||||
| 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 | |||
| 31538659 | 31538659 | PRJNA760976_P_NODE_2176_length_862_cov_1.612167_g1906_i0 | PRJNA760976 | 2176 | 862 | 1.612167 | 13.89687954 | Rhabdoviridae sp. | 1955137 | Viruses | Viruses | 80.1 | 8.02e-13 | NR | XKB76561.1 | 1955137 | g1906 | i0 | 27.6 | 0.755220417633411 | 217 | 134 | 71.3 | 6 | 243 | 857 | 170 | 375 | XKB76561.1 MAG: hypothetical protein [Rhabdoviridae sp.] | diamond | 651 | 80.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Rhabdoviridae sp. | |||
| 31664861 | 31664861 | PRJNA760976_P_NODE_39897_length_272_cov_1.095477_g39576_i0 | PRJNA760976 | 39897 | 272 | 1.095477 | 2.97969744 | Novo Mesto dicistrovirus 2 | 2950811 | Viruses | Viruses | 172 | 8.139999999999998e-48 | NR | UTQ50719.1 | 2950811 | g39576 | i0 | 91.1 | 0.992647058823529 | 90 | 8 | 99.3 | 0 | 270 | 1 | 730 | 819 | UTQ50719.1 MAG: capsid protein [Novo Mesto dicistrovirus 2] | diamond | 270 | 172 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Novo Mesto dicistrovirus 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 | |||
| 32645094 | 32645094 | PRJNA760976_P_NODE_640_length_1468_cov_4.090323_g513_i0 | PRJNA760976 | 640 | 1468 | 4.090323 | 60.04594164 | Durnavirales sp. | 2809355 | Viruses | Viruses | 287 | 1.2699999999999996e-87 | NR | WRQ64726.1 | 2809355 | g513 | i0 | 36.8 | 0.960490463215259 | 470 | 284 | 94 | 7 | 1384 | 5 | 6 | 472 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 1410 | 287 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales 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);;