RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

8 rows where Category = "Known" and clusterLCA_curated = "Myotis ricketti associated fish calicivirus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_family_NTorNR 1

clusterLCA_curated 1

  • Myotis ricketti associated fish calicivirus · 8 ✖

bioproject 1

Category 1

  • Known · 8 ✖

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
10092 10092 PRJNA698005_CONTIG_8|Myotis_ricketti_associated_fish_calicivirus|CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 Myotis ricketti associated fish calicivirus Known PRJNA698005_CONTIG_8|Myotis_ricketti_associated_fish_calicivirus PRJNA698005_CONTIG_8 Myotis ricketti associated fish calicivirus 8 1 2 CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 OR951111_1_MAG_Myotis_ricketti_associated_fish_calicivirus_isolate_GD2017_nonstructural_polyprotein_gene_partial_cds 9 1 PRJNA698005 8 3891 11.537454 448.9223351 Myotis ricketti associated fish calicivirus 3128426 Viruses Viruses 6202.0 0.0 Myotis ricketti associated fish calicivirus Non-phage NTclustered PRJNA698005_S_NODE_8_length_3891_cov_11.537454_g5_i0   MAG: Myotis ricketti associated fish calicivirus isolate GD2017 nonstructural polyprotein gene, partial cds gi|2699893476|gb|OR951111.1| 3128426 g5 i0 96.943 5.203289643 3697 113 95.0 0 3 3699 3423 7119 20246 6202.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Myotis ricketti associated fish calicivirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Myotis ricketti associated fish calicivirus Myotis ricketti associated fish calicivirus Guangdong pseudohemiculter dispar calicivirus gi|2699893476|gb|OR951111.1| Viruses Viruses Viruses Viruses 6202.0 2310.0 0.0 0.0
10093 10093 PRJNA698005_CONTIG_9|Myotis_ricketti_associated_fish_calicivirus|CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 Myotis ricketti associated fish calicivirus Known PRJNA698005_CONTIG_9|Myotis_ricketti_associated_fish_calicivirus PRJNA698005_CONTIG_9 Myotis ricketti associated fish calicivirus 8 1 2 CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 OR951111_1_MAG_Myotis_ricketti_associated_fish_calicivirus_isolate_GD2017_nonstructural_polyprotein_gene_partial_cds 9 1 PRJNA698005 9 3891 10.936878 425.553923 Myotis ricketti associated fish calicivirus 3128426 Viruses Viruses 6268.0 0.0 Myotis ricketti associated fish calicivirus Non-phage NTclustered PRJNA698005_S_NODE_9_length_3891_cov_10.936878_g5_i1   MAG: Myotis ricketti associated fish calicivirus isolate GD2017 nonstructural polyprotein gene, partial cds gi|2699893476|gb|OR951111.1| 3128426 g5 i1 97.268 4.853508096 3697 101 95.0 0 3 3699 3423 7119 18885 6268.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Myotis ricketti associated fish calicivirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Myotis ricketti associated fish calicivirus Myotis ricketti associated fish calicivirus Guangdong pseudohemiculter dispar calicivirus gi|2699893476|gb|OR951111.1| Viruses Viruses Viruses Viruses 6268.0 2310.0 0.0 0.0
10094 10094 PRJNA698005_CONTIG_112|Myotis_ricketti_associated_fish_calicivirus|CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 Myotis ricketti associated fish calicivirus Known PRJNA698005_CONTIG_112|Myotis_ricketti_associated_fish_calicivirus PRJNA698005_CONTIG_112 Myotis ricketti associated fish calicivirus 8 1 2 CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 OR951111_1_MAG_Myotis_ricketti_associated_fish_calicivirus_isolate_GD2017_nonstructural_polyprotein_gene_partial_cds 9 1 PRJNA698005 112 1978 2.541207 50.26507446 Myotis ricketti associated fish calicivirus 3128426 Viruses Viruses 3315.0 0.0 Myotis ricketti associated fish calicivirus Non-phage NTclustered PRJNA698005_S_NODE_112_length_1978_cov_2.541207_g55_i0   MAG: Myotis ricketti associated fish calicivirus isolate GD2017 nonstructural polyprotein gene, partial cds gi|2699893476|gb|OR951111.1| 3128426 g55 i0 96.916 2.546006067 1978 61 100.0 0 1 1978 1426 3403 5036 3315.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Myotis ricketti associated fish calicivirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Myotis ricketti associated fish calicivirus Myotis ricketti associated fish calicivirus Guangdong pseudohemiculter dispar calicivirus gi|2699893476|gb|OR951111.1| Viruses Viruses Viruses Viruses 3315.0 1273.0 0.0 0.0
10098 10098 PRJNA698005_CONTIG_312|Myotis_ricketti_associated_fish_calicivirus|CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 Myotis ricketti associated fish calicivirus Known PRJNA698005_CONTIG_312|Myotis_ricketti_associated_fish_calicivirus PRJNA698005_CONTIG_312 Myotis ricketti associated fish calicivirus 8 1 2 CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 OR951111_1_MAG_Myotis_ricketti_associated_fish_calicivirus_isolate_GD2017_nonstructural_polyprotein_gene_partial_cds 9 1 PRJNA698005 312 1400 16.295403 228.135642 Myotis ricketti associated fish calicivirus 3128426 Viruses Viruses 2065.0 0.0 Myotis ricketti associated fish calicivirus Non-phage NTclustered PRJNA698005_S_NODE_312_length_1400_cov_16.295403_g5_i2   MAG: Myotis ricketti associated fish calicivirus isolate GD2017 nonstructural polyprotein gene, partial cds gi|2699893476|gb|OR951111.1| 3128426 g5 i2 97.517 5.219285714 1208 30 86.0 0 193 1400 7119 5912 7307 2065.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Myotis ricketti associated fish calicivirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Myotis ricketti associated fish calicivirus Myotis ricketti associated fish calicivirus Guangdong pseudohemiculter dispar calicivirus gi|2699893476|gb|OR951111.1| Viruses Viruses Viruses Viruses 2065.0 671.0 0.0 2.15e-218
10101 10101 PRJNA698005_CONTIG_7603|Myotis_ricketti_associated_fish_calicivirus|CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 Myotis ricketti associated fish calicivirus Known PRJNA698005_CONTIG_7603|Myotis_ricketti_associated_fish_calicivirus PRJNA698005_CONTIG_7603 Myotis ricketti associated fish calicivirus 8 1 2 CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 OR951111_1_MAG_Myotis_ricketti_associated_fish_calicivirus_isolate_GD2017_nonstructural_polyprotein_gene_partial_cds 9 1 PRJNA698005 7603 323 1.196 3.86308 Myotis ricketti associated fish calicivirus 3128426 Viruses Viruses 520.0 6.92e-143 Myotis ricketti associated fish calicivirus Non-phage NTclustered PRJNA698005_S_NODE_7603_length_323_cov_1.196000_g7205_i0   MAG: Myotis ricketti associated fish calicivirus isolate GD2017 nonstructural polyprotein-like gene, complete sequence gi|2699893480|gb|OR951114.1| 3128426 g7205 i0 95.666 2.0 323 14 100.0 0 1 323 1990 2312 646 520.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Myotis ricketti associated fish calicivirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Myotis ricketti associated fish calicivirus Myotis ricketti associated fish calicivirus Guangdong pseudohemiculter dispar calicivirus gi|2699893480|gb|OR951114.1| Viruses Viruses Viruses Viruses 520.0 214.0 6.92e-143 4.83e-62
10104 10104 PRJNA698005_CONTIG_12760|Myotis_ricketti_associated_fish_calicivirus|CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 Myotis ricketti associated fish calicivirus Known PRJNA698005_CONTIG_12760|Myotis_ricketti_associated_fish_calicivirus PRJNA698005_CONTIG_12760 Myotis ricketti associated fish calicivirus 8 1 2 CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 OR951111_1_MAG_Myotis_ricketti_associated_fish_calicivirus_isolate_GD2017_nonstructural_polyprotein_gene_partial_cds 9 1 PRJNA698005 12760 262 1.73545 4.546879 Myotis ricketti associated fish calicivirus 3128426 Viruses Viruses 429.0 9.45e-116 Myotis ricketti associated fish calicivirus Non-phage NTclustered PRJNA698005_S_NODE_12760_length_262_cov_1.735450_g12362_i0   MAG: Myotis ricketti associated fish calicivirus isolate GD2017 nonstructural polyprotein gene, partial cds gi|2699893476|gb|OR951111.1| 3128426 g12362 i0 96.183 1.0 262 10 100.0 0 1 262 1321 1060 262 429.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Myotis ricketti associated fish calicivirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Myotis ricketti associated fish calicivirus Myotis ricketti associated fish calicivirus Guangdong pseudohemiculter dispar calicivirus gi|2699893476|gb|OR951111.1| Viruses Viruses Viruses Viruses 429.0 161.0 9.45e-116 7.89e-44
10106 10106 PRJNA698005_CONTIG_19487|Myotis_ricketti_associated_fish_calicivirus|CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 Myotis ricketti associated fish calicivirus Known PRJNA698005_CONTIG_19487|Myotis_ricketti_associated_fish_calicivirus PRJNA698005_CONTIG_19487 Myotis ricketti associated fish calicivirus 8 1 2 CLUSTER1_Myotis_ricketti_associated_fish_calicivirus|9|1 OR951111_1_MAG_Myotis_ricketti_associated_fish_calicivirus_isolate_GD2017_nonstructural_polyprotein_gene_partial_cds 9 1 PRJNA698005 19487 238 2.09697 4.9907886 Myotis ricketti associated fish calicivirus 3128426 Viruses Viruses 366.0 6.72e-97 Myotis ricketti associated fish calicivirus Non-phage NTclustered PRJNA698005_S_NODE_19487_length_238_cov_2.096970_g19089_i0   MAG: Myotis ricketti associated fish calicivirus isolate GD2017 nonstructural polyprotein gene, partial cds gi|2699893476|gb|OR951111.1| 3128426 g19089 i0 94.872 0.983193277 234 12 98.0 0 3 236 573 806 234 366.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Myotis ricketti associated fish calicivirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Myotis ricketti associated fish calicivirus Myotis ricketti associated fish calicivirus Guangdong pseudohemiculter dispar calicivirus gi|2699893476|gb|OR951111.1| Viruses Viruses Viruses Viruses 366.0 129.0 6.72e-97 8.86e-33
10258 10258 PRJNA698005_CONTIG_11625|Myotis_ricketti_associated_fish_calicivirus|CLUSTER2_Myotis_ricketti_associated_fish_calicivirus|2|1 Myotis ricketti associated fish calicivirus Known PRJNA698005_CONTIG_11625|Myotis_ricketti_associated_fish_calicivirus PRJNA698005_CONTIG_11625 Myotis ricketti associated fish calicivirus 8 1 2 CLUSTER2_Myotis_ricketti_associated_fish_calicivirus|2|1 OL355014_1_Ameiurus_nebulosus_calicivirus_1_isolate_Memphremagog_5_complete_genome 2 1 PRJNA698005 11625 272 1.643216 4.46954752 Myotis ricketti associated fish calicivirus 3128426 Viruses Viruses 464.0 2.7099999999999998e-126 Myotis ricketti associated fish calicivirus Non-phage NTclustered PRJNA698005_S_NODE_11625_length_272_cov_1.643216_g11227_i0   MAG: Myotis ricketti associated fish calicivirus isolate GD2017 nonstructural polyprotein gene, partial cds gi|2699893476|gb|OR951111.1| 3128426 g11227 i0 97.426 2.441176471 272 7 100.0 0 1 272 210 481 664 464.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Myotis ricketti associated fish calicivirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Myotis ricketti associated fish calicivirus Myotis ricketti associated fish calicivirus Guangdong pseudohemiculter dispar calicivirus gi|2699893476|gb|OR951111.1| Viruses Viruses Viruses Viruses 464.0 135.0 2.7099999999999998e-126 1.02e-34

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