viruses_fish_associated_curated
22 rows where bioproject = "PRJNA800053"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4798 | 4798 | PRJNA800053_CONTIG_13910|Carp_edema_virus|CLUSTER1_Carp_edema_virus|632|87 | Zebrafish jaw poxvirus | Novel | PRJNA800053_CONTIG_13910|Carp_edema_virus | PRJNA800053_CONTIG_13910 | 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 | PRJNA800053 | 13910 | 273 | 1.54 | 4.2042 | Carp edema virus | 1653087 | Viruses | Viruses | 129.0 | 1.4900000000000002e-32 | Carp edema virus | Non-phage | NR | PRJNA800053_P_NODE_13910_length_273_cov_1.540000_g13746_i0 | BCT22642.1 trimeric virion coat protein [Carp edema virus] | BCT22642.1 | 1653087 | g13746 | i0 | 58.2 | 1.0 | 91 | 38 | 100.0 | 0 | 1 | 273 | 73 | 163 | 273 | 129.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 | 129.0 | 1.4900000000000002e-32 | ||||||||
| 5444 | 5444 | PRJNA800053_CONTIG_21604|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 | Zebrafish jaw poxvirus | Novel | PRJNA800053_CONTIG_21604|Carp_edema_virus | PRJNA800053_CONTIG_21604 | Carp edema virus | 4680 | 143 | 36 | CLUSTER2_Carp_edema_virus|553|75 | LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome | 552 | 75 | PRJNA800053 | 21604 | 244 | 1.426901 | 3.48163844 | Carp edema virus | 1653087 | Viruses | Viruses | 64.7 | 5.22e-10 | Carp edema virus | Non-phage | NR | PRJNA800053_P_NODE_21604_length_244_cov_1.426901_g21440_i0 | BCT22608.1 poly(A)-polymerase small subunit VP39 PAPS [Carp edema virus] | BCT22608.1 | 1653087 | g21440 | i0 | 53.8 | 0.639344262 | 52 | 24 | 63.9 | 0 | 187 | 32 | 10 | 61 | 156 | 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 | 5.22e-10 | ||||||||
| 5819 | 5819 | PRJNA800053_CONTIG_17350|Carp_edema_virus|CLUSTER3_Carp_edema_virus|359|69 | Zebrafish jaw poxvirus | Novel | PRJNA800053_CONTIG_17350|Carp_edema_virus | PRJNA800053_CONTIG_17350 | 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 | PRJNA800053 | 17350 | 251 | 1.011236 | 2.53820236 | Carp edema virus | 1653087 | Viruses | Viruses | 52.8 | 1.24e-05 | Carp edema virus | Non-phage | NR | PRJNA800053_P_NODE_17350_length_251_cov_1.011236_g17186_i0 | BCT22717.1 B22R family protein [Carp edema virus] | BCT22717.1 | 1653087 | g17186 | i0 | 36.7 | 0.944223108 | 79 | 40 | 89.6 | 3 | 230 | 6 | 999 | 1071 | 237 | 52.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 | 52.8 | 1.24e-05 | ||||||||
| 6175 | 6175 | PRJNA800053_CONTIG_21742|Carp_edema_virus|CLUSTER4_Carp_edema_virus|348|78 | Zebrafish jaw poxvirus | Novel | PRJNA800053_CONTIG_21742|Carp_edema_virus | PRJNA800053_CONTIG_21742 | 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 | PRJNA800053 | 21742 | 244 | 0.900585 | 2.1974274 | Carp edema virus | 1653087 | Viruses | Viruses | 55.1 | 1.65e-06 | Carp edema virus | Non-phage | NR | PRJNA800053_P_NODE_21742_length_244_cov_0.900585_g21578_i0 | BCT22585.1 hypothetical protein [Carp edema virus] | BCT22585.1 | 1653087 | g21578 | i0 | 34.9 | 1.020491803 | 83 | 51 | 98.4 | 1 | 4 | 243 | 132 | 214 | 249 | 55.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 | 55.1 | 1.65e-06 | ||||||||
| 6655 | 6655 | PRJNA800053_CONTIG_9304|Carp_edema_virus|CLUSTER6_Carp_edema_virus|274|111 | Zebrafish jaw poxvirus | Novel | PRJNA800053_CONTIG_9304|Carp_edema_virus | PRJNA800053_CONTIG_9304 | 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 | PRJNA800053 | 9304 | 316 | 2.288066 | 7.23028856 | Carp edema virus | 1653087 | Viruses | Viruses | 73.2 | 1.21e-12 | Carp edema virus | Non-phage | NR | PRJNA800053_P_NODE_9304_length_316_cov_2.288066_g9140_i0 | BCT22626.1 putative DNA-binding virion core protein [Carp edema virus] | BCT22626.1 | 1653087 | g9140 | i0 | 39.2 | 0.96835443 | 102 | 61 | 96.8 | 1 | 314 | 9 | 179 | 279 | 306 | 73.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 | 73.2 | 1.21e-12 | ||||||||
| 7589 | 7589 | PRJNA800053_CONTIG_21278|Carp_edema_virus|CLUSTER11_Carp_edema_virus|185|63 | Zebrafish jaw poxvirus | Novel | PRJNA800053_CONTIG_21278|Carp_edema_virus | PRJNA800053_CONTIG_21278 | 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 | PRJNA800053 | 21278 | 245 | 0.895349 | 2.19360505 | Carp edema virus | 1653087 | Viruses | Viruses | 86.7 | 1.34e-17 | Carp edema virus | Non-phage | NR | PRJNA800053_P_NODE_21278_length_245_cov_0.895349_g21114_i0 | BCT22731.1 mRNA capping enzyme large subunit [Carp edema virus] | BCT22731.1 | 1653087 | g21114 | i0 | 51.3 | 0.955102041 | 78 | 37 | 95.5 | 1 | 9 | 242 | 293 | 369 | 234 | 86.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 | 86.7 | 1.34e-17 | ||||||||
| 7901 | 7901 | PRJNA800053_CONTIG_1791|Carp_edema_virus|CLUSTER13_Carp_edema_virus|165|64 | Zebrafish jaw poxvirus | Novel | PRJNA800053_CONTIG_1791|Carp_edema_virus | PRJNA800053_CONTIG_1791 | Carp edema virus | 4680 | 143 | 36 | CLUSTER13_Carp_edema_virus|165|64 | PRJNA1075480_S_NODE_19_length_10478_cov_35.577415_g8_i0|Carp_edema_virus|NR|1.04e-246|NA | 165 | 64 | PRJNA800053 | 1791 | 625 | 1.692029 | 10.57518125 | Carp edema virus | 1653087 | Viruses | Viruses | 78.6 | 2.91e-14 | Carp edema virus | Non-phage | NR | PRJNA800053_P_NODE_1791_length_625_cov_1.692029_g1637_i0 | BCT22600.1 hypothetical protein [Carp edema virus] | BCT22600.1 | 1653087 | g1637 | i0 | 36.1 | 0.6384 | 133 | 81 | 62.9 | 3 | 417 | 25 | 47 | 177 | 399 | 78.6 | 1.0 | Viruses | Varidnaviria | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Carp edema virus | Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus | Ananas comosus | Carp edema virus | gi|1885270526|emb|LR862145.1| | Plants | Viruses | Plants | Viruses | 54.7 | 78.6 | 0.017 | 2.91e-14 | ||
| 8026 | 8026 | PRJNA800053_CONTIG_2323|African_cichlid_piscichuvirus|CLUSTER1_African_cichlid_piscichuvirus|150|125 | African cichlid piscichuvirus | Endogenous or not fish-associated | PRJNA800053_CONTIG_2323|African_cichlid_piscichuvirus | PRJNA800053_CONTIG_2323 | African cichlid piscichuvirus | 151 | 125 | 2 | CLUSTER1_African_cichlid_piscichuvirus|150|125 | PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0|African_cichlid_piscichuvirus|NR|2.83e-43|NA | 150 | 125 | PRJNA800053 | 2323 | 565 | 2.894309 | 16.35284585 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 92.0 | 8.18e-18 | African cichlid piscichuvirus | Non-phage | NR | PRJNA800053_P_NODE_2323_length_565_cov_2.894309_g2166_i0 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | WLN26256.1 | 3065075 | g2166 | i0 | 50.0 | 0.488495575 | 92 | 46 | 48.8 | 0 | 264 | 539 | 229 | 320 | 276 | 92.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus | African cichlid piscichuvirus | Viruses | Viruses | 92.0 | 8.18e-18 | |||||||
| 8722 | 8722 | PRJNA800053_CONTIG_8368|Carp_edema_virus|CLUSTER16_Carp_edema_virus|89|60 | Zebrafish jaw poxvirus | Novel | PRJNA800053_CONTIG_8368|Carp_edema_virus | PRJNA800053_CONTIG_8368 | 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 | PRJNA800053 | 8368 | 330 | 2.478599 | 8.1793767 | Carp edema virus | 1653087 | Viruses | Viruses | 66.2 | 7.35e-11 | Carp edema virus | Non-phage | NR | PRJNA800053_P_NODE_8368_length_330_cov_2.478599_g8204_i0 | BCT22744.1 hypothetical protein [Carp edema virus] | BCT22744.1 | 1653087 | g8204 | i0 | 63.5 | 0.472727273 | 52 | 19 | 47.3 | 0 | 328 | 173 | 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 | 7.35e-11 | ||||||||
| 9785 | 9785 | PRJNA800053_CONTIG_926|Fish-associated_parvo-like_hybrid_virus|CLUSTER1_Fish-associated_parvo-like_hybrid_virus|21|14 | Fish-associated parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_926|Fish-associated_parvo-like_hybrid_virus | PRJNA800053_CONTIG_926 | Fish-associated parvo-like hybrid virus | 35 | 19 | 4 | CLUSTER1_Fish-associated_parvo-like_hybrid_virus|21|14 | MT138265_1_MAG_Nicoomyvirus_lizumae_isolate_par077par1_genomic_sequence | 21 | 14 | PRJNA800053 | 926 | 813 | 5.85 | 47.5605 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 1469.0 | 0.0 | Fish-associated parvo-like hybrid virus | Non-phage | NTclustered | PRJNA800053_P_NODE_926_length_813_cov_5.850000_g799_i0 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | gi|2413975758|gb|OP933682.1| | 3003968 | g799 | i0 | 99.262 | 8.18696187 | 813 | 6 | 100.0 | 0 | 1 | 813 | 961 | 1773 | 6656 | 1469.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus | Fish-associated parvo-like hybrid virus | Parvo-like hybrid virus UC4 | gi|2413975758|gb|OP933682.1| | Viruses | Viruses | Viruses | Viruses | 1469.0 | 530.0 | 0.0 | 8.689999999999999e-188 | ||
| 9954 | 9954 | PRJNA800053_CONTIG_1555|Shotokuvirae|CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | Fish-associated parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_1555|Shotokuvirae | PRJNA800053_CONTIG_1555 | Fish-associated parvo-like hybrid virus | 35 | 19 | 4 | CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA | 14 | 7 | PRJNA800053 | 1555 | 659 | 3.387372 | 22.32278148 | Shotokuvirae | 2732092 | Viruses | Viruses | 278.0 | 1.7399999999999998e-89 | Shotokuvirae | Non-phage | NR | PRJNA800053_P_NODE_1555_length_659_cov_3.387372_g1407_i0 | AGV22413.1 replication protein [Parvo-like hybrid virus UC9] | AGV22413.1 | 1395620 | g1407 | i0 | 71.3 | 3.268588771 | 181 | 51 | 82.4 | 1 | 619 | 77 | 3 | 182 | 2154 | 278.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Nicoomyvirus moldensis | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus | Shotokuvirae | Viruses | Viruses | 278.0 | 1.7399999999999998e-89 | ||||||||||||
| 9962 | 9962 | PRJNA800053_CONTIG_5510|Fish-associated_parvo-like_hybrid_virus|CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | Fish-associated parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_5510|Fish-associated_parvo-like_hybrid_virus | PRJNA800053_CONTIG_5510 | Fish-associated parvo-like hybrid virus | 35 | 19 | 4 | CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA | 14 | 7 | PRJNA800053 | 5510 | 390 | 2.596215 | 10.1252385 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 472.0 | 2.41e-128 | Fish-associated parvo-like hybrid virus | Non-phage | NTclustered | PRJNA800053_P_NODE_5510_length_390_cov_2.596215_g5347_i0 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | gi|2413975758|gb|OP933682.1| | 3003968 | g5347 | i0 | 98.864 | 1.987179487 | 264 | 3 | 100.0 | 0 | 1 | 264 | 956 | 693 | 775 | 472.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus | Fish-associated parvo-like hybrid virus | Grus japonensis parvo-like hybrid virus | gi|2413975758|gb|OP933682.1| | Viruses | Viruses | Viruses | Viruses | 472.0 | 68.2 | 2.41e-128 | 2.07e-10 | ||
| 9963 | 9963 | PRJNA800053_CONTIG_10244|Fish-associated_parvo-like_hybrid_virus|CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | Fish-associated parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_10244|Fish-associated_parvo-like_hybrid_virus | PRJNA800053_CONTIG_10244 | Fish-associated parvo-like hybrid virus | 35 | 19 | 4 | CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA | 14 | 7 | PRJNA800053 | 10244 | 305 | 1.413793 | 4.31206865 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 564.0 | 2.95e-156 | Fish-associated parvo-like hybrid virus | Non-phage | NTclustered | PRJNA800053_P_NODE_10244_length_305_cov_1.413793_g10080_i0 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | gi|2413975758|gb|OP933682.1| | 3003968 | g10080 | i0 | 100.0 | 1.0 | 305 | 0 | 100.0 | 0 | 1 | 305 | 3114 | 2810 | 305 | 564.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus | Fish-associated parvo-like hybrid virus | Fish-associated parvo-like hybrid virus | gi|2413975758|gb|OP933682.1| | Viruses | Viruses | Viruses | Viruses | 564.0 | 171.0 | 2.95e-156 | 3.52e-50 | ||
| 9964 | 9964 | PRJNA800053_CONTIG_10647|Fish-associated_parvo-like_hybrid_virus|CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | Fish-associated parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_10647|Fish-associated_parvo-like_hybrid_virus | PRJNA800053_CONTIG_10647 | Fish-associated parvo-like hybrid virus | 35 | 19 | 4 | CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA | 14 | 7 | PRJNA800053 | 10647 | 300 | 1.933921 | 5.801763 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 457.0 | 5.06e-124 | Fish-associated parvo-like hybrid virus | Non-phage | NTclustered | PRJNA800053_P_NODE_10647_length_300_cov_1.933921_g10483_i0 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | gi|2413975758|gb|OP933682.1| | 3003968 | g10483 | i0 | 94.295 | 0.993333333 | 298 | 17 | 99.0 | 0 | 1 | 298 | 2815 | 2518 | 298 | 457.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus | Fish-associated parvo-like hybrid virus | Fish-associated parvo-like hybrid virus | gi|2413975758|gb|OP933682.1| | Viruses | Viruses | Viruses | Viruses | 457.0 | 207.0 | 5.06e-124 | 2.3200000000000002e-64 | ||
| 9965 | 9965 | PRJNA800053_CONTIG_12375|Nicoomyvirus_moldensis|CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | Fish-associated parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_12375|Nicoomyvirus_moldensis | PRJNA800053_CONTIG_12375 | Fish-associated parvo-like hybrid virus | 35 | 19 | 4 | CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA | 14 | 7 | PRJNA800053 | 12375 | 284 | 1.819905 | 5.1685302 | Nicoomyvirus moldensis | 3431103 | Viruses | Viruses | 359.0 | 1.38e-94 | Nicoomyvirus moldensis | Non-phage | NTclustered | PRJNA800053_P_NODE_12375_length_284_cov_1.819905_g12211_i0 | MAG: Parvo-like hybrid virus UC4 isolate par077par1 genomic sequence | gi|1836405723|gb|MT138265.1| | 1395615 | g12211 | i0 | 89.474 | 1.003521127 | 285 | 28 | 100.0 | 2 | 1 | 284 | 1897 | 1614 | 285 | 359.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Nicoomyvirus moldensis | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus | Nicoomyvirus moldensis | Parvo-like hybrid virus UC4 | gi|1836405723|gb|MT138265.1| | Viruses | Viruses | Viruses | Viruses | 359.0 | 175.0 | 1.38e-94 | 2.49e-51 | |
| 9969 | 9969 | PRJNA800053_CONTIG_24906|Fish-associated_parvo-like_hybrid_virus|CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | Fish-associated parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_24906|Fish-associated_parvo-like_hybrid_virus | PRJNA800053_CONTIG_24906 | Fish-associated parvo-like hybrid virus | 35 | 19 | 4 | CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 | PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA | 14 | 7 | PRJNA800053 | 24906 | 226 | 3.673203 | 8.30143878 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 298.0 | 2.34e-76 | Fish-associated parvo-like hybrid virus | Non-phage | NTclustered | PRJNA800053_P_NODE_24906_length_226_cov_3.673203_g24742_i0 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | gi|2413975758|gb|OP933682.1| | 3003968 | g24742 | i0 | 90.95 | 0.977876106 | 221 | 20 | 98.0 | 0 | 4 | 224 | 2508 | 2288 | 221 | 298.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus | Fish-associated parvo-like hybrid virus | Fish-associated parvo-like hybrid virus | gi|2413975758|gb|OP933682.1| | Viruses | Viruses | Viruses | Viruses | 298.0 | 147.0 | 2.34e-76 | 2.23e-41 | ||
| 10043 | 10043 | PRJNA800053_CONTIG_21839|Psittaciform_aveparvovirus|CLUSTER1_Psittaciform_aveparvovirus|12|7 | Psittaciform aveparvovirus | Endogenous or not fish-associated | PRJNA800053_CONTIG_21839|Psittaciform_aveparvovirus | PRJNA800053_CONTIG_21839 | Psittaciform aveparvovirus | 19 | 12 | 2 | CLUSTER1_Psittaciform_aveparvovirus|12|7 | OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome | 12 | 7 | PRJNA800053 | 21839 | 244 | 0.900585 | 2.1974274 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 329.0 | 9.080000000000001e-86 | Psittaciform aveparvovirus | Non-phage | NTclustered | PRJNA800053_P_NODE_21839_length_244_cov_0.900585_g21675_i0 | Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome | gi|2496529060|gb|OP577480.1| | 3042447 | g21675 | i0 | 91.322 | 0.991803279 | 242 | 19 | 99.0 | 2 | 4 | 244 | 1965 | 2205 | 242 | 329.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittaciform aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus | Psittaciform aveparvovirus | Psittaciform aveparvovirus | gi|2496529060|gb|OP577480.1| | Viruses | Viruses | Viruses | Viruses | 329.0 | 158.0 | 9.080000000000001e-86 | 2.3e-45 | |
| 10068 | 10068 | PRJNA800053_CONTIG_7218|parvo-like_hybrid_virus|CLUSTER2_Psittaciform_aveparvovirus|11|8 | Psittaciform aveparvovirus | Endogenous or not fish-associated | PRJNA800053_CONTIG_7218|parvo-like_hybrid_virus | PRJNA800053_CONTIG_7218 | Psittaciform aveparvovirus | 19 | 12 | 2 | CLUSTER2_Psittaciform_aveparvovirus|11|8 | PRJNA642647_P_NODE_4_length_3343_cov_14.130067_g3_i0|Psittaciform_aveparvovirus|NTclustered|0|NA | 11 | 8 | PRJNA800053 | 7218 | 351 | 1.097122 | 3.85089822 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 436.0 | 7.8400000000000005e-118 | parvo-like hybrid virus | Non-phage | NTclustered | PRJNA800053_P_NODE_7218_length_351_cov_1.097122_g7054_i0 | Parvo-like hybrid virus isolate SpinColumn05, partial genome | gi|2814138511|gb|PQ313120.1| | 3367306 | g7054 | i0 | 99.174 | 2.01994302 | 242 | 2 | 69.0 | 0 | 109 | 350 | 2881 | 2640 | 709 | 436.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus | parvo-like hybrid virus | Phoenicopteridae parvo-like hybrid virus | gi|2814138511|gb|PQ313120.1| | Viruses | Viruses | Viruses | Viruses | 436.0 | 160.0 | 7.8400000000000005e-118 | 2.37e-44 | ||
| 10139 | 10139 | PRJNA800053_CONTIG_21524|Fish-associated_parvo-like_virus|CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus|7|3 | Luscinia sibilans parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_21524|Fish-associated_parvo-like_virus | PRJNA800053_CONTIG_21524 | Luscinia sibilans parvo-like hybrid virus | 8 | 5 | 4 | CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus|7|3 | OP933679_1_MAG_Fish_associated_parvo_like_virus_isolate_fi099par1_genomic_sequence_sequence | 7 | 3 | PRJNA800053 | 21524 | 244 | 2.146199 | 5.23672556 | Fish-associated parvo-like virus | 3003969 | Viruses | Viruses | 429.0 | 8.699999999999999e-116 | Fish-associated parvo-like virus | Non-phage | NTclustered | PRJNA800053_P_NODE_21524_length_244_cov_2.146199_g21360_i0 | MAG: Fish-associated parvo-like virus isolate fi099par1 genomic sequence, sequence | gi|2416706441|gb|OP933679.1| | 3003969 | g21360 | i0 | 99.16 | 1.950819672 | 238 | 2 | 98.0 | 0 | 4 | 241 | 1027 | 790 | 476 | 429.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Luscinia sibilans parvo-like hybrid virus | Fish-associated parvo-like virus | parvo-like hybrid virus | gi|2416706441|gb|OP933679.1| | Viruses | Viruses | Viruses | Viruses | 429.0 | 140.0 | 8.699999999999999e-116 | 1.06e-37 | ||
| 10140 | 10140 | PRJNA800053_CONTIG_24367|parvo-like_hybrid_virus|CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus|7|3 | Luscinia sibilans parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_24367|parvo-like_hybrid_virus | PRJNA800053_CONTIG_24367 | Luscinia sibilans parvo-like hybrid virus | 8 | 5 | 4 | CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus|7|3 | OP933679_1_MAG_Fish_associated_parvo_like_virus_isolate_fi099par1_genomic_sequence_sequence | 7 | 3 | PRJNA800053 | 24367 | 235 | 6.759259 | 15.88425865 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 418.0 | 1.8e-112 | parvo-like hybrid virus | Non-phage | NTclustered | PRJNA800053_P_NODE_24367_length_235_cov_6.759259_g24203_i0 | Parvo-like hybrid virus isolate SpinColumn11, partial genome | gi|2814138527|gb|PQ313126.1| | 3367306 | g24203 | i0 | 99.563 | 1.94893617 | 229 | 1 | 97.0 | 0 | 4 | 232 | 1136 | 1364 | 458 | 418.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Luscinia sibilans parvo-like hybrid virus | parvo-like hybrid virus | parvo-like hybrid virus | gi|2814138527|gb|PQ313126.1| | Viruses | Viruses | Viruses | Viruses | 418.0 | 128.0 | 1.8e-112 | 3.18e-33 | ||
| 10141 | 10141 | PRJNA800053_CONTIG_25208|Fish-associated_parvo-like_virus|CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus|7|3 | Luscinia sibilans parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_25208|Fish-associated_parvo-like_virus | PRJNA800053_CONTIG_25208 | Luscinia sibilans parvo-like hybrid virus | 8 | 5 | 4 | CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus|7|3 | OP933679_1_MAG_Fish_associated_parvo_like_virus_isolate_fi099par1_genomic_sequence_sequence | 7 | 3 | PRJNA800053 | 25208 | 206 | 4.067669 | 8.37939814 | Fish-associated parvo-like virus | 3003969 | Viruses | Viruses | 322.0 | 1.24e-83 | Fish-associated parvo-like virus | Non-phage | NTclustered | PRJNA800053_P_NODE_25208_length_206_cov_4.067669_g25044_i0 | MAG: Fish-associated parvo-like virus isolate fi099par1 genomic sequence, sequence | gi|2416706441|gb|OP933679.1| | 3003969 | g25044 | i0 | 94.811 | 1.029126214 | 212 | 2 | 99.0 | 1 | 4 | 206 | 2938 | 2727 | 212 | 322.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Luscinia sibilans parvo-like hybrid virus | Fish-associated parvo-like virus | Fish-associated parvo-like virus | gi|2416706441|gb|OP933679.1| | Viruses | Viruses | Viruses | Viruses | 322.0 | 119.0 | 1.24e-83 | 1.37e-29 | ||
| 10261 | 10261 | PRJNA800053_CONTIG_14866|Phoenicopterus_roseus_parvo-like_hybrid_virus|CLUSTER1_Phoenicopterus_roseus_parvo-like_hybrid_virus|2|2 | Phoenicopterus roseus parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA800053_CONTIG_14866|Phoenicopterus_roseus_parvo-like_hybrid_virus | PRJNA800053_CONTIG_14866 | Phoenicopterus roseus parvo-like hybrid virus | 3 | 2 | 2 | CLUSTER1_Phoenicopterus_roseus_parvo-like_hybrid_virus|2|2 | PRJNA800053_P_NODE_14866_length_266_cov_1.585492_g14702_i0|Phoenicopterus_roseus_parvo-like_hybrid_virus|NR|5.02e-11|NA | 2 | 2 | PRJNA800053 | 14866 | 266 | 1.585492 | 4.21740872 | Phoenicopterus roseus parvo-like hybrid virus | 2794530 | Viruses | Viruses | 68.2 | 5.02e-11 | Phoenicopterus roseus parvo-like hybrid virus | Non-phage | NR | PRJNA800053_P_NODE_14866_length_266_cov_1.585492_g14702_i0 | QTE03705.1 MAG: capsid protein, partial [Phoenicopterus roseus parvo-like hybrid virus] | QTE03705.1 | 2794530 | g14702 | i0 | 39.5 | 0.969924812 | 86 | 52 | 97.0 | 0 | 5 | 262 | 273 | 358 | 258 | 68.2 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Phoenicopterus roseus parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Phoenicopterus roseus parvo-like hybrid virus | Phoenicopterus roseus parvo-like hybrid virus | Viruses | Viruses | 68.2 | 5.02e-11 |
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);;