RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA1248424", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 20 ✖

tax_kingdom 1

  • Orthornavirae · 20 ✖

bioproject 1

  • PRJNA1248424 · 20 ✖

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
352608 352608 PRJNA1248424_P_NODE_47901_length_321_cov_12.342742_g41834_i0 PRJNA1248424 47901 321 12.342742 39.62020182 Fabavirus betaviciae 3047702 Viruses Viruses 261 4.6e-65   NTclustered gi|2314647701|gb|ON241335.1| 76875 g41834 i0 98 0.928348909657321 150 3 93 0 1 150 884 735 Broad bean wilt virus 2 segment RNA2 polyprotein gene, complete cds blastn 298 261 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
2903679 2903679 PRJNA1248424_P_NODE_53483_length_292_cov_6.538813_g47415_i0 PRJNA1248424 53483 292 6.538813 19.09333396 Fabavirus betaviciae 3047702 Viruses Viruses 494 3.74e-135   NTclustered gi|2314647695|gb|ON241332.1| 76875 g47415 i0 97.26 46.986301369863 292 6 99 2 3 292 238 529 Broad bean wilt virus 2 segment RNA2 polyprotein gene, complete cds blastn 13720 494 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
4179800 4179800 PRJNA1248424_P_NODE_38104_length_391_cov_12.352201_g32046_i0 PRJNA1248424 38104 391 12.352201 48.29710591 Fabavirus betaviciae 3047702 Viruses Viruses 651 0   NTclustered gi|2314647701|gb|ON241335.1| 76875 g32046 i0 96.675 1 391 13 100 0 1 391 1689 1299 Broad bean wilt virus 2 segment RNA2 polyprotein gene, complete cds blastn 391 651 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
6730375 6730375 PRJNA1248424_P_NODE_39946_length_374_cov_0.910299_g33886_i0 PRJNA1248424 39946 374 0.910299 3.40451826 Fabavirus betaviciae 3047702 Viruses Viruses 649 0   NTclustered gi|2314647691|gb|ON241330.1| 76875 g33886 i0 98.118 0.994652406417112 372 7 99 0 1 372 5568 5197 Broad bean wilt virus 2 segment RNA1 polyprotein gene, complete cds blastn 372 649 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
6730952 6730952 PRJNA1248424_P_NODE_70646_length_250_cov_0.870056_g64577_i0 PRJNA1248424 70646 250 0.870056 2.17514 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 418 1.9399999999999998e-112   NTclustered gi|2196303930|gb|MZ678981.1| 3003959 g64577 i0 96.8 1 250 8 100 0 1 250 10071 10320 MAG: Picornavirales sp. isolate 10-k141_24627 putative polyprotein gene, complete cds blastn 250 418 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
8005974 8005974 PRJNA1248424_P_NODE_41187_length_364_cov_1.024055_g35126_i0 PRJNA1248424 41187 364 1.024055 3.7275602 Fabavirus betaviciae 3047702 Viruses Viruses 603 7.599999999999998e-168   NTclustered gi|2314647687|gb|ON241328.1| 76875 g35126 i0 96.694 25.489010989011 363 11 99 1 1 363 4467 4828 Broad bean wilt virus 2 segment RNA1 polyprotein gene, complete cds blastn 9278 603 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
8006102 8006102 PRJNA1248424_P_NODE_47347_length_322_cov_14.590361_g41280_i0 PRJNA1248424 47347 322 14.590361 46.98096242 Fabavirus betaviciae 3047702 Viruses Viruses 272 2.1299999999999993e-68   NTclustered gi|2314647691|gb|ON241330.1| 76875 g41280 i0 99.333 3.01552795031056 150 1 93 0 173 322 3162 3311 Broad bean wilt virus 2 segment RNA1 polyprotein gene, complete cds blastn 971 272 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
9281083 9281083 PRJNA1248424_P_NODE_52128_length_298_cov_10.808889_g46060_i0 PRJNA1248424 52128 298 10.808889 32.21048922 Fabavirus betaviciae 3047702 Viruses Viruses 401 2.3899999999999992e-107   NTclustered gi|2314647691|gb|ON241330.1| 76875 g46060 i0 90.373 1.08053691275168 322 7 100 5 1 298 3870 4191 Broad bean wilt virus 2 segment RNA1 polyprotein gene, complete cds blastn 322 401 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
10556317 10556317 PRJNA1248424_P_NODE_23089_length_721_cov_8.563272_g17286_i0 PRJNA1248424 23089 721 8.563272 61.74119112 Fabavirus betaviciae 3047702 Viruses Viruses 880 0   NTclustered gi|2314647701|gb|ON241335.1| 76875 g17286 i0 95.691 0.986130374479889 557 7 96 1 1 540 1687 2243 Broad bean wilt virus 2 segment RNA2 polyprotein gene, complete cds blastn 711 880 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
10556823 10556823 PRJNA1248424_P_NODE_44749_length_338_cov_13.864151_g38685_i0 PRJNA1248424 44749 338 13.864151 46.86083038 Fabavirus betaviciae 3047702 Viruses Viruses 278 4.84e-70   NTclustered gi|2314647701|gb|ON241335.1| 76875 g38685 i0 97.531 36.8698224852071 162 4 92 0 1 162 21 182 Broad bean wilt virus 2 segment RNA2 polyprotein gene, complete cds blastn 12462 278 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
14381498 14381498 PRJNA1248424_P_NODE_28392_length_550_cov_15.723270_g22374_i0 PRJNA1248424 28392 550 15.72327 86.477985 Fabavirus betaviciae 3047702 Viruses Viruses 941 0   NTclustered gi|2314647701|gb|ON241335.1| 76875 g22374 i0 97.632 5.65454545454545 549 12 99 1 1 548 2795 3343 Broad bean wilt virus 2 segment RNA2 polyprotein gene, complete cds blastn 3110 941 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
15655574 15655574 PRJNA1248424_P_NODE_39713_length_376_cov_1.270627_g33653_i0 PRJNA1248424 39713 376 1.270627 4.77755752 Zebrafish picornavirus 1 2304617 Viruses Viruses 573 6.179999999999999e-159   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g33653 i0 94.149 3.00265957446809 376 22 100 0 1 376 5397 5022 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1129 573 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
16930155 16930155 PRJNA1248424_P_NODE_56534_length_284_cov_2.061611_g50466_i0 PRJNA1248424 56534 284 2.061611 5.85497524 Bemisia tabaci dicistro-like virus 1 2840019 Viruses Viruses 481 2.82e-131   NTclustered gi|2047377804|gb|MW256674.1| 2840019 g50466 i0 97.183 2.00352112676056 284 8 100 0 1 284 5144 5427 Bemisia tabaci dicistro-like virus 1 isolate CAU-Q1 ORF1 gene, complete cds; and ORF2 gene, partial cds blastn 569 481 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Bemisia tabaci dicistro-like virus 1
18204236 18204236 PRJNA1248424_P_NODE_36035_length_414_cov_15.234604_g29979_i0 PRJNA1248424 36035 414 15.234604 63.07126056 Fabavirus betaviciae 3047702 Viruses Viruses 416 1.23e-111   NTclustered gi|2314647689|gb|ON241329.1| 76875 g29979 i0 98.312 3.85507246376812 237 4 97 0 1 237 5274 5510 Broad bean wilt virus 2 segment RNA1 polyprotein gene, complete cds blastn 1596 416 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
19478598 19478598 PRJNA1248424_P_NODE_35636_length_419_cov_5.606936_g29580_i0 PRJNA1248424 35636 419 5.606936 23.49306184 Fabavirus betaviciae 3047702 Viruses Viruses 446 1.5799999999999998e-120   NTclustered gi|2314647699|gb|ON241334.1| 76875 g29580 i0 99.19 32.7374701670644 247 2 95 0 1 247 1277 1523 Broad bean wilt virus 2 segment RNA2 polyprotein gene, complete cds blastn 13717 446 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
19479426 19479426 PRJNA1248424_P_NODE_79076_length_242_cov_0.911243_g73007_i0 PRJNA1248424 79076 242 0.911243 2.20520806 Bemisia tabaci dicistro-like virus 1 2840019 Viruses Viruses 403 5.22e-108   NTclustered gi|2047377804|gb|MW256674.1| 2840019 g73007 i0 96.694 2 242 8 100 0 1 242 4859 5100 Bemisia tabaci dicistro-like virus 1 isolate CAU-Q1 ORF1 gene, complete cds; and ORF2 gene, partial cds blastn 484 403 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Bemisia tabaci dicistro-like virus 1
23305224 23305224 PRJNA1248424_P_NODE_54619_length_289_cov_1.351852_g48551_i0 PRJNA1248424 54619 289 1.351852 3.90685228 Fabavirus betaviciae 3047702 Viruses Viruses 501 2.21e-137   NTclustered gi|2314647701|gb|ON241335.1| 76875 g48551 i0 97.924 1 289 6 100 0 1 289 1174 886 Broad bean wilt virus 2 segment RNA2 polyprotein gene, complete cds blastn 289 501 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
27326512 27326512 PRJNA1248424_P_NODE_3423_length_3237_cov_12.444690_g2572_i0 PRJNA1248424 3423 3237 12.44469 402.8346153 brine shrimp partitivirus 1 2900392 Viruses Viruses 536 9.359999999999997e-178   NR UNI73932.1 2900392 g2572 i0 59.7 0.833178869323448 432 168 40 1 2722 1427 1 426 UNI73932.1 MAG: coat protein [brine shrimp partitivirus 1] diamond 2697 536 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   brine shrimp partitivirus 1
29063238 29063238 PRJNA1248424_P_NODE_58008_length_281_cov_1.052885_g51940_i0 PRJNA1248424 58008 281 1.052885 2.95860685 Bemisia tabaci dicistro-like virus 1 2840019 Viruses Viruses 115 2.1900000000000003e-27   NR QWC36477.1 2840019 g51940 i0 88.1 0.629893238434164 59 7 63 0 261 85 823 881 QWC36477.1 ORF2, partial [Bemisia tabaci dicistro-like virus 1] diamond 177 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Bemisia tabaci dicistro-like virus 1
29536716 29536716 PRJNA1248424_P_NODE_46990_length_325_cov_1.035714_g40923_i0 PRJNA1248424 46990 325 1.035714 3.3660705 Cinnamomum chago deltapartitivirus 1 2765856 Viruses Viruses 182 5.88e-53   NR DAF42460.1 2765856 g40923 i0 73.1 2.99076923076923 108 29 99.7 0 325 2 327 434 DAF42460.1 TPA_exp: RNA-dependent RNA polymerase [Cinnamomum chago deltapartitivirus 1] diamond 972 182 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Deltapartitivirus Cinnamomum chago deltapartitivirus 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);;