contig_metadata
23 rows where bioproject = "PRJNA1122875", tax_phylum = "Pisuviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 277482 | 277482 | PRJNA1122875_P_NODE_13761_length_449_cov_2.047872_g13537_i0 | PRJNA1122875 | 13761 | 449 | 2.047872 | 9.19494528 | Potyvirus telosmae | 3240618 | Viruses | Viruses | 830 | 0 | NTclustered | gi|2622038455|gb|OR786368.1| | 400394 | g13537 | i0 | 100 | 99.5523385300668 | 449 | 0 | 100 | 0 | 1 | 449 | 1085 | 637 | Telosma mosaic virus isolate TeMV-GX-FCG1 polyprotein gene, partial cds | blastn | 44699 | 830 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus telosmae | ||
| 1552207 | 1552207 | PRJNA1122875_P_NODE_2_length_5768_cov_5.357155_g1_i0 | PRJNA1122875 | 2 | 5768 | 5.357155 | 309.0007004 | Lentinula eaodes hypovirus 2 | 2992848 | Viruses | Viruses | 4004 | 0 | NTclustered | gi|2324991072|gb|OK636212.1| | 2992848 | g1 | i0 | 79.242 | 1.00225381414702 | 5781 | 1174 | 100 | 26 | 1 | 5768 | 8429 | 2662 | Lentinula eaodes hypovirus 2 isolate LED2-8 RNA-dependent RNA polymerase (RdRp) gene, complete cds | blastn | 5781 | 4004 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Lentinula eaodes hypovirus 2 | ||
| 1552471 | 1552471 | PRJNA1122875_P_NODE_5162_length_691_cov_1.336570_g4953_i0 | PRJNA1122875 | 5162 | 691 | 1.33657 | 9.2356987 | Stralarivirus fragariae | 3052753 | Viruses | Viruses | 1253 | 0 | NTclustered | gi|2430128337|gb|OM311160.1| | 28351 | g4953 | i0 | 99.421 | 6.28654124457308 | 691 | 3 | 100 | 1 | 1 | 691 | 2832 | 3521 | Strawberry latent ringspot virus isolate SLRV/BJ, complete genome | blastn | 4344 | 1253 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Stralarivirus | Stralarivirus fragariae | ||
| 4104729 | 4104729 | PRJNA1122875_P_NODE_33504_length_285_cov_1.028302_g33280_i0 | PRJNA1122875 | 33504 | 285 | 1.028302 | 2.9306607 | Stralarivirus fragariae | 3052753 | Viruses | Viruses | 520 | 6e-143 | NTclustered | gi|2430128337|gb|OM311160.1| | 28351 | g33280 | i0 | 99.648 | 0.996491228070175 | 284 | 1 | 99 | 0 | 2 | 285 | 157 | 440 | Strawberry latent ringspot virus isolate SLRV/BJ, complete genome | blastn | 284 | 520 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Stralarivirus | Stralarivirus fragariae | ||
| 4104875 | 4104875 | PRJNA1122875_P_NODE_45444_length_249_cov_0.875000_g45220_i0 | PRJNA1122875 | 45444 | 249 | 0.875 | 2.17875 | Potyvirus citrulli | 3240504 | Viruses | Viruses | 416 | 6.939999999999999e-112 | NTclustered | gi|730091864|gb|KM597070.1| | 146500 | g45220 | i0 | 96.787 | 99.9919678714859 | 249 | 8 | 100 | 0 | 1 | 249 | 9322 | 9570 | Watermelon mosaic virus isolate RKG, complete genome | blastn | 24898 | 416 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus citrulli | ||
| 6655367 | 6655367 | PRJNA1122875_P_NODE_21606_length_357_cov_1.492958_g21382_i0 | PRJNA1122875 | 21606 | 357 | 1.492958 | 5.32986006 | Stralarivirus fragariae | 3052753 | Viruses | Viruses | 649 | 0 | NTclustered | gi|2430128337|gb|OM311160.1| | 28351 | g21382 | i0 | 99.44 | 1 | 357 | 2 | 100 | 0 | 1 | 357 | 1611 | 1967 | Strawberry latent ringspot virus isolate SLRV/BJ, complete genome | blastn | 357 | 649 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Stralarivirus | Stralarivirus fragariae | ||
| 9205666 | 9205666 | PRJNA1122875_P_NODE_34728_length_281_cov_1.110577_g34504_i0 | PRJNA1122875 | 34728 | 281 | 1.110577 | 3.12072137 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 514 | 2.75e-141 | NTclustered | gi|987898853|gb|KU171817.1| | 12224 | g34504 | i0 | 99.644 | 100 | 281 | 1 | 100 | 0 | 1 | 281 | 9130 | 8850 | Sugarcane mosaic virus isolate CN:HB:15, complete genome | blastn | 28100 | 514 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 11232119 | 11232119 | PRJNA1122875_P_NODE_44929_length_249_cov_1.750000_g44705_i0 | PRJNA1122875 | 44929 | 249 | 1.75 | 4.3575 | Viruses | 10239 | Viruses | Viruses | 451 | 1.9e-122 | NTclustered | gi|1836405768|gb|MN905961.1| | 1955144 | g44705 | i0 | 99.595 | 48.136546184739 | 247 | 1 | 99 | 0 | 3 | 249 | 7903 | 7657 | MAG: Dicistroviridae sp. isolate coa196dic1 genomic sequence, sequence | blastn | 11986 | 451 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 11756001 | 11756001 | PRJNA1122875_P_NODE_18590_length_387_cov_1.452229_g18366_i0 | PRJNA1122875 | 18590 | 387 | 1.452229 | 5.62012623 | Potyvirus pennisseti | 3240587 | Viruses | Viruses | 496 | 1.42e-135 | NTclustered | gi|451037263|gb|JX070150.1| | 221262 | g18366 | i0 | 90.052 | 33.5271317829457 | 382 | 38 | 99 | 0 | 5 | 386 | 8380 | 7999 | Pennisetum mosaic virus isolate CD2, complete genome | blastn | 12975 | 496 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus pennisseti | ||
| 13031291 | 13031291 | PRJNA1122875_P_NODE_28951_length_305_cov_1.327586_g28727_i0 | PRJNA1122875 | 28951 | 305 | 1.327586 | 4.0491373 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 542 | 1.38e-149 | NTclustered | gi|1173652586|gb|KU886553.1| | 12224 | g28727 | i0 | 98.689 | 85.6426229508197 | 305 | 4 | 100 | 0 | 1 | 305 | 8844 | 8540 | Sugarcane mosaic virus isolate Yunan, complete genome | blastn | 26121 | 542 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 13031605 | 13031605 | PRJNA1122875_P_NODE_6371_length_633_cov_1.708929_g6155_i0 | PRJNA1122875 | 6371 | 633 | 1.708929 | 10.81752057 | Potyvirus telosmae | 3240618 | Viruses | Viruses | 1144 | 0 | NTclustered | gi|2456538644|gb|ON932195.1| | 400394 | g6155 | i0 | 99.522 | 59.3981042654028 | 628 | 3 | 99 | 0 | 1 | 628 | 9169 | 8542 | Telosma mosaic virus isolate RJ, complete genome | blastn | 37599 | 1144 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus telosmae | ||
| 15056354 | 15056354 | PRJNA1122875_P_NODE_17632_length_397_cov_3.101852_g17408_i0 | PRJNA1122875 | 17632 | 397 | 3.101852 | 12.31435244 | Cripavirus | 144051 | Viruses | Viruses | 370 | 9.24e-98 | NTclustered | gi|2672713331|gb|OR723603.1| | 1955141 | g17408 | i0 | 100 | 48.6977329974811 | 200 | 0 | 88 | 0 | 198 | 397 | 2783 | 2982 | MAG: Cripavirus sp. isolate JLLYH22/43627 genomic sequence | blastn | 19333 | 370 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus sp. | ||
| 15580489 | 15580489 | PRJNA1122875_P_NODE_30693_length_295_cov_1.040541_g30469_i0 | PRJNA1122875 | 30693 | 295 | 1.040541 | 3.06959595 | Lentinula edodes fusarivirus 2 | 2778977 | Viruses | Viruses | 540 | 4.79e-149 | NTclustered | gi|1928162782|gb|MN744721.1| | 2778977 | g30469 | i0 | 99.661 | 1.19661016949153 | 295 | 1 | 100 | 0 | 1 | 295 | 3799 | 3505 | Lentinula edodes fusarivirus 2 isolate Le12Z84 RNA-dependent RNA polymerase gene, partial cds | blastn | 353 | 540 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Lentinula edodes fusarivirus 2 | |||
| 18129724 | 18129724 | PRJNA1122875_P_NODE_8055_length_575_cov_1.486056_g7837_i0 | PRJNA1122875 | 8055 | 575 | 1.486056 | 8.544822 | Fushun polycipivirus 2 | 2905451 | Viruses | Viruses | 1029 | 0 | NTclustered | gi|2169232387|gb|MZ210028.1| | 2905451 | g7837 | i0 | 98.958 | 1.00173913043478 | 576 | 5 | 100 | 1 | 1 | 575 | 12006 | 11431 | MAG: Fushun polycipivirus 2 isolate SBYYJFS21, complete genome | blastn | 576 | 1029 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Polycipiviridae | Fushun polycipivirus 2 | |||
| 20679070 | 20679070 | PRJNA1122875_P_NODE_30837_length_294_cov_1.045249_g30613_i0 | PRJNA1122875 | 30837 | 294 | 1.045249 | 3.07303206 | Potyvirus citrulli | 3240504 | Viruses | Viruses | 510 | 3.74e-140 | NTclustered | gi|2777077809|gb|PP505905.1| | 146500 | g30613 | i0 | 97.959 | 99.7891156462585 | 294 | 6 | 100 | 0 | 1 | 294 | 7970 | 8263 | Watermelon mosaic virus isolate EM170143, complete genome | blastn | 29338 | 510 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus citrulli | ||
| 24503363 | 24503363 | PRJNA1122875_P_NODE_15380_length_426_cov_0.827195_g15156_i0 | PRJNA1122875 | 15380 | 426 | 0.827195 | 3.5238507 | Stralarivirus fragariae | 3052753 | Viruses | Viruses | 760 | 0 | NTclustered | gi|2430128337|gb|OM311160.1| | 28351 | g15156 | i0 | 98.826 | 1 | 426 | 5 | 100 | 0 | 1 | 426 | 2193 | 2618 | Strawberry latent ringspot virus isolate SLRV/BJ, complete genome | blastn | 426 | 760 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Stralarivirus | Stralarivirus fragariae | ||
| 24503413 | 24503413 | PRJNA1122875_P_NODE_19280_length_380_cov_1.003257_g19056_i0 | PRJNA1122875 | 19280 | 380 | 1.003257 | 3.8123766 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 691 | 0 | NTclustered | gi|987898853|gb|KU171817.1| | 12224 | g19056 | i0 | 99.474 | 99.9657894736842 | 380 | 2 | 100 | 0 | 1 | 380 | 7108 | 7487 | Sugarcane mosaic virus isolate CN:HB:15, complete genome | blastn | 37987 | 691 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 27375791 | 27375791 | PRJNA1122875_P_NODE_3_length_5644_cov_12.296536_g2_i0 | PRJNA1122875 | 3 | 5644 | 12.296536 | 694.01649184 | Orthornavirae | 2732396 | Viruses | Viruses | 105 | 2.6e-19 | NR | WAY16551.1 | 2809883 | g2 | i0 | 25.9 | 0.737243090007087 | 494 | 276 | 26.1 | 13 | 4012 | 5484 | 1 | 407 | WAY16551.1 hypothetical protein [Stellavirales sp.] | diamond | 4161 | 105 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Stellavirales sp. | ||||
| 28428251 | 28428251 | PRJNA1122875_P_NODE_35286_length_279_cov_1.150485_g35062_i0 | PRJNA1122875 | 35286 | 279 | 1.150485 | 3.20985315 | Iflaviridae-like virus 3 | 3077009 | Viruses | Viruses | 119 | 7.07e-29 | NR | WPR18798.1 | 3077009 | g35062 | i0 | 60 | 1.93548387096774 | 90 | 36 | 96.8 | 0 | 3 | 272 | 2685 | 2774 | WPR18798.1 MAG: RNA-dependent RNA polymerase [Iflaviridae-like virus 3] | diamond | 540 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflaviridae-like virus 3 | |||
| 28459907 | 28459907 | PRJNA1122875_P_NODE_23206_length_346_cov_1.380952_g22982_i0 | PRJNA1122875 | 23206 | 346 | 1.380952 | 4.77809392 | Lentinula eaodes hypovirus 2 | 2992848 | Viruses | Viruses | 201 | 3.37e-57 | NR | UZA97544.1 | 2992848 | g22982 | i0 | 90.4 | 0.988439306358382 | 114 | 11 | 98.8 | 0 | 3 | 344 | 743 | 856 | UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2] | diamond | 342 | 201 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Lentinula eaodes hypovirus 2 | ||
| 29501548 | 29501548 | PRJNA1122875_P_NODE_2350_length_919_cov_1.825059_g2196_i0 | PRJNA1122875 | 2350 | 919 | 1.825059 | 16.77229221 | Lentinula eaodes hypovirus 2 | 2992848 | Viruses | Viruses | 565 | 2.609999999999999e-181 | NR | UZA97544.1 | 2992848 | g2196 | i0 | 96.4 | 0.998911860718172 | 306 | 11 | 99.9 | 0 | 918 | 1 | 432 | 737 | UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2] | diamond | 918 | 565 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Lentinula eaodes hypovirus 2 | ||
| 32030085 | 32030085 | PRJNA1122875_P_NODE_21938_length_354_cov_1.597865_g21714_i0 | PRJNA1122875 | 21938 | 354 | 1.597865 | 5.6564421 | Lentinula eaodes hypovirus 2 | 2992848 | Viruses | Viruses | 164 | 2.3999999999999996e-44 | NR | UZA97544.1 | 2992848 | g21714 | i0 | 91.9 | 0.728813559322034 | 86 | 7 | 72.9 | 0 | 259 | 2 | 1 | 86 | UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2] | diamond | 258 | 164 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Lentinula eaodes hypovirus 2 | ||
| 32093280 | 32093280 | PRJNA1122875_P_NODE_54678_length_227_cov_2.142857_g54454_i0 | PRJNA1122875 | 54678 | 227 | 2.142857 | 4.86428539 | Plasmopara viticola lesion associated Partitivirus 8 | 2692006 | Viruses | Viruses | 61.2 | 9e-9 | NR | QHD64792.1 | 2692006 | g54454 | i0 | 47.2 | 0.700440528634361 | 53 | 28 | 70 | 0 | 160 | 2 | 271 | 323 | QHD64792.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated Partitivirus 8] | diamond | 159 | 61.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Plasmopara viticola lesion associated Partitivirus 8 |
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);;