RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

19 rows where Category = "Known" and tax_genus_NTorNR = "Isavirus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

tax_genus_NTorNR 1

  • Isavirus · 19 ✖

tax_family_NTorNR 1

clusterLCA_curated 1

bioproject 1

Category 1

  • Known · 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
10114 10114 PRJNA974396_CONTIG_1895|Isavirus_salaris|CLUSTER1_Isavirus|7|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_1895|Isavirus_salaris PRJNA974396_CONTIG_1895 Isavirus 19 1 8 CLUSTER1_Isavirus|7|1 MN885647_1_Isavirus_salaris_isolate_ISAV_752_segment_1_complete_sequence 7 1 PRJNA974396 1895 511 8.363248 42.73619728 Isavirus salaris 55987 Viruses Viruses 922.0 0.0 Isavirus salaris Non-phage NTclustered PRJNA974396_S_NODE_1895_length_511_cov_8.363248_g1747_i0   Isavirus salaris isolate ISAV_752 segment 1, complete sequence gi|1917254754|gb|MN885647.1| 55987 g1747 i0 99.217 37.78082192 511 4 100.0 0 1 511 2243 1733 19306 922.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus salaris Isavirus gi|1917254754|gb|MN885647.1| Viruses Viruses Viruses Viruses 922.0 289.0 0.0 1.89e-92
10116 10116 PRJNA974396_CONTIG_2015|Isavirus_salaris|CLUSTER1_Isavirus_salaris|7|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_2015|Isavirus_salaris PRJNA974396_CONTIG_2015 Isavirus salaris 19 1 8 CLUSTER1_Isavirus_salaris|7|1 MN885648_1_Isavirus_salaris_isolate_ISAV_752_segment_2_complete_sequence 7 1 PRJNA974396 2015 503 6.236957 31.37189371 Isavirus salaris 55987 Viruses Viruses 900.0 0.0 Isavirus salaris Non-phage NTclustered PRJNA974396_S_NODE_2015_length_503_cov_6.236957_g1866_i0   Isavirus salaris isolate ISAV_752 segment 2, complete sequence gi|1917255071|gb|MN885648.1| 55987 g1866 i0 99.004 51.72962227 502 5 99.0 0 2 503 2235 1734 26020 900.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus salaris Isavirus gi|1917255071|gb|MN885648.1| Viruses Viruses Viruses Viruses 900.0 276.0 0.0 6.54e-92
10118 10118 PRJNA974396_CONTIG_2904|Isavirus|CLUSTER1_Isavirus|7|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_2904|Isavirus PRJNA974396_CONTIG_2904 Isavirus 19 1 8 CLUSTER1_Isavirus|7|1 MN885647_1_Isavirus_salaris_isolate_ISAV_752_segment_1_complete_sequence 7 1 PRJNA974396 2904 451 5.843137 26.35254787 Isavirus 324913 Viruses Viruses 828.0 0.0 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_2904_length_451_cov_5.843137_g2749_i0   Infectious salmon anemia virus isolate ISAV5(96/09/768) PB2 protein (PB2) gene, complete cds gi|110288250|gb|DQ785179.1| 55987 g2749 i0 99.778 37.34368071 451 1 100.0 0 1 451 277 727 16842 828.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Infectious salmon anemia virus gi|110288250|gb|DQ785179.1| Viruses Viruses Viruses Viruses 828.0 293.0 0.0 8.56e-93
10121 10121 PRJNA974396_CONTIG_4380|Isavirus|CLUSTER1_Isavirus|7|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_4380|Isavirus PRJNA974396_CONTIG_4380 Isavirus 19 1 8 CLUSTER1_Isavirus|7|1 MN885647_1_Isavirus_salaris_isolate_ISAV_752_segment_1_complete_sequence 7 1 PRJNA974396 4380 401 4.575419 18.34743019 Isavirus 324913 Viruses Viruses 725.0 0.0 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_4380_length_401_cov_4.575419_g4221_i0   Infectious salmon anemia virus isolate Bremnes 98 segment 1, complete sequence gi|27414136|gb|AY168787.1| 55987 g4221 i0 99.252 37.90773067 401 3 100.0 0 1 401 1481 1081 15201 725.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Isavirus gi|27414136|gb|AY168787.1| Viruses Viruses Viruses Viruses 725.0 271.0 0.0 3.32e-86
10122 10122 PRJNA974396_CONTIG_5013|Isavirus|CLUSTER1_Isavirus_salaris|7|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_5013|Isavirus PRJNA974396_CONTIG_5013 Isavirus salaris 19 1 8 CLUSTER1_Isavirus_salaris|7|1 MN885648_1_Isavirus_salaris_isolate_ISAV_752_segment_2_complete_sequence 7 1 PRJNA974396 5013 386 6.740525 26.0184265 Isavirus 324913 Viruses Viruses 708.0 0.0 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_5013_length_386_cov_6.740525_g4853_i0   Infectious salmon anemia virus segment 2 isolate Gullesfjord/94 polymerase PB1 mRNA, partial cds gi|8102003|gb|AF262396.1|AF262396 55987 g4853 i0 99.741 46.75647668 386 1 100.0 0 1 386 158 543 18048 708.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Isavirus gi|8102003|gb|AF262396.1|AF262396 Viruses Viruses Viruses Viruses 708.0 263.0 0.0 2.06e-86
10134 10134 PRJNA974396_CONTIG_15641|Isavirus_salaris|CLUSTER1_Isavirus_salaris|7|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_15641|Isavirus_salaris PRJNA974396_CONTIG_15641 Isavirus salaris 19 1 8 CLUSTER1_Isavirus_salaris|7|1 MN885648_1_Isavirus_salaris_isolate_ISAV_752_segment_2_complete_sequence 7 1 PRJNA974396 15641 278 4.46383 12.4094474 Isavirus salaris 55987 Viruses Viruses 514.0 2.7199999999999996e-141 Isavirus salaris Non-phage NTclustered PRJNA974396_S_NODE_15641_length_278_cov_4.463830_g15481_i0   Isavirus salaris strain NO/Lofoten/NVI-70-16183/2013 RNA-directed RNA polymerase catalytic subunit (PB1) gene, partial cds gi|2668628004|gb|OQ310918.1| 55987 g15481 i0 100.0 45.82374101 278 0 100.0 0 1 278 1049 772 12739 514.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus salaris Infectious salmon anemia virus gi|2668628004|gb|OQ310918.1| Viruses Viruses Viruses Viruses 514.0 182.0 2.7199999999999996e-141 1.01e-51
10136 10136 PRJNA974396_CONTIG_17764|Isavirus|CLUSTER1_Isavirus_salaris|7|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_17764|Isavirus PRJNA974396_CONTIG_17764 Isavirus salaris 19 1 8 CLUSTER1_Isavirus_salaris|7|1 MN885648_1_Isavirus_salaris_isolate_ISAV_752_segment_2_complete_sequence 7 1 PRJNA974396 17764 267 5.28125 14.1009375 Isavirus 324913 Viruses Viruses 492.0 1.2099999999999999e-134 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_17764_length_267_cov_5.281250_g17604_i0   Isavirus salaris strain NO/Lofoten/NVI-70-16183/2013 RNA-directed RNA polymerase catalytic subunit (PB1) gene, partial cds gi|2668628004|gb|OQ310918.1| 55987 g17604 i0 100.0 45.49438202 266 0 99.0 0 2 267 1612 1347 12147 492.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Infectious salmon anemia virus gi|2668628004|gb|OQ310918.1| Viruses Viruses Viruses Viruses 492.0 180.0 1.2099999999999999e-134 4.6e-51
10138 10138 PRJNA974396_CONTIG_20564|Isavirus|CLUSTER1_Isavirus|7|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_20564|Isavirus PRJNA974396_CONTIG_20564 Isavirus 19 1 8 CLUSTER1_Isavirus|7|1 MN885647_1_Isavirus_salaris_isolate_ISAV_752_segment_1_complete_sequence 7 1 PRJNA974396 20564 255 1.811321 4.61886855 Isavirus 324913 Viruses Viruses 460.0 3.25e-125 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_20564_length_255_cov_1.811321_g20404_i0   Infectious salmon anemia virus isolate Bremnes 98 segment 1, complete sequence gi|27414136|gb|AY168787.1| 55987 g20404 i0 99.216 37.0 255 2 100.0 0 1 255 988 734 9435 460.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Isavirus gi|27414136|gb|AY168787.1| Viruses Viruses Viruses Viruses 460.0 160.0 3.25e-125 1.72e-44
10152 10152 PRJNA974396_CONTIG_688|Isavirus_salaris|CLUSTER2_Isavirus_salaris|6|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_688|Isavirus_salaris PRJNA974396_CONTIG_688 Isavirus salaris 19 1 8 CLUSTER2_Isavirus_salaris|6|1 HQ259673_1_Infectious_salmon_anemia_virus_isolate_Glesvaer_2_90_segment_3_complete_sequence 6 1 PRJNA974396 688 700 4.595129 32.165903 Isavirus salaris 55987 Viruses Viruses 1264.0 0.0 Isavirus salaris Non-phage NTclustered PRJNA974396_S_NODE_688_length_700_cov_4.595129_g586_i0   Infectious salmon anemia virus isolate Glesvaer/2/90 segment 3, complete sequence gi|313754890|gb|HQ259673.1| 55987 g586 i0 99.425 93.6 696 4 99.0 0 5 700 1 696 65520 1264.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus salaris Infectious salmon anemia virus gi|313754890|gb|HQ259673.1| Viruses Viruses Viruses Viruses 1264.0 386.0 0.0 1.2599999999999998e-128
10156 10156 PRJNA974396_CONTIG_4030|Isavirus_salaris|CLUSTER2_Isavirus_salaris|6|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_4030|Isavirus_salaris PRJNA974396_CONTIG_4030 Isavirus salaris 19 1 8 CLUSTER2_Isavirus_salaris|6|1 HQ259673_1_Infectious_salmon_anemia_virus_isolate_Glesvaer_2_90_segment_3_complete_sequence 6 1 PRJNA974396 4030 410 19.414169 79.5980929 Isavirus salaris 55987 Viruses Viruses 726.0 0.0 Isavirus salaris Non-phage NTclustered PRJNA974396_S_NODE_4030_length_410_cov_19.414169_g3871_i0   Isavirus salaris isolate ISAV_752 segment 3, complete sequence gi|1917255340|gb|MN885649.1| 55987 g3871 i0 99.254 73.63658537 402 3 98.0 0 9 410 2032 1631 30191 726.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus salaris Isavirus salaris gi|1917255340|gb|MN885649.1| Viruses Viruses Viruses Viruses 726.0 157.0 0.0 6e-46
10159 10159 PRJNA974396_CONTIG_9562|Isavirus|CLUSTER2_Isavirus_salaris|6|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_9562|Isavirus PRJNA974396_CONTIG_9562 Isavirus salaris 19 1 8 CLUSTER2_Isavirus_salaris|6|1 HQ259673_1_Infectious_salmon_anemia_virus_isolate_Glesvaer_2_90_segment_3_complete_sequence 6 1 PRJNA974396 9562 322 2.236559 7.20171998 Isavirus 324913 Viruses Viruses 595.0 1.11e-165 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_9562_length_322_cov_2.236559_g9402_i0   Infectious salmon anemia virus isolate 901_09 segment 3, complete sequence gi|701668765|gb|KM262774.1| 55987 g9402 i0 100.0 95.99378882 322 0 100.0 0 1 322 1008 687 30910 595.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Infectious salmon anemia virus gi|701668765|gb|KM262774.1| Viruses Viruses Viruses Viruses 595.0 208.0 1.11e-165 7.52e-62
10177 10177 PRJNA974396_CONTIG_109|Isavirus|CLUSTER3_Isavirus_salaris|4|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_109|Isavirus PRJNA974396_CONTIG_109 Isavirus salaris 19 1 8 CLUSTER3_Isavirus_salaris|4|1 HQ259674_1_Infectious_salmon_anemia_virus_isolate_Glesvaer_2_90_segment_4_complete_sequence 4 1 PRJNA974396 109 1177 6.651675 78.29021475 Isavirus 324913 Viruses Viruses 2163.0 0.0 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_109_length_1177_cov_6.651675_g78_i0   Infectious salmon anemia virus isolate ISAV1(96/09/1712) PA protein (PA) gene, complete cds gi|110288326|gb|DQ785217.1| 55987 g78 i0 99.83 99.87170773 1177 2 100.0 0 1 1177 1208 32 117549 2163.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Isavirus gi|110288326|gb|DQ785217.1| Viruses Viruses Viruses Viruses 2163.0 764.0 0.0 1.6099999999999998e-277
10181 10181 PRJNA974396_CONTIG_2387|Isavirus_salaris|CLUSTER3_Isavirus_salaris|4|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_2387|Isavirus_salaris PRJNA974396_CONTIG_2387 Isavirus salaris 19 1 8 CLUSTER3_Isavirus_salaris|4|1 HQ259674_1_Infectious_salmon_anemia_virus_isolate_Glesvaer_2_90_segment_4_complete_sequence 4 1 PRJNA974396 2387 477 9.571429 45.65571633 Isavirus salaris 55987 Viruses Viruses 880.0 0.0 Isavirus salaris Non-phage NTclustered PRJNA974396_S_NODE_2387_length_477_cov_9.571429_g2234_i0   Infectious salmon anemia virus isolate Glesvaer/2/90 segment 4, complete sequence gi|313754892|gb|HQ259674.1| 55987 g2234 i0 100.0 94.81551363 476 0 99.0 0 1 476 1338 1813 45227 880.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus salaris Infectious salmon anemia virus gi|313754892|gb|HQ259674.1| Viruses Viruses Viruses Viruses 880.0 283.0 0.0 6.01e-90
10190 10190 PRJNA974396_CONTIG_7597|Isavirus_salaris|CLUSTER4_Isavirus_salaris|4|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_7597|Isavirus_salaris PRJNA974396_CONTIG_7597 Isavirus salaris 19 1 8 CLUSTER4_Isavirus_salaris|4|1 AF429988_1_Infectious_salmon_anemia_virus_isolate_Scotland_390_98_segment_5_putative_acetylesterase_P3_gene_complete_cds 4 1 PRJNA974396 7597 344 2.159468 7.42856992 Isavirus salaris 55987 Viruses Viruses 636.0 7.06e-178 Isavirus salaris Non-phage NTclustered PRJNA974396_S_NODE_7597_length_344_cov_2.159468_g7437_i0   Isavirus salaris isolate SCO/4750/09 fusion protein gene, partial cds gi|1515565723|gb|MH708661.1| 55987 g7437 i0 100.0 99.97674419 344 0 100.0 0 1 344 153 496 34392 636.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus salaris Isavirus gi|1515565723|gb|MH708661.1| Viruses Viruses Viruses Viruses 636.0 233.0 7.06e-178 3.07e-74
10193 10193 PRJNA974396_CONTIG_9291|Isavirus_salaris|CLUSTER5_Isavirus_salaris|4|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_9291|Isavirus_salaris PRJNA974396_CONTIG_9291 Isavirus salaris 19 1 8 CLUSTER5_Isavirus_salaris|4|1 AF220607_1_Infectious_salmon_anemia_virus_hemagglutinin_gene_complete_cds 4 1 PRJNA974396 9291 324 29.580071 95.83943004 Isavirus salaris 55987 Viruses Viruses 547.0 3.18e-151 Isavirus salaris Non-phage NTclustered PRJNA974396_S_NODE_9291_length_324_cov_29.580071_g9131_i0   Infectious salmon anemia virus hemagglutinin gene, complete cds gi|6942213|gb|AF220607.1|AF220607 55987 g9131 i0 97.214 74.0462963 323 9 99.0 0 1 323 979 1301 23991 547.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus salaris Isavirus gi|6942213|gb|AF220607.1|AF220607 Viruses Viruses Viruses Viruses 547.0 118.0 3.18e-151 1.8099999999999997e-30
10194 10194 PRJNA974396_CONTIG_11824|Isavirus_salaris|CLUSTER4_Isavirus_salaris|4|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_11824|Isavirus_salaris PRJNA974396_CONTIG_11824 Isavirus salaris 19 1 8 CLUSTER4_Isavirus_salaris|4|1 AF429988_1_Infectious_salmon_anemia_virus_isolate_Scotland_390_98_segment_5_putative_acetylesterase_P3_gene_complete_cds 4 1 PRJNA974396 11824 302 6.135135 18.5281077 Isavirus salaris 55987 Viruses Viruses 547.0 2.94e-151 Isavirus salaris Non-phage NTclustered PRJNA974396_S_NODE_11824_length_302_cov_6.135135_g11664_i0   Infectious salmon anemia virus isolate Scotland 390/98 segment 5 putative acetylesterase P3 gene, complete cds gi|24369749|gb|AF429988.1| 55987 g11664 i0 99.338 79.93377483 302 2 100.0 0 1 302 1164 1465 24140 547.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus salaris Isavirus gi|24369749|gb|AF429988.1| Viruses Viruses Viruses Viruses 547.0 129.0 2.94e-151 1.7700000000000002e-35
10202 10202 PRJNA974396_CONTIG_33573|Isavirus|CLUSTER5_Isavirus_salaris|4|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_33573|Isavirus PRJNA974396_CONTIG_33573 Isavirus salaris 19 1 8 CLUSTER5_Isavirus_salaris|4|1 AF220607_1_Infectious_salmon_anemia_virus_hemagglutinin_gene_complete_cds 4 1 PRJNA974396 33573 215 1.116279 2.39999985 Isavirus 324913 Viruses Viruses 398.0 2.11e-106 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_33573_length_215_cov_1.116279_g33413_i0   Infectious salmon anemia virus isolate 52/00 hemagglutinin (HA) mRNA, partial cds gi|17046352|gb|AF364892.1|AF364892 55987 g33413 i0 100.0 100.0 215 0 100.0 0 1 215 969 755 21500 398.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Isavirus gi|17046352|gb|AF364892.1|AF364892 Viruses Viruses Viruses Viruses 398.0 149.0 2.11e-106 2.1699999999999998e-42
10235 10235 PRJNA974396_CONTIG_448|Isavirus|CLUSTER2_Isavirus|2|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_448|Isavirus PRJNA974396_CONTIG_448 Isavirus 19 1 8 CLUSTER2_Isavirus|2|1 KM262779_1_Infectious_salmon_anemia_virus_isolate_901_09_segment_8_complete_sequence 2 1 PRJNA974396 448 790 23.453815 185.2851385 Isavirus 324913 Viruses Viruses 1441.0 0.0 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_448_length_790_cov_23.453815_g368_i0   Infectious salmon anemia virus isolate 901_09 segment 8, complete sequence gi|701668776|gb|KM262779.1| 55987 g368 i0 99.62 59.89240506 789 3 99.0 0 2 790 886 98 47315 1441.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Isavirus salaris gi|701668776|gb|KM262779.1| Viruses Viruses Viruses Viruses 1441.0 440.0 0.0 1.71e-154
10239 10239 PRJNA974396_CONTIG_936|Isavirus|CLUSTER3_Isavirus|2|1 Infectious Salmon Anemia Virus Known PRJNA974396_CONTIG_936|Isavirus PRJNA974396_CONTIG_936 Isavirus 19 1 8 CLUSTER3_Isavirus|2|1 HQ259677_1_Infectious_salmon_anemia_virus_isolate_Glesvaer_2_90_segment_7_complete_sequence 2 1 PRJNA974396 936 633 14.915254 94.41355782 Isavirus 324913 Viruses Viruses 1142.0 0.0 Isavirus Non-phage NTclustered PRJNA974396_S_NODE_936_length_633_cov_14.915254_g817_i0   Infectious salmon anemia virus isolate Glesvaer/2/90 segment 7, complete sequence gi|313754898|gb|HQ259677.1| 55987 g817 i0 99.365 53.59083728 630 4 99.0 0 1 630 479 1108 33923 1142.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Isavirus Isavirus salaris Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Isavirus;Infectious Salmon Anemia Virus Isavirus Isavirus salaris gi|313754898|gb|HQ259677.1| Viruses Viruses Viruses Viruses 1142.0 309.0 0.0 3.16e-103

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