viruses_fish_associated_curated
29 rows where bioproject = "PRJNA701156" and clusterLCA_curated = "Zebrafish jaw poxvirus"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4623 | 4623 | PRJNA701156_CONTIG_3265|Carp_edema_virus|CLUSTER1_Carp_edema_virus|632|87 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_3265|Carp_edema_virus | PRJNA701156_CONTIG_3265 | 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 | PRJNA701156 | 3265 | 363 | 1.062069 | 3.85531047 | Carp edema virus | 1653087 | Viruses | Viruses | 185.0 | 1.45e-51 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_3265_length_363_cov_1.062069_g3123_i0 | BCT22639.1 DNA topoisomerase 2 [Carp edema virus] | BCT22639.1 | 1653087 | g3123 | i0 | 75.2 | 1.0 | 121 | 29 | 100.0 | 1 | 363 | 1 | 403 | 522 | 363 | 185.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 | 185.0 | 1.45e-51 | ||||||||
| 4670 | 4670 | PRJNA701156_CONTIG_5093|Carp_edema_virus|CLUSTER1_Carp_edema_virus|632|87 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_5093|Carp_edema_virus | PRJNA701156_CONTIG_5093 | 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 | PRJNA701156 | 5093 | 315 | 1.714876 | 5.4018594 | Carp edema virus | 1653087 | Viruses | Viruses | 55.5 | 3.01e-06 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_5093_length_315_cov_1.714876_g4951_i0 | BCT22639.1 DNA topoisomerase 2 [Carp edema virus] | BCT22639.1 | 1653087 | g4951 | i0 | 35.4 | 0.942857143 | 99 | 63 | 94.3 | 1 | 313 | 17 | 1039 | 1136 | 297 | 55.5 | 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 | 55.5 | 3.01e-06 | ||||||||
| 4815 | 4815 | PRJNA701156_CONTIG_15856|Carp_edema_virus|CLUSTER1_Carp_edema_virus|632|87 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_15856|Carp_edema_virus | PRJNA701156_CONTIG_15856 | 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 | PRJNA701156 | 15856 | 250 | 0.870056 | 2.17514 | Carp edema virus | 1653087 | Viruses | Viruses | 100.0 | 1.43e-22 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_15856_length_250_cov_0.870056_g15714_i0 | BCT22646.1 virion core protein P4b [Carp edema virus] | BCT22646.1 | 1653087 | g15714 | i0 | 54.2 | 0.996 | 83 | 38 | 99.6 | 0 | 249 | 1 | 162 | 244 | 249 | 100.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 | 100.0 | 1.43e-22 | ||||||||
| 4845 | 4845 | PRJNA701156_CONTIG_20631|Carp_edema_virus|CLUSTER1_Carp_edema_virus|632|87 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_20631|Carp_edema_virus | PRJNA701156_CONTIG_20631 | 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 | PRJNA701156 | 20631 | 246 | 0.890173 | 2.18982558 | Carp edema virus | 1653087 | Viruses | Viruses | 56.6 | 2.22e-08 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_20631_length_246_cov_0.890173_g20489_i0 | BCT22645.1 S-S bond formation pathway protein [Carp edema virus] | BCT22645.1 | 1653087 | g20489 | i0 | 50.9 | 0.670731707 | 55 | 27 | 67.1 | 0 | 4 | 168 | 20 | 74 | 165 | 56.6 | 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 | 56.6 | 2.22e-08 | ||||||||
| 4860 | 4860 | PRJNA701156_CONTIG_23977|Carp_edema_virus|CLUSTER1_Carp_edema_virus|632|87 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_23977|Carp_edema_virus | PRJNA701156_CONTIG_23977 | 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 | PRJNA701156 | 23977 | 243 | 1.811765 | 4.40258895 | Carp edema virus | 1653087 | Viruses | Viruses | 114.0 | 3.25e-27 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_23977_length_243_cov_1.811765_g23835_i0 | BCT22635.1 NTPase [Carp edema virus] | BCT22635.1 | 1653087 | g23835 | i0 | 65.0 | 0.987654321 | 80 | 28 | 98.8 | 0 | 242 | 3 | 459 | 538 | 240 | 114.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 | 114.0 | 3.25e-27 | ||||||||
| 5110 | 5110 | PRJNA701156_CONTIG_1150|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_1150|Carp_edema_virus | PRJNA701156_CONTIG_1150 | Carp edema virus | 4680 | 143 | 36 | CLUSTER2_Carp_edema_virus|553|75 | LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome | 552 | 75 | PRJNA701156 | 1150 | 548 | 2.511579 | 13.76345292 | Carp edema virus | 1653087 | Viruses | Viruses | 101.0 | 2.13e-22 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_1150_length_548_cov_2.511579_g1009_i0 | BCT22606.1 hypothetical protein AL387_gp060 [Carp edema virus] | BCT22606.1 | 1653087 | g1009 | i0 | 44.8 | 0.476277372 | 87 | 48 | 47.6 | 0 | 495 | 235 | 177 | 263 | 261 | 101.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 | 101.0 | 2.13e-22 | ||||||||
| 5187 | 5187 | PRJNA701156_CONTIG_2403|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_2403|Carp_edema_virus | PRJNA701156_CONTIG_2403 | Carp edema virus | 4680 | 143 | 36 | CLUSTER2_Carp_edema_virus|553|75 | LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome | 552 | 75 | PRJNA701156 | 2403 | 402 | 2.753799 | 11.07027198 | Carp edema virus | 1653087 | Viruses | Viruses | 77.4 | 9.48e-14 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_2403_length_402_cov_2.753799_g2261_i0 | BCT22728.1 DNA topoisomerase I [Carp edema virus] | BCT22728.1 | 1653087 | g2261 | i0 | 56.1 | 0.492537313 | 66 | 23 | 49.3 | 1 | 7 | 204 | 276 | 335 | 198 | 77.4 | 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 | 77.4 | 9.48e-14 | ||||||||
| 5400 | 5400 | PRJNA701156_CONTIG_13367|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_13367|Carp_edema_virus | PRJNA701156_CONTIG_13367 | Carp edema virus | 4680 | 143 | 36 | CLUSTER2_Carp_edema_virus|553|75 | LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome | 552 | 75 | PRJNA701156 | 13367 | 251 | 1.724719 | 4.32904469 | Carp edema virus | 1653087 | Viruses | Viruses | 118.0 | 4.19e-30 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_13367_length_251_cov_1.724719_g13225_i0 | BCT22608.1 poly(A)-polymerase small subunit VP39 PAPS [Carp edema virus] | BCT22608.1 | 1653087 | g13225 | i0 | 63.4 | 0.980079681 | 82 | 30 | 98.0 | 0 | 247 | 2 | 113 | 194 | 246 | 118.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 | 118.0 | 4.19e-30 | ||||||||
| 5465 | 5465 | PRJNA701156_CONTIG_27473|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_27473|Carp_edema_virus | PRJNA701156_CONTIG_27473 | Carp edema virus | 4680 | 143 | 36 | CLUSTER2_Carp_edema_virus|553|75 | LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome | 552 | 75 | PRJNA701156 | 27473 | 241 | 0.916667 | 2.20916747 | Carp edema virus | 1653087 | Viruses | Viruses | 110.0 | 3.96e-26 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_27473_length_241_cov_0.916667_g27331_i0 | BCT22721.1 RNA polymerase subunit RPO147 [Carp edema virus] | BCT22721.1 | 1653087 | g27331 | i0 | 67.1 | 0.946058091 | 76 | 25 | 94.6 | 0 | 13 | 240 | 1142 | 1217 | 228 | 110.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 | 110.0 | 3.96e-26 | ||||||||
| 5691 | 5691 | PRJNA701156_CONTIG_2774|Carp_edema_virus|CLUSTER3_Carp_edema_virus|359|69 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_2774|Carp_edema_virus | PRJNA701156_CONTIG_2774 | Carp edema virus | 4680 | 143 | 36 | CLUSTER3_Carp_edema_virus|359|69 | PRJNA318414_P_NODE_2_length_28050_cov_65.213304_g1_i0|Carp_edema_virus|NR|0|NA | 358 | 69 | PRJNA701156 | 2774 | 383 | 2.090323 | 8.00593709 | Carp edema virus | 1653087 | Viruses | Viruses | 84.3 | 5.21e-16 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_2774_length_383_cov_2.090323_g2632_i0 | BCT22720.1 poxvirus B22R superfamily protein [Carp edema virus] | BCT22720.1 | 1653087 | g2632 | i0 | 38.9 | 0.98694517 | 126 | 69 | 95.6 | 6 | 2 | 367 | 1153 | 1274 | 378 | 84.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 | 84.3 | 5.21e-16 | ||||||||
| 5760 | 5760 | PRJNA701156_CONTIG_7432|Carp_edema_virus|CLUSTER3_Carp_edema_virus|359|69 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_7432|Carp_edema_virus | PRJNA701156_CONTIG_7432 | Carp edema virus | 4680 | 143 | 36 | CLUSTER3_Carp_edema_virus|359|69 | PRJNA318414_P_NODE_2_length_28050_cov_65.213304_g1_i0|Carp_edema_virus|NR|0|NA | 358 | 69 | PRJNA701156 | 7432 | 285 | 1.372642 | 3.9120297 | Carp edema virus | 1653087 | Viruses | Viruses | 49.7 | 0.000227 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_7432_length_285_cov_1.372642_g7290_i0 | BCT22715.1 putative membrane-associated glycoprotein [Carp edema virus] | BCT22715.1 | 1653087 | g7290 | i0 | 48.8 | 0.452631579 | 43 | 22 | 45.3 | 0 | 283 | 155 | 757 | 799 | 129 | 49.7 | 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 | 49.7 | 0.000227 | ||||||||
| 5800 | 5800 | PRJNA701156_CONTIG_12845|Carp_edema_virus|CLUSTER3_Carp_edema_virus|359|69 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_12845|Carp_edema_virus | PRJNA701156_CONTIG_12845 | Carp edema virus | 4680 | 143 | 36 | CLUSTER3_Carp_edema_virus|359|69 | PRJNA318414_P_NODE_2_length_28050_cov_65.213304_g1_i0|Carp_edema_virus|NR|0|NA | 358 | 69 | PRJNA701156 | 12845 | 254 | 2.303867 | 5.85182218 | Carp edema virus | 1653087 | Viruses | Viruses | 42.7 | 0.044 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_12845_length_254_cov_2.303867_g12703_i0 | BCT22720.1 poxvirus B22R superfamily protein [Carp edema virus] | BCT22720.1 | 1653087 | g12703 | i0 | 39.2 | 0.602362205 | 51 | 31 | 60.2 | 0 | 6 | 158 | 1321 | 1371 | 153 | 42.7 | 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 | 42.7 | 0.044 | ||||||||
| 6027 | 6027 | PRJNA701156_CONTIG_1104|Carp_edema_virus|CLUSTER4_Carp_edema_virus|348|78 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_1104|Carp_edema_virus | PRJNA701156_CONTIG_1104 | Carp edema virus | 4680 | 143 | 36 | CLUSTER4_Carp_edema_virus|348|78 | PRJNA1075480_S_NODE_1_length_24682_cov_102.472876_g0_i0|Carp_edema_virus|NR|2.31e-98|NA | 331 | 77 | PRJNA701156 | 1104 | 560 | 2.256674 | 12.6373744 | Carp edema virus | 1653087 | Viruses | Viruses | 90.1 | 5.36e-19 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_1104_length_560_cov_2.256674_g963_i0 | BCT22576.1 deoxyuridine triphosphatase [Carp edema virus] | BCT22576.1 | 1653087 | g963 | i0 | 40.7 | 0.776785714 | 145 | 80 | 76.6 | 3 | 131 | 559 | 26 | 166 | 435 | 90.1 | 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 | 90.1 | 5.36e-19 | ||||||||
| 6281 | 6281 | PRJNA701156_CONTIG_989|Carp_edema_virus|CLUSTER5_Carp_edema_virus|282|82 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_989|Carp_edema_virus | PRJNA701156_CONTIG_989 | 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 | PRJNA701156 | 989 | 586 | 2.202729 | 12.90799194 | Carp edema virus | 1653087 | Viruses | Viruses | 76.6 | 2.54e-13 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_989_length_586_cov_2.202729_g848_i0 | BCT22707.1 hypothetical protein [Carp edema virus] | BCT22707.1 | 1653087 | g848 | i0 | 34.3 | 0.880546075 | 172 | 96 | 85.0 | 7 | 47 | 544 | 18 | 178 | 516 | 76.6 | 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 | 76.6 | 2.54e-13 | ||||||||
| 6507 | 6507 | PRJNA701156_CONTIG_195|Carp_edema_virus|CLUSTER6_Carp_edema_virus|274|111 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_195|Carp_edema_virus | PRJNA701156_CONTIG_195 | Carp edema virus | 4680 | 143 | 36 | CLUSTER6_Carp_edema_virus|274|111 | PRJNA1075480_S_NODE_10_length_11763_cov_107.476048_g4_i0|Carp_edema_virus|NR|0|NA | 264 | 107 | PRJNA701156 | 195 | 1473 | 6.488571 | 95.57665083 | Carp edema virus | 1653087 | Viruses | Viruses | 181.0 | 1.0699999999999999e-48 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_195_length_1473_cov_6.488571_g114_i0 | BCT22626.1 putative DNA-binding virion core protein [Carp edema virus] | BCT22626.1 | 1653087 | g114 | i0 | 36.4 | 0.637474542 | 313 | 182 | 60.9 | 6 | 1395 | 499 | 3 | 312 | 939 | 181.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 | 181.0 | 1.0699999999999999e-48 | ||||||||
| 6670 | 6670 | PRJNA701156_CONTIG_12434|Carp_edema_virus|CLUSTER6_Carp_edema_virus|274|111 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_12434|Carp_edema_virus | PRJNA701156_CONTIG_12434 | Carp edema virus | 4680 | 143 | 36 | CLUSTER6_Carp_edema_virus|274|111 | PRJNA1075480_S_NODE_10_length_11763_cov_107.476048_g4_i0|Carp_edema_virus|NR|0|NA | 264 | 107 | PRJNA701156 | 12434 | 257 | 1.559783 | 4.00864231 | Carp edema virus | 1653087 | Viruses | Viruses | 85.9 | 2.96e-17 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_12434_length_257_cov_1.559783_g12292_i0 | BCT22623.1 DNA polymerase [Carp edema virus] | BCT22623.1 | 1653087 | g12292 | i0 | 49.4 | 0.992217899 | 85 | 42 | 99.2 | 1 | 257 | 3 | 884 | 967 | 255 | 85.9 | 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 | 85.9 | 2.96e-17 | ||||||||
| 6797 | 6797 | PRJNA701156_CONTIG_2122|Carp_edema_virus|CLUSTER7_Carp_edema_virus|191|60 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_2122|Carp_edema_virus | PRJNA701156_CONTIG_2122 | Carp edema virus | 4680 | 143 | 36 | CLUSTER7_Carp_edema_virus|191|60 | PRJNA318414_P_NODE_4_length_21553_cov_145.486805_g3_i0|Carp_edema_virus|NR|0|NA | 184 | 57 | PRJNA701156 | 2122 | 421 | 2.12069 | 8.9281049 | Carp edema virus | 1653087 | Viruses | Viruses | 55.8 | 3.9e-07 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_2122_length_421_cov_2.120690_g1980_i0 | BCT22656.1 hypothetical protein [Carp edema virus] | BCT22656.1 | 1653087 | g1980 | i0 | 41.1 | 0.641330166 | 90 | 44 | 63.4 | 3 | 409 | 143 | 7 | 88 | 270 | 55.8 | 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 | 55.8 | 3.9e-07 | ||||||||
| 6893 | 6893 | PRJNA701156_CONTIG_26832|Carp_edema_virus|CLUSTER7_Carp_edema_virus|191|60 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_26832|Carp_edema_virus | PRJNA701156_CONTIG_26832 | Carp edema virus | 4680 | 143 | 36 | CLUSTER7_Carp_edema_virus|191|60 | PRJNA318414_P_NODE_4_length_21553_cov_145.486805_g3_i0|Carp_edema_virus|NR|0|NA | 184 | 57 | PRJNA701156 | 26832 | 241 | 0.916667 | 2.20916747 | Carp edema virus | 1653087 | Viruses | Viruses | 75.9 | 7.88e-14 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_26832_length_241_cov_0.916667_g26690_i0 | BCT22650.1 early transcription factor (VETF) large subunit [Carp edema virus] | BCT22650.1 | 1653087 | g26690 | i0 | 53.2 | 0.958506224 | 77 | 30 | 95.9 | 1 | 231 | 1 | 8 | 78 | 231 | 75.9 | 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 | 75.9 | 7.88e-14 | ||||||||
| 7090 | 7090 | PRJNA701156_CONTIG_5411|Carp_edema_virus|CLUSTER9_Carp_edema_virus|189|53 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_5411|Carp_edema_virus | PRJNA701156_CONTIG_5411 | Carp edema virus | 4680 | 143 | 36 | CLUSTER9_Carp_edema_virus|189|53 | PRJNA1075480_S_NODE_36_length_9686_cov_68.302923_g23_i0|Carp_edema_virus|NR|9.15e-292|NA | 188 | 53 | PRJNA701156 | 5411 | 309 | 1.957627 | 6.04906743 | Carp edema virus | 1653087 | Viruses | Viruses | 116.0 | 5.36e-29 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_5411_length_309_cov_1.957627_g5269_i0 | BCT22694.1 mRNA capping enzyme small subunit [Carp edema virus] | BCT22694.1 | 1653087 | g5269 | i0 | 59.6 | 0.961165049 | 99 | 38 | 96.1 | 2 | 302 | 6 | 49 | 145 | 297 | 116.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 | 116.0 | 5.36e-29 | ||||||||
| 7106 | 7106 | PRJNA701156_CONTIG_6842|Carp_edema_virus|CLUSTER8_Carp_edema_virus|189|52 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_6842|Carp_edema_virus | PRJNA701156_CONTIG_6842 | Carp edema virus | 4680 | 143 | 36 | CLUSTER8_Carp_edema_virus|189|52 | PRJEB2894_P_NODE_1_length_11775_cov_16.335690_g0_i0|Carp_edema_virus|NR|0|NA | 189 | 52 | PRJNA701156 | 6842 | 288 | 3.902326 | 11.23869888 | Carp edema virus | 1653087 | Viruses | Viruses | 56.2 | 1.16e-06 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_6842_length_288_cov_3.902326_g6700_i0 | BCT22673.1 DNA-dependent RNA polymerase subunit rpo132 [Carp edema virus] | BCT22673.1 | 1653087 | g6700 | i0 | 69.7 | 0.34375 | 33 | 10 | 34.4 | 0 | 286 | 188 | 1138 | 1170 | 99 | 56.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 | 56.2 | 1.16e-06 | ||||||||
| 7145 | 7145 | PRJNA701156_CONTIG_10905|Carp_edema_virus|CLUSTER9_Carp_edema_virus|189|53 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_10905|Carp_edema_virus | PRJNA701156_CONTIG_10905 | Carp edema virus | 4680 | 143 | 36 | CLUSTER9_Carp_edema_virus|189|53 | PRJNA1075480_S_NODE_36_length_9686_cov_68.302923_g23_i0|Carp_edema_virus|NR|9.15e-292|NA | 188 | 53 | PRJNA701156 | 10905 | 266 | 1.082902 | 2.88051932 | Carp edema virus | 1653087 | Viruses | Viruses | 58.9 | 7.1e-08 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_10905_length_266_cov_1.082902_g10763_i0 | BCT22690.1 DNA-directed RNA polymerase, 18 kD subunit [Carp edema virus] | BCT22690.1 | 1653087 | g10763 | i0 | 45.1 | 0.92481203 | 82 | 36 | 86.8 | 2 | 235 | 5 | 21 | 98 | 246 | 58.9 | 1.0 | Viruses | Varidnaviria | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Carp edema virus | Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus | Pandoravirus aubagnensis | Carp edema virus | gi|2203411877|gb|MZ420563.1| | Viruses | Viruses | Viruses | Viruses | 52.8 | 58.9 | 0.024 | 7.1e-08 | ||
| 7349 | 7349 | PRJNA701156_CONTIG_385|Carp_edema_virus|CLUSTER11_Carp_edema_virus|185|63 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_385|Carp_edema_virus | PRJNA701156_CONTIG_385 | Carp edema virus | 4680 | 143 | 36 | CLUSTER11_Carp_edema_virus|185|63 | PRJNA318414_P_NODE_13_length_11789_cov_179.829762_g10_i0|Carp_edema_virus|NR|4.62999999998593e-293|NA | 184 | 63 | PRJNA701156 | 385 | 1006 | 4.380493 | 44.06775958 | Carp edema virus | 1653087 | Viruses | Viruses | 174.0 | 8.869999999999999e-48 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_385_length_1006_cov_4.380493_g268_i0 | BCT22728.1 DNA topoisomerase I [Carp edema virus] | BCT22728.1 | 1653087 | g268 | i0 | 63.9 | 0.396620278 | 133 | 47 | 39.4 | 1 | 396 | 1 | 1 | 133 | 399 | 174.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 | 174.0 | 8.869999999999999e-48 | ||||||||
| 7446 | 7446 | PRJNA701156_CONTIG_2582|Carp_edema_virus|CLUSTER11_Carp_edema_virus|185|63 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_2582|Carp_edema_virus | PRJNA701156_CONTIG_2582 | Carp edema virus | 4680 | 143 | 36 | CLUSTER11_Carp_edema_virus|185|63 | PRJNA318414_P_NODE_13_length_11789_cov_179.829762_g10_i0|Carp_edema_virus|NR|4.62999999998593e-293|NA | 184 | 63 | PRJNA701156 | 2582 | 393 | 1.203125 | 4.72828125 | Carp edema virus | 1653087 | Viruses | Viruses | 204.0 | 1.4500000000000001e-58 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_2582_length_393_cov_1.203125_g2440_i0 | BCT22731.1 mRNA capping enzyme large subunit [Carp edema virus] | BCT22731.1 | 1653087 | g2440 | i0 | 75.0 | 0.977099237 | 128 | 32 | 97.7 | 0 | 10 | 393 | 597 | 724 | 384 | 204.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 | 204.0 | 1.4500000000000001e-58 | ||||||||
| 7512 | 7512 | PRJNA701156_CONTIG_5805|Carp_edema_virus|CLUSTER10_Carp_edema_virus|185|56 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_5805|Carp_edema_virus | PRJNA701156_CONTIG_5805 | Carp edema virus | 4680 | 143 | 36 | CLUSTER10_Carp_edema_virus|185|56 | PRJNA318414_P_NODE_23_length_7708_cov_280.993359_g18_i0|Carp_edema_virus|NR|5.21e-142|NA | 183 | 56 | PRJNA701156 | 5805 | 302 | 1.19214 | 3.6002628 | Carp edema virus | 1653087 | Viruses | Viruses | 64.7 | 1.21e-09 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_5805_length_302_cov_1.192140_g5663_i0 | BCT22665.1 putative apurinic-apyrimidinic endonuclease 1 [Carp edema virus] | BCT22665.1 | 1653087 | g5663 | i0 | 44.6 | 0.556291391 | 56 | 31 | 55.6 | 0 | 36 | 203 | 288 | 343 | 168 | 64.7 | 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 | 64.7 | 1.21e-09 | ||||||||
| 8555 | 8555 | PRJNA701156_CONTIG_2851|Carp_edema_virus|CLUSTER15_Carp_edema_virus|92|41 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_2851|Carp_edema_virus | PRJNA701156_CONTIG_2851 | Carp edema virus | 4680 | 143 | 36 | CLUSTER15_Carp_edema_virus|92|41 | PRJNA318414_P_NODE_22_length_7797_cov_118.161689_g17_i0|Carp_edema_virus|NR|1.23e-128|NA | 92 | 41 | PRJNA701156 | 2851 | 380 | 1.504886 | 5.7185668 | Carp edema virus | 1653087 | Viruses | Viruses | 60.1 | 6.95e-08 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_2851_length_380_cov_1.504886_g2709_i0 | BCT22683.1 hypothetical protein [Carp edema virus] | BCT22683.1 | 1653087 | g2709 | i0 | 30.8 | 1.05 | 133 | 83 | 99.5 | 5 | 2 | 379 | 94 | 224 | 399 | 60.1 | 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 | 60.1 | 6.95e-08 | ||||||||
| 8663 | 8663 | PRJNA701156_CONTIG_1283|Carp_edema_virus|CLUSTER16_Carp_edema_virus|89|60 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_1283|Carp_edema_virus | PRJNA701156_CONTIG_1283 | Carp edema virus | 4680 | 143 | 36 | CLUSTER16_Carp_edema_virus|89|60 | PRJNA318414_P_NODE_16_length_10532_cov_251.265543_g13_i0|Carp_edema_virus|NR|5.62e-42|NA | 79 | 59 | PRJNA701156 | 1283 | 522 | 2.412027 | 12.59078094 | Carp edema virus | 1653087 | Viruses | Viruses | 66.2 | 4.69e-10 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_1283_length_522_cov_2.412027_g1142_i0 | BCT22744.1 hypothetical protein [Carp edema virus] | BCT22744.1 | 1653087 | g1142 | i0 | 63.5 | 0.298850575 | 52 | 19 | 29.9 | 0 | 520 | 365 | 4 | 55 | 156 | 66.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 | 66.2 | 4.69e-10 | ||||||||
| 8811 | 8811 | PRJNA701156_CONTIG_4391|Carp_edema_virus|CLUSTER18_Carp_edema_virus|87|53 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_4391|Carp_edema_virus | PRJNA701156_CONTIG_4391 | Carp edema virus | 4680 | 143 | 36 | CLUSTER18_Carp_edema_virus|87|53 | PRJNA854078_P_NODE_15_length_5165_cov_11.858209_g9_i0|Carp_edema_virus|NR|2.41e-94|NA | 86 | 52 | PRJNA701156 | 4391 | 330 | 1.595331 | 5.2645923 | Carp edema virus | 1653087 | Viruses | Viruses | 44.3 | 0.0244 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_4391_length_330_cov_1.595331_g4249_i0 | BCT22606.1 hypothetical protein AL387_gp060 [Carp edema virus] | BCT22606.1 | 1653087 | g4249 | i0 | 35.6 | 0.536363636 | 59 | 37 | 53.6 | 1 | 72 | 248 | 4 | 61 | 177 | 44.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 | 44.3 | 0.0244 | ||||||||
| 8998 | 8998 | PRJNA701156_CONTIG_5998|Carp_edema_virus|CLUSTER20_Carp_edema_virus|75|44 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_5998|Carp_edema_virus | PRJNA701156_CONTIG_5998 | Carp edema virus | 4680 | 143 | 36 | CLUSTER20_Carp_edema_virus|75|44 | PRJNA318414_P_NODE_7_length_17473_cov_56.726324_g6_i0|Carp_edema_virus|NR|0|NA | 69 | 42 | PRJNA701156 | 5998 | 299 | 1.256637 | 3.75734463 | Carp edema virus | 1653087 | Viruses | Viruses | 81.3 | 1.62e-15 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_5998_length_299_cov_1.256637_g5856_i0 | BCT22629.1 DNA-binding protein [Carp edema virus] | BCT22629.1 | 1653087 | g5856 | i0 | 41.2 | 0.973244147 | 97 | 56 | 97.3 | 1 | 8 | 298 | 83 | 178 | 291 | 81.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 | 81.3 | 1.62e-15 | ||||||||
| 9279 | 9279 | PRJNA701156_CONTIG_1839|Carp_edema_virus|CLUSTER23_Carp_edema_virus|62|54 | Zebrafish jaw poxvirus | Novel | PRJNA701156_CONTIG_1839|Carp_edema_virus | PRJNA701156_CONTIG_1839 | Carp edema virus | 4680 | 143 | 36 | CLUSTER23_Carp_edema_virus|62|54 | PRJNA318414_P_NODE_26_length_7203_cov_323.641065_g21_i0|Carp_edema_virus|NR|1.66e-43|NA | 57 | 54 | PRJNA701156 | 1839 | 445 | 1.459677 | 6.49556265 | Carp edema virus | 1653087 | Viruses | Viruses | 127.0 | 1.1900000000000001e-32 | Carp edema virus | Non-phage | NR | PRJNA701156_P_NODE_1839_length_445_cov_1.459677_g1697_i0 | BCT22575.1 thymidine kinase [Carp edema virus] | BCT22575.1 | 1653087 | g1697 | i0 | 46.9 | 0.97752809 | 145 | 74 | 95.7 | 1 | 19 | 444 | 100 | 244 | 435 | 127.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 | 127.0 | 1.1900000000000001e-32 |
Advanced export
JSON shape: default, array, newline-delimited
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);;