RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

19 rows where bioproject = "PRJNA690124"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_genus_NTorNR 3

tax_family_NTorNR 3

Category 2

bioproject 1

  • PRJNA690124 · 19 ✖
Link rowid ▼ contig_withLCA_withcluster clusterLCA_curated Category contig_withLCA shortcontigname clusterLCA clusterLCAcurated_contigcount clusterLCAcurated_bioprojectcount clusterLCAcurated_clustercount shortclustername cluster clustersize bioprojectsbycluster bioproject node length coverage rel_abundance taxname_lca_NTorNR taxid_lca_NTorNR taxoncategory_NTorNR taxoncategorysimple_NTorNR bits_NTorNR evalue_NTorNR viruscategory_NTorNR viruscategorysimple_NTorNR analysis_used contig_name lowcoverage_flag target_title_NTorNR target_NTorNR taxid_NTorNR gene_NTorNR allele_NTorNR pident_NTorNR sumperc_cov_NTorNR alnlen_NTorNR mismatch_NTorNR qcov_NTorNR gapopen_NTorNR qstart_NTorNR qend_NTorNR tstart_NTorNR tend_NTorNR sumalnlen_NTorNR maxbits_NTorNR bits_percmax_NTorNR tax_superkingdom_NTorNR tax_clade_NTorNR tax_kingdom_NTorNR tax_phylum_NTorNR tax_class_NTorNR tax_order_NTorNR tax_family_NTorNR tax_genus_NTorNR tax_species_NTorNR classification taxname_lca_NTclustered taxname_lca_NR target_NTclustered taxoncategory_NTclustered taxoncategory_NR taxoncategorysimple_NTclustered taxoncategorysimple_NR bits_NTclustered bits_NR evalue_NTclustered evalue_NR
1897 1897 PRJNA690124_CONTIG_3|Zebrafish_picornavirus_2|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA690124_CONTIG_3|Zebrafish_picornavirus_2 PRJNA690124_CONTIG_3 Zebrafish picornavirus 2 1369 320 1 CLUSTER1_Zebrafish_picornavirus_2|1382|320 PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0|Zebrafish_picornavirus_2|NR|0|NA 1370 320 PRJNA690124 3 7198 46.612912 3355.197406 Zebrafish picornavirus 2 3063761 Viruses Viruses 2839.0 0.0 Zebrafish picornavirus 2 Non-phage NTclustered PRJNA690124_P_NODE_3_length_7198_cov_46.612912_g2_i0   Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds gi|2551699335|gb|OK619588.1| 3063761 g2 i0 95.694 0.666157266 1765 73 67.0 3 1 1764 7091 5329 4795 2839.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 2 Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2 Zebrafish picornavirus 2 Zebrafish picornavirus 2 gi|2551699335|gb|OK619588.1| Viruses Viruses Viruses Viruses 2839.0 2485.0 0.0 0.0
3218 3218 PRJNA690124_CONTIG_2|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA690124_CONTIG_2|Cyprivirus_A PRJNA690124_CONTIG_2 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA690124 2 7254 7.986631 579.3502127 Cyprivirus A 2304617 Viruses Viruses 11845.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA690124_P_NODE_2_length_7254_cov_7.986631_g1_i0   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g1 i0 96.129 3.05707196 7260 275 100.0 4 1 7254 920 8179 22176 11845.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|2500378199|ref|NC_076245.1| Viruses Viruses Viruses Viruses 11845.0 4417.0 0.0 0.0
3239 3239 PRJNA690124_CONTIG_9|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA690124_CONTIG_9|Cyprivirus_A PRJNA690124_CONTIG_9 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA690124 9 5347 6.780812 362.5700176 Cyprivirus A 2304617 Viruses Viruses 8591.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA690124_P_NODE_9_length_5347_cov_6.780812_g1_i1   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g1 i1 95.664 3.002244249 5350 229 100.0 3 1 5347 6269 920 16053 8591.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|2500378199|ref|NC_076245.1| Viruses Viruses Viruses Viruses 8591.0 3305.0 0.0 0.0
3675 3675 PRJNA690124_CONTIG_3546|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA690124_CONTIG_3546|Cyprivirus_A PRJNA690124_CONTIG_3546 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA690124 3546 826 8.289509 68.47134434 Cyprivirus A 2304617 Viruses Viruses 1406.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA690124_P_NODE_3546_length_826_cov_8.289509_g3246_i0   TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome gi|1990739381|tpg|BK011179.1| 2563826 g3246 i0 97.455 2.87409201 825 19 99.0 2 1 824 2 825 2374 1406.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|1990739381|tpg|BK011179.1| Viruses Viruses Viruses Viruses 1406.0 139.0 0.0 6.52e-33
4270 4270 PRJNA690124_CONTIG_48524|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA690124_CONTIG_48524|Cyprivirus_A PRJNA690124_CONTIG_48524 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA690124 48524 248 1.32 3.2736 Cyprivirus A 2304617 Viruses Viruses 418.0 1.9199999999999999e-112 Cyprivirus A Non-phage NTclustered PRJNA690124_P_NODE_48524_length_248_cov_1.320000_g48158_i0   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g48158 i0 97.166 2.987903226 247 7 99.0 0 1 247 6851 7097 741 418.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|2500378199|ref|NC_076245.1| Viruses Viruses Viruses Viruses 418.0 167.0 1.9199999999999999e-112 4.63e-46
4901 4901 PRJNA690124_CONTIG_32634|Carp_edema_virus|CLUSTER1_Carp_edema_virus|632|87 Zebrafish jaw poxvirus Novel PRJNA690124_CONTIG_32634|Carp_edema_virus PRJNA690124_CONTIG_32634 Carp edema virus 4680 143 36 CLUSTER1_Carp_edema_virus|632|87 PRJNA1075480_S_NODE_3_length_24555_cov_43.250551_g1_i0|Carp_edema_virus|NR|0|NA 629 87 PRJNA690124 32634 290 1.520737 4.4101373 Carp edema virus 1653087 Viruses Viruses 137.0 2.0300000000000002e-35 Carp edema virus Non-phage NR PRJNA690124_P_NODE_32634_length_290_cov_1.520737_g32268_i0   BCT22642.1 trimeric virion coat protein [Carp edema virus] BCT22642.1 1653087 g32268 i0 67.7 0.993103448 96 31 99.3 0 288 1 424 519 288 137.0 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus   Carp edema virus     Viruses   Viruses   137.0   2.0300000000000002e-35
6444 6444 PRJNA690124_CONTIG_28350|Carp_edema_virus|CLUSTER5_Carp_edema_virus|282|82 Zebrafish jaw poxvirus Novel PRJNA690124_CONTIG_28350|Carp_edema_virus PRJNA690124_CONTIG_28350 Carp edema virus 4680 143 36 CLUSTER5_Carp_edema_virus|282|82 PRJNA318414_P_NODE_10_length_15674_cov_109.855034_g8_i0|Carp_edema_virus|NR|1.76e-230|NA 266 81 PRJNA690124 28350 310 1.316456 4.0810136 Carp edema virus 1653087 Viruses Viruses 61.2 1.06e-08 Carp edema virus Non-phage NR PRJNA690124_P_NODE_28350_length_310_cov_1.316456_g27984_i0   BCT22707.1 hypothetical protein [Carp edema virus] BCT22707.1 1653087 g27984 i0 35.4 0.958064516 99 61 93.9 3 16 306 63 160 297 61.2 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus   Carp edema virus     Viruses   Viruses   61.2   1.06e-08
7792 7792 PRJNA690124_CONTIG_15346|Carp_edema_virus|CLUSTER12_Carp_edema_virus|176|54 Zebrafish jaw poxvirus Novel PRJNA690124_CONTIG_15346|Carp_edema_virus PRJNA690124_CONTIG_15346 Carp edema virus 4680 143 36 CLUSTER12_Carp_edema_virus|176|54 PRJNA318414_P_NODE_15_length_10645_cov_116.245761_g12_i0|Carp_edema_virus|NR|2.1e-150|NA 175 54 PRJNA690124 15346 412 1.374631 5.66347972 Carp edema virus 1653087 Viruses Viruses 54.3 2.1e-05 Carp edema virus Non-phage NR PRJNA690124_P_NODE_15346_length_412_cov_1.374631_g14980_i0   BCT22620.1 hypothetical protein [Carp edema virus] BCT22620.1 1653087 g14980 i0 42.1 0.415048544 57 32 40.8 1 11 178 138 194 171 54.3 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus   Carp edema virus     Viruses   Viruses   54.3   2.1e-05
8366 8366 PRJNA690124_CONTIG_1914|ludopivirus_A1|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA690124_CONTIG_1914|ludopivirus_A1 PRJNA690124_CONTIG_1914 Coleura bat picornavirus 89 37 1 CLUSTER1_Coleura_bat_picornavirus|100|37 PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA 93 37 PRJNA690124 1914 1078 2.054726 22.14994628 ludopivirus A1 2079465 Viruses Viruses 65.9 1.68e-07 ludopivirus A1 Non-phage NR PRJNA690124_P_NODE_1914_length_1078_cov_2.054726_g1685_i0   QUS52515.1 polyprotein [ludopivirus A1] QUS52515.1 2079465 g1685 i0 27.8 1.486085343 216 123 57.3 9 620 3 1826 2018 1602 65.9 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Ludopivirus Ludopivirus agrewhifrogo Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   ludopivirus A1     Viruses   Viruses   65.9   1.68e-07
8376 8376 PRJNA690124_CONTIG_4675|Picornaviridae_sp.|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA690124_CONTIG_4675|Picornaviridae_sp. PRJNA690124_CONTIG_4675 Coleura bat picornavirus 89 37 1 CLUSTER1_Coleura_bat_picornavirus|100|37 PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA 93 37 PRJNA690124 4675 732 2.883156 21.10470192 Picornaviridae sp. 1530251 Viruses Viruses 168.0 1.65e-43 Picornaviridae sp. Non-phage NR PRJNA690124_P_NODE_4675_length_732_cov_2.883156_g4340_i0   QKE55033.1 MAG: polyprotein [Picornaviridae sp.] QKE55033.1 1530251 g4340 i0 49.4 0.721311475 176 87 71.3 2 2 523 2141 2316 528 168.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp. Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   Picornaviridae sp.     Viruses   Viruses   168.0   1.65e-43
8388 8388 PRJNA690124_CONTIG_9097|Mink_kobuvirus|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA690124_CONTIG_9097|Mink_kobuvirus PRJNA690124_CONTIG_9097 Coleura bat picornavirus 89 37 1 CLUSTER1_Coleura_bat_picornavirus|100|37 PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA 93 37 PRJNA690124 9097 532 1.392157 7.40627524 Mink kobuvirus 3242813 Viruses Viruses 65.5 9.69e-09 Mink kobuvirus Non-phage NR PRJNA690124_P_NODE_9097_length_532_cov_1.392157_g8732_i0   XEQ84337.1 polyprotein, partial [Mink kobuvirus] XEQ84337.1 3242813 g8732 i0 33.1 1.398496241 124 73 64.3 2 31 372 332 455 744 65.5 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Mink kobuvirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   Mink kobuvirus     Viruses   Viruses   65.5   9.69e-09
8395 8395 PRJNA690124_CONTIG_17890|Coleura_bat_picornavirus|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA690124_CONTIG_17890|Coleura_bat_picornavirus PRJNA690124_CONTIG_17890 Coleura bat picornavirus 89 37 1 CLUSTER1_Coleura_bat_picornavirus|100|37 PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA 93 37 PRJNA690124 17890 383 1.203226 4.60835558 Coleura bat picornavirus 3141868 Viruses Viruses 126.0 1.07e-30 Coleura bat picornavirus Non-phage NR PRJNA690124_P_NODE_17890_length_383_cov_1.203226_g17524_i0   XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] XBH24011.1 3141868 g17524 i0 54.3 1.989556136 127 51 97.9 5 9 383 1973 2094 762 126.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Coleura bat picornavirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   Coleura bat picornavirus     Viruses   Viruses   126.0   1.07e-30
8406 8406 PRJNA690124_CONTIG_32349|pemapivirus_B1|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA690124_CONTIG_32349|pemapivirus_B1 PRJNA690124_CONTIG_32349 Coleura bat picornavirus 89 37 1 CLUSTER1_Coleura_bat_picornavirus|100|37 PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA 93 37 PRJNA690124 32349 291 1.711009 4.97903619 pemapivirus B1 2870355 Viruses Viruses 118.0 2.12e-28 pemapivirus B1 Non-phage NR PRJNA690124_P_NODE_32349_length_291_cov_1.711009_g31983_i0   YP_010796385.1 polyprotein [pemapivirus B1] YP_010796385.1 2870355 g31983 i0 58.9 0.979381443 95 39 97.9 0 290 6 2431 2525 285 118.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Pemapivirus Pemapivirus brohepotu Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   pemapivirus B1     Viruses   Viruses   118.0   2.12e-28
10184 10184 PRJNA690124_CONTIG_3829|Siamese_algae-eater_influenza-like_virus|CLUSTER1_Siamese_algae-eater_influenza-like_virus|4|3 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_3829|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_3829 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER1_Siamese_algae-eater_influenza-like_virus|4|3 PRJNA690124_P_NODE_3829_length_802_cov_1.341564_g3518_i0|Siamese_algae-eater_influenza-like_virus|NR|2.39e-35|NA 4 3 PRJNA690124 3829 802 1.341564 10.75934328 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 137.0 2.3900000000000002e-35 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_3829_length_802_cov_1.341564_g3518_i0   QOE76807.1 matrix protein [Siamese algae-eater influenza-like virus] QOE76807.1 2777035 g3518 i0 41.0 0.703241895 188 109 70.0 2 3 563 68 254 564 137.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   137.0   2.3900000000000002e-35
10263 10263 PRJNA690124_CONTIG_15411|Siamese_algae-eater_influenza-like_virus|CLUSTER2_Siamese_algae-eater_influenza-like_virus|2|2 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_15411|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_15411 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER2_Siamese_algae-eater_influenza-like_virus|2|2 PRJNA690124_P_NODE_15411_length_411_cov_1.834320_g15045_i0|Siamese_algae-eater_influenza-like_virus|NR|5.91e-24|NA 2 2 PRJNA690124 15411 411 1.83432 7.5390552 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 107.0 5.91e-24 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_15411_length_411_cov_1.834320_g15045_i0   QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus] QOE76804.1 2777035 g15045 i0 38.5 0.98540146 135 82 98.5 1 5 409 404 537 405 107.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   107.0   5.91e-24
10271 10271 PRJNA690124_CONTIG_35319|Siamese_algae-eater_influenza-like_virus|CLUSTER4_Siamese_algae-eater_influenza-like_virus|2|2 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_35319|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_35319 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER4_Siamese_algae-eater_influenza-like_virus|2|2 PRJNA690124_P_NODE_35319_length_280_cov_0.956522_g34953_i0|Siamese_algae-eater_influenza-like_virus|NR|4.83e-19|NA 2 2 PRJNA690124 35319 280 0.956522 2.6782616 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 91.3 4.83e-19 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_35319_length_280_cov_0.956522_g34953_i0   QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus] QOE76804.1 2777035 g34953 i0 48.9 0.964285714 90 46 96.4 0 280 11 317 406 270 91.3 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   91.3   4.83e-19
10418 10418 PRJNA690124_CONTIG_20269|Siamese_algae-eater_influenza-like_virus|CLUSTER5_Siamese_algae-eater_influenza-like_virus|1|1 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_20269|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_20269 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER5_Siamese_algae-eater_influenza-like_virus|1|1 PRJNA690124_P_NODE_20269_length_361_cov_1.222222_g19903_i0|Siamese_algae-eater_influenza-like_virus|NR|9.69e-34|NA 1 1 PRJNA690124 20269 361 1.222222 4.41222142 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 133.0 9.689999999999999e-34 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_20269_length_361_cov_1.222222_g19903_i0   QOE76806.1 hemagglutinin [Siamese algae-eater influenza-like virus] QOE76806.1 2777035 g19903 i0 58.5 1.022160665 123 44 99.7 3 361 2 275 393 369 133.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   133.0   9.689999999999999e-34
10447 10447 PRJNA690124_CONTIG_34936|Siamese_algae-eater_influenza-like_virus|CLUSTER7_Siamese_algae-eater_influenza-like_virus|1|1 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_34936|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_34936 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER7_Siamese_algae-eater_influenza-like_virus|1|1 PRJNA690124_P_NODE_34936_length_281_cov_1.495192_g34570_i0|Siamese_algae-eater_influenza-like_virus|NR|2e-14|NA 1 1 PRJNA690124 34936 281 1.495192 4.20148952 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 78.2 2e-14 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_34936_length_281_cov_1.495192_g34570_i0   QOE76806.1 hemagglutinin [Siamese algae-eater influenza-like virus] QOE76806.1 2777035 g34570 i0 37.6 0.992882562 93 58 99.3 0 2 280 47 139 279 78.2 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   78.2   2e-14
10452 10452 PRJNA690124_CONTIG_37976|Siamese_algae-eater_influenza-like_virus|CLUSTER8_Siamese_algae-eater_influenza-like_virus|1|1 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_37976|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_37976 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER8_Siamese_algae-eater_influenza-like_virus|1|1 PRJNA690124_P_NODE_37976_length_270_cov_1.187817_g37610_i0|Siamese_algae-eater_influenza-like_virus|NR|1.29e-14|NA 1 1 PRJNA690124 37976 270 1.187817 3.2071059 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 78.6 1.29e-14 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_37976_length_270_cov_1.187817_g37610_i0   QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus] QOE76804.1 2777035 g37610 i0 55.9 0.755555556 68 30 75.6 0 249 46 55 122 204 78.6 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   78.6   1.29e-14

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE viruses_fish_associated_curated(contig_withLCA_withcluster VARCHAR, clusterLCA_curated VARCHAR, Category VARCHAR, contig_withLCA VARCHAR, shortcontigname VARCHAR, clusterLCA VARCHAR, clusterLCAcurated_contigcount BIGINT, clusterLCAcurated_bioprojectcount BIGINT, clusterLCAcurated_clustercount BIGINT, shortclustername VARCHAR, "cluster" VARCHAR, clustersize BIGINT, bioprojectsbycluster BIGINT, bioproject VARCHAR, node BIGINT, length BIGINT, coverage DOUBLE, rel_abundance DOUBLE, taxname_lca_NTorNR VARCHAR, taxid_lca_NTorNR BIGINT, taxoncategory_NTorNR VARCHAR, taxoncategorysimple_NTorNR VARCHAR, bits_NTorNR DOUBLE, evalue_NTorNR DOUBLE, viruscategory_NTorNR VARCHAR, viruscategorysimple_NTorNR VARCHAR, analysis_used VARCHAR, contig_name VARCHAR, lowcoverage_flag DOUBLE, target_title_NTorNR VARCHAR, target_NTorNR VARCHAR, taxid_NTorNR BIGINT, gene_NTorNR VARCHAR, allele_NTorNR VARCHAR, pident_NTorNR DOUBLE, sumperc_cov_NTorNR DOUBLE, alnlen_NTorNR BIGINT, mismatch_NTorNR BIGINT, qcov_NTorNR DOUBLE, gapopen_NTorNR BIGINT, qstart_NTorNR BIGINT, qend_NTorNR BIGINT, tstart_NTorNR BIGINT, tend_NTorNR BIGINT, sumalnlen_NTorNR BIGINT, maxbits_NTorNR DOUBLE, bits_percmax_NTorNR DOUBLE, tax_superkingdom_NTorNR VARCHAR, tax_clade_NTorNR VARCHAR, tax_kingdom_NTorNR VARCHAR, tax_phylum_NTorNR VARCHAR, tax_class_NTorNR VARCHAR, tax_order_NTorNR VARCHAR, tax_family_NTorNR VARCHAR, tax_genus_NTorNR VARCHAR, tax_species_NTorNR VARCHAR, classification VARCHAR, taxname_lca_NTclustered VARCHAR, taxname_lca_NR VARCHAR, target_NTclustered VARCHAR, taxoncategory_NTclustered VARCHAR, taxoncategory_NR VARCHAR, taxoncategorysimple_NTclustered VARCHAR, taxoncategorysimple_NR VARCHAR, bits_NTclustered DOUBLE, bits_NR DOUBLE, evalue_NTclustered DOUBLE, evalue_NR DOUBLE);;
CREATE INDEX idx_vfac_bioproject ON viruses_fish_associated_curated(bioproject);;
CREATE INDEX idx_vfac_category ON viruses_fish_associated_curated(Category);;
CREATE INDEX idx_vfac_clusterLCA_curated ON viruses_fish_associated_curated(clusterLCA_curated);;
CREATE INDEX idx_vfac_tax_family ON viruses_fish_associated_curated(tax_family_NTorNR);;
CREATE INDEX idx_vfac_tax_genus ON viruses_fish_associated_curated(tax_genus_NTorNR);;
CREATE INDEX idx_vfac_tax_species ON viruses_fish_associated_curated(tax_species_NTorNR);;