RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

18 rows where Category = "Endogenous or not fish-associated" and clusterLCA_curated = "Psittacidae aveparvovirus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_genus_NTorNR 1

tax_family_NTorNR 1

clusterLCA_curated 1

  • Psittacidae aveparvovirus · 18 ✖

Category 1

  • Endogenous or not fish-associated · 18 ✖
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
9886 9886 PRJNA283169_CONTIG_31|parvo-like_hybrid_virus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA283169_CONTIG_31|parvo-like_hybrid_virus PRJNA283169_CONTIG_31 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA283169 31 1982 12.799793 253.6918973 parvo-like hybrid virus 3367306 Viruses Viruses 1162.0 0.0 parvo-like hybrid virus Non-phage NTclustered PRJNA283169_P_NODE_31_length_1982_cov_12.799793_g23_i0   Parvo-like hybrid virus isolate SpinColumn12, partial genome gi|2814138529|gb|PQ313127.1| 3367306 g23 i0 92.839 1.594349142 796 56 78.0 1 970 1764 796 1 3160 1162.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus parvo-like hybrid virus Psittacidae aveparvovirus gi|2814138529|gb|PQ313127.1| Viruses Viruses Viruses Viruses 1162.0 231.0 0.0 3.5699999999999996e-68
9891 9891 PRJNA283169_CONTIG_128|parvo-like_hybrid_virus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA283169_CONTIG_128|parvo-like_hybrid_virus PRJNA283169_CONTIG_128 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA283169 128 695 1.243034 8.6390863 parvo-like hybrid virus 3367306 Viruses Viruses 987.0 0.0 parvo-like hybrid virus Non-phage NTclustered PRJNA283169_S_NODE_128_length_695_cov_1.243034_g117_i0   Parvo-like hybrid virus isolate SpinColumn12, partial genome gi|2814138529|gb|PQ313127.1| 3367306 g117 i0 92.086 1.945323741 695 55 100.0 0 1 695 64 758 1352 987.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus parvo-like hybrid virus Psittacidae aveparvovirus gi|2814138529|gb|PQ313127.1| Viruses Viruses Viruses Viruses 987.0 207.0 0.0 4.9e-64
9892 9892 PRJNA283169_CONTIG_132|parvo-like_hybrid_virus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA283169_CONTIG_132|parvo-like_hybrid_virus PRJNA283169_CONTIG_132 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA283169 132 1119 5.658879 63.32285601 parvo-like hybrid virus 3367306 Viruses Viruses 1221.0 0.0 parvo-like hybrid virus Non-phage NTclustered PRJNA283169_P_NODE_132_length_1119_cov_5.658879_g94_i0   Parvo-like hybrid virus isolate SpinColumn12, partial genome gi|2814138529|gb|PQ313127.1| 3367306 g94 i0 91.705 1.574620197 880 73 79.0 0 1 880 1177 2056 1762 1221.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus parvo-like hybrid virus Psittacidae aveparvovirus gi|2814138529|gb|PQ313127.1| Viruses Viruses Viruses Viruses 1221.0 395.0 0.0 1.15e-132
9895 9895 PRJNA283169_CONTIG_388|parvo-like_hybrid_virus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA283169_CONTIG_388|parvo-like_hybrid_virus PRJNA283169_CONTIG_388 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA283169 388 400 0.683761 2.735044 parvo-like hybrid virus 3367306 Viruses Viruses 152.0 3.6700000000000005e-32 parvo-like hybrid virus Non-phage NTclustered PRJNA283169_S_NODE_388_length_400_cov_0.683761_g374_i0   Parvo-like hybrid virus isolate SpinColumn12, partial genome gi|2814138529|gb|PQ313127.1| 3367306 g374 i0 95.652 0.23 92 4 23.0 0 292 383 1 92 92 152.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus parvo-like hybrid virus Psittacidae aveparvovirus gi|2814138529|gb|PQ313127.1| Viruses Viruses Viruses Viruses 152.0 47.0 3.6700000000000005e-32 0.00372
9905 9905 PRJNA283169_CONTIG_1049|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA283169_CONTIG_1049|Psittacidae_aveparvovirus PRJNA283169_CONTIG_1049 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA283169 1049 260 0.132701 0.3450226 Psittacidae aveparvovirus 2794556 Viruses Viruses 152.0 1.06e-41 Psittacidae aveparvovirus Non-phage NR PRJNA283169_S_NODE_1049_length_260_cov_0.132701_g1035_i0   QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus] QTE03752.1 2794556 g1035 i0 82.4 0.980769231 85 15 98.1 0 5 259 334 418 255 152.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus   Psittacidae aveparvovirus     Viruses   Viruses   152.0   1.06e-41
9909 9909 PRJNA283169_CONTIG_2156|parvo-like_hybrid_virus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA283169_CONTIG_2156|parvo-like_hybrid_virus PRJNA283169_CONTIG_2156 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA283169 2156 279 1.304348 3.63913092 parvo-like hybrid virus 3367306 Viruses Viruses 486.0 5.94e-133 parvo-like hybrid virus Non-phage NTclustered PRJNA283169_P_NODE_2156_length_279_cov_1.304348_g2094_i0   Parvo-like hybrid virus isolate SpinColumn12, partial genome gi|2814138529|gb|PQ313127.1| 3367306 g2094 i0 98.201 1.996415771 278 5 99.0 0 1 278 848 1125 557 486.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus parvo-like hybrid virus Psittacidae aveparvovirus gi|2814138529|gb|PQ313127.1| Viruses Viruses Viruses Viruses 486.0 187.0 5.94e-133 4.29e-56
9912 9912 PRJNA784979_CONTIG_3690|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA784979_CONTIG_3690|Psittacidae_aveparvovirus PRJNA784979_CONTIG_3690 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA784979 3690 242 1.948187 4.71461254 Psittacidae aveparvovirus 2794556 Viruses Viruses 327.0 3.23e-85 Psittacidae aveparvovirus Non-phage NTclustered PRJNA784979_S_NODE_3690_length_242_cov_1.948187_g3648_i0   MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence gi|2015372674|gb|MW046380.1| 2794556 g3648 i0 91.561 1.946280992 237 20 98.0 0 6 242 1647 1883 471 327.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus Psittacidae aveparvovirus Psittacidae aveparvovirus gi|2015372674|gb|MW046380.1| Viruses Viruses Viruses Viruses 327.0 159.0 3.23e-85 3.87e-45
9913 9913 PRJNA407368_CONTIG_4786|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA407368_CONTIG_4786|Psittacidae_aveparvovirus PRJNA407368_CONTIG_4786 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA407368 4786 257 3.061404 7.86780828 Psittacidae aveparvovirus 2794556 Viruses Viruses 263.0 9.92e-66 Psittacidae aveparvovirus Non-phage NTclustered PRJNA407368_S_NODE_4786_length_257_cov_3.061404_g4684_i0   MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence gi|2015372674|gb|MW046380.1| 2794556 g4684 i0 94.675 0.929961089 169 9 92.0 0 21 189 681 513 239 263.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus Psittacidae aveparvovirus Psittacidae aveparvovirus gi|2015372674|gb|MW046380.1| Viruses Viruses Viruses Viruses 263.0 104.0 9.92e-66 9.870000000000001e-26
9919 9919 PRJNA407368_CONTIG_7698|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA407368_CONTIG_7698|Psittacidae_aveparvovirus PRJNA407368_CONTIG_7698 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA407368 7698 186 2.382166 4.43082876 Psittacidae aveparvovirus 2794556 Viruses Viruses 289.0 1.11e-73 Psittacidae aveparvovirus Non-phage NTclustered PRJNA407368_S_NODE_7698_length_186_cov_2.382166_g7596_i0   MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence gi|2015372674|gb|MW046380.1| 2794556 g7596 i0 94.624 1.0 186 10 100.0 0 1 186 469 284 186 289.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus Psittacidae aveparvovirus Psittacidae aveparvovirus gi|2015372674|gb|MW046380.1| Viruses Viruses Viruses Viruses 289.0 112.0 1.11e-73 2.62e-29
9926 9926 PRJNA309466_CONTIG_15363|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA309466_CONTIG_15363|Psittacidae_aveparvovirus PRJNA309466_CONTIG_15363 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA309466 15363 169 3.391667 5.73191723 Psittacidae aveparvovirus 2794556 Viruses Viruses 254.0 3.6e-63 Psittacidae aveparvovirus Non-phage NTclustered PRJNA309466_P_NODE_15363_length_169_cov_3.391667_g15306_i0   MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence gi|2015372674|gb|MW046380.1| 2794556 g15306 i0 94.545 0.976331361 165 8 98.0 1 1 165 817 654 165 254.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus Psittacidae aveparvovirus Psittacidae aveparvovirus gi|2015372674|gb|MW046380.1| Viruses Viruses Viruses Viruses 254.0 84.7 3.6e-63 1.33e-18
9930 9930 PRJNA474426_CONTIG_20814|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA474426_CONTIG_20814|Psittacidae_aveparvovirus PRJNA474426_CONTIG_20814 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA474426 20814 218 2.763314 6.02402452 Psittacidae aveparvovirus 2794556 Viruses Viruses 248.0 2.29e-61 Psittacidae aveparvovirus Non-phage NTclustered PRJNA474426_P_NODE_20814_length_218_cov_2.763314_g20609_i0   MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence gi|2015372674|gb|MW046380.1| 2794556 g20609 i0 87.215 1.004587156 219 26 100.0 2 1 218 1536 1753 219 248.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus Psittacidae aveparvovirus Psittacidae aveparvovirus gi|2015372674|gb|MW046380.1| Viruses Viruses Viruses Viruses 248.0 140.0 2.29e-61 4.96e-38
9937 9937 PRJNA558770_CONTIG_41702|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA558770_CONTIG_41702|Psittacidae_aveparvovirus PRJNA558770_CONTIG_41702 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA558770 41702 329 8.064626 26.53261954 Psittacidae aveparvovirus 2794556 Viruses Viruses 440.0 5.66e-119 Psittacidae aveparvovirus Non-phage NTclustered PRJNA558770_P_NODE_41702_length_329_cov_8.064626_g39704_i0   MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence gi|2015372674|gb|MW046380.1| 2794556 g39704 i0 91.562 0.972644377 320 25 97.0 2 1 319 347 29 320 440.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus Psittacidae aveparvovirus   gi|2015372674|gb|MW046380.1| Viruses   Viruses   440.0   5.66e-119  
9943 9943 PRJNA558770_CONTIG_192780|parvo-like_hybrid_virus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA558770_CONTIG_192780|parvo-like_hybrid_virus PRJNA558770_CONTIG_192780 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA558770 192780 234 4.070352 9.52462368 parvo-like hybrid virus 3367306 Viruses Viruses 134.0 7.28e-27 parvo-like hybrid virus Non-phage NTclustered PRJNA558770_P_NODE_192780_length_234_cov_4.070352_g190775_i0   Parvo-like hybrid virus isolate SpinColumn12, partial genome gi|2814138529|gb|PQ313127.1| 3367306 g190775 i0 98.649 0.786324786 74 1 64.0 0 1 74 443 370 184 134.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus parvo-like hybrid virus   gi|2814138529|gb|PQ313127.1| Viruses   Viruses   134.0   7.28e-27  
10217 10217 PRJNA630162_CONTIG_16732|Psittacidae_aveparvovirus|CLUSTER2_Psittacidae_aveparvovirus|3|3 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA630162_CONTIG_16732|Psittacidae_aveparvovirus PRJNA630162_CONTIG_16732 Psittacidae aveparvovirus 18 10 4 CLUSTER2_Psittacidae_aveparvovirus|3|3 PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0|Psittacidae_aveparvovirus|NR|1.21e-18|NA 3 3 PRJNA630162 16732 457 2.938725 13.42997325 Psittacidae aveparvovirus 2794556 Viruses Viruses 92.0 1.21e-18 Psittacidae aveparvovirus Non-phage NR PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0   QTE03751.1 MAG: replication protein [Psittacidae aveparvovirus] QTE03751.1 2794556 g15229 i0 39.3 0.800875274 122 58 78.1 3 97 453 16 124 366 92.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus   Psittacidae aveparvovirus     Viruses   Viruses   92.0   1.21e-18
10218 10218 PRJNA312107_CONTIG_25980|Psittaciform_aveparvovirus|CLUSTER2_Psittacidae_aveparvovirus|3|3 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA312107_CONTIG_25980|Psittaciform_aveparvovirus PRJNA312107_CONTIG_25980 Psittacidae aveparvovirus 18 10 4 CLUSTER2_Psittacidae_aveparvovirus|3|3 PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0|Psittacidae_aveparvovirus|NR|1.21e-18|NA 3 3 PRJNA312107 25980 162 0.920354 1.49097348 Psittaciform aveparvovirus 3042447 Viruses Viruses 43.9 0.00498 Psittaciform aveparvovirus Non-phage NR PRJNA312107_P_NODE_25980_length_162_cov_0.920354_g25814_i0   WGL41068.1 replication protein [Psittaciform aveparvovirus] WGL41068.1 3042447 g25814 i0 37.0 1.0 54 26 94.4 2 156 4 9 57 162 43.9 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittaciform aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus   Psittaciform aveparvovirus     Viruses   Viruses   43.9   0.00498
10223 10223 PRJEB10140_CONTIG_118258|Parvoviridae_sp.|CLUSTER2_Psittacidae_aveparvovirus|3|3 Psittacidae aveparvovirus Endogenous or not fish-associated PRJEB10140_CONTIG_118258|Parvoviridae_sp. PRJEB10140_CONTIG_118258 Psittacidae aveparvovirus 18 10 4 CLUSTER2_Psittacidae_aveparvovirus|3|3 PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0|Psittacidae_aveparvovirus|NR|1.21e-18|NA 3 3 PRJEB10140 118258 309 2.111538 6.52465242 Parvoviridae sp. 1940570 Viruses Viruses 64.7 1.46e-09 Parvoviridae sp. Non-phage NR PRJEB10140_P_NODE_118258_length_309_cov_2.111538_g100952_i0   QKE54887.1 MAG: replication protein [Parvoviridae sp.] QKE54887.1 1940570 g100952 i0 37.4 1.922330097 99 55 94.2 3 300 10 70 163 594 64.7 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Parvoviridae sp. Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus   Parvoviridae sp.     Viruses   Viruses   64.7   1.46e-09
10311 10311 PRJNA489308_CONTIG_214|Psittacidae_aveparvovirus|CLUSTER3_Psittacidae_aveparvovirus|1|1 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA489308_CONTIG_214|Psittacidae_aveparvovirus PRJNA489308_CONTIG_214 Psittacidae aveparvovirus 18 10 4 CLUSTER3_Psittacidae_aveparvovirus|1|1 PRJNA489308_P_NODE_214_length_1473_cov_66.962857_g184_i0|Psittacidae_aveparvovirus|NR|1.74e-86|NA 1 1 PRJNA489308 214 1473 66.962857 986.3628836 Psittacidae aveparvovirus 2794556 Viruses Viruses 285.0 1.74e-86 Psittacidae aveparvovirus Non-phage NR PRJNA489308_P_NODE_214_length_1473_cov_66.962857_g184_i0   QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus] QTE03752.1 2794556 g184 i0 45.3 1.50509165 369 187 73.5 9 1110 28 165 526 2217 285.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus Flumine parvovirus 18 Psittacidae aveparvovirus gi|2235497426|gb|OM954002.1| Viruses Viruses Viruses Viruses 121.0 285.0 4.0900000000000002e-22 1.74e-86
10489 10489 PRJEB10140_CONTIG_251847|Psittacidae_aveparvovirus|CLUSTER4_Psittacidae_aveparvovirus|1|1 Psittacidae aveparvovirus Endogenous or not fish-associated PRJEB10140_CONTIG_251847|Psittacidae_aveparvovirus PRJEB10140_CONTIG_251847 Psittacidae aveparvovirus 18 10 4 CLUSTER4_Psittacidae_aveparvovirus|1|1 PRJEB10140_P_NODE_251847_length_168_cov_0.873950_g234538_i0|Psittacidae_aveparvovirus|NR|3.45e-16|NA 1 1 PRJEB10140 251847 168 0.87395 1.468236 Psittacidae aveparvovirus 2794556 Viruses Viruses 81.3 3.45e-16 Psittacidae aveparvovirus Non-phage NR PRJEB10140_P_NODE_251847_length_168_cov_0.873950_g234538_i0   QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus] QTE03752.1 2794556 g234538 i0 61.8 0.982142857 55 21 98.2 0 166 2 305 359 165 81.3 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus   Psittacidae aveparvovirus     Viruses   Viruses   81.3   3.45e-16

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