contig_metadata
16 rows where bioproject = "PRJNA792582", tax_phylum = "Kitrinoviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12256746 | 12256746 | PRJNA792582_P_NODE_54710_length_246_cov_0.890173_g53896_i0 | PRJNA792582 | 54710 | 246 | 0.890173 | 2.18982558 | Pumpkin alphaendornavirus | 2861712 | Viruses | Viruses | 444 | 3.14e-120 | NTclustered | gi|2072437000|gb|MW018478.1| | 2861712 | g53896 | i0 | 99.187 | 8.64227642276423 | 246 | 2 | 100 | 0 | 1 | 246 | 14757 | 14512 | Pumpkin alphaendornavirus isolate Anhui, complete genome | blastn | 2126 | 444 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Pumpkin alphaendornavirus | ||
| 25003652 | 25003652 | PRJNA792582_P_NODE_57440_length_243_cov_0.905882_g56626_i0 | PRJNA792582 | 57440 | 243 | 0.905882 | 2.20129326 | Cucurbit chlorotic yellows virus | 558690 | Viruses | Viruses | 444 | 3.09e-120 | NTclustered | gi|2899224146|gb|PQ686549.1| | 558690 | g56626 | i0 | 99.588 | 64.761316872428 | 243 | 1 | 100 | 0 | 1 | 243 | 4815 | 5057 | Cucurbit chlorotic yellows virus isolate CCYV-M-NJ1 segment RNA2, complete sequence | blastn | 15737 | 444 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Crinivirus | Cucurbit chlorotic yellows virus | ||
| 26651188 | 26651188 | PRJNA792582_P_NODE_4981_length_737_cov_2.045181_g4262_i0 | PRJNA792582 | 4981 | 737 | 2.045181 | 15.07298397 | Alphaendornavirus | 2003394 | Viruses | Viruses | 63.5 | 2.13e-7 | NR | QUA12642.1 | 2829282 | g4262 | i0 | 31.9 | 1.1763907734057 | 144 | 95 | 58.2 | 2 | 635 | 207 | 1138 | 1279 | QUA12642.1 polyprotein, partial [Phytophthora cactorum alphaendornavirus 3] | diamond | 867 | 63.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Phytophthora cactorum alphaendornavirus 3 | ||
| 26958638 | 26958638 | PRJNA792582_P_NODE_50102_length_251_cov_0.865169_g49288_i0 | PRJNA792582 | 50102 | 251 | 0.865169 | 2.17157419 | Phytophthora heveae alphaendornavirus 1 | 3044010 | Viruses | Viruses | 53.1 | 9.19e-6 | NR | WGT76336.1 | 3044010 | g49288 | i0 | 33.8 | 0.920318725099602 | 77 | 51 | 92 | 0 | 1 | 231 | 621 | 697 | WGT76336.1 polyprotein [Phytophthora heveae alphaendornavirus 1] | diamond | 231 | 53.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Phytophthora heveae alphaendornavirus 1 | ||
| 26967979 | 26967979 | PRJNA792582_P_NODE_5582_length_700_cov_1.593301_g4835_i0 | PRJNA792582 | 5582 | 700 | 1.593301 | 11.153107 | Alphaendornavirus | 2003394 | Viruses | Viruses | 140 | 2.3600000000000002e-36 | NR | WWU04017.1 | 2809381 | g4835 | i0 | 32.1 | 2.95714285714286 | 234 | 158 | 99.9 | 1 | 2 | 700 | 32 | 265 | WWU04017.1 MAG: polyprotein, partial [Endornaviridae sp.] | diamond | 2070 | 141 | 0.99290780141844 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Endornaviridae sp. | |||
| 26999505 | 26999505 | PRJNA792582_P_NODE_1742_length_1184_cov_3.025203_g1307_i0 | PRJNA792582 | 1742 | 1184 | 3.025203 | 35.81840352 | Alphaendornavirus | 2003394 | Viruses | Viruses | 68.6 | 2.85e-8 | NR | WWU04021.1 | 2809381 | g1307 | i0 | 31.3 | 2.30067567567568 | 198 | 113 | 47.4 | 9 | 828 | 268 | 920 | 1105 | WWU04021.1 MAG: polyprotein, partial [Endornaviridae sp.] | diamond | 2724 | 68.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Endornaviridae sp. | |||
| 27874974 | 27874974 | PRJNA792582_P_NODE_32985_length_300_cov_1.898678_g32171_i0 | PRJNA792582 | 32985 | 300 | 1.898678 | 5.696034 | Phytophthora heveae alphaendornavirus 1 | 3044010 | Viruses | Viruses | 75.5 | 2.38e-13 | NR | WGT76336.1 | 3044010 | g32171 | i0 | 41.8 | 0.91 | 91 | 52 | 90 | 1 | 289 | 20 | 1457 | 1547 | WGT76336.1 polyprotein [Phytophthora heveae alphaendornavirus 1] | diamond | 273 | 75.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Phytophthora heveae alphaendornavirus 1 | ||
| 28506561 | 28506561 | PRJNA792582_P_NODE_6287_length_663_cov_2.369492_g5519_i0 | PRJNA792582 | 6287 | 663 | 2.369492 | 15.70973196 | Phytophthora cactorum alphaendornavirus 5 | 3367733 | Viruses | Viruses | 251 | 7.599999999999999e-73 | NR | BFT85755.1 | 3367733 | g5519 | i0 | 58.5 | 0.936651583710407 | 207 | 86 | 93.7 | 0 | 659 | 39 | 3988 | 4194 | BFT85755.1 polyprotein [Phytophthora cactorum alphaendornavirus 5] | diamond | 621 | 251 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Phytophthora cactorum alphaendornavirus 5 | ||
| 29674406 | 29674406 | PRJNA792582_P_NODE_15390_length_439_cov_1.377049_g14576_i0 | PRJNA792582 | 15390 | 439 | 1.377049 | 6.04524511 | Dicrocoelium alphaendornavirus | 3038081 | Viruses | Viruses | 74.3 | 3.29e-12 | NR | WFD53206.1 | 3038081 | g14576 | i0 | 30.9 | 0.840546697038724 | 123 | 76 | 77.9 | 1 | 439 | 98 | 763 | 885 | WFD53206.1 MAG: polyprotein [Dicrocoelium alphaendornavirus] | diamond | 369 | 74.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Dicrocoelium alphaendornavirus | ||
| 29683602 | 29683602 | PRJNA792582_P_NODE_27990_length_326_cov_2.430830_g27176_i0 | PRJNA792582 | 27990 | 326 | 2.43083 | 7.9245058 | Alphaendornavirus | 2003394 | Viruses | Viruses | 54.3 | 8.08e-6 | NR | WWU04019.1 | 2809381 | g27176 | i0 | 32.4 | 3.67177914110429 | 108 | 70 | 97.5 | 2 | 318 | 1 | 201 | 307 | WWU04019.1 MAG: polyprotein, partial [Endornaviridae sp.] | diamond | 1197 | 54.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Endornaviridae sp. | |||
| 29990653 | 29990653 | PRJNA792582_P_NODE_52851_length_248_cov_0.880000_g52037_i0 | PRJNA792582 | 52851 | 248 | 0.88 | 2.1824 | Heilongjiang sediment alphaendornavirus 5 | 2824275 | Viruses | Viruses | 65.1 | 5.25e-10 | NR | QYF50122.1 | 2824275 | g52037 | i0 | 41 | 2.00806451612903 | 83 | 46 | 99.2 | 3 | 247 | 2 | 424 | 504 | QYF50122.1 MAG: polyprotein, partial [Heilongjiang sediment alphaendornavirus 5] | diamond | 498 | 65.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Heilongjiang sediment alphaendornavirus 5 | ||
| 30907053 | 30907053 | PRJNA792582_P_NODE_10274_length_530_cov_2.505470_g9469_i0 | PRJNA792582 | 10274 | 530 | 2.50547 | 13.278991 | Nodamuvirales sp. | 2809606 | Viruses | Viruses | 92 | 3.49e-18 | NR | XKB76511.1 | 2809606 | g9469 | i0 | 39.9 | 1.58490566037736 | 138 | 82 | 77.5 | 1 | 426 | 16 | 2 | 139 | XKB76511.1 MAG: coat protein, partial [Nodamuvirales sp.] | diamond | 840 | 92 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodamuvirales sp. | ||||
| 30947827 | 30947827 | PRJNA792582_P_NODE_1554_length_1245_cov_2.668942_g1141_i0 | PRJNA792582 | 1554 | 1245 | 2.668942 | 33.2283279 | Alphaendornavirus | 2003394 | Viruses | Viruses | 108 | 2.89e-21 | NR | QUA12642.1 | 2829282 | g1141 | i0 | 26.9 | 1.88433734939759 | 391 | 260 | 90.4 | 9 | 121 | 1245 | 1802 | 2182 | QUA12642.1 polyprotein, partial [Phytophthora cactorum alphaendornavirus 3] | diamond | 2346 | 109 | 0.990825688073395 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Phytophthora cactorum alphaendornavirus 3 | ||
| 31254397 | 31254397 | PRJNA792582_P_NODE_37995_length_283_cov_1.409524_g37181_i0 | PRJNA792582 | 37995 | 283 | 1.409524 | 3.98895292 | Endornaviridae sp. | 2809381 | Viruses | Viruses | 58.2 | 2.34e-7 | NR | WWU04020.1 | 2809381 | g37181 | i0 | 28.6 | 0.964664310954064 | 91 | 65 | 96.5 | 0 | 277 | 5 | 779 | 869 | WWU04020.1 MAG: polyprotein, partial [Endornaviridae sp.] | diamond | 273 | 58.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Endornaviridae sp. | |||
| 31981874 | 31981874 | PRJNA792582_P_NODE_17478_length_412_cov_2.696165_g16664_i0 | PRJNA792582 | 17478 | 412 | 2.696165 | 11.1081998 | Dicrocoelium alphaendornavirus | 3038081 | Viruses | Viruses | 72.4 | 1.14e-11 | NR | WFD53206.1 | 3038081 | g16664 | i0 | 35.2 | 0.640776699029126 | 88 | 57 | 64.1 | 0 | 149 | 412 | 1978 | 2065 | WFD53206.1 MAG: polyprotein [Dicrocoelium alphaendornavirus] | diamond | 264 | 72.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Dicrocoelium alphaendornavirus | ||
| 32076904 | 32076904 | PRJNA792582_P_NODE_14418_length_452_cov_2.432718_g13605_i0 | PRJNA792582 | 14418 | 452 | 2.432718 | 10.99588536 | Phytophthora heveae alphaendornavirus 1 | 3044010 | Viruses | Viruses | 61.2 | 1.34e-7 | NR | WGT76336.1 | 3044010 | g13605 | i0 | 30.6 | 0.955752212389381 | 144 | 91 | 92.9 | 6 | 8 | 427 | 181 | 319 | WGT76336.1 polyprotein [Phytophthora heveae alphaendornavirus 1] | diamond | 432 | 61.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Phytophthora heveae alphaendornavirus 1 |
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);;