viruses_fish_associated_curated
14 rows where Category = "Known" and clusterLCA_curated = "Grass carp reovirus"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10154 | 10154 | PRJNA698005_CONTIG_1971|Aquareovirus_ctenopharyngodontis|CLUSTER1_Aquareovirus_ctenopharyngodontis|6|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_1971|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_1971 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER1_Aquareovirus_ctenopharyngodontis|6|1 | HQ231201_1_Grass_carp_reovirus_strain_GCRV_GD108_segment_M4_complete_sequence | 6 | 1 | PRJNA698005 | 1971 | 626 | 1.811935 | 11.3427131 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 1112.0 | 0.0 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_1971_length_626_cov_1.811935_g1588_i0 | Grass carp reovirus strain GCRV-GD108 segment M4, complete sequence | gi|315112495|gb|HQ231201.1| | 128987 | g1588 | i0 | 98.722 | 13.0 | 626 | 8 | 100.0 | 0 | 1 | 626 | 1704 | 1079 | 8138 | 1112.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|315112495|gb|HQ231201.1| | Viruses | Viruses | Viruses | Viruses | 1112.0 | 397.0 | 0.0 | 4.7600000000000006e-132 | |
| 10155 | 10155 | PRJNA698005_CONTIG_2972|Aquareovirus_ctenopharyngodontis|CLUSTER1_Aquareovirus_ctenopharyngodontis|6|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_2972|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_2972 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER1_Aquareovirus_ctenopharyngodontis|6|1 | HQ231201_1_Grass_carp_reovirus_strain_GCRV_GD108_segment_M4_complete_sequence | 6 | 1 | PRJNA698005 | 2972 | 504 | 1.921114 | 9.68241456 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 898.0 | 0.0 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_2972_length_504_cov_1.921114_g2576_i0 | Grass carp reovirus isolate 109 segment 4, complete sequence | gi|568261593|gb|KF712478.1| | 128987 | g2576 | i0 | 99.197 | 12.84722222 | 498 | 4 | 99.0 | 0 | 1 | 498 | 547 | 50 | 6475 | 898.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|568261593|gb|KF712478.1| | Viruses | Viruses | Viruses | Viruses | 898.0 | 321.0 | 0.0 | 4.0900000000000004e-103 | |
| 10158 | 10158 | PRJNA698005_CONTIG_8190|Aquareovirus_ctenopharyngodontis|CLUSTER1_Aquareovirus_ctenopharyngodontis|6|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_8190|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_8190 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER1_Aquareovirus_ctenopharyngodontis|6|1 | HQ231201_1_Grass_carp_reovirus_strain_GCRV_GD108_segment_M4_complete_sequence | 6 | 1 | PRJNA698005 | 8190 | 313 | 1.720833 | 5.38620729 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 556.0 | 5.09e-154 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_8190_length_313_cov_1.720833_g7792_i0 | Grass carp reovirus strain GCRV-DY197 segment 4, complete sequence | gi|2664538878|gb|PP196476.1| | 128987 | g7792 | i0 | 98.722 | 13.0 | 313 | 4 | 100.0 | 0 | 1 | 313 | 1727 | 2039 | 4069 | 556.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|2664538878|gb|PP196476.1| | Viruses | Viruses | Viruses | Viruses | 556.0 | 197.0 | 5.09e-154 | 1.77e-57 | |
| 10178 | 10178 | PRJNA698005_CONTIG_267|Aquareovirus_ctenopharyngodontis|CLUSTER2_Aquareovirus_ctenopharyngodontis|4|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_267|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_267 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER2_Aquareovirus_ctenopharyngodontis|4|1 | KF712482_1_Grass_carp_reovirus_isolate_109_segment_8_complete_sequence | 4 | 1 | PRJNA698005 | 267 | 1484 | 5.394047 | 80.04765748 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 2708.0 | 0.0 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_267_length_1484_cov_5.394047_g152_i0 | Grass carp reovirus isolate 109 segment 8, complete sequence | gi|568261601|gb|KF712482.1| | 128987 | g152 | i0 | 99.596 | 13.01280323 | 1484 | 6 | 100.0 | 0 | 1 | 1484 | 37 | 1520 | 19311 | 2708.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|568261601|gb|KF712482.1| | Viruses | Viruses | Viruses | Viruses | 2708.0 | 691.0 | 0.0 | 6.370000000000001e-248 | |
| 10180 | 10180 | PRJNA698005_CONTIG_885|Aquareovirus_ctenopharyngodontis|CLUSTER3_Aquareovirus_ctenopharyngodontis|4|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_885|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_885 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER3_Aquareovirus_ctenopharyngodontis|4|1 | KF712485_1_Grass_carp_reovirus_isolate_109_segment_11_complete_sequence | 4 | 1 | PRJNA698005 | 885 | 903 | 4.062651 | 36.68573853 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 1591.0 | 0.0 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_885_length_903_cov_4.062651_g622_i0 | Grass carp reovirus strain GCRV-DY197 segment 11, complete sequence | gi|2664538897|gb|PP196483.1| | 128987 | g622 | i0 | 98.45 | 12.26135105 | 903 | 14 | 100.0 | 0 | 1 | 903 | 959 | 57 | 11072 | 1591.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|2664538897|gb|PP196483.1| | Viruses | Viruses | Viruses | Viruses | 1591.0 | 637.0 | 0.0 | 9.24e-231 | |
| 10182 | 10182 | PRJNA698005_CONTIG_2760|Aquareovirus_ctenopharyngodontis|CLUSTER2_Aquareovirus_ctenopharyngodontis|4|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_2760|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_2760 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER2_Aquareovirus_ctenopharyngodontis|4|1 | KF712482_1_Grass_carp_reovirus_isolate_109_segment_8_complete_sequence | 4 | 1 | PRJNA698005 | 2760 | 523 | 8.24 | 43.0952 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 955.0 | 0.0 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_2760_length_523_cov_8.240000_g2364_i0 | Grass carp reovirus strain GCRV-YX06 segment 8, complete sequence | gi|2877358127|gb|PQ553633.1| | 128987 | g2364 | i0 | 99.618 | 13.72848948 | 523 | 2 | 100.0 | 0 | 1 | 523 | 559 | 37 | 7180 | 955.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|2877358127|gb|PQ553633.1| | Viruses | Viruses | Viruses | Viruses | 955.0 | 312.0 | 0.0 | 5.0199999999999996e-104 | |
| 10185 | 10185 | PRJNA698005_CONTIG_4275|Aquareovirus_ctenopharyngodontis|CLUSTER4_Aquareovirus_ctenopharyngodontis|4|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_4275|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_4275 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER4_Aquareovirus_ctenopharyngodontis|4|1 | GU350747_1_Grass_carp_reovirus_strain_HZ08_segment_10_complete_sequence | 4 | 1 | PRJNA698005 | 4275 | 420 | 1.29683 | 5.446686 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 765.0 | 0.0 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_4275_length_420_cov_1.296830_g3877_i0 | Grass carp reovirus strain HZ08 segment 10, complete sequence | gi|300213904|gb|GU350747.1| | 128987 | g3877 | i0 | 99.524 | 13.35714286 | 420 | 2 | 100.0 | 0 | 1 | 420 | 527 | 946 | 5610 | 765.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|300213904|gb|GU350747.1| | Viruses | Viruses | Viruses | Viruses | 765.0 | 275.0 | 0.0 | 5.54e-90 | |
| 10192 | 10192 | PRJNA698005_CONTIG_8519|Aquareovirus_ctenopharyngodontis|CLUSTER4_Aquareovirus_ctenopharyngodontis|4|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_8519|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_8519 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER4_Aquareovirus_ctenopharyngodontis|4|1 | GU350747_1_Grass_carp_reovirus_strain_HZ08_segment_10_complete_sequence | 4 | 1 | PRJNA698005 | 8519 | 308 | 4.319149 | 13.30297892 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 569.0 | 6.4199999999999996e-158 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_8519_length_308_cov_4.319149_g8121_i0 | Grass carp reovirus strain HuNan794 segment 10, complete sequence | gi|458592472|gb|KC238685.1| | 128987 | g8121 | i0 | 100.0 | 13.26298701 | 308 | 0 | 100.0 | 0 | 1 | 308 | 356 | 49 | 4085 | 569.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|458592472|gb|KC238685.1| | Viruses | Viruses | Viruses | Viruses | 569.0 | 219.0 | 6.4199999999999996e-158 | 1.07e-68 | |
| 10195 | 10195 | PRJNA698005_CONTIG_12673|Aquareovirus_ctenopharyngodontis|CLUSTER5_Aquareovirus_ctenopharyngodontis|4|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_12673|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_12673 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER5_Aquareovirus_ctenopharyngodontis|4|1 | GU350742_1_Grass_carp_reovirus_strain_HZ08_segment_3_complete_sequence | 4 | 1 | PRJNA698005 | 12673 | 263 | 1.215789 | 3.19752507 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 481.0 | 2.58e-131 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_12673_length_263_cov_1.215789_g12275_i0 | Grass carp reovirus strain GCRV-DY197 segment 3, complete sequence | gi|2664538876|gb|PP196475.1| | 128987 | g12275 | i0 | 99.62 | 13.95057034 | 263 | 1 | 100.0 | 0 | 1 | 263 | 1822 | 2084 | 3669 | 481.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|2664538876|gb|PP196475.1| | Viruses | Viruses | Viruses | Viruses | 481.0 | 187.0 | 2.58e-131 | 6.11e-58 | |
| 10196 | 10196 | PRJNA698005_CONTIG_13163|Aquareovirus_ctenopharyngodontis|CLUSTER3_Aquareovirus_ctenopharyngodontis|4|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_13163|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_13163 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER3_Aquareovirus_ctenopharyngodontis|4|1 | KF712485_1_Grass_carp_reovirus_isolate_109_segment_11_complete_sequence | 4 | 1 | PRJNA698005 | 13163 | 258 | 3.145946 | 8.11654068 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 449.0 | 7.13e-122 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_13163_length_258_cov_3.145946_g12765_i0 | Grass carp reovirus isolate 109 segment 11, complete sequence | gi|568261607|gb|KF712485.1| | 128987 | g12765 | i0 | 98.062 | 12.0 | 258 | 5 | 100.0 | 0 | 1 | 258 | 408 | 151 | 3096 | 449.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|568261607|gb|KF712485.1| | Viruses | Viruses | Viruses | Viruses | 449.0 | 187.0 | 7.13e-122 | 3.3600000000000004e-57 | |
| 10197 | 10197 | PRJNA698005_CONTIG_17284|Aquareovirus_ctenopharyngodontis|CLUSTER5_Aquareovirus_ctenopharyngodontis|4|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_17284|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_17284 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER5_Aquareovirus_ctenopharyngodontis|4|1 | GU350742_1_Grass_carp_reovirus_strain_HZ08_segment_3_complete_sequence | 4 | 1 | PRJNA698005 | 17284 | 245 | 0.895349 | 2.19360505 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 448.0 | 2.41e-121 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_17284_length_245_cov_0.895349_g16886_i0 | Grass carp reovirus strain HZ08 segment 3, complete sequence | gi|300213908|gb|GU350742.1| | 128987 | g16886 | i0 | 99.592 | 13.0 | 245 | 1 | 100.0 | 0 | 1 | 245 | 746 | 502 | 3185 | 448.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|300213908|gb|GU350742.1| | Viruses | Viruses | Viruses | Viruses | 448.0 | 153.0 | 2.41e-121 | 4.3e-41 | |
| 10247 | 10247 | PRJNA698005_CONTIG_3080|Aquareovirus_ctenopharyngodontis|CLUSTER6_Aquareovirus_ctenopharyngodontis|2|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_3080|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_3080 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER6_Aquareovirus_ctenopharyngodontis|2|1 | KC130075_1_Grass_carp_reovirus_isolate_HN12_VP6_S9_gene_complete_cds | 2 | 1 | PRJNA698005 | 3080 | 496 | 1.297872 | 6.43744512 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 911.0 | 0.0 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_3080_length_496_cov_1.297872_g2683_i0 | Grass carp reovirus isolate HN12 VP6 (S9) gene, complete cds | gi|444246570|gb|KC130075.1| | 128987 | g2683 | i0 | 99.798 | 18.99596774 | 496 | 1 | 100.0 | 0 | 1 | 496 | 507 | 12 | 9422 | 911.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|444246570|gb|KC130075.1| | Viruses | Viruses | Viruses | Viruses | 911.0 | 350.0 | 0.0 | 2.16e-118 | |
| 10254 | 10254 | PRJNA698005_CONTIG_9408|Aquareovirus_ctenopharyngodontis|CLUSTER7_Aquareovirus_ctenopharyngodontis|2|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_9408|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_9408 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER7_Aquareovirus_ctenopharyngodontis|2|1 | KU254570_1_Grass_carp_reovirus_strain_Huan1307_segment_5_complete_sequence | 2 | 1 | PRJNA698005 | 9408 | 297 | 1.080357 | 3.20866029 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 538.0 | 1.7400000000000002e-148 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_9408_length_297_cov_1.080357_g9010_i0 | Grass carp reovirus strain Huan1307 segment 5, complete sequence | gi|1026739374|gb|KU254570.1| | 128987 | g9010 | i0 | 99.327 | 14.30976431 | 297 | 2 | 100.0 | 0 | 1 | 297 | 948 | 1244 | 4250 | 538.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|1026739374|gb|KU254570.1| | Viruses | Viruses | Viruses | Viruses | 538.0 | 196.0 | 1.7400000000000002e-148 | 1.12e-56 | |
| 10257 | 10257 | PRJNA698005_CONTIG_10725|Aquareovirus_ctenopharyngodontis|CLUSTER8_Aquareovirus_ctenopharyngodontis|2|1 | Grass carp reovirus | Known | PRJNA698005_CONTIG_10725|Aquareovirus_ctenopharyngodontis | PRJNA698005_CONTIG_10725 | Aquareovirus ctenopharyngodontis | 14 | 1 | 8 | CLUSTER8_Aquareovirus_ctenopharyngodontis|2|1 | HQ231198_1_Grass_carp_reovirus_strain_GCRV_GD108_segment_L1_complete_sequence | 2 | 1 | PRJNA698005 | 10725 | 282 | 0.942584 | 2.65808688 | Aquareovirus ctenopharyngodontis | 185782 | Viruses | Viruses | 505.0 | 1.6599999999999998e-138 | Aquareovirus ctenopharyngodontis | Non-phage | NTclustered | PRJNA698005_S_NODE_10725_length_282_cov_0.942584_g10327_i0 | Grass carp reovirus strain GCRV-GD108 segment L1, complete sequence | gi|315112489|gb|HQ231198.1| | 128987 | g10327 | i0 | 98.936 | 13.0 | 282 | 3 | 100.0 | 0 | 1 | 282 | 638 | 357 | 3666 | 505.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Aquareovirus | Aquareovirus ctenopharyngodontis | Viruses;Riboviria;Orthornavirae;Duplornaviricota;Resentoviricetes;Reovirales;Spinareoviridae;Aquareovirus;Grass carp reovirus | Aquareovirus ctenopharyngodontis | Grass carp reovirus | gi|315112489|gb|HQ231198.1| | Viruses | Viruses | Viruses | Viruses | 505.0 | 193.0 | 1.6599999999999998e-138 | 7.089999999999999e-55 |
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);;