contig_metadata
24 rows where bioproject = "PRJNA835051" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2101566 | 2101566 | PRJNA835051_S_NODE_44242_length_225_cov_1.307692_g43946_i0 | PRJNA835051 | 44242 | 225 | 1.307692 | 2.942307 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g43946 | i0 | 100 | 0.648888888888889 | 30 | 0 | 13 | 0 | 1 | 30 | 13 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 146 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 2102127 | 2102127 | PRJNA835051_S_NODE_87922_length_178_cov_1.837037_g87626_i0 | PRJNA835051 | 87922 | 178 | 1.837037 | 3.26992586 | Ilarvirus SnIV1 | 3429937 | Viruses | Viruses | 318 | 1.34e-82 | NTclustered | gi|2484149205|tpg|BK061655.1| | 2676886 | g87626 | i0 | 98.876 | 29.8539325842697 | 178 | 2 | 100 | 0 | 1 | 178 | 458 | 635 | TPA_asm: Solanum nigrum ilarvirus 1 isolate SRR11680723 segment RNA1 replicase-associated polyprotein (1a) gene, complete cds | blastn | 5314 | 318 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Ilarvirus | Ilarvirus SnIV1 | ||
| 3376841 | 3376841 | PRJNA835051_S_NODE_40323_length_231_cov_1.739362_g40027_i0 | PRJNA835051 | 40323 | 231 | 1.739362 | 4.01792622 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g40027 | i0 | 100 | 0.61038961038961 | 29 | 0 | 13 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 3377283 | 3377283 | PRJNA835051_S_NODE_76583_length_188_cov_0.813793_g76287_i0 | PRJNA835051 | 76583 | 188 | 0.813793 | 1.52993084 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g76287 | i0 | 100 | 0.303191489361702 | 29 | 0 | 15 | 0 | 160 | 188 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 4654897 | 4654897 | PRJNA835051_S_NODE_7684_length_347_cov_2.000000_g7388_i0 | PRJNA835051 | 7684 | 347 | 2 | 6.94 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g7388 | i0 | 96.97 | 0.175792507204611 | 33 | 1 | 10 | 0 | 315 | 347 | 38 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 61 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 4655066 | 4655066 | PRJNA835051_S_NODE_93224_length_174_cov_1.778626_g92928_i0 | PRJNA835051 | 93224 | 174 | 1.778626 | 3.09480924 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 311 | 2.19e-80 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g92928 | i0 | 98.851 | 99.9597701149425 | 174 | 2 | 100 | 0 | 1 | 174 | 3715 | 3542 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 17393 | 311 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 5929048 | 5929048 | PRJNA835051_S_NODE_32925_length_244_cov_1.796020_g32629_i0 | PRJNA835051 | 32925 | 244 | 1.79602 | 4.3822888 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g32629 | i0 | 100 | 0.577868852459016 | 29 | 0 | 12 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 8478478 | 8478478 | PRJNA835051_S_NODE_12987_length_306_cov_1.794677_g12691_i0 | PRJNA835051 | 12987 | 306 | 1.794677 | 5.49171162 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g12691 | i0 | 100 | 0.464052287581699 | 30 | 0 | 10 | 0 | 277 | 306 | 42 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 8478955 | 8478955 | PRJNA835051_S_NODE_43667_length_226_cov_1.295082_g43371_i0 | PRJNA835051 | 43667 | 226 | 1.295082 | 2.92688532 | Potexvirus pepini | 3433856 | Viruses | Viruses | 418 | 1.7199999999999998e-112 | NTclustered | gi|375808845|gb|JN835466.1| | 112229 | g43371 | i0 | 100 | 75.7610619469027 | 226 | 0 | 100 | 0 | 1 | 226 | 3757 | 3982 | Pepino mosaic virus strain CH2, complete genome | blastn | 17122 | 418 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 11030380 | 11030380 | PRJNA835051_S_NODE_88409_length_178_cov_1.066667_g88113_i0 | PRJNA835051 | 88409 | 178 | 1.066667 | 1.89866726 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g88113 | i0 | 100 | 0.320224719101124 | 29 | 0 | 16 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 12305522 | 12305522 | PRJNA835051_S_NODE_65090_length_199_cov_1.230769_g64794_i0 | PRJNA835051 | 65090 | 199 | 1.230769 | 2.44923031 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g64794 | i0 | 96.97 | 0.306532663316583 | 33 | 0 | 16 | 1 | 1 | 32 | 6 | 38 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 61 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 14853905 | 14853905 | PRJNA835051_S_NODE_2852_length_463_cov_3.100000_g2561_i0 | PRJNA835051 | 2852 | 463 | 3.1 | 14.353 | Potexvirus pepini | 3433856 | Viruses | Viruses | 845 | 0 | NTclustered | gi|1740135758|gb|MN182534.1| | 112229 | g2561 | i0 | 100 | 95.511879049676 | 457 | 0 | 99 | 0 | 1 | 457 | 5949 | 6405 | Pepino mosaic virus strain PMV.21930919, complete genome | blastn | 44222 | 845 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 14854406 | 14854406 | PRJNA835051_S_NODE_70252_length_193_cov_5.066667_g69956_i0 | PRJNA835051 | 70252 | 193 | 5.066667 | 9.77866731 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g69956 | i0 | 100 | 0.155440414507772 | 30 | 0 | 16 | 0 | 164 | 193 | 44 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 30 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 16128864 | 16128864 | PRJNA835051_S_NODE_56553_length_208_cov_2.266667_g56257_i0 | PRJNA835051 | 56553 | 208 | 2.266667 | 4.71466736 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g56257 | i0 | 100 | 0.139423076923077 | 29 | 0 | 14 | 0 | 180 | 208 | 44 | 16 | Carnation latent virus isolate KL, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 16129239 | 16129239 | PRJNA835051_S_NODE_83213_length_182_cov_1.374101_g82917_i0 | PRJNA835051 | 83213 | 182 | 1.374101 | 2.50086382 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g82917 | i0 | 100 | 0.78021978021978 | 30 | 0 | 16 | 0 | 1 | 30 | 13 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 17404630 | 17404630 | PRJNA835051_S_NODE_6714_length_359_cov_3.655063_g6418_i0 | PRJNA835051 | 6714 | 359 | 3.655063 | 13.12167617 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g6418 | i0 | 100 | 0.392757660167131 | 29 | 0 | 8 | 0 | 331 | 359 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 17404744 | 17404744 | PRJNA835051_S_NODE_7674_length_347_cov_2.167763_g7378_i0 | PRJNA835051 | 7674 | 347 | 2.167763 | 7.52213761 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.033 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g7378 | i0 | 100 | 0.0806916426512968 | 28 | 0 | 8 | 0 | 320 | 347 | 42 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 19080956 | 19080956 | PRJNA835051_S_NODE_124355_length_154_cov_1.297297_g124059_i0 | PRJNA835051 | 124355 | 154 | 1.297297 | 1.99783738 | Potexvirus | 12176 | Viruses | Viruses | 285 | 1.14e-72 | NTclustered | gi|148283741|gb|EF408821.3| | 112229 | g124059 | i0 | 100 | 58.974025974026 | 154 | 0 | 100 | 0 | 1 | 154 | 1183 | 1030 | Pepino mosaic virus isolate PepMV-PK, complete genome | blastn | 9082 | 285 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 19952290 | 19952290 | PRJNA835051_S_NODE_27896_length_255_cov_1.122642_g27600_i0 | PRJNA835051 | 27896 | 255 | 1.122642 | 2.8627371 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g27600 | i0 | 100 | 0.666666666666667 | 30 | 0 | 12 | 0 | 226 | 255 | 42 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 170 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 22503349 | 22503349 | PRJNA835051_S_NODE_79898_length_185_cov_1.014085_g79602_i0 | PRJNA835051 | 79898 | 185 | 1.014085 | 1.87605725 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g79602 | i0 | 100 | 0.308108108108108 | 29 | 0 | 16 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 23777753 | 23777753 | PRJNA835051_S_NODE_106299_length_165_cov_1.475410_g106003_i0 | PRJNA835051 | 106299 | 165 | 1.47541 | 2.4344265 | Potexvirus pepini | 3433856 | Viruses | Viruses | 305 | 9.59e-79 | NTclustered | gi|375808845|gb|JN835466.1| | 112229 | g106003 | i0 | 100 | 58 | 165 | 0 | 100 | 0 | 1 | 165 | 300 | 136 | Pepino mosaic virus strain CH2, complete genome | blastn | 9570 | 305 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 25052008 | 25052008 | PRJNA835051_S_NODE_22400_length_269_cov_1.814159_g22104_i0 | PRJNA835051 | 22400 | 269 | 1.814159 | 4.88008771 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g22104 | i0 | 100 | 0.104089219330855 | 28 | 0 | 10 | 0 | 242 | 269 | 42 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 25455978 | 25455978 | PRJNA835051_S_NODE_12960_length_306_cov_2.171103_g12664_i0 | PRJNA835051 | 12960 | 306 | 2.171103 | 6.64357518 | Potexvirus | 12176 | Viruses | Viruses | 560 | 3.84e-155 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g12664 | i0 | 99.673 | 59.9150326797386 | 306 | 1 | 100 | 0 | 1 | 306 | 3429 | 3124 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 18334 | 560 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 25456154 | 25456154 | PRJNA835051_S_NODE_50500_length_216_cov_1.872832_g50204_i0 | PRJNA835051 | 50500 | 216 | 1.872832 | 4.04531712 | Potexvirus | 12176 | Viruses | Viruses | 399 | 5.909999999999999e-107 | NTclustered | gi|1421680767|gb|MH550257.1| | 112229 | g50204 | i0 | 100 | 100 | 216 | 0 | 100 | 0 | 1 | 216 | 1255 | 1470 | Pepino mosaic virus isolate GR17-8b TGBp1, TGBp2, TGBp3, and CP genes, complete cds | blastn | 21600 | 399 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini |
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);;