contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26701076 | 26701076 | PRJNA641707_P_NODE_182501_length_200_cov_2.105960_g179838_i0 | PRJNA641707 | 182501 | 200 | 2.10596 | 4.21192 | Lolium latent virus | 365150 | Viruses | Viruses | 110 | 2.99e-26 | NR | WCJ13304.1 | 365150 | g179838 | i0 | 80 | 0.975 | 65 | 12 | 96 | 1 | 193 | 2 | 848 | 912 | WCJ13304.1 putative RdRp [Lolium latent virus] | diamond | 195 | 110 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Lolavirus | Lolavirus latenslolii | ||
| 27017787 | 27017787 | PRJNA641707_P_NODE_169542_length_201_cov_9.013158_g166879_i0 | PRJNA641707 | 169542 | 201 | 9.013158 | 18.11644758 | Lolium latent virus | 365150 | Viruses | Viruses | 74.3 | 1.56e-13 | NR | YP_001718499.1 | 365150 | g166879 | i0 | 97 | 1.47761194029851 | 33 | 1 | 49.3 | 0 | 8 | 106 | 1470 | 1502 | YP_001718499.1 replicase [Lolium latent virus] | diamond | 297 | 74.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Lolavirus | Lolavirus latenslolii | ||
| 27270799 | 27270799 | PRJNA641707_P_NODE_318043_length_158_cov_9.422018_g315380_i0 | PRJNA641707 | 318043 | 158 | 9.422018 | 14.88678844 | Lolium latent virus | 365150 | Viruses | Viruses | 59.7 | 1.21e-8 | NR | WCJ13304.1 | 365150 | g315380 | i0 | 62 | 0.949367088607595 | 50 | 19 | 94.9 | 0 | 152 | 3 | 601 | 650 | WCJ13304.1 putative RdRp [Lolium latent virus] | diamond | 150 | 59.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Lolavirus | Lolavirus latenslolii | ||
| 27460463 | 27460463 | PRJNA641707_P_NODE_190083_length_199_cov_3.160000_g187420_i0 | PRJNA641707 | 190083 | 199 | 3.16 | 6.2884 | Deltaflexiviridae sp. | 2809074 | Viruses | Viruses | 49.3 | 1.05e-4 | NR | XNT21189.1 | 2809074 | g187420 | i0 | 69 | 0.437185929648241 | 29 | 9 | 43.7 | 0 | 99 | 13 | 179 | 207 | XNT21189.1 MAG: RNA-dependent RNA polymerase [Deltaflexiviridae sp.] | diamond | 87 | 49.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexiviridae sp. | |||
| 27744843 | 27744843 | PRJNA641707_P_NODE_321124_length_157_cov_6.759259_g318461_i0 | PRJNA641707 | 321124 | 157 | 6.759259 | 10.61203663 | Lolium latent virus | 365150 | Viruses | Viruses | 110 | 3.770000000000001e-27 | NR | ABC60027.1 | 365150 | g318461 | i0 | 98 | 4.87261146496815 | 51 | 1 | 97.5 | 0 | 3 | 155 | 24 | 74 | ABC60027.1 putative RNA-dependent RNA polymerase, partial [Lolium latent virus] | diamond | 765 | 110 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Lolavirus | Lolavirus latenslolii | ||
| 28407554 | 28407554 | PRJNA641707_P_NODE_118886_length_245_cov_9.438776_g116223_i0 | PRJNA641707 | 118886 | 245 | 9.438776 | 23.1250012 | Rhizopus microsporus virga-like virus 1 | 3156536 | Viruses | Viruses | 62 | 6.32e-9 | NR | BFM51661.1 | 3156536 | g116223 | i0 | 81.8 | 0.404081632653061 | 33 | 6 | 40.4 | 0 | 99 | 1 | 1316 | 1348 | BFM51661.1 RNA-dependent RNA polymerase [Rhizopus microsporus virga-like virus 1] | diamond | 99 | 62 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Rhizopus microsporus virga-like virus 1 | |||
| 28439259 | 28439259 | PRJNA641707_P_NODE_197326_length_198_cov_3.093960_g194663_i0 | PRJNA641707 | 197326 | 198 | 3.09396 | 6.1260408 | Qianjiang noda-like virus 162 | 3348537 | Viruses | Viruses | 68.6 | 1.6e-11 | NR | XHA86186.1 | 3348537 | g194663 | i0 | 65.3 | 2.95454545454545 | 49 | 17 | 74.2 | 0 | 191 | 45 | 831 | 879 | XHA86186.1 MAG: polyprotein, partial [Qianjiang noda-like virus 162] | diamond | 585 | 68.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Qianjiang noda-like virus 162 | |||
| 28975973 | 28975973 | PRJNA641707_P_NODE_184108_length_199_cov_11.333333_g181445_i0 | PRJNA641707 | 184108 | 199 | 11.333333 | 22.55333267 | Lolium latent virus | 365150 | Viruses | Viruses | 108 | 1.4199999999999999e-25 | NR | WCJ13299.1 | 365150 | g181445 | i0 | 63.3 | 4.4321608040201 | 98 | 3 | 98 | 1 | 196 | 2 | 1547 | 1644 | WCJ13299.1 putative RdRp [Lolium latent virus] | diamond | 882 | 108 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Lolavirus | Lolavirus latenslolii | ||
| 29165639 | 29165639 | PRJNA641707_P_NODE_329209_length_154_cov_7.838095_g326546_i0 | PRJNA641707 | 329209 | 154 | 7.838095 | 12.0706663 | water chestnut virus A | 2884706 | Viruses | Viruses | 95.9 | 2.1200000000000003e-21 | NR | UCY33660.1 | 2884706 | g326546 | i0 | 88 | 0.974025974025974 | 50 | 6 | 97.4 | 0 | 5 | 154 | 457 | 506 | UCY33660.1 RNA-dependent RNA polymerase [water chestnut virus A] | diamond | 150 | 95.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Ilarvirus | Ilarvirus WCVA | ||
| 29556438 | 29556438 | PRJNA641707_P_NODE_210970_length_195_cov_7.445205_g208307_i0 | PRJNA641707 | 210970 | 195 | 7.445205 | 14.51814975 | Deltaflexivirus | 2169569 | Viruses | Viruses | 49.7 | 7.05e-5 | NR | XNT21189.1 | 2809074 | g208307 | i0 | 77.4 | 2.35384615384615 | 31 | 7 | 47.7 | 0 | 102 | 194 | 1686 | 1716 | XNT21189.1 MAG: RNA-dependent RNA polymerase [Deltaflexiviridae sp.] | diamond | 459 | 49.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexiviridae sp. | |||
| 29701712 | 29701712 | PRJNA641707_P_NODE_206390_length_196_cov_6.809524_g203727_i0 | PRJNA641707 | 206390 | 196 | 6.809524 | 13.34666704 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 50.4 | 3.93e-5 | NR | WAY16437.1 | 2809460 | g203727 | i0 | 40.4 | 0.872448979591837 | 57 | 34 | 87.2 | 0 | 171 | 1 | 44 | 100 | WAY16437.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 171 | 50.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 29986331 | 29986331 | PRJNA641707_P_NODE_223711_length_192_cov_6.069930_g221048_i0 | PRJNA641707 | 223711 | 192 | 6.06993 | 11.6542656 | Guiyang tombus-like virus 2 | 2970222 | Viruses | Viruses | 117 | 5.1899999999999995e-30 | NR | UUW21075.1 | 2970222 | g221048 | i0 | 88.7 | 0.96875 | 62 | 7 | 96.9 | 0 | 7 | 192 | 56 | 117 | UUW21075.1 MAG: coat protein [Guiyang tombus-like virus 2] | diamond | 186 | 117 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Guiyang tombus-like virus 2 | |||
| 30776302 | 30776302 | PRJNA641707_P_NODE_187834_length_199_cov_5.686667_g185171_i0 | PRJNA641707 | 187834 | 199 | 5.686667 | 11.31646733 | Mute swan feces associated tombus-like virus 2 | 2832226 | Viruses | Viruses | 120 | 1.47e-30 | NR | QUS52772.1 | 2832226 | g185171 | i0 | 88.9 | 0.949748743718593 | 63 | 7 | 95 | 0 | 9 | 197 | 297 | 359 | QUS52772.1 hypothetical protein 1 [Mute swan feces associated tombus-like virus 2] | diamond | 189 | 120 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Mute swan feces associated tombus-like virus 2 | |||
| 31155001 | 31155001 | PRJNA641707_P_NODE_192835_length_198_cov_9.503356_g190172_i0 | PRJNA641707 | 192835 | 198 | 9.503356 | 18.81664488 | Lolium latent virus | 365150 | Viruses | Viruses | 70.1 | 4.63e-12 | NR | WCJ13304.1 | 365150 | g190172 | i0 | 77.1 | 2.18181818181818 | 48 | 10 | 71.2 | 1 | 197 | 57 | 179 | 226 | WCJ13304.1 putative RdRp [Lolium latent virus] | diamond | 432 | 70.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Lolavirus | Lolavirus latenslolii | ||
| 31281735 | 31281735 | PRJNA641707_P_NODE_241275_length_186_cov_2.510949_g238612_i0 | PRJNA641707 | 241275 | 186 | 2.510949 | 4.67036514 | Cucumber mosaic virus | 12305 | Viruses | Viruses | 105 | 1.87e-24 | NR | AMN92170.1 | 12305 | g238612 | i0 | 90 | 3.87096774193548 | 60 | 6 | 96.8 | 0 | 6 | 185 | 702 | 761 | AMN92170.1 1a [Cucumber mosaic virus] | diamond | 720 | 105 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus CMV | ||
| 31408471 | 31408471 | PRJNA641707_P_NODE_296136_length_165_cov_5.603448_g293473_i0 | PRJNA641707 | 296136 | 165 | 5.603448 | 9.2456892 | Vicia faba alphaendornavirus | 310749 | Viruses | Viruses | 46.6 | 5.65e-4 | NR | YP_438201.1 | 310749 | g293473 | i0 | 36.7 | 0.890909090909091 | 49 | 31 | 89.1 | 0 | 163 | 17 | 1804 | 1852 | YP_438201.1 ORFA+B [Vicia faba alphaendornavirus] | diamond | 147 | 46.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus viciae | ||
| 31471791 | 31471791 | PRJNA641707_P_NODE_245416_length_184_cov_5.022222_g242753_i0 | PRJNA641707 | 245416 | 184 | 5.022222 | 9.24088848 | Morchella importuna endornavirus 3 | 2501279 | Viruses | Viruses | 53.5 | 2.71e-6 | NR | AZT88618.1 | 2501279 | g242753 | i0 | 50 | 1.67934782608696 | 50 | 25 | 81.5 | 0 | 29 | 178 | 4485 | 4534 | AZT88618.1 polyprotein [Morchella importuna endornavirus 3] | diamond | 309 | 53.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Morchella importuna endornavirus 3 | |||
| 31471808 | 31471808 | PRJNA641707_P_NODE_261916_length_177_cov_6.609375_g259253_i0 | PRJNA641707 | 261916 | 177 | 6.609375 | 11.69859375 | Lolium latent virus | 365150 | Viruses | Viruses | 103 | 3.32e-25 | NR | WCJ13308.1 | 365150 | g259253 | i0 | 94.6 | 0.949152542372881 | 56 | 3 | 94.9 | 0 | 169 | 2 | 47 | 102 | WCJ13308.1 putative coat protein [Lolium latent virus] | diamond | 168 | 103 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Lolavirus | Lolavirus latenslolii | ||
| 31566743 | 31566743 | PRJNA641707_P_NODE_238416_length_187_cov_3.833333_g235753_i0 | PRJNA641707 | 238416 | 187 | 3.833333 | 7.16833271 | Deltaflexiviridae sp. | 2809074 | Viruses | Viruses | 62.4 | 2.11e-9 | NR | XNT21189.1 | 2809074 | g235753 | i0 | 50.9 | 0.882352941176471 | 55 | 27 | 88.2 | 0 | 8 | 172 | 276 | 330 | XNT21189.1 MAG: RNA-dependent RNA polymerase [Deltaflexiviridae sp.] | diamond | 165 | 62.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexiviridae sp. | |||
| 32167884 | 32167884 | PRJNA641707_P_NODE_94918_length_246_cov_4.944162_g92255_i0 | PRJNA641707 | 94918 | 246 | 4.944162 | 12.16263852 | Uromyces anulavirus A | 2592793 | Viruses | Viruses | 75.1 | 1.62e-13 | NR | QED42936.1 | 2592793 | g92255 | i0 | 48.1 | 0.963414634146341 | 79 | 40 | 96.3 | 1 | 4 | 240 | 362 | 439 | QED42936.1 putative RdRp [Uromyces anulavirus A] | diamond | 237 | 75.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Anulavirus | Uromyces anulavirus A | ||
| 32862120 | 32862120 | PRJNA641707_P_NODE_137780_length_242_cov_7.673575_g135117_i0 | PRJNA641707 | 137780 | 242 | 7.673575 | 18.5700515 | Lolium latent virus | 365150 | Viruses | Viruses | 68.9 | 2.21e-11 | NR | YP_001718499.1 | 365150 | g135117 | i0 | 96.9 | 0.793388429752066 | 32 | 1 | 39.7 | 0 | 145 | 240 | 396 | 427 | YP_001718499.1 replicase [Lolium latent virus] | diamond | 192 | 68.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Lolavirus | Lolavirus latenslolii |
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);;