RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

7 rows where bioproject = "PRJNA896758" and clusterLCA_curated = "Zebrafish picornavirus 1"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

tax_family_NTorNR 1

clusterLCA_curated 1

  • Zebrafish picornavirus 1 · 7 ✖

bioproject 1

  • PRJNA896758 · 7 ✖

Category 1

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
3212 3212 PRJNA896758_CONTIG_1|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA896758_CONTIG_1|Cyprivirus_A PRJNA896758_CONTIG_1 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA896758 1 8278 71.580378 5925.423691 Cyprivirus A 2304617 Viruses Viruses 13651.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA896758_P_NODE_1_length_8278_cov_71.580378_g0_i0   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g0 i0 96.438 3.024643634 8281 287 100.0 6 1 8278 8295 20 25038 13651.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|2500378199|ref|NC_076245.1| Viruses Viruses Viruses Viruses 13651.0 4610.0 0.0 0.0
3222 3222 PRJNA896758_CONTIG_2|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA896758_CONTIG_2|Cyprivirus_A PRJNA896758_CONTIG_2 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA896758 2 8278 70.724071 5854.538597 Cyprivirus A 2304617 Viruses Viruses 13640.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA896758_P_NODE_2_length_8278_cov_70.724071_g0_i1   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g0 i1 96.413 3.024643634 8281 289 100.0 6 1 8278 8295 20 25038 13640.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|2500378199|ref|NC_076245.1| Viruses Viruses Viruses Viruses 13640.0 4606.0 0.0 0.0
3225 3225 PRJNA896758_CONTIG_3|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA896758_CONTIG_3|Cyprivirus_A PRJNA896758_CONTIG_3 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA896758 3 8278 70.262645 5816.341753 Cyprivirus A 2304617 Viruses Viruses 13590.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA896758_P_NODE_3_length_8278_cov_70.262645_g0_i2   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g0 i2 96.305 3.024643634 8281 298 100.0 6 1 8278 8295 20 25038 13590.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|2500378199|ref|NC_076245.1| Viruses Viruses Viruses Viruses 13590.0 4602.0 0.0 0.0
3323 3323 PRJNA896758_CONTIG_247|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA896758_CONTIG_247|Cyprivirus_A PRJNA896758_CONTIG_247 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA896758 247 2016 19.200206 387.076153 Cyprivirus A 2304617 Viruses Viruses 3044.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA896758_P_NODE_247_length_2016_cov_19.200206_g0_i3   TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome gi|1990739381|tpg|BK011179.1| 2563826 g0 i3 93.908 3.004960317 2019 120 100.0 1 1 2016 3281 1263 6058 3044.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|1990739381|tpg|BK011179.1| Viruses Viruses Viruses Viruses 3044.0 1272.0 0.0 0.0
3336 3336 PRJNA896758_CONTIG_305|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA896758_CONTIG_305|Cyprivirus_A PRJNA896758_CONTIG_305 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA896758 305 1866 18.607362 347.2133749 Cyprivirus A 2304617 Viruses Viruses 3118.0 0.0 Cyprivirus A Non-phage NTclustered PRJNA896758_P_NODE_305_length_1866_cov_18.607362_g0_i4   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g0 i4 96.838 2.967309753 1866 58 100.0 1 1 1866 1884 20 5537 3118.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|2500378199|ref|NC_076245.1| Viruses Viruses Viruses Viruses 3118.0 750.0 0.0 5.97e-245
4127 4127 PRJNA896758_CONTIG_19324|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA896758_CONTIG_19324|Cyprivirus_A PRJNA896758_CONTIG_19324 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA896758 19324 265 0.802083 2.12551995 Cyprivirus A 2304617 Viruses Viruses 407.0 4.49e-109 Cyprivirus A Non-phage NTclustered PRJNA896758_P_NODE_19324_length_265_cov_0.802083_g18934_i0   Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome gi|2500378199|ref|NC_076245.1| 2563826 g18934 i0 94.34 3.0 265 15 100.0 0 1 265 1340 1604 795 407.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|2500378199|ref|NC_076245.1| Viruses Viruses Viruses Viruses 407.0 166.0 4.49e-109 2.71e-45
4155 4155 PRJNA896758_CONTIG_23390|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 Zebrafish picornavirus 1 Known PRJNA896758_CONTIG_23390|Cyprivirus_A PRJNA896758_CONTIG_23390 Cyprivirus A 1161 220 1 CLUSTER1_Cyprivirus_A|1164|220 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA 1164 220 PRJNA896758 23390 247 0.885057 2.18609079 Cyprivirus A 2304617 Viruses Viruses 385.0 1.94e-102 Cyprivirus A Non-phage NTclustered PRJNA896758_P_NODE_23390_length_247_cov_0.885057_g23000_i0   TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome gi|1990739381|tpg|BK011179.1| 2563826 g23000 i0 94.737 2.987854251 247 13 100.0 0 1 247 2936 2690 738 385.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Cyprivirus A Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 Cyprivirus A Zebrafish picornavirus 1 gi|1990739381|tpg|BK011179.1| Viruses Viruses Viruses Viruses 385.0 156.0 1.94e-102 5.1399999999999995e-42

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