contig_metadata
19 rows where bioproject = "PRJNA1067370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181210 | 181210 | PRJNA1067370_P_NODE_861_length_1585_cov_1.854497_g657_i0 | PRJNA1067370 | 861 | 1585 | 1.854497 | 29.39377745 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 2492 | 0 | NTclustered | gi|2512663715|gb|OQ139537.1| | 263004 | g657 | i0 | 95.127 | 13.7129337539432 | 1580 | 77 | 99 | 0 | 1 | 1580 | 1924 | 3503 | Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome | blastn | 21735 | 2492 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 1455395 | 1455395 | PRJNA1067370_P_NODE_20822_length_413_cov_0.900000_g20274_i0 | PRJNA1067370 | 20822 | 413 | 0.9 | 3.717 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 625 | 1.8699999999999995e-174 | NTclustered | gi|930624036|gb|KR072674.1| | 1718190 | g20274 | i0 | 93.947 | 2.99757869249395 | 413 | 25 | 100 | 0 | 1 | 413 | 3963 | 3551 | Sweet potato yellow mottle virus, complete genome | blastn | 1238 | 625 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 1455478 | 1455478 | PRJNA1067370_P_NODE_30282_length_354_cov_1.505338_g29734_i0 | PRJNA1067370 | 30282 | 354 | 1.505338 | 5.32889652 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 520 | 7.639999999999999e-143 | NTclustered | gi|930624036|gb|KR072674.1| | 1718190 | g29734 | i0 | 93.22 | 3.94915254237288 | 354 | 22 | 99 | 2 | 2 | 354 | 3252 | 2900 | Sweet potato yellow mottle virus, complete genome | blastn | 1398 | 520 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 2731503 | 2731503 | PRJNA1067370_P_NODE_61903_length_277_cov_1.181373_g61354_i0 | PRJNA1067370 | 61903 | 277 | 1.181373 | 3.27240321 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 429 | 1.0099999999999999e-115 | NTclustered | gi|930624036|gb|KR072674.1| | 1718190 | g61354 | i0 | 94.585 | 3.99638989169675 | 277 | 15 | 100 | 0 | 1 | 277 | 5156 | 5432 | Sweet potato yellow mottle virus, complete genome | blastn | 1107 | 429 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 4007180 | 4007180 | PRJNA1067370_P_NODE_22844_length_397_cov_2.478395_g22296_i0 | PRJNA1067370 | 22844 | 397 | 2.478395 | 9.83922815 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 678 | 0 | NTclustered | gi|2512663715|gb|OQ139537.1| | 263004 | g22296 | i0 | 97.481 | 18.9773299748111 | 397 | 10 | 100 | 0 | 1 | 397 | 28 | 424 | Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome | blastn | 7534 | 678 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 4007265 | 4007265 | PRJNA1067370_P_NODE_33444_length_341_cov_2.044776_g32896_i0 | PRJNA1067370 | 33444 | 341 | 2.044776 | 6.97268616 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 575 | 1.5499999999999994e-159 | NTclustered | gi|2512663715|gb|OQ139537.1| | 263004 | g32896 | i0 | 97.067 | 11.0029325513196 | 341 | 10 | 100 | 0 | 1 | 341 | 436 | 776 | Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome | blastn | 3752 | 575 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 5283835 | 5283835 | PRJNA1067370_P_NODE_68145_length_267_cov_2.159794_g67596_i0 | PRJNA1067370 | 68145 | 267 | 2.159794 | 5.76664998 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 388 | 1.64e-103 | NTclustered | gi|930624036|gb|KR072674.1| | 1718190 | g67596 | i0 | 92.884 | 5.96629213483146 | 267 | 19 | 100 | 0 | 1 | 267 | 6788 | 6522 | Sweet potato yellow mottle virus, complete genome | blastn | 1593 | 388 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 6558578 | 6558578 | PRJNA1067370_P_NODE_1646_length_1261_cov_4.066498_g1353_i0 | PRJNA1067370 | 1646 | 1261 | 4.066498 | 51.27853978 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 793 | 0 | NTclustered | gi|2416689812|gb|OP699083.1| | 2809460 | g1353 | i0 | 80.246 | 0.839016653449643 | 1058 | 205 | 84 | 4 | 206 | 1261 | 1067 | 12 | Hepelivirales sp. strain MR644-18E/5050 nonstructural polyprotein gene, partial cds | blastn | 1058 | 793 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 6559037 | 6559037 | PRJNA1067370_P_NODE_826_length_1612_cov_3.637427_g631_i0 | PRJNA1067370 | 826 | 1612 | 3.637427 | 58.63532324 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 2684 | 0 | NTclustered | gi|2512663715|gb|OQ139537.1| | 263004 | g631 | i0 | 96.712 | 46.2382133995037 | 1612 | 53 | 100 | 0 | 1 | 1612 | 7472 | 9083 | Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome | blastn | 74536 | 2684 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 10383994 | 10383994 | PRJNA1067370_P_NODE_21789_length_405_cov_1.692771_g21241_i0 | PRJNA1067370 | 21789 | 405 | 1.692771 | 6.85572255 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 536 | 8.799999999999998e-148 | NTclustered | gi|930624036|gb|KR072674.1| | 1718190 | g21241 | i0 | 90.617 | 4.6962962962963 | 405 | 36 | 99 | 2 | 1 | 404 | 2469 | 2872 | Sweet potato yellow mottle virus, complete genome | blastn | 1902 | 536 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 12934451 | 12934451 | PRJNA1067370_P_NODE_21931_length_404_cov_1.531722_g21383_i0 | PRJNA1067370 | 21931 | 404 | 1.531722 | 6.18815688 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 610 | 5.0999999999999976e-170 | NTclustered | gi|930624036|gb|KR072674.1| | 1718190 | g21383 | i0 | 94.03 | 5.9480198019802 | 402 | 24 | 99 | 0 | 3 | 404 | 6513 | 6112 | Sweet potato yellow mottle virus, complete genome | blastn | 2403 | 610 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 14209367 | 14209367 | PRJNA1067370_P_NODE_152_length_2988_cov_2.581818_g90_i0 | PRJNA1067370 | 152 | 2988 | 2.581818 | 77.14472184 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 5073 | 0 | NTclustered | gi|2512663715|gb|OQ139537.1| | 263004 | g90 | i0 | 97.323 | 17.0619143239625 | 2988 | 79 | 100 | 1 | 1 | 2988 | 4518 | 7504 | Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome | blastn | 50981 | 5073 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 18032738 | 18032738 | PRJNA1067370_P_NODE_6495_length_698_cov_1.388800_g5985_i0 | PRJNA1067370 | 6495 | 698 | 1.3888 | 9.693824 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 1116 | 0 | NTclustered | gi|930624036|gb|KR072674.1| | 1718190 | g5985 | i0 | 95.552 | 5.97421203438395 | 697 | 31 | 99 | 0 | 2 | 698 | 6911 | 7607 | Sweet potato yellow mottle virus, complete genome | blastn | 4170 | 1116 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 19306300 | 19306300 | PRJNA1067370_P_NODE_16116_length_462_cov_1.624679_g15568_i0 | PRJNA1067370 | 16116 | 462 | 1.624679 | 7.50601698 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 767 | 0 | NTclustered | gi|2512663715|gb|OQ139537.1| | 263004 | g15568 | i0 | 96.739 | 13.969696969697 | 460 | 15 | 99 | 0 | 3 | 462 | 1231 | 1690 | Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome | blastn | 6454 | 767 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 19306507 | 19306507 | PRJNA1067370_P_NODE_45576_length_308_cov_1.217021_g45028_i0 | PRJNA1067370 | 45576 | 308 | 1.217021 | 3.74842468 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 507 | 5.0999999999999996e-139 | NTclustered | gi|2512663715|gb|OQ139537.1| | 263004 | g45028 | i0 | 96.417 | 9.89935064935065 | 307 | 11 | 99 | 0 | 2 | 308 | 826 | 1132 | Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome | blastn | 3049 | 507 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 20581934 | 20581934 | PRJNA1067370_P_NODE_32457_length_345_cov_1.830882_g31909_i0 | PRJNA1067370 | 32457 | 345 | 1.830882 | 6.3165429 | Chrocomolt virus | 3129476 | Viruses | Viruses | 429 | 1.29e-115 | NTclustered | gi|2717317674|gb|PP171924.1| | 3129476 | g31909 | i0 | 95.203 | 28.2347826086957 | 271 | 13 | 79 | 0 | 1 | 271 | 4130 | 4400 | MAG: Chrocomolt virus isolate CC1B_k141_48525 genomic sequence | blastn | 9741 | 429 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Chrocomolt virus | ||||
| 20582007 | 20582007 | PRJNA1067370_P_NODE_4417_length_834_cov_1.950066_g3944_i0 | PRJNA1067370 | 4417 | 834 | 1.950066 | 16.26355044 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 1391 | 0 | NTclustered | gi|2512663715|gb|OQ139537.1| | 263004 | g3944 | i0 | 96.763 | 11.0011990407674 | 834 | 27 | 100 | 0 | 1 | 834 | 4524 | 3691 | Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome | blastn | 9175 | 1391 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 24406803 | 24406803 | PRJNA1067370_P_NODE_4500_length_826_cov_1.940239_g4023_i0 | PRJNA1067370 | 4500 | 826 | 1.940239 | 16.02637414 | Carlavirus chloroipomoeae | 3427748 | Viruses | Viruses | 1304 | 0 | NTclustered | gi|930624036|gb|KR072674.1| | 1718190 | g4023 | i0 | 95.157 | 11.7130750605327 | 826 | 40 | 100 | 0 | 1 | 826 | 8924 | 8099 | Sweet potato yellow mottle virus, complete genome | blastn | 9675 | 1304 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus chloroipomoeae | ||
| 29814375 | 29814375 | PRJNA1067370_P_NODE_31_length_6458_cov_5.867659_g7_i0 | PRJNA1067370 | 31 | 6458 | 5.867659 | 378.93341822 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 997 | 0 | NR | WAY16397.1 | 2809460 | g7 | i0 | 93.3 | 0.24852895633323 | 535 | 36 | 24.9 | 0 | 4445 | 2841 | 1 | 535 | WAY16397.1 nonstructural polyprotein, partial [Hepelivirales sp.] | diamond | 1605 | 997 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. |
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);;