RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

8 rows where bioproject = "PRJNA345071" and clusterLCA_curated = "Zebrafish influenza B-like virus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_genus_NTorNR 1

tax_family_NTorNR 1

clusterLCA_curated 1

  • Zebrafish influenza B-like virus · 8 ✖

bioproject 1

  • PRJNA345071 · 8 ✖

Category 1

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
9855 9855 PRJNA345071_CONTIG_22|Betainfluenzavirus|CLUSTER1_Betainfluenzavirus|18|9 Zebrafish influenza B-like virus Novel PRJNA345071_CONTIG_22|Betainfluenzavirus PRJNA345071_CONTIG_22 Betainfluenzavirus 80 13 8 CLUSTER1_Betainfluenzavirus|18|9 PRJEB2368_P_NODE_159_length_1879_cov_149.901737_g111_i0|Betainfluenzavirus_influenzae|NTclustered|0|NA 18 9 PRJNA345071 22 1844 504.219085 9297.799927 Betainfluenzavirus 197912 Viruses Viruses 900.0 0.0 Betainfluenzavirus Non-phage NTclustered PRJNA345071_P_NODE_22_length_1844_cov_504.219085_g16_i0   Influenza B virus B/Victoria/2/87 segment 5 nucleoprotein (NP) gene, complete cds gi|4760940|gb|AF100359.1|AF100359 11520 g16 i0 77.302 84.33785249 1564 332 84.0 19 37 1590 1743 193 155519 902.0 0.997782705 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Betainfluenzavirus Betainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus Betainfluenzavirus Influenza B virus gi|4760940|gb|AF100359.1|AF100359 Viruses Viruses Viruses Viruses 900.0 845.0 0.0 7.32e-292
9884 9884 PRJNA345071_CONTIG_7|Betainfluenzavirus|CLUSTER2_Betainfluenzavirus|15|6 Zebrafish influenza B-like virus Novel PRJNA345071_CONTIG_7|Betainfluenzavirus PRJNA345071_CONTIG_7 Betainfluenzavirus 80 13 8 CLUSTER2_Betainfluenzavirus|15|6 PRJEB2368_P_NODE_81_length_2400_cov_12.127380_g53_i0|Betainfluenzavirus|NTclustered|0|NA 15 6 PRJNA345071 7 2357 14.318301 337.4823546 Betainfluenzavirus 197912 Viruses Viruses 1628.0 0.0 Betainfluenzavirus Non-phage NTclustered PRJNA345071_P_NODE_7_length_2357_cov_14.318301_g4_i0   Influenza B virus (B/USA/762910_Segment_1/2021) segment 1 polymerase PB1 (PB1) gene, complete cds gi|2054205231|gb|MZ401397.1| 11520 g4 i0 79.504 96.72931693 2298 463 97.0 8 62 2355 2295 2 227991 1628.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Betainfluenzavirus Betainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus Betainfluenzavirus Influenza B virus (B/Lee/194 gi|2054205231|gb|MZ401397.1| Viruses Viruses Viruses Viruses 1628.0 1420.0 0.0 0.0
9885 9885 PRJNA345071_CONTIG_21|Wuhan_spiny_eel_influenza_virus|CLUSTER1_Wuhan_spiny_eel_influenza_virus|15|11 Zebrafish influenza B-like virus Novel PRJNA345071_CONTIG_21|Wuhan_spiny_eel_influenza_virus PRJNA345071_CONTIG_21 Wuhan spiny eel influenza virus 80 13 8 CLUSTER1_Wuhan_spiny_eel_influenza_virus|15|11 PRJNA345071_P_NODE_21_length_1869_cov_841.831292_g15_i0|Wuhan_spiny_eel_influenza_virus|NR|2.51e-251|NA 15 11 PRJNA345071 21 1869 841.831292 15733.82685 Wuhan spiny eel influenza virus 2116483 Viruses Viruses 713.0 2.5100000000000003e-251 Wuhan spiny eel influenza virus Non-phage NR PRJNA345071_P_NODE_21_length_1869_cov_841.831292_g15_i0   AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus] AVM87624.1 2116483 g15 i0 62.7 0.913322632 569 208 91.2 3 1796 93 3 568 1707 713.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Wuhan spiny eel influenza virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus   Wuhan spiny eel influenza virus     Viruses   Viruses   713.0   2.5100000000000003e-251
9890 9890 PRJNA345071_CONTIG_110|Betainfluenzavirus|CLUSTER1_Betainfluenzavirus_influenzae|15|8 Zebrafish influenza B-like virus Novel PRJNA345071_CONTIG_110|Betainfluenzavirus PRJNA345071_CONTIG_110 Betainfluenzavirus influenzae 80 13 8 CLUSTER1_Betainfluenzavirus_influenzae|15|8 PRJNA897077_P_NODE_539_length_1214_cov_128.316389_g477_i0|Betainfluenzavirus|NTclustered|0|NA 15 8 PRJNA345071 110 1179 515.866184 6082.062309 Betainfluenzavirus 197912 Viruses Viruses 641.0 5.610000000000001e-179 Betainfluenzavirus Non-phage NTclustered PRJNA345071_P_NODE_110_length_1179_cov_515.866184_g97_i0   Influenza B virus (B/USA/8B1/2011) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds gi|2449947533|gb|OQ535360.1| 11520 g97 i0 80.546 71.47582697 843 156 71.0 8 6 844 1 839 84270 641.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Betainfluenzavirus Betainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus Betainfluenzavirus Influenza B virus (B/Lee/194 gi|2449947533|gb|OQ535360.1| Viruses Viruses Viruses Viruses 641.0 439.0 5.610000000000001e-179 3.37e-152
9945 9945 PRJNA345071_CONTIG_41|Wuhan_spiny_eel_influenza_virus|CLUSTER2_Wuhan_spiny_eel_influenza_virus|14|10 Zebrafish influenza B-like virus Novel PRJNA345071_CONTIG_41|Wuhan_spiny_eel_influenza_virus PRJNA345071_CONTIG_41 Wuhan spiny eel influenza virus 80 13 8 CLUSTER2_Wuhan_spiny_eel_influenza_virus|14|10 PRJEB2368_P_NODE_284_length_1571_cov_81.546284_g203_i0|Wuhan_spiny_eel_influenza_virus|NR|1.26e-192|NA 14 10 PRJNA345071 41 1563 367.995973 5751.777058 Wuhan spiny eel influenza virus 2116483 Viruses Viruses 578.0 1.75e-201 Wuhan spiny eel influenza virus Non-phage NR PRJNA345071_P_NODE_41_length_1563_cov_367.995973_g33_i0   AVM87625.1 NA [Wuhan spiny eel influenza virus] AVM87625.1 2116483 g33 i0 64.4 0.905950096 472 163 89.6 3 66 1466 1 472 1416 578.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Wuhan spiny eel influenza virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus   Wuhan spiny eel influenza virus     Viruses   Viruses   578.0   1.75e-201
9997 9997 PRJNA345071_CONTIG_6|Betainfluenzavirus|CLUSTER2_Betainfluenzavirus_influenzae|12|6 Zebrafish influenza B-like virus Novel PRJNA345071_CONTIG_6|Betainfluenzavirus PRJNA345071_CONTIG_6 Betainfluenzavirus influenzae 80 13 8 CLUSTER2_Betainfluenzavirus_influenzae|12|6 PRJEB2368_P_NODE_78_length_2413_cov_23.010943_g52_i0|Betainfluenzavirus_influenzae|NTclustered|0|NA 12 6 PRJNA345071 6 2383 21.471429 511.6641531 Betainfluenzavirus 197912 Viruses Viruses 1711.0 0.0 Betainfluenzavirus Non-phage NTclustered PRJNA345071_P_NODE_6_length_2383_cov_21.471429_g3_i0   Influenza B virus (B/USA/5/2017) segment 2 polymerase PB2 (PB2) gene, complete cds gi|2070683497|gb|MZ603947.1| 11520 g3 i0 79.84 99.07091901 2371 456 99.0 22 4 2363 2 2361 236086 1711.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Betainfluenzavirus Betainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus Betainfluenzavirus   gi|2070683497|gb|MZ603947.1| Viruses Viruses Viruses Viruses 1711.0 1422.0 0.0 0.0
9998 9998 PRJNA345071_CONTIG_9|Betainfluenzavirus|CLUSTER3_Betainfluenzavirus|12|7 Zebrafish influenza B-like virus Novel PRJNA345071_CONTIG_9|Betainfluenzavirus PRJNA345071_CONTIG_9 Betainfluenzavirus 80 13 8 CLUSTER3_Betainfluenzavirus|12|7 PRJEB2368_P_NODE_84_length_2374_cov_54.372700_g56_i0|Betainfluenzavirus|NTclustered|0|NA 12 7 PRJNA345071 9 2260 14.909465 336.953909 Betainfluenzavirus 197912 Viruses Viruses 1448.0 0.0 Betainfluenzavirus Non-phage NTclustered PRJNA345071_P_NODE_9_length_2260_cov_14.909465_g6_i0   Influenza B virus (B/Florida/91/2016) polymerase PA (PA) gene, complete cds gi|1128385509|gb|CY211229.1| 1932546 g6 i0 78.662 97.10929204 2198 455 97.0 14 19 2209 2 2192 219467 1448.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Betainfluenzavirus Betainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus Betainfluenzavirus Betainfluenzavirus gi|1128385509|gb|CY211229.1| Viruses Viruses Viruses Viruses 1448.0 1308.0 0.0 0.0
10003 10003 PRJNA345071_CONTIG_152|Betainfluenzavirus_influenzae|CLUSTER3_Betainfluenzavirus_influenzae|12|7 Zebrafish influenza B-like virus Novel PRJNA345071_CONTIG_152|Betainfluenzavirus_influenzae PRJNA345071_CONTIG_152 Betainfluenzavirus influenzae 80 13 8 CLUSTER3_Betainfluenzavirus_influenzae|12|7 PRJEB2368_P_NODE_544_length_1151_cov_155.050269_g412_i0|Betainfluenzavirus_influenzae|NTclustered|9.55e-147|NA 12 7 PRJNA345071 152 1090 195.870206 2134.985245 Betainfluenzavirus influenzae 2955465 Viruses Viruses 468.0 9.29e-127 Betainfluenzavirus influenzae Non-phage NTclustered PRJNA345071_P_NODE_152_length_1090_cov_195.870206_g133_i0   Influenza B virus (B/Great Lakes/1739/1954) segment 8 nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds gi|2413738156|gb|OQ034364.1| 11520 g133 i0 74.886 79.24036697 1099 240 99.0 32 1 1085 1077 1 86372 468.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Betainfluenzavirus Betainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus Betainfluenzavirus influenzae Influenza B virus (B/Lee/194 gi|2413738156|gb|OQ034364.1| Viruses Viruses Viruses Viruses 468.0 387.0 9.29e-127 2.48e-131

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