contig_metadata
26 rows where bioproject = "PRJNA758770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 740368 | 740368 | PRJNA758770_S_NODE_14321_length_309_cov_1.322034_g14195_i0 | PRJNA758770 | 14321 | 309 | 1.322034 | 4.08508506 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 571 | 1.7899999999999995e-158 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g14195 | i0 | 100 | 86.0097087378641 | 309 | 0 | 100 | 0 | 1 | 309 | 4159 | 3851 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 26577 | 571 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 3292149 | 3292149 | PRJNA758770_S_NODE_663_length_1277_cov_3.324751_g603_i0 | PRJNA758770 | 663 | 1277 | 3.324751 | 42.45707027 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 2313 | 0 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g603 | i0 | 99.373 | 94.4244322631167 | 1276 | 8 | 99 | 0 | 1 | 1276 | 6235 | 7510 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 120580 | 2313 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 3292182 | 3292182 | PRJNA758770_S_NODE_7983_length_385_cov_1.362179_g7857_i0 | PRJNA758770 | 7983 | 385 | 1.362179 | 5.24438915 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 695 | 0 | NTclustered | gi|1214997675|gb|KX156739.1| | 1214459 | g7857 | i0 | 99.221 | 83 | 385 | 3 | 100 | 0 | 1 | 385 | 1236 | 1620 | Citrus yellow vein clearing virus isolate GD-STJ, complete genome | blastn | 31955 | 695 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 4569227 | 4569227 | PRJNA758770_S_NODE_5604_length_447_cov_1.104278_g5478_i0 | PRJNA758770 | 5604 | 447 | 1.104278 | 4.93612266 | Mus musculus mobilized endogenous polytropic provirus | 590745 | Viruses | Viruses | 809 | 0 | NTclustered | gi|221326511|gb|FJ544576.1| | 590745 | g5478 | i0 | 99.329 | 101.959731543624 | 447 | 3 | 100 | 0 | 1 | 447 | 3250 | 2804 | Mus musculus mobilized endogenous polytropic provirus clone 5 truncated gag-pol polyprotein (gag) gene, complete cds | blastn | 45576 | 809 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Mus musculus mobilized endogenous polytropic provirus | ||
| 8393870 | 8393870 | PRJNA758770_S_NODE_23587_length_253_cov_0.866667_g23461_i0 | PRJNA758770 | 23587 | 253 | 0.866667 | 2.19266751 | Betaretrovirus murmamtum | 3427295 | Viruses | Viruses | 468 | 1.92e-127 | NTclustered | gi|6911285|gb|AF228552.1|AF228552 | 46608 | g23461 | i0 | 100 | 22.2687747035573 | 253 | 0 | 100 | 0 | 1 | 253 | 2266 | 2518 | Exogenous mouse mammary tumor virus C3H complete proviral genome | blastn | 5634 | 468 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 9668944 | 9668944 | PRJNA758770_S_NODE_18048_length_283_cov_1.147619_g17922_i0 | PRJNA758770 | 18048 | 283 | 1.147619 | 3.24776177 | Apscaviroid alphaflavivitis | 3416569 | Viruses | Viruses | 462 | 1.02e-125 | NTclustered | gi|2053420969|gb|MW732682.1| | 12904 | g17922 | i0 | 96.763 | 81.4876325088339 | 278 | 8 | 98 | 1 | 6 | 283 | 1 | 277 | Grapevine yellow speckle viroid 1 isolate BIO6-25J_GYSVd-1, complete genome | blastn | 23061 | 462 | 1 | Viruses | Pospiviroidae | Apscaviroid | Apscaviroid alphaflavivitis | ||||||
| 10944735 | 10944735 | PRJNA758770_S_NODE_2489_length_655_cov_2.314433_g2369_i0 | PRJNA758770 | 2489 | 655 | 2.314433 | 15.15953615 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 1210 | 0 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g2369 | i0 | 100 | 80.7465648854962 | 655 | 0 | 100 | 0 | 1 | 655 | 5383 | 4729 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 52889 | 1210 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 13494352 | 13494352 | PRJNA758770_S_NODE_22691_length_255_cov_3.510989_g22565_i0 | PRJNA758770 | 22691 | 255 | 3.510989 | 8.95302195 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 462 | 9.03e-126 | NTclustered | gi|1214997668|gb|KX156738.1| | 1214459 | g22565 | i0 | 99.605 | 81.4235294117647 | 253 | 1 | 99 | 0 | 3 | 255 | 4679 | 4427 | Citrus yellow vein clearing virus isolate GD-JG, complete genome | blastn | 20763 | 462 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 13958727 | 13958727 | PRJNA758770_S_NODE_28891_length_246_cov_1.473988_g28765_i0 | PRJNA758770 | 28891 | 246 | 1.473988 | 3.62601048 | Tobamovirus | 12234 | Viruses | Viruses | 453 | 5.2100000000000006e-123 | NTclustered | gi|1782797563|gb|MK933286.1| | 12235 | g28765 | i0 | 100 | 99.5975609756098 | 245 | 0 | 99 | 0 | 2 | 246 | 4397 | 4153 | Cucumber green mottle mosaic virus isolate GDLZ, complete genome | blastn | 24501 | 453 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus viridimaculae | ||
| 14769434 | 14769434 | PRJNA758770_S_NODE_21132_length_264_cov_1.617801_g21006_i0 | PRJNA758770 | 21132 | 264 | 1.617801 | 4.27099464 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 488 | 1.5499999999999999e-133 | NTclustered | gi|2866530880|gb|PQ567901.1| | 1214459 | g21006 | i0 | 100 | 83.6666666666667 | 264 | 0 | 100 | 0 | 1 | 264 | 1277 | 1014 | Citrus yellow vein clearing virus isolate CYVCV-FL-15, complete genome | blastn | 22088 | 488 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 16043113 | 16043113 | PRJNA758770_S_NODE_17313_length_288_cov_1.027907_g17187_i0 | PRJNA758770 | 17313 | 288 | 1.027907 | 2.96037216 | Betaretrovirus murmamtum | 3427295 | Viruses | Viruses | 377 | 3.87e-100 | NTclustered | gi|6911279|gb|AF228551.1|AF228551 | 46608 | g17187 | i0 | 99.517 | 50.2083333333333 | 207 | 1 | 72 | 0 | 80 | 286 | 1277 | 1483 | Exogenous mouse mammary tumor virus HeJ complete proviral genome | blastn | 14460 | 377 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 19867649 | 19867649 | PRJNA758770_S_NODE_30936_length_244_cov_0.912281_g30810_i0 | PRJNA758770 | 30936 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 189 | 1.6099999999999996e-43 | NTclustered | gi|2057119259|tpg|BK057927.1| | 2832643 | g30810 | i0 | 81.938 | 0.930327868852459 | 227 | 38 | 93 | 3 | 4 | 229 | 22001 | 22225 | MAG TPA_asm: Caudoviricetes sp. isolate ctw9w9, partial genome | blastn | 227 | 189 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21142907 | 21142907 | PRJNA758770_S_NODE_1397_length_858_cov_3.033121_g1301_i0 | PRJNA758770 | 1397 | 858 | 3.033121 | 26.02417818 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 1580 | 0 | NTclustered | gi|1214997710|gb|KX156744.1| | 1214459 | g1301 | i0 | 99.883 | 81.7097902097902 | 858 | 1 | 100 | 0 | 1 | 858 | 5363 | 6220 | Citrus yellow vein clearing virus isolate HN-GXP, complete genome | blastn | 70107 | 1580 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 21143492 | 21143492 | PRJNA758770_S_NODE_9477_length_360_cov_1.560976_g9351_i0 | PRJNA758770 | 9477 | 360 | 1.560976 | 5.6195136 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 599 | 9.72e-167 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g9351 | i0 | 99.694 | 76.1722222222222 | 327 | 1 | 91 | 0 | 1 | 327 | 3511 | 3185 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 27422 | 599 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 22417617 | 22417617 | PRJNA758770_S_NODE_10638_length_344_cov_1.435424_g10512_i0 | PRJNA758770 | 10638 | 344 | 1.435424 | 4.93785856 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 636 | 7.059999999999998e-178 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g10512 | i0 | 100 | 89.6191860465116 | 344 | 0 | 100 | 0 | 1 | 344 | 26 | 369 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 30829 | 636 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 22417689 | 22417689 | PRJNA758770_S_NODE_13858_length_313_cov_1.104167_g13732_i0 | PRJNA758770 | 13858 | 313 | 1.104167 | 3.45604271 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 569 | 6.539999999999998e-158 | NTclustered | gi|764160352|ref|NC_026592.1| | 1214459 | g13732 | i0 | 99.678 | 94.8753993610224 | 311 | 1 | 99 | 0 | 3 | 313 | 960 | 650 | Citrus yellow vein clearing virus isolate CQ, complete genome | blastn | 29696 | 569 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 27053178 | 27053178 | PRJNA758770_S_NODE_28562_length_247_cov_0.896552_g28436_i0 | PRJNA758770 | 28562 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52 | 2.06e-5 | NR | DAO73127.1 | 2832643 | g28436 | i0 | 46 | 0.765182186234818 | 63 | 27 | 72.9 | 2 | 242 | 63 | 150 | 208 | DAO73127.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 189 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27306112 | 27306112 | PRJNA758770_S_NODE_9923_length_353_cov_1.671429_g9797_i0 | PRJNA758770 | 9923 | 353 | 1.671429 | 5.90014437 | Currant latent virus | 1476584 | Viruses | Viruses | 232 | 1.6599999999999999e-68 | NR | WMN13751.1 | 1476584 | g9797 | i0 | 88 | 0.994334277620397 | 117 | 14 | 99.4 | 0 | 3 | 353 | 730 | 846 | WMN13751.1 polyprotein [Currant latent virus] | diamond | 351 | 232 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus ribis | ||
| 28663786 | 28663786 | PRJNA758770_S_NODE_18427_length_281_cov_0.966346_g18301_i0 | PRJNA758770 | 18427 | 281 | 0.966346 | 2.71543226 | Currant latent virus | 1476584 | Viruses | Viruses | 164 | 1.14e-44 | NR | WMN13751.1 | 1476584 | g18301 | i0 | 84.9 | 0.99288256227758 | 93 | 14 | 99.3 | 0 | 280 | 2 | 612 | 704 | WMN13751.1 polyprotein [Currant latent virus] | diamond | 279 | 164 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus ribis | ||
| 28663794 | 28663794 | PRJNA758770_S_NODE_32087_length_243_cov_0.900000_g31961_i0 | PRJNA758770 | 32087 | 243 | 0.9 | 2.187 | Currant latent virus | 1476584 | Viruses | Viruses | 138 | 7.58e-36 | NR | WMN13750.1 | 1476584 | g31961 | i0 | 83.3 | 0.962962962962963 | 78 | 13 | 96.3 | 0 | 9 | 242 | 402 | 479 | WMN13750.1 polyprotein [Currant latent virus] | diamond | 234 | 138 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus ribis | ||
| 28695477 | 28695477 | PRJNA758770_S_NODE_4607_length_487_cov_2.195652_g4482_i0 | PRJNA758770 | 4607 | 487 | 2.195652 | 10.69282524 | Currant latent virus | 1476584 | Viruses | Viruses | 278 | 5.960000000000001e-85 | NR | WMN13751.1 | 1476584 | g4482 | i0 | 88.6 | 1.02258726899384 | 166 | 15 | 99.8 | 1 | 486 | 1 | 344 | 509 | WMN13751.1 polyprotein [Currant latent virus] | diamond | 498 | 278 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus ribis | ||
| 28726873 | 28726873 | PRJNA758770_S_NODE_27387_length_248_cov_0.891429_g27261_i0 | PRJNA758770 | 27387 | 248 | 0.891429 | 2.21074392 | Thermus phage MN1 | 3018631 | Viruses | Viruses | 107 | 3.2499999999999998e-28 | NR | BDX35512.1 | 3018631 | g27261 | i0 | 78.3 | 0.834677419354839 | 69 | 15 | 83.5 | 0 | 2 | 208 | 28 | 96 | BDX35512.1 hypothetical protein MN1_450 [Thermus phage MN1] | diamond | 207 | 107 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage MN1 | |||||
| 29137592 | 29137592 | PRJNA758770_S_NODE_26389_length_249_cov_1.465909_g26263_i0 | PRJNA758770 | 26389 | 249 | 1.465909 | 3.65011341 | Tomato fruit blotch virus | 2762435 | Viruses | Viruses | 57.4 | 2.78e-7 | NR | QZN83593.1 | 2762435 | g26263 | i0 | 36.6 | 0.987951807228916 | 82 | 50 | 97.6 | 2 | 244 | 2 | 153 | 233 | QZN83593.1 putative helicase-RdRP protein [Tomato fruit blotch virus] | diamond | 246 | 57.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Kitaviridae | Blunervirus | Blunervirus solani | ||
| 31822954 | 31822954 | PRJNA758770_S_NODE_30957_length_244_cov_0.912281_g30831_i0 | PRJNA758770 | 30957 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 103 | 3.77e-25 | NR | DAL65659.1 | 2832643 | g30831 | i0 | 60 | 1.93032786885246 | 75 | 28 | 89.8 | 2 | 16 | 234 | 136 | 210 | DAL65659.1 MAG TPA_asm: DNA helix destabilizing protein [Caudoviricetes sp.] | diamond | 471 | 103 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32298094 | 32298094 | PRJNA758770_S_NODE_32899_length_242_cov_0.893491_g32773_i0 | PRJNA758770 | 32899 | 242 | 0.893491 | 2.16224822 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 66.6 | 1.14e-11 | NR | XOR68879.1 | 2832643 | g32773 | i0 | 60 | 1.51239669421488 | 45 | 18 | 55.8 | 0 | 135 | 1 | 1 | 45 | XOR68879.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 366 | 66.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32582575 | 32582575 | PRJNA758770_S_NODE_5699_length_444_cov_1.690027_g5573_i0 | PRJNA758770 | 5699 | 444 | 1.690027 | 7.50371988 | Currant latent virus | 1476584 | Viruses | Viruses | 296 | 1.0200000000000001e-91 | NR | WMN13751.1 | 1476584 | g5573 | i0 | 95.9 | 0.986486486486487 | 146 | 6 | 98.6 | 0 | 440 | 3 | 829 | 974 | WMN13751.1 polyprotein [Currant latent virus] | diamond | 438 | 296 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus ribis |
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);;