contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26454369 | 26454369 | PRJEB14175_P_NODE_119992_length_319_cov_20.162791_g117726_i0 | PRJEB14175 | 119992 | 319 | 20.162791 | 64.31930329 | Partitiviridae sp. | 1955170 | Viruses | Viruses | 173 | 4.52e-51 | NR | QDH91349.1 | 1955170 | g117726 | i0 | 86.6 | 0.912225705329154 | 97 | 13 | 91.2 | 0 | 22 | 312 | 148 | 244 | QDH91349.1 MAG: hypothetical protein H3Bulk427771_000001, partial [Partitiviridae sp.] | diamond | 291 | 173 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 26462654 | 26462654 | PRJEB14175_P_NODE_52048_length_516_cov_18.501099_g49805_i0 | PRJEB14175 | 52048 | 516 | 18.501099 | 95.46567084 | Gammapartitivirus sp. | 2809420 | Viruses | Viruses | 248 | 8.650000000000001e-77 | NR | UDL14424.1 | 2809420 | g49805 | i0 | 72.8 | 0.918604651162791 | 158 | 43 | 91.9 | 0 | 494 | 21 | 1 | 158 | UDL14424.1 MAG: putative RNA-dependent RNA polymerase [Gammapartitivirus sp.] | diamond | 474 | 248 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Gammapartitivirus | Gammapartitivirus sp. | ||
| 32908944 | 32908944 | PRJEB14175_P_NODE_188993_length_237_cov_1.852273_g186726_i0 | PRJEB14175 | 188993 | 237 | 1.852273 | 4.38988701 | Alphapartitivirus sp. | 2809141 | Viruses | Viruses | 68.6 | 2.82e-11 | NR | UDL14378.1 | 2809141 | g186726 | i0 | 47.9 | 0.924050632911392 | 73 | 37 | 91.1 | 1 | 22 | 237 | 168 | 240 | UDL14378.1 MAG: putative coat protein [Alphapartitivirus sp.] | diamond | 219 | 68.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Alphapartitivirus | Alphapartitivirus sp. | ||
| 32944301 | 32944301 | PRJEB14175_P_NODE_68682_length_445_cov_10.869792_g66424_i0 | PRJEB14175 | 68682 | 445 | 10.869792 | 48.3705744 | Aspergillus flavus partitivirus 2 | 2871719 | Viruses | Viruses | 77 | 3.37e-13 | NR | UAW09572.1 | 2871719 | g66424 | i0 | 38.8 | 0.573033707865168 | 85 | 52 | 57.3 | 0 | 424 | 170 | 425 | 509 | UAW09572.1 MAG: capsid protein [Aspergillus flavus partitivirus 2] | diamond | 255 | 77 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Aspergillus flavus partitivirus 2 | |||
| 32991065 | 32991065 | PRJEB14175_P_NODE_19395_length_828_cov_20.119948_g17586_i0 | PRJEB14175 | 19395 | 828 | 20.119948 | 166.59316944 | Viruses | 10239 | Viruses | Viruses | 267 | 5.58e-82 | NR | UDL14430.1 | 1955170 | g17586 | i0 | 59.7 | 1.74275362318841 | 238 | 89 | 85.9 | 2 | 19 | 729 | 321 | 552 | UDL14430.1 MAG: putative RNA-dependent RNA polymerase [Partitiviridae sp.] | diamond | 1443 | 268 | 0.996268656716418 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 32994159 | 32994159 | PRJEB14175_P_NODE_153595_length_272_cov_7.137441_g151328_i0 | PRJEB14175 | 153595 | 272 | 7.137441 | 19.41383952 | Leptosphaeria biglobosa partitivirus 1 | 2985709 | Viruses | Viruses | 57.8 | 2.64e-7 | NR | UYL94490.1 | 2985709 | g151328 | i0 | 68.4 | 0.419117647058824 | 38 | 11 | 40.8 | 1 | 272 | 162 | 458 | 495 | UYL94490.1 MAG: capsid protein [Leptosphaeria biglobosa partitivirus 1] | diamond | 114 | 57.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Leptosphaeria biglobosa partitivirus 1 | |||
| 33012173 | 33012173 | PRJEB14175_P_NODE_25444_length_732_cov_5.400894_g23450_i0 | PRJEB14175 | 25444 | 732 | 5.400894 | 39.53454408 | Aspergillus flavus partitivirus 1 | 2590841 | Viruses | Viruses | 49.7 | 0.00452 | NR | BED98299.1 | 2590841 | g23450 | i0 | 33.8 | 0.266393442622951 | 65 | 43 | 26.6 | 0 | 46 | 240 | 66 | 130 | BED98299.1 MAG: hypothetical protein [Aspergillus flavus partitivirus 1] | diamond | 195 | 49.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Aspergillus flavus partitivirus 1 | |||
| 33012488 | 33012488 | PRJEB14175_P_NODE_4972_length_1535_cov_31.685210_g4045_i0 | PRJEB14175 | 4972 | 1535 | 31.68521 | 486.3679735 | Rosellinia necatrix partitivirus 19 | 2699387 | Viruses | Viruses | 455 | 2.709999999999999e-152 | NR | BBU59847.1 | 2699387 | g4045 | i0 | 51.5 | 0.846254071661238 | 433 | 205 | 83.8 | 3 | 1513 | 227 | 77 | 508 | BBU59847.1 capsid protein [Rosellinia necatrix partitivirus 19] | diamond | 1299 | 455 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Rosellinia necatrix partitivirus 19 | |||
| 33045269 | 33045269 | PRJEB14175_P_NODE_149717_length_277_cov_3.009259_g147450_i0 | PRJEB14175 | 149717 | 277 | 3.009259 | 8.33564743 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 162 | 5.02e-44 | NR | XCM68404.1 | 3003959 | g147450 | i0 | 87.6 | 0.963898916967509 | 89 | 11 | 96.4 | 0 | 9 | 275 | 304 | 392 | XCM68404.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 267 | 162 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 33046821 | 33046821 | PRJEB14175_P_NODE_7485_length_1271_cov_4.153719_g6294_i0 | PRJEB14175 | 7485 | 1271 | 4.153719 | 52.79376849 | Solenopsis invicta virus 12 | 2547305 | Viruses | Viruses | 236 | 1.23e-65 | NR | QBL75902.1 | 2547305 | g6294 | i0 | 43.9 | 0.752950432730134 | 319 | 151 | 72.2 | 8 | 1269 | 352 | 598 | 901 | QBL75902.1 putative structural polyprotein [Solenopsis invicta virus 12] | diamond | 957 | 236 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Solenopsis invicta virus 12 | ||
| 33062915 | 33062915 | PRJEB14175_P_NODE_214749_length_217_cov_2.461538_g212482_i0 | PRJEB14175 | 214749 | 217 | 2.461538 | 5.34153746 | Heterobasidion partitivirus 1 | 942041 | Viruses | Viruses | 74.3 | 1.87e-13 | NR | YP_009508050.1 | 942041 | g212482 | i0 | 59.2 | 0.981566820276498 | 71 | 28 | 96.8 | 1 | 212 | 3 | 39 | 109 | YP_009508050.1 putative coat protein [Heterobasidion partitivirus 1] | diamond | 213 | 74.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Alphapartitivirus | Alphapartitivirus uniheterobasidion | ||
| 33078973 | 33078973 | PRJEB14175_P_NODE_10502_length_1084_cov_27.330401_g9093_i0 | PRJEB14175 | 10502 | 1084 | 27.330401 | 296.26154684 | Ohio dicistro-like virus | 2789442 | Viruses | Viruses | 219 | 1.81e-59 | NR | QPG92983.1 | 2789442 | g9093 | i0 | 38.3 | 1.66051660516605 | 300 | 183 | 83 | 2 | 1060 | 161 | 1899 | 2196 | QPG92983.1 polyprotein [Ohio dicistro-like virus] | diamond | 1800 | 219 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Ohio dicistro-like virus | |||
| 33080253 | 33080253 | PRJEB14175_P_NODE_24358_length_747_cov_7.932945_g22396_i0 | PRJEB14175 | 24358 | 747 | 7.932945 | 59.25909915 | Thelebolus microsporus partitivirus 1 | 2501047 | Viruses | Viruses | 139 | 1.3e-34 | NR | AZT88599.1 | 2501047 | g22396 | i0 | 49 | 1.81124497991968 | 153 | 77 | 61 | 1 | 56 | 511 | 4 | 156 | AZT88599.1 capsid protein [Thelebolus microsporus partitivirus 1] | diamond | 1353 | 139 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Thelebolus microsporus partitivirus 1 | |||
| 33097745 | 33097745 | PRJEB14175_P_NODE_48254_length_537_cov_8.021008_g46025_i0 | PRJEB14175 | 48254 | 537 | 8.021008 | 43.07281296 | Aspergillus flavus partitivirus 1 | 2590841 | Viruses | Viruses | 63.9 | 1.75e-8 | NR | BED98291.1 | 2590841 | g46025 | i0 | 27.5 | 0.932960893854749 | 167 | 118 | 91.6 | 3 | 5 | 496 | 113 | 279 | BED98291.1 MAG: hypothetical protein [Aspergillus flavus partitivirus 1] | diamond | 501 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Aspergillus flavus partitivirus 1 | |||
| 33110368 | 33110368 | PRJEB14175_P_NODE_22718_length_771_cov_21.952113_g20803_i0 | PRJEB14175 | 22718 | 771 | 21.952113 | 169.25079123 | Betapartitivirus | 1511809 | Viruses | Viruses | 275 | 5.24e-84 | NR | YP_392480.1 | 235994 | g20803 | i0 | 61.2 | 2.53696498054475 | 219 | 85 | 85.2 | 0 | 745 | 89 | 490 | 708 | YP_392480.1 putative RNA-dependent RNA polymerase [Rosellinia necatrix partitivirus 1-W8] | diamond | 1956 | 275 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Betapartitivirus | Betapartitivirus roselliniae | ||
| 33113034 | 33113034 | PRJEB14175_P_NODE_106359_length_344_cov_12.169611_g104093_i0 | PRJEB14175 | 106359 | 344 | 12.169611 | 41.86346184 | Mycosphaerella hypovirus A | 2592776 | Viruses | Viruses | 48.1 | 0.0016 | NR | QED42897.1 | 2592776 | g104093 | i0 | 41.1 | 0.488372093023256 | 56 | 33 | 48.8 | 0 | 319 | 152 | 3200 | 3255 | QED42897.1 unknown [Mycosphaerella hypovirus A] | diamond | 168 | 48.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Mycosphaerella hypovirus A | |||
| 33113390 | 33113390 | PRJEB14175_P_NODE_143007_length_285_cov_7.633929_g140740_i0 | PRJEB14175 | 143007 | 285 | 7.633929 | 21.75669765 | Rosellinia necatrix partitivirus 21 | 2699389 | Viruses | Viruses | 93.6 | 8.25e-20 | NR | BBU59850.1 | 2699389 | g140740 | i0 | 58.1 | 0.778947368421053 | 74 | 31 | 77.9 | 0 | 263 | 42 | 648 | 721 | BBU59850.1 RNA dependent RNA polymerase [Rosellinia necatrix partitivirus 21] | diamond | 222 | 93.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Rosellinia necatrix partitivirus 21 | |||
| 33115061 | 33115061 | PRJEB14175_P_NODE_81407_length_404_cov_6.081633_g79145_i0 | PRJEB14175 | 81407 | 404 | 6.081633 | 24.56979732 | Panax cryptic virus 4 | 2809267 | Viruses | Viruses | 102 | 1.51e-25 | NR | WAQ73893.1 | 2809267 | g79145 | i0 | 78.5 | 0.965346534653465 | 65 | 14 | 48.3 | 0 | 393 | 199 | 32 | 96 | WAQ73893.1 coat protein, partial [Panax cryptic virus 4] | diamond | 390 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Panax cryptic virus 4 | |||
| 33127484 | 33127484 | PRJEB14175_P_NODE_249431_length_203_cov_2.802817_g247163_i0 | PRJEB14175 | 249431 | 203 | 2.802817 | 5.68971851 | Viruses | 10239 | Viruses | Viruses | 80.5 | 7.45e-16 | NR | USE08435.1 | 1955170 | g247163 | i0 | 60 | 1.77339901477833 | 60 | 24 | 88.7 | 0 | 23 | 202 | 244 | 303 | USE08435.1 MAG: putative RNA-dependent RNA polymerase, partial [Partitiviridae sp.] | diamond | 360 | 80.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 33131532 | 33131532 | PRJEB14175_P_NODE_249383_length_203_cov_3.056338_g247115_i0 | PRJEB14175 | 249383 | 203 | 3.0563380000000002 | 6.20436614 | Plasmopara viticola lesion associated amalga like virus 1 | 2692081 | Viruses | Viruses | 52.8 | 6.42e-6 | NR | QHD64761.1 | 2692081 | g247115 | i0 | 40.6 | 0.945812807881773 | 64 | 38 | 94.6 | 0 | 193 | 2 | 115 | 178 | QHD64761.1 RdRp [Plasmopara viticola lesion associated amalga like virus 1] | diamond | 192 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Amalgaviridae | Plasmopara viticola lesion associated amalga like virus 1 | |||
| 33144658 | 33144658 | PRJEB14175_P_NODE_62319_length_469_cov_9.612745_g60063_i0 | PRJEB14175 | 62319 | 469 | 9.612745 | 45.08377405 | Unirnavirus | 3424976 | Viruses | Viruses | 218 | 9.57e-65 | NR | ALO50135.1 | 1755782 | g60063 | i0 | 70.9 | 3.78678038379531 | 148 | 43 | 94.7 | 0 | 444 | 1 | 343 | 490 | ALO50135.1 67 kDa protein [Penicillium janczewskii Beauveria bassiana-like virus 1] | diamond | 1776 | 218 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Amalgaviridae | Unirnavirus | Unirnavirus pripenicillii | ||
| 33147588 | 33147588 | PRJEB14175_P_NODE_143712_length_284_cov_11.174888_g141445_i0 | PRJEB14175 | 143712 | 284 | 11.174888 | 31.73668192 | Botrytis cinerea partitivirus 1 | 1354497 | Viruses | Viruses | 58.9 | 1.22e-7 | NR | AGQ21570.1 | 1354497 | g141445 | i0 | 71.4 | 1.13028169014085 | 35 | 10 | 37 | 0 | 42 | 146 | 599 | 633 | AGQ21570.1 coat protein [Botrytis cinerea partitivirus 1] | diamond | 321 | 58.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Botrytis cinerea partitivirus 1 | |||
| 33164197 | 33164197 | PRJEB14175_P_NODE_105056_length_347_cov_3.213287_g102790_i0 | PRJEB14175 | 105056 | 347 | 3.213287 | 11.15010589 | Soniwok virus | 3131542 | Viruses | Viruses | 80.9 | 5.02e-15 | NR | WZH61574.1 | 3131542 | g102790 | i0 | 45.3 | 0.743515850144092 | 86 | 47 | 74.4 | 0 | 296 | 39 | 439 | 524 | WZH61574.1 MAG: RNA-dependent RNA polymerase [Soniwok virus] | diamond | 258 | 80.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Soniwok virus | |||
| 33165836 | 33165836 | PRJEB14175_P_NODE_39864_length_591_cov_4.498113_g37676_i0 | PRJEB14175 | 39864 | 591 | 4.498113 | 26.58384783 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 135 | 5.98e-33 | NR | QPN36948.1 | 2789378 | g37676 | i0 | 52.3 | 1.34010152284264 | 132 | 62 | 66.5 | 1 | 11 | 403 | 1015 | 1146 | QPN36948.1 polyprotein [Shenzhen dicistro-like virus] | diamond | 792 | 135 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus |
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);;