RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where bioproject = "PRJEB28062", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 29 ✖

tax_phylum 1

  • Kitrinoviricota · 29 ✖

tax_kingdom 1

bioproject 1

  • PRJEB28062 · 29 ✖

tax_clade 0

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
23588 23588 PRJEB28062_P_NODE_1081_length_4477_cov_136.189146_g514_i0 PRJEB28062 1081 4477 136.189146 6097.18806642 Potexvirus pepini 3433856 Viruses Viruses 8165 0   NTclustered gi|2618216078|gb|OR733205.1| 112229 g514 i0 99.753 73.6665177574268 4454 11 99 0 24 4477 1957 6410 Pepino mosaic virus strain EU, complete genome blastn 329805 8165 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
25812 25812 PRJEB28062_P_NODE_961_length_5000_cov_776.499696_g423_i0 PRJEB28062 961 5000 776.499696 38824.9848 Potexvirus trifolii 3433859 Viruses Viruses 8366 0   NTclustered gi|2054359742|gb|MW248353.1| 12188 g423 i0 97.006 24.6204 4977 149 99 0 2 4978 5842 866 White clover mosaic virus isolate DSMZ PV-0310 replication-associated protein (ORF1), triple gene block 1 protein (ORF2), triple gene block 2 protein (ORF3), triple gene block 3 protein (ORF4), and capsid protein (ORF5) genes, complete cds blastn 123102 8366 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii
1298339 1298339 PRJEB28062_P_NODE_136942_length_208_cov_58.688889_g134578_i0 PRJEB28062 136942 208 58.688889 122.07288912 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.005   NTclustered gi|1995060321|gb|MN450069.1| 12164 g134578 i0 100 0.711538461538462 29 0 14 0 9 37 13 41 Carnation latent virus isolate KL, complete genome blastn 148 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
1299395 1299395 PRJEB28062_P_NODE_59442_length_454_cov_54.653543_g57083_i0 PRJEB28062 59442 454 54.653543 248.12708522 Tobamovirus capsici 3432865 Viruses Viruses 763 0   NTclustered gi|1927969406|gb|MW012414.1| 12239 g57083 i0 99.523 86.8149779735683 419 2 92 0 1 419 3832 3414 Pepper mild mottle virus isolate VPCP, complete genome blastn 39414 763 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus capsici
2575785 2575785 PRJEB28062_P_NODE_99403_length_316_cov_28.790123_g97041_i0 PRJEB28062 99403 316 28.790123 90.97678868 Jujube closterovirus 1 3043313 Viruses Viruses 56.5 0.002   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g97041 i0 94.595 0.117088607594937 37 0 12 1 1 37 8 42 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 37 56.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
3849733 3849733 PRJEB28062_P_NODE_106784_length_295_cov_2.504505_g104421_i0 PRJEB28062 106784 295 2.504505 7.38828975 Potexvirus pepini 3433856 Viruses Viruses 499 8.14e-137   NTclustered gi|375808845|gb|JN835466.1| 112229 g104421 i0 99.634 56.4237288135593 273 1 93 0 1 273 2084 1812 Pepino mosaic virus strain CH2, complete genome blastn 16645 499 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
3851197 3851197 PRJEB28062_P_NODE_54584_length_478_cov_17.276543_g52231_i0 PRJEB28062 54584 478 17.276543 82.58187554 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.013   NTclustered gi|1995060321|gb|MN450069.1| 12164 g52231 i0 94.444 0.309623430962343 36 1 7 1 444 478 48 13 Carnation latent virus isolate KL, complete genome blastn 148 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
5127436 5127436 PRJEB28062_P_NODE_55505_length_473_cov_43.717500_g53151_i0 PRJEB28062 55505 473 43.7175 206.783775 Carlavirus sigmasolani 3427796 Viruses Viruses 800 0   NTclustered gi|1159373126|gb|KX377344.1| 12169 g53151 i0 98.886 94.8837209302326 449 4 95 1 26 473 238 686 Potato virus S isolate 340-15 coat protein gene, partial cds; and 11 kDa protein gene, complete cds blastn 44880 800 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus sigmasolani
6402217 6402217 PRJEB28062_P_NODE_135426_length_221_cov_17.979730_g133062_i0 PRJEB28062 135426 221 17.97973 39.7352033 Carlavirus sigmasolani 3427796 Viruses Viruses 350 6.2e-92   NTclustered gi|1159373120|gb|KX377342.1| 12169 g133062 i0 98.01 90.9004524886878 201 4 91 0 21 221 398 598 Potato virus S isolate 179-15 coat protein gene, partial cds; and 11 kDa protein gene, complete cds blastn 20089 350 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus sigmasolani
6403327 6403327 PRJEB28062_P_NODE_61026_length_447_cov_39.256684_g58666_i0 PRJEB28062 61026 447 39.256684 175.47737748 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.012   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g58666 i0 100 0.12751677852349 29 0 6 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
6403698 6403698 PRJEB28062_P_NODE_7906_length_1401_cov_74.146084_g6470_i0 PRJEB28062 7906 1401 74.146084 1038.78663684 Potexvirus pepini 3433856 Viruses Viruses 2507 0   NTclustered gi|2523281636|gb|OR082776.1| 112229 g6470 i0 99.492 97.0970735189151 1378 7 98 0 23 1400 1 1378 Pepino mosaic virus isolate DSMZ PV-0999, complete genome blastn 136033 2507 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
8951828 8951828 PRJEB28062_P_NODE_4568_length_1889_cov_141.982379_g3538_i0 PRJEB28062 4568 1889 141.982379 2682.04713931 Potexvirus pepini 3433856 Viruses Viruses 3404 0   NTclustered gi|1345606506|gb|MF422613.1| 112229 g3538 i0 99.572 97.3208046585495 1867 8 99 0 23 1889 4546 6412 Pepino mosaic virus isolate CH_bpo162, complete genome blastn 183839 3404 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
8952167 8952167 PRJEB28062_P_NODE_60948_length_448_cov_2.760000_g58588_i0 PRJEB28062 60948 448 2.76 12.3648 Carlavirus latensdianthi 3427766 Viruses Viruses 52.8 0.043   NTclustered gi|1995060321|gb|MN450069.1| 12164 g58588 i0 100 0.0625 28 0 6 0 421 448 42 15 Carnation latent virus isolate KL, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
8952473 8952473 PRJEB28062_P_NODE_76388_length_389_cov_5.876582_g74026_i0 PRJEB28062 76388 389 5.876582 22.85990398 Jujube closterovirus 1 3043313 Viruses Viruses 52.8 0.037   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g74026 i0 100 0.0719794344473008 28 0 7 0 362 389 36 9 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
10226402 10226402 PRJEB28062_P_NODE_111069_length_283_cov_9.195238_g108706_i0 PRJEB28062 111069 283 9.195238 26.02252354 Carlavirus latensdianthi 3427766 Viruses Viruses 52.8 0.026   NTclustered gi|1995060321|gb|MN450069.1| 12164 g108706 i0 100 0.0989399293286219 28 0 10 0 1 28 16 43 Carnation latent virus isolate KL, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
10226880 10226880 PRJEB28062_P_NODE_13949_length_1026_cov_8466.352571_g12121_i0 PRJEB28062 13949 1026 8466.352571 86864.77737846 Potexvirus trifolii 3433859 Viruses Viruses 1600 0   NTclustered gi|1843793423|gb|MN399742.1| 12188 g12121 i0 97.835 20.3723196881092 924 20 90 0 47 970 924 1 White clover mosaic virus isolate Kreis Stormarn_18 RNA replication protein, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds blastn 20902 1600 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii
10228017 10228017 PRJEB28062_P_NODE_65809_length_427_cov_9.985876_g63448_i0 PRJEB28062 65809 427 9.985876 42.63969052 Bromovirus BMV 3427622 Viruses Viruses 721 0   NTclustered gi|107015874|gb|DQ530425.1| 12302 g63448 i0 98.765 35.2014051522248 405 5 95 0 23 427 793 1197 Brome mosaic virus strain Fescue segment RNA3, complete sequence blastn 15031 721 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Bromovirus Bromovirus BMV
10228545 10228545 PRJEB28062_P_NODE_93029_length_335_cov_23.106870_g90667_i0 PRJEB28062 93029 335 23.10687 77.4080145 Galium odoratum potexvirus 2738917 Viruses Viruses 353 7.73e-93   NTclustered gi|1845309154|gb|MN814316.1| 2738917 g90667 i0 88.255 7.98805970149254 298 32 88 1 24 318 2408 2705 Galium odoratum potexvirus strain pt040-lat-5, complete genome blastn 2676 353 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Galium odoratum potexvirus
12777835 12777835 PRJEB28062_P_NODE_19911_length_842_cov_3.814044_g17869_i0 PRJEB28062 19911 842 3.814044 32.11425048 Carlavirus latensdianthi 3427766 Viruses Viruses 56.5 0.007   NTclustered gi|1995060321|gb|MN450069.1| 12164 g17869 i0 96.97 0.176959619952494 33 1 4 0 799 831 44 12 Carnation latent virus isolate KL, complete genome blastn 149 56.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
12779022 12779022 PRJEB28062_P_NODE_7731_length_1419_cov_40.270431_g6311_i0 PRJEB28062 7731 1419 40.270431 571.43741589 Alphacarmovirus 1911599 Viruses Viruses 573 7.229999999999998e-196   NR YP_004191789.1 943272 g6311 i0 70 3.88372093023256 373 112 78.9 0 299 1417 316 688 YP_004191789.1 p87 [Honeysuckle ringspot virus] diamond 5511 578 0.991349480968858 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae Alphacarmovirus Alphacarmovirus lonicerae
14053986 14053986 PRJEB28062_P_NODE_94192_length_332_cov_3.374517_g91830_i0 PRJEB28062 94192 332 3.374517 11.20339644 Tobamovirus tabaci 3432891 Viruses Viruses 569 6.979999999999998e-158   NTclustered gi|2770826564|gb|PQ032045.1| 12242 g91830 i0 99.678 93.6746987951807 311 1 94 0 1 311 1012 702 Tobacco mosaic virus isolate Sru-1, complete genome blastn 31100 569 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci
16602600 16602600 PRJEB28062_P_NODE_93054_length_335_cov_15.270992_g90692_i0 PRJEB28062 93054 335 15.270992 51.1578232 Carlavirus latensdianthi 3427766 Viruses Viruses 56.5 0.002   NTclustered gi|1995060321|gb|MN450069.1| 12164 g90692 i0 96.97 0.0985074626865672 33 1 10 0 303 335 48 16 Carnation latent virus isolate KL, complete genome blastn 33 56.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
20424314 20424314 PRJEB28062_P_NODE_108977_length_289_cov_2.578704_g106614_i0 PRJEB28062 108977 289 2.578704 7.45245456 Potexvirus pepini 3433856 Viruses Viruses 460 3.749999999999999e-125   NTclustered gi|336288971|gb|HQ663890.1| 112229 g106614 i0 97.761 53.8823529411765 268 4 92 1 24 289 1396 1663 Pepino mosaic virus isolate SAR09, complete genome blastn 15572 460 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
20424694 20424694 PRJEB28062_P_NODE_130637_length_241_cov_1.386905_g128273_i0 PRJEB28062 130637 241 1.386905 3.34244105 Carlavirus sigmasolani 3427796 Viruses Viruses 315 2.51e-81   NTclustered gi|913375150|emb|LN851194.1| 12169 g128273 i0 98.333 76.8672199170124 180 2 74 1 45 223 7201 7022 Potato virus S complete genome, isolate Ewa blastn 18525 315 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus sigmasolani
20426318 20426318 PRJEB28062_P_NODE_85117_length_360_cov_93.954704_g82755_i0 PRJEB28062 85117 360 93.954704 338.2369344 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.009   NTclustered gi|1995060321|gb|MN450069.1| 12164 g82755 i0 100 0.391666666666667 29 0 8 0 9 37 13 41 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
21700800 21700800 PRJEB28062_P_NODE_135058_length_224_cov_22.251656_g132694_i0 PRJEB28062 135058 224 22.251656 49.84370944 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.006   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g132694 i0 94.444 0.285714285714286 36 0 16 2 168 203 34 1 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 64 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
24251374 24251374 PRJEB28062_P_NODE_81780_length_371_cov_4.667785_g79418_i0 PRJEB28062 81780 371 4.667785 17.31748235 Jujube closterovirus 1 3043313 Viruses Viruses 52.8 0.035   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g79418 i0 100 0.0754716981132075 28 0 8 0 344 371 36 9 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
26780084 26780084 PRJEB28062_P_NODE_129221_length_243_cov_1.788235_g126857_i0 PRJEB28062 129221 243 1.788235 4.34541105 Pleurotus pulmonarius virga-like virus 1 3231516 Viruses Viruses 55.1 1.64e-6   NR XCI72490.1 3231516 g126857 i0 40 0.925925925925926 75 42 92.6 1 18 242 325 396 XCI72490.1 methyltransferase [Pleurotus pulmonarius virga-like virus 1] diamond 225 55.1 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae   Pleurotus pulmonarius virga-like virus 1
29528036 29528036 PRJEB28062_P_NODE_85810_length_358_cov_22.459649_g83448_i0 PRJEB28062 85810 358 22.459649 80.40554342 Ripoflin virus 3130381 Viruses Viruses 47 0.00395   NR WZH59543.1 3130381 g83448 i0 30.5 0.879888268156425 105 71 87.2 2 26 337 164 267 WZH59543.1 MAG: hypothetical protein [Ripoflin virus] diamond 315 47 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Ripoflin virus

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;