RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA812715" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA812715 · 16 ✖

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
9740699 9740699 PRJNA812715_P_NODE_21628_length_716_cov_2.356143_g19969_i0 PRJNA812715 21628 716 2.356143 16.86998388 Zebrafish picornavirus 1 2304617 Viruses Viruses 1040 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g19969 i0 94.51 2.94972067039106 674 37 100 0 43 716 1187 1860 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2112 1040 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9740721 9740721 PRJNA812715_P_NODE_22288_length_699_cov_2.416933_g20613_i0 PRJNA812715 22288 699 2.416933 16.89436167 Zebrafish picornavirus 1 2304617 Viruses Viruses 1221 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g20613 i0 98.281 2.98855507868383 698 11 99 1 1 697 886 189 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 2089 1221 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9741033 9741033 PRJNA812715_P_NODE_31628_length_531_cov_2.587336_g29857_i0 PRJNA812715 31628 531 2.587336 13.73875416 Zebrafish picornavirus 1 2304617 Viruses Viruses 870 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g29857 i0 96.234 3 531 20 100 0 1 531 1609 2139 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1593 870 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9741914 9741914 PRJNA812715_P_NODE_59248_length_341_cov_2.641791_g57449_i0 PRJNA812715 59248 341 2.641791 9.00850731 Zebrafish picornavirus 1 2304617 Viruses Viruses 547 3.3699999999999985e-151   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g57449 i0 95.614 3 342 13 100 2 1 341 2520 2860 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1023 547 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14839873 14839873 PRJNA812715_P_NODE_103332_length_250_cov_1.514124_g101531_i0 PRJNA812715 103332 250 1.514124 3.78531 Picornaviridae sp. 1530251 Viruses Viruses 261 3.4600000000000002e-65   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g101531 i0 87.892 0.892 223 25 88 1 1 221 3602 3380 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 223 261 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
22489311 22489311 PRJNA812715_P_NODE_1838_length_3068_cov_5.371953_g238_i2 PRJNA812715 1838 3068 5.371953 164.81151804 Zebrafish picornavirus 1 2304617 Viruses Viruses 4809 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g238 i2 94.956 3.00456323337679 3073 148 100 7 1 3068 2185 5255 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 9218 4809 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
22489574 22489574 PRJNA812715_P_NODE_258_length_5788_cov_9.986877_g238_i0 PRJNA812715 258 5788 9.986877 578.04044076 Zebrafish picornavirus 1 2304617 Viruses Viruses 9575 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g238 i0 96.514 3.00259156876296 5795 194 100 6 1 5788 7978 2185 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 17379 9575 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23764537 23764537 PRJNA812715_P_NODE_114679_length_244_cov_1.801170_g112878_i0 PRJNA812715 114679 244 1.80117 4.3948548 Zebrafish picornavirus 1 2304617 Viruses Viruses 385 1.91e-102   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g112878 i0 95.082 3 244 12 100 0 1 244 2664 2907 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 732 385 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23765407 23765407 PRJNA812715_P_NODE_30099_length_552_cov_1.887265_g28336_i0 PRJNA812715 30099 552 1.887265 10.4177028 Zebrafish picornavirus 1 2304617 Viruses Viruses 915 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g28336 i0 96.558 2.9981884057971 552 19 100 0 1 552 906 1457 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1655 915 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23765529 23765529 PRJNA812715_P_NODE_339_length_5280_cov_8.793547_g238_i1 PRJNA812715 339 5280 8.793547 464.2992816 Zebrafish picornavirus 1 2304617 Viruses Viruses 8660 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g238 i1 96.255 3.00284090909091 5287 190 100 6 1 5280 7470 2185 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 15855 8660 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23766290 23766290 PRJNA812715_P_NODE_57019_length_350_cov_1.509025_g55220_i0 PRJNA812715 57019 350 1.509025 5.2815875 Zebrafish picornavirus 1 2304617 Viruses Viruses 592 1.5799999999999996e-164   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g55220 i0 97.143 2.99428571428571 350 10 100 0 1 350 1050 1399 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1048 592 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
26737346 26737346 PRJNA812715_P_NODE_112481_length_245_cov_2.627907_g110680_i0 PRJNA812715 112481 245 2.627907 6.43837215 Qianjiang picobirna-like virus 2 3348870 Viruses Viruses 51.2 2.56e-5   NR XHA87591.1 3348870 g110680 i0 47.3 0.673469387755102 55 21 57.6 1 2 142 108 162 XHA87591.1 MAG: hypothetical protein [Qianjiang picobirna-like virus 2] diamond 165 51.2 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Picobirnaviridae   Qianjiang picobirna-like virus 2
27411003 27411003 PRJNA812715_P_NODE_13263_length_1044_cov_2.147271_g11956_i0 PRJNA812715 13263 1044 2.147271 22.41750924 Viruses 10239 Viruses Viruses 362 8.71e-114   NR XCM68360.1 1955153 g11956 i0 57.4 2.50574712643678 291 124 83.6 0 4 876 630 920 XCM68360.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 2616 362 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
28065011 28065011 PRJNA812715_P_NODE_29065_length_567_cov_1.838057_g27306_i0 PRJNA812715 29065 567 1.838057 10.42178319 Chemarfal virus 126 3062881 Viruses Viruses 110 4.2999999999999996e-24   NR WPR17951.1 3062881 g27306 i0 45.1 1.94708994708995 122 65 64.6 1 368 3 1353 1472 WPR17951.1 MAG: RNA-dependent RNA polymerase [Chemarfal virus 126] diamond 1104 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 126
28601936 28601936 PRJNA812715_P_NODE_95807_length_259_cov_2.387097_g94006_i0 PRJNA812715 95807 259 2.387097 6.18258123 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 108 4.44e-25   NR QDH87657.1 3003959 g94006 i0 62.5 1.01930501930502 88 31 99.6 2 258 1 583 670 QDH87657.1 MAG: hypothetical protein H4Rhizo4411_000001 [Picornavirales sp.] diamond 264 108 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32835415 32835415 PRJNA812715_P_NODE_54560_length_360_cov_2.675958_g52761_i0 PRJNA812715 54560 360 2.675958 9.6334488 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 135 5.96e-34   NR XNT20716.1 3003959 g52761 i0 53.4 1.975 118 54 97.5 1 351 1 429 546 XNT20716.1 MAG: RNA-dependent RNA polymerase, partial [Picornavirales sp.] diamond 711 135 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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