RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA611476 · 18 ✖

analysis 1

  • blastn · 18 ✖

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
589730 589730 PRJNA611476_P_NODE_601_length_2856_cov_7.490478_g341_i0 PRJNA611476 601 2856 7.490478 213.92805168 Cheravirus mali 3047371 Viruses Viruses 2508 0   NTclustered gi|20451026|ref|NC_003788.1| 101688 g341 i0 82.653 1.89040616246499 2865 466 99 27 8 2855 3384 534 Apple latent spherical virus segment 2, complete sequence blastn 5399 2508 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
1865011 1865011 PRJNA611476_P_NODE_13722_length_530_cov_1.439825_g12932_i0 PRJNA611476 13722 530 1.439825 7.6310725 Cheravirus avii 3047742 Viruses Viruses 372 3.52e-98   NTclustered gi|52093349|ref|NC_006271.1| 202566 g12932 i0 79.922 2.90377358490566 513 97 96 6 4 513 3093 2584 Cherry rasp leaf virus, complete genome blastn 1539 372 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus avii
3140669 3140669 PRJNA611476_P_NODE_6283_length_771_cov_3.117479_g5532_i0 PRJNA611476 6283 771 3.117479 24.03576309 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 1290 0   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g5532 i0 97.365 1.97665369649805 759 18 98 1 12 770 7789 7033 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 1524 1290 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
4417494 4417494 PRJNA611476_P_NODE_7504_length_708_cov_0.968504_g6735_i0 PRJNA611476 7504 708 0.968504 6.85700832 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 1297 0   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g6735 i0 99.718 1 708 2 100 0 1 708 4963 5670 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 708 1297 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
6967836 6967836 PRJNA611476_P_NODE_42566_length_329_cov_1.203125_g41775_i0 PRJNA611476 42566 329 1.203125 3.95828125 Cheravirus mali 3047371 Viruses Viruses 409 1.5899999999999998e-109   NTclustered gi|20451026|ref|NC_003788.1| 101688 g41775 i0 89.058 1 329 36 100 0 1 329 2566 2894 Apple latent spherical virus segment 2, complete sequence blastn 329 409 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
6968022 6968022 PRJNA611476_P_NODE_55406_length_294_cov_1.384615_g54615_i0 PRJNA611476 55406 294 1.384615 4.0707680999999996 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 492 1.36e-134   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g54615 i0 96.928 0.996598639455782 293 9 99 0 2 294 3240 3532 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 293 492 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
9517267 9517267 PRJNA611476_P_NODE_110588_length_243_cov_0.905882_g109797_i0 PRJNA611476 110588 243 0.905882 2.20129326 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 388 1.47e-103   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g109797 i0 95.473 1 243 11 100 0 1 243 2455 2213 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 243 388 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
10793339 10793339 PRJNA611476_P_NODE_17689_length_470_cov_1.914358_g16899_i0 PRJNA611476 17689 470 1.914358 8.9974826 Picornaviridae sp. 1530251 Viruses Viruses 531 4.8099999999999985e-146   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g16899 i0 87.049 1.00212765957447 471 59 100 2 1 470 3726 3257 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 471 531 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
10793354 10793354 PRJNA611476_P_NODE_18509_length_461_cov_1.675258_g17719_i0 PRJNA611476 18509 461 1.675258 7.72293938 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 802 0   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g17719 i0 98.048 1 461 9 100 0 1 461 4736 4276 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 461 802 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
10793645 10793645 PRJNA611476_P_NODE_389_length_4006_cov_5.302059_g201_i0 PRJNA611476 389 4006 5.302059 212.40048354 Cheravirus mali 3047371 Viruses Viruses 3059 0   NTclustered gi|20451024|ref|NC_003787.1| 101688 g201 i0 80.51 1.48077883175237 4038 725 99 48 2 3999 2797 6812 Apple latent spherical virus segment 1, complete sequence blastn 5932 3059 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
13343472 13343472 PRJNA611476_P_NODE_34311_length_357_cov_1.218310_g33520_i0 PRJNA611476 34311 357 1.21831 4.3493667 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 627 4.4199999999999986e-175   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g33520 i0 98.588 2.87675070028011 354 5 99 0 1 354 6603 6956 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 1027 627 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
14617736 14617736 PRJNA611476_P_NODE_1012_length_1980_cov_2.785527_g645_i0 PRJNA611476 1012 1980 2.785527 55.1534346 Picornaviridae sp. 1530251 Viruses Viruses 1561 0   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g645 i0 80.976 1.00353535353535 1987 362 100 15 1 1980 7739 5762 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 1987 1561 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
14618127 14618127 PRJNA611476_P_NODE_192_length_7213_cov_49.534594_g95_i0 PRJNA611476 192 7213 49.534594 3572.93026522 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2505 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g95 i0 92.036 0.651046721197837 1783 137 65 5 5426 7206 5329 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 4696 2505 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15893049 15893049 PRJNA611476_P_NODE_85713_length_249_cov_1.147727_g84922_i0 PRJNA611476 85713 249 1.147727 2.85784023 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 438 1.4799999999999996e-118   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g84922 i0 98.394 1 249 4 100 0 1 249 3920 4168 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 249 438 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
18441182 18441182 PRJNA611476_P_NODE_17475_length_473_cov_1.500000_g16685_i0 PRJNA611476 17475 473 1.5 7.095 Cheravirus ribis 3047783 Viruses Viruses 398 5.13e-106   NTclustered gi|2571475827|gb|OR096292.1| 1476584 g16685 i0 82.303 0.99154334038055 469 73 98 8 10 473 799 336 Currant latent virus isolate YWDi segment 1 polyprotein gene, complete cds blastn 469 398 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
21549900 21549900 PRJNA611476_P_NODE_50177_length_307_cov_1.786325_g49386_i0 PRJNA611476 50177 307 1.786325 5.48401775 Cripavirus 144051 Viruses Viruses 455 1.87e-123   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g49386 i0 93.464 5.8599348534202 306 20 99 0 2 307 8459 8764 Bactrocera dorsalis cripavirus, complete genome blastn 1799 457 0.99562363238512 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus
23542498 23542498 PRJNA611476_P_NODE_84139_length_250_cov_0.870056_g83348_i0 PRJNA611476 84139 250 0.870056 2.17514 Potyvirus halapensis 3240535 Viruses Viruses 390 4.22e-104   NTclustered gi|2699880115|gb|PP480666.1| 31742 g83348 i0 94.821 14.016 251 12 100 1 1 250 9738 9488 Johnsongrass mosaic virus isolate Santa_Ana-2021-JgM1 polyprotein gene, complete cds blastn 3504 390 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus halapensis
24815517 24815517 PRJNA611476_P_NODE_25240_length_403_cov_1.042424_g24449_i0 PRJNA611476 25240 403 1.042424 4.20096872 Zebrafish picornavirus 1 2304617 Viruses Viruses 651 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g24449 i0 95.782 3.00496277915633 403 17 100 0 1 403 5602 5200 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1211 651 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1

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