contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27331424 | 27331424 | PRJNA556992_P_NODE_212203_length_320_cov_5.967611_g210015_i0 | PRJNA556992 | 212203 | 320 | 5.967611 | 19.0963552 | Qianjiang endorna-like virus 3 | 3349071 | Viruses | Viruses | 145 | 8.35e-38 | NR | XHA85864.1 | 3349071 | g210015 | i0 | 66.3 | 0.975 | 104 | 35 | 97.5 | 0 | 3 | 314 | 1570 | 1673 | XHA85864.1 MAG: polyprotein [Qianjiang endorna-like virus 3] | diamond | 312 | 145 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Qianjiang endorna-like virus 3 | |||
| 27363187 | 27363187 | PRJNA556992_P_NODE_282783_length_292_cov_2.296804_g280594_i0 | PRJNA556992 | 282783 | 292 | 2.296804 | 6.70666768 | Citrus leaf blotch virus Ac | 2507947 | Viruses | Viruses | 92.8 | 1.8e-19 | NR | QAT18645.1 | 2507947 | g280594 | i0 | 55.9 | 0.955479452054795 | 93 | 36 | 95.5 | 1 | 1 | 279 | 543 | 630 | QAT18645.1 replicase polyprotein [Citrus leaf blotch virus Ac] | diamond | 279 | 92.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Citrus leaf blotch virus Ac | |||
| 27363286 | 27363286 | PRJNA556992_P_NODE_462163_length_270_cov_4.477157_g459974_i0 | PRJNA556992 | 462163 | 270 | 4.477157 | 12.0883239 | Qianjiang endorna-like virus 1 | 3349069 | Viruses | Viruses | 59.3 | 7.82e-8 | NR | XHA85862.1 | 3349069 | g459974 | i0 | 43.8 | 3.95555555555556 | 89 | 48 | 97.8 | 2 | 265 | 2 | 3136 | 3223 | XHA85862.1 MAG: polyprotein [Qianjiang endorna-like virus 1] | diamond | 1068 | 59.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Qianjiang endorna-like virus 1 | |||
| 27489687 | 27489687 | PRJNA556992_P_NODE_986783_length_232_cov_2.371069_g984593_i0 | PRJNA556992 | 986783 | 232 | 2.371069 | 5.50088008 | Qianjiang noda-like virus 127 | 3348498 | Viruses | Viruses | 85.9 | 1.99e-17 | NR | XHA86150.1 | 3348498 | g984593 | i0 | 51.9 | 0.995689655172414 | 77 | 37 | 99.6 | 0 | 232 | 2 | 29 | 105 | XHA86150.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang noda-like virus 127] | diamond | 231 | 85.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Qianjiang noda-like virus 127 | |||
| 27679049 | 27679049 | PRJNA556992_P_NODE_400164_length_276_cov_4.201970_g397975_i0 | PRJNA556992 | 400164 | 276 | 4.20197 | 11.5974372 | Sichuan sediment alphaendornavirus 24 | 2824213 | Viruses | Viruses | 95.1 | 6.120000000000001e-21 | NR | QYF50108.1 | 2824213 | g397975 | i0 | 55.4 | 1.90217391304348 | 83 | 37 | 90.2 | 0 | 252 | 4 | 117 | 199 | QYF50108.1 MAG: polyprotein, partial [Sichuan sediment alphaendornavirus 24] | diamond | 525 | 95.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Sichuan sediment alphaendornavirus 24 | ||
| 28057619 | 28057619 | PRJNA556992_P_NODE_528165_length_265_cov_1.312500_g525976_i0 | PRJNA556992 | 528165 | 265 | 1.3125 | 3.478125 | Martellivirales sp. gcode 6 | 3108922 | Viruses | Viruses | 52 | 2.81e-5 | NR | WRQ64711.1 | 3108922 | g525976 | i0 | 32.6 | 1.00754716981132 | 89 | 58 | 98.5 | 1 | 264 | 4 | 1323 | 1411 | WRQ64711.1 polyprotein, partial [Martellivirales sp. gcode 6] | diamond | 267 | 52 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Martellivirales sp. gcode 6 | ||||
| 28103383 | 28103383 | PRJNA556992_P_NODE_16425_length_830_cov_4.496697_g14621_i0 | PRJNA556992 | 16425 | 830 | 4.496697 | 37.3225851 | Alphaendornavirus | 2003394 | Viruses | Viruses | 180 | 2.7399999999999997e-47 | NR | QTE76046.1 | 2818056 | g14621 | i0 | 38.4 | 3.79879518072289 | 255 | 157 | 92.2 | 0 | 6 | 770 | 4301 | 4555 | QTE76046.1 polyprotein, partial [Neofusicoccum parvum endornavirus 1] | diamond | 3153 | 181 | 0.994475138121547 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Neofusicoccum parvum endornavirus 1 | |||
| 28121061 | 28121061 | PRJNA556992_P_NODE_950585_length_235_cov_5.629630_g948395_i0 | PRJNA556992 | 950585 | 235 | 5.62963 | 13.2296305 | Digyalum oweni associated virus | 3004187 | Viruses | Viruses | 45.8 | 0.00284 | NR | CAI9240335.1 | 3004187 | g948395 | i0 | 31.3 | 0.85531914893617 | 67 | 46 | 85.5 | 0 | 23 | 223 | 309 | 375 | CAI9240335.1 polyprotein, partial [Digyalum oweni associated virus] | diamond | 201 | 45.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Digyalum oweni associated virus | ||||
| 28215000 | 28215000 | PRJNA556992_P_NODE_1013326_length_229_cov_2.980769_g1011136_i0 | PRJNA556992 | 1013326 | 229 | 2.980769 | 6.82596101 | Digyalum oweni associated virus | 3004187 | Viruses | Viruses | 47 | 0.00103 | NR | CAI9240335.1 | 3004187 | g1011136 | i0 | 29.7 | 0.838427947598253 | 64 | 45 | 83.8 | 0 | 193 | 2 | 219 | 282 | CAI9240335.1 polyprotein, partial [Digyalum oweni associated virus] | diamond | 192 | 47 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Digyalum oweni associated virus | ||||
| 28341629 | 28341629 | PRJNA556992_P_NODE_1118906_length_208_cov_6.244444_g1116715_i0 | PRJNA556992 | 1118906 | 208 | 6.244444 | 12.98844352 | Rhizoctonia solani beny-like virus 5 | 2838386 | Viruses | Viruses | 46.2 | 0.00138 | NR | UIW13793.1 | 2838386 | g1116715 | i0 | 41.2 | 0.980769230769231 | 68 | 39 | 96.6 | 1 | 206 | 6 | 626 | 693 | UIW13793.1 MAG: replication-associated protein, partial [Rhizoctonia solani beny-like virus 5] | diamond | 204 | 46.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Benyviridae | Rhizoctonia solani beny-like virus 5 | |||
| 28499829 | 28499829 | PRJNA556992_P_NODE_440667_length_272_cov_4.512563_g438478_i0 | PRJNA556992 | 440667 | 272 | 4.512563 | 12.27417136 | Martellivirales sp. gcode 6 | 3108922 | Viruses | Viruses | 67.8 | 8.4e-11 | NR | WRQ64711.1 | 3108922 | g438478 | i0 | 41.8 | 0.871323529411765 | 79 | 46 | 87.1 | 0 | 254 | 18 | 368 | 446 | WRQ64711.1 polyprotein, partial [Martellivirales sp. gcode 6] | diamond | 237 | 67.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Martellivirales sp. gcode 6 | ||||
| 28562827 | 28562827 | PRJNA556992_P_NODE_24047_length_695_cov_3.959807_g22036_i0 | PRJNA556992 | 24047 | 695 | 3.959807 | 27.52065865 | Apis mellifera associated alphaendornavirus 2 | 3238874 | Viruses | Viruses | 49.3 | 0.00949 | NR | XDI97929.1 | 3238874 | g22036 | i0 | 28.1 | 1.38561151079137 | 135 | 95 | 57.8 | 2 | 82 | 483 | 2432 | 2565 | XDI97929.1 MAG: polyprotein [Apis mellifera associated alphaendornavirus 2] | diamond | 963 | 49.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Apis mellifera associated alphaendornavirus 2 | ||
| 29163283 | 29163283 | PRJNA556992_P_NODE_998349_length_230_cov_6.949045_g996159_i0 | PRJNA556992 | 998349 | 230 | 6.949045 | 15.9828035 | Rhizoctonia solani endornavirus 14 | 3135731 | Viruses | Viruses | 48.5 | 2.98e-4 | NR | WYC13929.1 | 3135731 | g996159 | i0 | 40.3 | 1.87826086956522 | 72 | 42 | 93.9 | 1 | 217 | 2 | 5140 | 5210 | WYC13929.1 MAG: polyprotein [Rhizoctonia solani endornavirus 14] | diamond | 432 | 48.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Rhizoctonia solani endornavirus 14 | |||
| 29731108 | 29731108 | PRJNA556992_P_NODE_99770_length_405_cov_4.430723_g97586_i0 | PRJNA556992 | 99770 | 405 | 4.430723 | 17.94442815 | Hainan sediment alphaendornavirus 6 | 2824262 | Viruses | Viruses | 66.2 | 1.16e-9 | NR | QYF50119.1 | 2824262 | g97586 | i0 | 37.5 | 0.888888888888889 | 120 | 66 | 86.7 | 5 | 397 | 47 | 240 | 353 | QYF50119.1 MAG: polyprotein, partial [Hainan sediment alphaendornavirus 6] | diamond | 360 | 66.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Hainan sediment alphaendornavirus 6 | ||
| 30773504 | 30773504 | PRJNA556992_P_NODE_1047014_length_225_cov_7.611842_g1044824_i0 | PRJNA556992 | 1047014 | 225 | 7.611842 | 17.1266445 | Digyalum oweni associated virus | 3004187 | Viruses | Viruses | 75.1 | 1.22e-13 | NR | CAI9240335.1 | 3004187 | g1044824 | i0 | 58.3 | 0.8 | 60 | 24 | 78.7 | 1 | 43 | 219 | 674 | 733 | CAI9240335.1 polyprotein, partial [Digyalum oweni associated virus] | diamond | 180 | 75.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Digyalum oweni associated virus | ||||
| 30946101 | 30946101 | PRJNA556992_P_NODE_615154_length_257_cov_5.521739_g612965_i0 | PRJNA556992 | 615154 | 257 | 5.521739 | 14.19086923 | Alphaendornavirus | 2003394 | Viruses | Viruses | 46.2 | 0.00277 | NR | YP_009010973.1 | 1468454 | g612965 | i0 | 39.4 | 2.26459143968872 | 66 | 40 | 77 | 0 | 257 | 60 | 1383 | 1448 | YP_009010973.1 polyprotein [Lagenaria siceraria endornavirus-California] | diamond | 582 | 46.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus lagenariae | ||
| 31500641 | 31500641 | PRJNA556992_P_NODE_142716_length_363_cov_8.834483_g140528_i0 | PRJNA556992 | 142716 | 363 | 8.834483 | 32.06917329 | Digyalum oweni associated virus | 3004187 | Viruses | Viruses | 53.5 | 2.53e-5 | NR | CAI9240335.1 | 3004187 | g140528 | i0 | 35.6 | 0.975206611570248 | 118 | 71 | 97.5 | 4 | 4 | 357 | 552 | 664 | CAI9240335.1 polyprotein, partial [Digyalum oweni associated virus] | diamond | 354 | 53.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Digyalum oweni associated virus | ||||
| 31500750 | 31500750 | PRJNA556992_P_NODE_35836_length_584_cov_19.336595_g33711_i0 | PRJNA556992 | 35836 | 584 | 19.336595 | 112.9257148 | Beijing sediment alphaendornavirus 1 | 2824271 | Viruses | Viruses | 82.4 | 1.46e-14 | NR | QZI85212.1 | 2824271 | g33711 | i0 | 50.6 | 0.395547945205479 | 77 | 38 | 39.6 | 0 | 232 | 2 | 119 | 195 | QZI85212.1 MAG: polyprotein, partial [Beijing sediment alphaendornavirus 1] | diamond | 231 | 82.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Beijing sediment alphaendornavirus 1 | ||
| 32038534 | 32038534 | PRJNA556992_P_NODE_589518_length_259_cov_9.521505_g587329_i0 | PRJNA556992 | 589518 | 259 | 9.521505 | 24.66069795 | Forneby virus | 2651956 | Viruses | Viruses | 46.6 | 0.00209 | NR | QGA70918.1 | 2651956 | g587329 | i0 | 30.1 | 0.961389961389961 | 83 | 54 | 96.1 | 3 | 4 | 252 | 1474 | 1552 | QGA70918.1 RNA-dependent RNA polymerase, partial [Forneby virus] | diamond | 249 | 46.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Forneby virus | |||
| 32386284 | 32386284 | PRJNA556992_P_NODE_1116899_length_209_cov_4.139706_g1114708_i0 | PRJNA556992 | 1116899 | 209 | 4.139706 | 8.65198554 | Cowpea mild mottle virus | 67761 | Viruses | Viruses | 50.1 | 6.35e-5 | NR | UZG77120.1 | 67761 | g1114708 | i0 | 46.7 | 1.29186602870813 | 45 | 24 | 64.6 | 0 | 75 | 209 | 712 | 756 | UZG77120.1 replicase [Cowpea mild mottle virus] | diamond | 270 | 50.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 32576466 | 32576466 | PRJNA556992_P_NODE_543439_length_263_cov_3.578947_g541250_i0 | PRJNA556992 | 543439 | 263 | 3.578947 | 9.41263061 | Inner Mongolia sediment alphaendornavirus 3 | 2824244 | Viruses | Viruses | 81.3 | 1.32e-15 | NR | QYF50098.1 | 2824244 | g541250 | i0 | 42.5 | 0.992395437262357 | 87 | 49 | 99.2 | 1 | 261 | 1 | 467 | 552 | QYF50098.1 MAG: polyprotein, partial [Inner Mongolia sediment alphaendornavirus 3] | diamond | 261 | 81.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Inner Mongolia sediment alphaendornavirus 3 |
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);;