contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26630783 | 26630783 | PRJNA168635_P_NODE_901_length_804_cov_11.684768_g659_i0 | PRJNA168635 | 901 | 804 | 11.684768 | 93.94553472 | Flumine noda-like virus 16 | 2941167 | Viruses | Viruses | 282 | 4.36e-87 | NR | UQB76287.1 | 2941167 | g659 | i0 | 56.6 | 1.98134328358209 | 265 | 114 | 98.9 | 1 | 9 | 803 | 39 | 302 | UQB76287.1 RNA-dependent RNA polymerase, partial [Flumine noda-like virus 16] | diamond | 1593 | 282 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Flumine noda-like virus 16 | |||
| 27154513 | 27154513 | PRJNA168635_P_NODE_26762_length_167_cov_2.601695_g26346_i0 | PRJNA168635 | 26762 | 167 | 2.601695 | 4.34483065 | Viruses | 10239 | Viruses | Viruses | 41.6 | 0.0345 | NR | WPR18419.1 | 3063124 | g26346 | i0 | 50 | 1.59880239520958 | 38 | 19 | 68.3 | 0 | 18 | 131 | 29 | 66 | WPR18419.1 MAG: capsid protein, partial [Skomarfal virus 22] | diamond | 267 | 42 | 0.990476190476191 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skomarfal virus 22 | |||
| 27706118 | 27706118 | PRJNA168635_P_NODE_21984_length_176_cov_3.047244_g21568_i0 | PRJNA168635 | 21984 | 176 | 3.047244 | 5.36314944 | Tolivirales sp. | 2809914 | Viruses | Viruses | 70.1 | 2.77e-12 | NR | WRQ65820.1 | 2809914 | g21568 | i0 | 54.4 | 1.94318181818182 | 57 | 26 | 97.2 | 0 | 5 | 175 | 100 | 156 | WRQ65820.1 structural protein [Tolivirales sp.] | diamond | 342 | 70.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 28273899 | 28273899 | PRJNA168635_P_NODE_10466_length_255_cov_2.640777_g10051_i0 | PRJNA168635 | 10466 | 255 | 2.640777 | 6.73398135 | Tolivirales sp. | 2809914 | Viruses | Viruses | 115 | 1.11e-27 | NR | WRQ65370.1 | 2809914 | g10051 | i0 | 68.3 | 2.89411764705882 | 82 | 26 | 96.5 | 0 | 2 | 247 | 699 | 780 | WRQ65370.1 polyprotein [Tolivirales sp.] | diamond | 738 | 115 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 28558366 | 28558366 | PRJNA168635_P_NODE_2147_length_552_cov_6.218688_g1775_i0 | PRJNA168635 | 2147 | 552 | 6.218688 | 34.32715776 | Tolivirales sp. gcode 6 | 3108923 | Viruses | Viruses | 95.5 | 9.14e-20 | NR | WRQ65070.1 | 3108923 | g1775 | i0 | 64.3 | 0.380434782608696 | 70 | 25 | 38 | 0 | 489 | 280 | 259 | 328 | WRQ65070.1 structural protein [Tolivirales sp. gcode 6] | diamond | 210 | 95.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. gcode 6 | ||||
| 28937203 | 28937203 | PRJNA168635_P_NODE_16408_length_197_cov_5.364865_g15992_i0 | PRJNA168635 | 16408 | 197 | 5.364865 | 10.56878405 | Skomarfal virus 38 | 3063069 | Viruses | Viruses | 82.4 | 2.01e-16 | NR | WPR18329.1 | 3063069 | g15992 | i0 | 58.5 | 0.989847715736041 | 65 | 26 | 97.5 | 1 | 197 | 6 | 122 | 186 | WPR18329.1 MAG: RNA-dependent RNA polymerase [Skomarfal virus 38] | diamond | 195 | 82.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Skomarfal virus 38 | ||||
| 28968774 | 28968774 | PRJNA168635_P_NODE_2728_length_501_cov_4.652655_g2339_i0 | PRJNA168635 | 2728 | 501 | 4.652655 | 23.30980155 | Tolivirales sp. | 2809914 | Viruses | Viruses | 65.5 | 6.64e-9 | NR | WRQ65360.1 | 2809914 | g2339 | i0 | 44.9 | 1.80239520958084 | 89 | 39 | 50.3 | 4 | 278 | 27 | 298 | 381 | WRQ65360.1 polyprotein [Tolivirales sp.] | diamond | 903 | 65.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 29063533 | 29063533 | PRJNA168635_P_NODE_5048_length_376_cov_8.636086_g4644_i0 | PRJNA168635 | 5048 | 376 | 8.636086 | 32.47168336 | Tolivirales sp. | 2809914 | Viruses | Viruses | 70.9 | 1.77e-11 | NR | WRQ65820.1 | 2809914 | g4644 | i0 | 50.6 | 0.678191489361702 | 85 | 39 | 66.2 | 3 | 360 | 112 | 268 | 351 | WRQ65820.1 structural protein [Tolivirales sp.] | diamond | 255 | 70.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 29252608 | 29252608 | PRJNA168635_P_NODE_26749_length_167_cov_2.627119_g26333_i0 | PRJNA168635 | 26749 | 167 | 2.627119 | 4.38728873 | Chrocowirk virus | 3129570 | Viruses | Viruses | 53.9 | 1.47e-6 | NR | WZH58535.1 | 3129570 | g26333 | i0 | 53.6 | 2.01197604790419 | 56 | 25 | 98.8 | 1 | 2 | 166 | 40 | 95 | WZH58535.1 MAG: RNA-dependent RNA polymerase, partial [Chrocowirk virus] | diamond | 336 | 53.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Chrocowirk virus | |||
| 29568538 | 29568538 | PRJNA168635_P_NODE_9130_length_277_cov_3.692982_g8715_i0 | PRJNA168635 | 9130 | 277 | 3.692982 | 10.22956014 | Skomarfal virus 38 | 3063069 | Viruses | Viruses | 52 | 2.91e-5 | NR | WPR18330.1 | 3063069 | g8715 | i0 | 49.1 | 0.617328519855596 | 57 | 28 | 61.7 | 1 | 8 | 178 | 281 | 336 | WPR18330.1 MAG: coat protein [Skomarfal virus 38] | diamond | 171 | 52 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Skomarfal virus 38 | ||||
| 29757912 | 29757912 | PRJNA168635_P_NODE_33551_length_157_cov_4.833333_g33135_i0 | PRJNA168635 | 33551 | 157 | 4.833333 | 7.58833281 | Crogonang virus 45 | 3063011 | Viruses | Viruses | 77.8 | 4.88e-15 | NR | WPR18220.1 | 3063011 | g33135 | i0 | 70 | 0.955414012738854 | 50 | 15 | 95.5 | 0 | 152 | 3 | 333 | 382 | WPR18220.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 45] | diamond | 150 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Crogonang virus 45 | ||||
| 29757914 | 29757914 | PRJNA168635_P_NODE_35091_length_152_cov_6.116505_g34675_i0 | PRJNA168635 | 35091 | 152 | 6.116505 | 9.2970876 | Chrocowirk virus | 3129570 | Viruses | Viruses | 79.3 | 8.67e-16 | NR | WZH58535.1 | 3129570 | g34675 | i0 | 74 | 0.986842105263158 | 50 | 13 | 98.7 | 0 | 151 | 2 | 93 | 142 | WZH58535.1 MAG: RNA-dependent RNA polymerase, partial [Chrocowirk virus] | diamond | 150 | 79.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Chrocowirk virus | |||
| 30105416 | 30105416 | PRJNA168635_P_NODE_33312_length_158_cov_3.596330_g32896_i0 | PRJNA168635 | 33312 | 158 | 3.59633 | 5.6822014 | Ginkgo biloba tombusvirus | 2739248 | Viruses | Viruses | 84.3 | 2.43e-17 | NR | QKI28846.1 | 2739248 | g32896 | i0 | 68.6 | 0.968354430379747 | 51 | 16 | 96.8 | 0 | 2 | 154 | 395 | 445 | QKI28846.1 hypothetical protein 2 [Ginkgo biloba tombusvirus] | diamond | 153 | 84.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusvirus | Ginkgo biloba tombusvirus | ||
| 30769100 | 30769100 | PRJNA168635_P_NODE_23574_length_172_cov_2.886179_g23158_i0 | PRJNA168635 | 23574 | 172 | 2.886179 | 4.96422788 | Qianjiang noda-like virus 184 | 3348561 | Viruses | Viruses | 52 | 7.75e-6 | NR | XHA86218.1 | 3348561 | g23158 | i0 | 50 | 0.941860465116279 | 54 | 27 | 94.2 | 0 | 162 | 1 | 57 | 110 | XHA86218.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang noda-like virus 184] | diamond | 162 | 52 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Qianjiang noda-like virus 184 | |||
| 31179428 | 31179428 | PRJNA168635_P_NODE_13095_length_224_cov_3.634286_g12679_i0 | PRJNA168635 | 13095 | 224 | 3.634286 | 8.14080064 | Tombusviridae sp. gcode 4 | 2954839 | Viruses | Viruses | 106 | 1.2e-24 | NR | USN25167.1 | 2954839 | g12679 | i0 | 59.5 | 5.94642857142857 | 74 | 30 | 99.1 | 0 | 224 | 3 | 497 | 570 | USN25167.1 MAG: putative RNA dependent RNA polymerase, partial [Tombusviridae sp. gcode 4] | diamond | 1332 | 106 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusviridae sp. gcode 4 | |||
| 31197149 | 31197149 | PRJNA168635_P_NODE_22335_length_175_cov_3.365079_g21919_i0 | PRJNA168635 | 22335 | 175 | 3.365079 | 5.88888825 | Viruses | 10239 | Viruses | Viruses | 97.4 | 8.29e-22 | NR | WRQ65312.1 | 2809914 | g21919 | i0 | 72.4 | 2.96571428571429 | 58 | 16 | 99.4 | 0 | 1 | 174 | 676 | 733 | WRQ65312.1 polyprotein [Tolivirales sp.] | diamond | 519 | 97.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 31907188 | 31907188 | PRJNA168635_P_NODE_11177_length_245_cov_4.540816_g10762_i0 | PRJNA168635 | 11177 | 245 | 4.540816 | 11.1249992 | Tolivirales sp. | 2809914 | Viruses | Viruses | 129 | 1.82e-32 | NR | WRQ65007.1 | 2809914 | g10762 | i0 | 71.3 | 0.979591836734694 | 80 | 23 | 98 | 0 | 4 | 243 | 628 | 707 | WRQ65007.1 polyprotein [Tolivirales sp.] | diamond | 240 | 129 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 31970448 | 31970448 | PRJNA168635_P_NODE_33418_length_158_cov_2.541284_g33002_i0 | PRJNA168635 | 33418 | 158 | 2.541284 | 4.01522872 | Qianjiang noda-like virus 146 | 3348519 | Viruses | Viruses | 75.9 | 2.43e-14 | NR | XHA86170.1 | 3348519 | g33002 | i0 | 79.1 | 0.816455696202532 | 43 | 9 | 81.6 | 0 | 30 | 158 | 162 | 204 | XHA86170.1 MAG: polyprotein [Qianjiang noda-like virus 146] | diamond | 129 | 75.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Qianjiang noda-like virus 146 | |||
| 32318858 | 32318858 | PRJNA168635_P_NODE_10459_length_255_cov_3.135922_g10044_i0 | PRJNA168635 | 10459 | 255 | 3.135922 | 7.9966011 | Tombusviridae sp. | 2583950 | Viruses | Viruses | 105 | 6.31e-25 | NR | USC30213.1 | 2583950 | g10044 | i0 | 61.3 | 0.941176470588235 | 80 | 31 | 94.1 | 0 | 246 | 7 | 138 | 217 | USC30213.1 MAG: putative RNA dependent RNA polymerase, partial [Tombusviridae sp.] | diamond | 240 | 105 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusviridae sp. | |||
| 32476922 | 32476922 | PRJNA168635_P_NODE_3759_length_431_cov_5.149215_g3359_i0 | PRJNA168635 | 3759 | 431 | 5.149215 | 22.19311665 | Tolivirales sp. | 2809914 | Viruses | Viruses | 86.7 | 1.37e-16 | NR | WRQ65370.1 | 2809914 | g3359 | i0 | 50 | 2.5614849187935 | 92 | 42 | 61.9 | 2 | 165 | 431 | 157 | 247 | WRQ65370.1 polyprotein [Tolivirales sp.] | diamond | 1104 | 86.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 32508651 | 32508651 | PRJNA168635_P_NODE_16259_length_198_cov_4.718121_g15843_i0 | PRJNA168635 | 16259 | 198 | 4.718121 | 9.34187958 | Qianjiang tombus-like virus 331 | 3348016 | Viruses | Viruses | 55.8 | 5.05e-7 | NR | XHA87166.1 | 3348016 | g15843 | i0 | 42.9 | 0.848484848484849 | 56 | 32 | 84.8 | 0 | 4 | 171 | 597 | 652 | XHA87166.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang tombus-like virus 331] | diamond | 168 | 55.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 331 |
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);;