RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

24 rows where Category = "Endogenous or not fish-associated" and tax_species_NTorNR = "Adintovirus anguilla10665"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

  • Adintovirus anguilla10665 · 24 ✖

tax_family_NTorNR 1

clusterLCA_curated 1

Category 1

  • Endogenous or not fish-associated · 24 ✖

tax_genus_NTorNR 0

Link rowid ▼ contig_withLCA_withcluster clusterLCA_curated Category contig_withLCA shortcontigname clusterLCA clusterLCAcurated_contigcount clusterLCAcurated_bioprojectcount clusterLCAcurated_clustercount shortclustername cluster clustersize bioprojectsbycluster bioproject node length coverage rel_abundance taxname_lca_NTorNR taxid_lca_NTorNR taxoncategory_NTorNR taxoncategorysimple_NTorNR bits_NTorNR evalue_NTorNR viruscategory_NTorNR viruscategorysimple_NTorNR analysis_used contig_name lowcoverage_flag target_title_NTorNR target_NTorNR taxid_NTorNR gene_NTorNR allele_NTorNR pident_NTorNR sumperc_cov_NTorNR alnlen_NTorNR mismatch_NTorNR qcov_NTorNR gapopen_NTorNR qstart_NTorNR qend_NTorNR tstart_NTorNR tend_NTorNR sumalnlen_NTorNR maxbits_NTorNR bits_percmax_NTorNR tax_superkingdom_NTorNR tax_clade_NTorNR tax_kingdom_NTorNR tax_phylum_NTorNR tax_class_NTorNR tax_order_NTorNR tax_family_NTorNR tax_genus_NTorNR tax_species_NTorNR classification taxname_lca_NTclustered taxname_lca_NR target_NTclustered taxoncategory_NTclustered taxoncategory_NR taxoncategorysimple_NTclustered taxoncategorysimple_NR bits_NTclustered bits_NR evalue_NTclustered evalue_NR
9981 9981 PRJNA1105232_CONTIG_12917|Adintovirus_anguilla1|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1105232_CONTIG_12917|Adintovirus_anguilla1 PRJNA1105232_CONTIG_12917 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA1105232 12917 181 2.05303 3.7159843 Adintovirus anguilla1 3115889 Viruses Viruses 63.9 6.96e-11 Adintovirus anguilla1 Non-phage NR PRJNA1105232_S_NODE_12917_length_181_cov_2.053030_g12701_i0   DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] DBA49781.1 3115889 g12701 i0 62.2 0.745856354 45 17 74.6 0 171 37 7 51 135 63.9 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   63.9   6.96e-11
9982 9982 PRJNA973994_CONTIG_15055|Adintovirus_anguilla1|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA973994_CONTIG_15055|Adintovirus_anguilla1 PRJNA973994_CONTIG_15055 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA973994 15055 184 1.333333 2.45333272 Adintovirus anguilla1 3115889 Viruses Viruses 73.6 1.24e-14 Adintovirus anguilla1 Non-phage NR PRJNA973994_S_NODE_15055_length_184_cov_1.333333_g14943_i0   DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] DBA49781.1 3115889 g14943 i0 67.4 2.25 46 15 75.0 0 42 179 7 52 414 73.6 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   73.6   1.24e-14
9986 9986 PRJNA1150539_CONTIG_16621|Adintovirus_anguilla1|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1150539_CONTIG_16621|Adintovirus_anguilla1 PRJNA1150539_CONTIG_16621 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA1150539 16621 396 2.439628 9.66092688 Adintovirus anguilla1 3115889 Viruses Viruses 65.1 3.06e-10 Adintovirus anguilla1 Non-phage NR PRJNA1150539_S_NODE_16621_length_396_cov_2.439628_g16026_i0   DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] DBA49781.1 3115889 g16026 i0 62.2 0.340909091 45 17 34.1 0 269 135 7 51 135 65.1 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   65.1   3.06e-10
9989 9989 PRJNA1034995_CONTIG_20521|Adintovirus_anguilla1|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1034995_CONTIG_20521|Adintovirus_anguilla1 PRJNA1034995_CONTIG_20521 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA1034995 20521 376 5.393393 20.27915768 Adintovirus anguilla1 3115889 Viruses Viruses 116.0 2.4200000000000002e-29 Adintovirus anguilla1 Non-phage NR PRJNA1034995_S_NODE_20521_length_376_cov_5.393393_g20365_i0   DBA49780.1 MAG TPA_asm: Penton [Adintovirus anguilla10665] DBA49780.1 3115889 g20365 i0 60.5 0.686170213 86 34 68.6 0 35 292 154 239 258 116.0 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   116.0   2.4200000000000002e-29
9990 9990 PRJNA1200128_CONTIG_22740|Adintovirus_anguilla1|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1200128_CONTIG_22740|Adintovirus_anguilla1 PRJNA1200128_CONTIG_22740 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA1200128 22740 196 1.176471 2.30588316 Adintovirus anguilla1 3115889 Viruses Viruses 95.9 2.7e-23 Adintovirus anguilla1 Non-phage NR PRJNA1200128_S_NODE_22740_length_196_cov_1.176471_g22631_i0   DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] DBA49781.1 3115889 g22631 i0 67.2 1.959183673 64 21 98.0 0 192 1 7 70 384 95.9 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   95.9   2.7e-23
9994 9994 PRJNA1069776_CONTIG_54168|Adintovirus_anguilla1|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1069776_CONTIG_54168|Adintovirus_anguilla1 PRJNA1069776_CONTIG_54168 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA1069776 54168 151 2.222222 3.35555522 Adintovirus anguilla1 3115889 Viruses Viruses 53.1 1.81e-06 Adintovirus anguilla1 Non-phage NR PRJNA1069776_S_NODE_54168_length_151_cov_2.222222_g53854_i0   DBA49780.1 MAG TPA_asm: Penton [Adintovirus anguilla10665] DBA49780.1 3115889 g53854 i0 64.7 1.350993377 34 12 67.5 0 151 50 217 250 204 53.1 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   53.1   1.81e-06
9996 9996 PRJNA980839_CONTIG_225352|Adintovirus_anguilla1|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA980839_CONTIG_225352|Adintovirus_anguilla1 PRJNA980839_CONTIG_225352 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA980839 225352 244 0.900585 2.1974274 Adintovirus anguilla1 3115889 Viruses Viruses 102.0 1.03e-24 Adintovirus anguilla1 Non-phage NR PRJNA980839_P_NODE_225352_length_244_cov_0.900585_g221568_i0   DBA49780.1 MAG TPA_asm: Penton [Adintovirus anguilla10665] DBA49780.1 3115889 g221568 i0 68.3 0.774590164 63 20 77.5 0 1 189 184 246 189 102.0 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   102.0   1.03e-24
10032 10032 PRJNA1249535_CONTIG_11960|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_11960|Adintovirus_anguilla1 PRJNA1249535_CONTIG_11960 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 11960 782 16.507757 129.0906597 Adintovirus anguilla1 3115889 Viruses Viruses 72.8 1.27e-11 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g9425 i0 28.6 0.510230179 133 92 49.9 2 15 404 40 172 399 72.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   72.8   1.27e-11
10038 10038 PRJNA1249535_CONTIG_19610|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_19610|Adintovirus_anguilla1 PRJNA1249535_CONTIG_19610 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 19610 662 98.758913 653.7840041 Adintovirus anguilla1 3115889 Viruses Viruses 73.2 4.4e-12 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_19610_length_662_cov_98.758913_g16574_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g16574 i0 28.6 0.602719033 133 92 58.9 2 648 259 40 172 399 73.2 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   73.2   4.4e-12
10039 10039 PRJNA1249535_CONTIG_19614|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_19614|Adintovirus_anguilla1 PRJNA1249535_CONTIG_19614 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 19614 662 75.651952 500.8159222 Adintovirus anguilla1 3115889 Viruses Viruses 70.1 6.2e-11 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_19614_length_662_cov_75.651952_g16578_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g16578 i0 27.8 0.987915408 133 93 58.9 2 648 259 40 172 654 70.1 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   70.1   6.2e-11
10047 10047 PRJNA1249535_CONTIG_33391|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_33391|Adintovirus_anguilla1 PRJNA1249535_CONTIG_33391 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 33391 553 51.891667 286.9609185 Adintovirus anguilla1 3115889 Viruses Viruses 55.8 5.59e-06 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_33391_length_553_cov_51.891667_g30120_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g30120 i0 25.0 1.03074141 100 73 53.2 1 5 298 73 172 570 55.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   55.8   5.59e-06
10051 10051 PRJNA556992_CONTIG_71210|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA556992_CONTIG_71210|Adintovirus_anguilla1 PRJNA556992_CONTIG_71210 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA556992 71210 451 3.492063 15.74920413 Adintovirus anguilla1 3115889 Viruses Viruses 74.7 1.93e-13 Adintovirus anguilla1 Non-phage NR PRJNA556992_P_NODE_71210_length_451_cov_3.492063_g69035_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g69035 i0 31.1 0.87804878 132 81 85.8 4 449 63 42 166 396 74.7 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   74.7   1.93e-13
10054 10054 PRJNA1249535_CONTIG_108182|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_108182|Adintovirus_anguilla1 PRJNA1249535_CONTIG_108182 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 108182 366 72.952218 267.0051179 Adintovirus anguilla1 3115889 Viruses Viruses 71.6 1.22e-12 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_108182_length_366_cov_72.952218_g104799_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g104799 i0 31.3 1.639344262 115 76 91.8 2 15 350 40 154 600 71.6 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   71.6   1.22e-12
10058 10058 PRJNA1249535_CONTIG_175500|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_175500|Adintovirus_anguilla1 PRJNA1249535_CONTIG_175500 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 175500 320 1.578947 5.0526304 Adintovirus anguilla1 3115889 Viruses Viruses 47.4 0.00113 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_175500_length_320_cov_1.578947_g172117_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g172117 i0 23.9 2.296875 88 60 82.5 1 289 26 86 166 735 47.4 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   47.4   0.00113
10061 10061 PRJNA1249535_CONTIG_256425|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_256425|Adintovirus_anguilla1 PRJNA1249535_CONTIG_256425 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 256425 276 4.374384 12.07329984 Adintovirus anguilla1 3115889 Viruses Viruses 50.8 3.58e-05 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_256425_length_276_cov_4.374384_g253042_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g253042 i0 25.3 0.945652174 87 63 92.4 1 269 15 68 154 261 50.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   50.8   3.58e-05
10062 10062 PRJNA1249535_CONTIG_280610|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_280610|Adintovirus_anguilla1 PRJNA1249535_CONTIG_280610 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 280610 263 3.694737 9.71715831 Adintovirus anguilla1 3115889 Viruses Viruses 52.8 5.9e-06 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_280610_length_263_cov_3.694737_g277227_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g277227 i0 31.1 1.02661597 90 59 99.2 2 261 1 54 143 270 52.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   52.8   5.9e-06
10253 10253 PRJNA638138_CONTIG_8911|Adintovirus_anguilla1|CLUSTER3_Adintovirus_anguilla1|2|1 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA638138_CONTIG_8911|Adintovirus_anguilla1 PRJNA638138_CONTIG_8911 Adintovirus anguilla1 34 19 10 CLUSTER3_Adintovirus_anguilla1|2|1 PRJNA638138_P_NODE_2716_length_580_cov_0.962525_g2504_i0|Astyanax_tetra_cavefish_adintovirus|NR|5.26e-35|NA 2 1 PRJNA638138 8911 345 1.466912 5.0608464 Adintovirus anguilla1 3115889 Viruses Viruses 82.8 4.89e-17 Adintovirus anguilla1 Non-phage NR PRJNA638138_P_NODE_8911_length_345_cov_1.466912_g8696_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g8696 i0 50.0 0.67826087 78 39 67.8 0 1 234 104 181 234 82.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   82.8   4.89e-17
10356 10356 PRJNA638138_CONTIG_2523|Adintovirus_anguilla1|CLUSTER4_Adintovirus_anguilla1|1|1 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA638138_CONTIG_2523|Adintovirus_anguilla1 PRJNA638138_CONTIG_2523 Adintovirus anguilla1 34 19 10 CLUSTER4_Adintovirus_anguilla1|1|1 PRJNA638138_P_NODE_2523_length_599_cov_0.931559_g2311_i0|Adintovirus_anguilla1|NR|4.76e-76|NA 1 1 PRJNA638138 2523 599 0.931559 5.58003841 Adintovirus anguilla1 3115889 Viruses Viruses 242.0 4.76e-76 Adintovirus anguilla1 Non-phage NR PRJNA638138_P_NODE_2523_length_599_cov_0.931559_g2311_i0   DBA49779.1 MAG TPA_asm: Integrase [Adintovirus anguilla10665] DBA49779.1 3115889 g2311 i0 60.5 2.85475793 190 75 95.2 0 570 1 159 348 1710 242.0 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   242.0   4.76e-76
10367 10367 PRJNA408129_CONTIG_3713|Adintovirus_anguilla1|CLUSTER5_Adintovirus_anguilla1|1|1 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA408129_CONTIG_3713|Adintovirus_anguilla1 PRJNA408129_CONTIG_3713 Adintovirus anguilla1 34 19 10 CLUSTER5_Adintovirus_anguilla1|1|1 PRJNA408129_S_NODE_3713_length_289_cov_2.456349_g3695_i0|Adintovirus_anguilla1|NR|3.84e-12|NA 1 1 PRJNA408129 3713 289 2.456349 7.09884861 Adintovirus anguilla1 3115889 Viruses Viruses 69.3 3.84e-12 Adintovirus anguilla1 Non-phage NR PRJNA408129_S_NODE_3713_length_289_cov_2.456349_g3695_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g3695 i0 36.8 0.98615917 95 53 91.3 2 3 266 59 153 285 69.3 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   69.3   3.84e-12
10377 10377 PRJNA638138_CONTIG_4878|Adintovirus_anguilla1|CLUSTER6_Adintovirus_anguilla1|1|1 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA638138_CONTIG_4878|Adintovirus_anguilla1 PRJNA638138_CONTIG_4878 Adintovirus anguilla1 34 19 10 CLUSTER6_Adintovirus_anguilla1|1|1 PRJNA638138_P_NODE_4878_length_443_cov_0.897297_g4664_i0|Adintovirus_anguilla1|NR|5.62e-34|NA 1 1 PRJNA638138 4878 443 0.897297 3.97502571 Adintovirus anguilla1 3115889 Viruses Viruses 136.0 5.6199999999999996e-34 Adintovirus anguilla1 Non-phage NR PRJNA638138_P_NODE_4878_length_443_cov_0.897297_g4664_i0   DBA49787.1 MAG TPA_asm: PolBb [Adintovirus anguilla10665] DBA49787.1 3115889 g4664 i0 58.3 2.09255079 103 43 69.8 0 3 311 51 153 927 136.0 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   136.0   5.6199999999999996e-34
10378 10378 PRJNA638138_CONTIG_4954|Adintovirus_anguilla1|CLUSTER7_Adintovirus_anguilla1|1|1 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA638138_CONTIG_4954|Adintovirus_anguilla1 PRJNA638138_CONTIG_4954 Adintovirus anguilla1 34 19 10 CLUSTER7_Adintovirus_anguilla1|1|1 PRJNA638138_P_NODE_4954_length_439_cov_2.040984_g4740_i0|Adintovirus_anguilla1|NR|6.34e-23|NA 1 1 PRJNA638138 4954 439 2.040984 8.95991976 Adintovirus anguilla1 3115889 Viruses Viruses 97.1 6.339999999999999e-23 Adintovirus anguilla1 Non-phage NR PRJNA638138_P_NODE_4954_length_439_cov_2.040984_g4740_i0   DBA49785.1 MAG TPA_asm: GasderminX [Adintovirus anguilla10665] DBA49785.1 3115889 g4740 i0 61.3 0.512528474 75 29 51.3 0 1 225 37 111 225 97.1 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   97.1   6.339999999999999e-23
10469 10469 PRJNA1249042_CONTIG_51448|Adintovirus_anguilla1|CLUSTER8_Adintovirus_anguilla1|1|1 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249042_CONTIG_51448|Adintovirus_anguilla1 PRJNA1249042_CONTIG_51448 Adintovirus anguilla1 34 19 10 CLUSTER8_Adintovirus_anguilla1|1|1 PRJNA1249042_S_NODE_51448_length_208_cov_2.272727_g51234_i0|Adintovirus_anguilla1|NR|1.23e-20|NA 1 1 PRJNA1249042 51448 208 2.272727 4.72727216 Adintovirus anguilla1 3115889 Viruses Viruses 91.7 1.23e-20 Adintovirus anguilla1 Non-phage NR PRJNA1249042_S_NODE_51448_length_208_cov_2.272727_g51234_i0   DBA49784.1 MAG TPA_asm: Adintoc2 [Adintovirus anguilla10665] DBA49784.1 3115889 g51234 i0 56.5 1.990384615 69 30 99.5 0 207 1 122 190 414 91.7 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   91.7   1.23e-20
10482 10482 PRJNA1249042_CONTIG_113789|Adintovirus_anguilla1|CLUSTER9_Adintovirus_anguilla1|1|1 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249042_CONTIG_113789|Adintovirus_anguilla1 PRJNA1249042_CONTIG_113789 Adintovirus anguilla1 34 19 10 CLUSTER9_Adintovirus_anguilla1|1|1 PRJNA1249042_S_NODE_113789_length_152_cov_1.321101_g113575_i0|Adintovirus_anguilla1|NR|1.27e-10|NA 1 1 PRJNA1249042 113789 152 1.321101 2.00807352 Adintovirus anguilla1 3115889 Viruses Viruses 65.1 1.27e-10 Adintovirus anguilla1 Non-phage NR PRJNA1249042_S_NODE_113789_length_152_cov_1.321101_g113575_i0   DBA49779.1 MAG TPA_asm: Integrase [Adintovirus anguilla10665] DBA49779.1 3115889 g113575 i0 68.1 0.927631579 47 15 92.8 0 2 142 23 69 141 65.1 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   65.1   1.27e-10
10488 10488 PRJNA493827_CONTIG_233582|Adintovirus_anguilla1|CLUSTER10_Adintovirus_anguilla1|1|1 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA493827_CONTIG_233582|Adintovirus_anguilla1 PRJNA493827_CONTIG_233582 Adintovirus anguilla1 34 19 10 CLUSTER10_Adintovirus_anguilla1|1|1 PRJNA493827_P_NODE_233582_length_241_cov_0.916667_g231384_i0|Adintovirus_anguilla1|NR|1.64e-11|NA 1 1 PRJNA493827 233582 241 0.916667 2.20916747 Adintovirus anguilla1 3115889 Viruses Viruses 67.0 1.64e-11 Adintovirus anguilla1 Non-phage NR PRJNA493827_P_NODE_233582_length_241_cov_0.916667_g231384_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g231384 i0 61.9 1.543568465 42 16 52.3 0 236 111 40 81 372 67.0 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   67.0   1.64e-11

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