RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

13 rows where bioproject = "PRJNA944406"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_family_NTorNR 2

bioproject 1

  • PRJNA944406 · 13 ✖

tax_genus_NTorNR 0

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
3243 3243 PRJNA944406_CONTIG_12|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_12|Cyprivirus_A PRJNA944406_CONTIG_12 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 PRJNA944406 12 5028 91.640767 4607.697765 Cyprivirus A 2304617 Viruses Viruses 8468.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_12_length_5028_cov_91.640767_g7_i0   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g7 i0 97.076 3.050517104 5028 143 100.0 2 1 5028 8297 3274 15338 8468.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 8468.0 2998.0 0.0 0.0
3244 3244 PRJNA944406_CONTIG_13|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_13|Cyprivirus_A PRJNA944406_CONTIG_13 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 PRJNA944406 13 5028 91.245207 4587.809008 Cyprivirus A 2304617 Viruses Viruses 8414.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_13_length_5028_cov_91.245207_g7_i1   Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome gi|1812398529|gb|MN524064.1| 2563826 g7 i1 96.879 3.050517104 5030 152 100.0 4 1 5028 3201 8227 15338 8414.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|1812398529|gb|MN524064.1| Viruses Viruses Viruses Viruses 8414.0 2992.0 0.0 0.0
3247 3247 PRJNA944406_CONTIG_14|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_14|Cyprivirus_A PRJNA944406_CONTIG_14 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 PRJNA944406 14 5028 90.563269 4553.521165 Cyprivirus A 2304617 Viruses Viruses 8479.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_14_length_5028_cov_90.563269_g7_i2   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g7 i2 97.116 3.050517104 5028 141 100.0 2 1 5028 8297 3274 15338 8479.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 8479.0 3000.0 0.0 0.0
3249 3249 PRJNA944406_CONTIG_15|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_15|Cyprivirus_A PRJNA944406_CONTIG_15 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 PRJNA944406 15 5000 30.9178 1545.89 Cyprivirus A 2304617 Viruses Viruses 8194.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_15_length_5000_cov_30.917800_g7_i3   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g7 i3 96.242 2.9994 5003 184 100.0 4 1 5000 5069 68 14997 8194.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 8194.0 2784.0 0.0 0.0
3267 3267 PRJNA944406_CONTIG_68|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_68|Cyprivirus_A PRJNA944406_CONTIG_68 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 PRJNA944406 68 3053 39.120805 1194.358177 Cyprivirus A 2304617 Viruses Viruses 4937.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_68_length_3053_cov_39.120805_g7_i4   TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome gi|1990739381|tpg|BK011179.1| 2563826 g7 i4 95.844 3.003275467 3056 124 100.0 1 1 3053 2027 5082 9169 4937.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 4937.0 1911.0 0.0 0.0
3268 3268 PRJNA944406_CONTIG_69|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_69|Cyprivirus_A PRJNA944406_CONTIG_69 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 PRJNA944406 69 3053 38.221812 1166.91192 Cyprivirus A 2304617 Viruses Viruses 4909.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_69_length_3053_cov_38.221812_g7_i5   TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome gi|1990739381|tpg|BK011179.1| 2563826 g7 i5 95.681 3.00294792 3056 129 100.0 1 1 3053 5082 2027 9168 4909.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 4909.0 1907.0 0.0 0.0
3293 3293 PRJNA944406_CONTIG_141|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_141|Cyprivirus_A PRJNA944406_CONTIG_141 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 PRJNA944406 141 2486 21.242851 528.0972759 Cyprivirus A 2304617 Viruses Viruses 4082.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_141_length_2486_cov_21.242851_g7_i6   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g7 i6 96.301 2.995172969 2487 90 100.0 2 1 2486 2553 68 7446 4082.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 4082.0 1241.0 0.0 0.0
3294 3294 PRJNA944406_CONTIG_142|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_142|Cyprivirus_A PRJNA944406_CONTIG_142 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 PRJNA944406 142 2486 20.382511 506.7092235 Cyprivirus A 2304617 Viruses Viruses 4181.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_142_length_2486_cov_20.382511_g7_i7   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g7 i7 97.025 2.995172969 2487 72 100.0 2 1 2486 2553 68 7446 4181.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 4181.0 1236.0 0.0 0.0
3295 3295 PRJNA944406_CONTIG_143|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_143|Cyprivirus_A PRJNA944406_CONTIG_143 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 PRJNA944406 143 2486 19.667634 488.9373812 Cyprivirus A 2304617 Viruses Viruses 4120.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_143_length_2486_cov_19.667634_g7_i8   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g7 i8 96.582 2.995172969 2487 83 100.0 2 1 2486 68 2553 7446 4120.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 4120.0 1240.0 0.0 0.0
3967 3967 PRJNA944406_CONTIG_10873|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA944406_CONTIG_10873|Cyprivirus_A PRJNA944406_CONTIG_10873 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 PRJNA944406 10873 378 2.688525 10.1626245 Cyprivirus A 2304617 Viruses Viruses 566.0 1.0400000000000001e-156 Cyprivirus A Non-phage NTclustered PRJNA944406_P_NODE_10873_length_378_cov_2.688525_g9914_i0   Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome gi|1812398529|gb|MN524064.1| 2563826 g9914 i0 93.651 3.002645503 378 24 100.0 0 1 378 2071 1694 1135 566.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|1812398529|gb|MN524064.1| Viruses Viruses Viruses Viruses 566.0 253.0 1.0400000000000001e-156 4.79e-75
9983 9983 PRJNA944406_CONTIG_15085|Astyanax_tetra_cavefish_adintovirus|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA944406_CONTIG_15085|Astyanax_tetra_cavefish_adintovirus PRJNA944406_CONTIG_15085 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA944406 15085 331 0.751938 2.48891478 Astyanax tetra cavefish adintovirus 2609866 Viruses Viruses 110.0 2.63e-28 Astyanax tetra cavefish adintovirus Non-phage NR PRJNA944406_P_NODE_15085_length_331_cov_0.751938_g14126_i0   DAC81254.1 TPA_asm: cupiennin [Astyanax tetra cavefish adintovirus] DAC81254.1 2609866 g14126 i0 60.7 1.432024169 84 33 76.1 0 252 1 6 89 474 110.0 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Astyanax tetra cavefish adintovirus Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Astyanax tetra cavefish adintovirus     Viruses   Viruses   110.0   2.63e-28
10109 10109 PRJNA944406_CONTIG_84573|Larimichthys_croaker_adintovirus|CLUSTER1_Larimichthys_croaker_adintovirus|8|6 Larimichthys croaker adintovirus Insufficient Evidence PRJNA944406_CONTIG_84573|Larimichthys_croaker_adintovirus PRJNA944406_CONTIG_84573 Larimichthys croaker adintovirus 19 14 10 CLUSTER1_Larimichthys_croaker_adintovirus|8|6 PRJNA1249042_S_NODE_6306_length_354_cov_2.350482_g6092_i0|Adintovirus_corythoichthys13919|NR|1.1e-28|NA 7 6 PRJNA944406 84573 246 1.768786 4.35121356 Larimichthys croaker adintovirus 2609857 Viruses Viruses 94.7 6.910000000000001e-21 Larimichthys croaker adintovirus Non-phage NR PRJNA944406_P_NODE_84573_length_246_cov_1.768786_g83614_i0   DAC81309.1 TPA_asm: integrase [Larimichthys croaker adintovirus] DAC81309.1 2609857 g83614 i0 56.6 0.926829268 76 33 92.7 0 245 18 193 268 228 94.7 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Larimichthys croaker adintovirus Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Larimichthys croaker adintovirus   Larimichthys croaker adintovirus     Viruses   Viruses   94.7   6.910000000000001e-21
10166 10166 PRJNA944406_CONTIG_6007|Larimichthys_croaker_adintovirus|CLUSTER2_Larimichthys_croaker_adintovirus|5|5 Larimichthys croaker adintovirus Insufficient Evidence PRJNA944406_CONTIG_6007|Larimichthys_croaker_adintovirus PRJNA944406_CONTIG_6007 Larimichthys croaker adintovirus 19 14 10 CLUSTER2_Larimichthys_croaker_adintovirus|5|5 PRJNA944406_P_NODE_6007_length_524_cov_1.352550_g5055_i0|Larimichthys_croaker_adintovirus|NR|4.27e-20|NA 4 4 PRJNA944406 6007 524 1.35255 7.087362 Larimichthys croaker adintovirus 2609857 Viruses Viruses 92.8 4.27e-20 Larimichthys croaker adintovirus Non-phage NR PRJNA944406_P_NODE_6007_length_524_cov_1.352550_g5055_i0   DAC81313.1 TPA_asm: adenain [Larimichthys croaker adintovirus] DAC81313.1 2609857 g5055 i0 57.4 2.25 68 26 38.9 1 320 523 37 101 1179 92.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Larimichthys croaker adintovirus Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Larimichthys croaker adintovirus   Larimichthys croaker adintovirus     Viruses   Viruses   92.8   4.27e-20

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