RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

10 rows where bioproject = "PRJNA893346" and tax_genus_NTorNR = "Betainfluenzavirus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

tax_genus_NTorNR 1

  • Betainfluenzavirus · 10 ✖

tax_family_NTorNR 1

clusterLCA_curated 1

bioproject 1

  • PRJNA893346 · 10 ✖

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
9860 9860 PRJNA893346_CONTIG_716|Betainfluenzavirus|CLUSTER1_Betainfluenzavirus|18|9 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_716|Betainfluenzavirus PRJNA893346_CONTIG_716 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 PRJNA893346 716 1727 3.243652 56.01787004 Betainfluenzavirus 197912 Viruses Viruses 904.0 0.0 Betainfluenzavirus Non-phage NTclustered PRJNA893346_P_NODE_716_length_1727_cov_3.243652_g589_i0   Influenza B virus B/Victoria/2/87 segment 5 nucleoprotein (NP) gene, complete cds gi|4760940|gb|AF100359.1|AF100359 11520 g589 i0 77.89 85.12159815 1479 309 85.0 15 9 1479 1661 193 147005 904.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 gi|4760940|gb|AF100359.1|AF100359 Viruses Viruses Viruses Viruses 904.0 854.0 0.0 5.15e-305
9861 9861 PRJNA893346_CONTIG_783|Betainfluenzavirus|CLUSTER1_Betainfluenzavirus|18|9 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_783|Betainfluenzavirus PRJNA893346_CONTIG_783 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 PRJNA893346 783 1670 3.524734 58.8630578 Betainfluenzavirus 197912 Viruses Viruses 944.0 0.0 Betainfluenzavirus Non-phage NTclustered PRJNA893346_P_NODE_783_length_1670_cov_3.524734_g642_i0   Influenza B virus (B/Michigan/UM-10057023818/2024) segment 5 nucleoprotein (NP) gene, complete cds gi|2733713083|gb|PP810550.1| 11520 g642 i0 78.334 88.45269461 1477 308 88.0 12 199 1670 199 1668 147716 950.0 0.993684211 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|2733713083|gb|PP810550.1| Viruses Viruses Viruses Viruses 944.0 855.0 0.0 1.22e-305
9908 9908 PRJNA893346_CONTIG_1995|Betainfluenzavirus_influenzae|CLUSTER1_Betainfluenzavirus_influenzae|15|8 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_1995|Betainfluenzavirus_influenzae PRJNA893346_CONTIG_1995 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 PRJNA893346 1995 1155 4.365065 50.41650075 Betainfluenzavirus influenzae 2955465 Viruses Viruses 625.0 5.53e-174 Betainfluenzavirus influenzae Non-phage NTclustered PRJNA893346_P_NODE_1995_length_1155_cov_4.365065_g1709_i0   Influenza B virus (B/Michigan/1/1971) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds gi|2413738133|gb|OQ034387.1| 11520 g1709 i0 80.143 72.86666667 841 163 73.0 4 317 1155 839 1 84161 625.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|2413738133|gb|OQ034387.1| Viruses Viruses Viruses Viruses 625.0 439.0 5.53e-174 2.59e-152
9911 9911 PRJNA893346_CONTIG_2869|Betainfluenzavirus_influenzae|CLUSTER1_Betainfluenzavirus_influenzae|15|8 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_2869|Betainfluenzavirus_influenzae PRJNA893346_CONTIG_2869 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 PRJNA893346 2869 973 5.24 50.9852 Betainfluenzavirus influenzae 2955465 Viruses Viruses 579.0 3.66e-160 Betainfluenzavirus influenzae Non-phage NTclustered PRJNA893346_P_NODE_2869_length_973_cov_5.240000_g2509_i0   Influenza B virus (B/California/H20-358-8435_B_MP/2024) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds gi|2716343578|gb|PP647745.1| 11520 g2509 i0 80.92 82.82322713 739 136 76.0 5 237 973 809 74 80587 579.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 Betainfluenzavirus gi|2716343578|gb|PP647745.1| Viruses Viruses Viruses Viruses 579.0 397.0 3.66e-160 5.559999999999999e-137
9931 9931 PRJNA893346_CONTIG_22948|Betainfluenzavirus|CLUSTER2_Betainfluenzavirus|15|6 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_22948|Betainfluenzavirus PRJNA893346_CONTIG_22948 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 PRJNA893346 22948 320 1.242915 3.977328 Betainfluenzavirus 197912 Viruses Viruses 204.0 1.03e-59 Betainfluenzavirus Non-phage NR PRJNA893346_P_NODE_22948_length_320_cov_1.242915_g22458_i0   QDC27501.1 polymerase PB1 [Influenza B virus] QDC27501.1 11520 g22458 i0 91.5 26.83125 106 9 99.4 0 319 2 52 157 8586 205.0 0.995121951 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Betainfluenzavirus Betainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus Alphainfluenzavirus influenzae Betainfluenzavirus gi|1800416214|gb|MN988382.1| Viruses Viruses Viruses Viruses 65.8 204.0 3.85e-06 1.03e-59
9934 9934 PRJNA893346_CONTIG_26708|Betainfluenzavirus|CLUSTER2_Betainfluenzavirus|15|6 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_26708|Betainfluenzavirus PRJNA893346_CONTIG_26708 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 PRJNA893346 26708 292 1.520548 4.44000016 Betainfluenzavirus 197912 Viruses Viruses 197.0 2.79e-58 Betainfluenzavirus Non-phage NR PRJNA893346_P_NODE_26708_length_292_cov_1.520548_g26218_i0   QCT23357.1 polymerase PB1, partial [Influenza B virus] QCT23357.1 11520 g26218 i0 97.9 21.91438356 97 2 99.7 0 1 291 253 349 6399 197.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     Viruses   Viruses   197.0   2.79e-58
9936 9936 PRJNA893346_CONTIG_36669|Betainfluenzavirus_influenzae|CLUSTER2_Betainfluenzavirus|15|6 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_36669|Betainfluenzavirus_influenzae PRJNA893346_CONTIG_36669 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 PRJNA893346 36669 246 0.890173 2.18982558 Betainfluenzavirus influenzae 2955465 Viruses Viruses 209.0 1.25e-49 Betainfluenzavirus influenzae Non-phage NTclustered PRJNA893346_P_NODE_36669_length_246_cov_0.890173_g36179_i0   Influenza B virus (B/King County/WA-S27676/2019) segment 1 polymerase PB1 (PB1) gene, complete cds gi|2915735270|gb|PV141215.1| 11520 g36179 i0 82.427 9.666666667 239 42 97.0 0 8 246 239 1 2378 209.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/Brisbane/39/2 gi|2915735270|gb|PV141215.1| Viruses Viruses Viruses Viruses 209.0 154.0 1.25e-49 9.829999999999999e-46
10022 10022 PRJNA893346_CONTIG_2447|Betainfluenzavirus|CLUSTER3_Betainfluenzavirus_influenzae|12|7 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_2447|Betainfluenzavirus PRJNA893346_CONTIG_2447 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 PRJNA893346 2447 1048 6.811282 71.38223536 Betainfluenzavirus 197912 Viruses Viruses 438.0 6.99e-118 Betainfluenzavirus Non-phage NTclustered PRJNA893346_P_NODE_2447_length_1048_cov_6.811282_g2121_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 g2121 i0 74.67 99.45229008 1062 233 100.0 32 1 1048 1053 14 104226 438.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|2413738156|gb|OQ034364.1| Viruses Viruses Viruses Viruses 438.0 390.0 6.99e-118 4.47e-133
10044 10044 PRJNA893346_CONTIG_22202|Betainfluenzavirus|CLUSTER2_Betainfluenzavirus_influenzae|12|6 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_22202|Betainfluenzavirus PRJNA893346_CONTIG_22202 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 PRJNA893346 22202 326 1.023715 3.3373109 Betainfluenzavirus 197912 Viruses Viruses 201.0 2.4400000000000002e-58 Betainfluenzavirus Non-phage NR PRJNA893346_P_NODE_22202_length_326_cov_1.023715_g21713_i0   AXG64340.1 polymerase PB2, partial [Influenza B virus] AXG64340.1 11520 g21713 i0 90.7 8.944785276 108 10 99.4 0 325 2 400 507 2916 201.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     Viruses   Viruses   201.0   2.4400000000000002e-58
10045 10045 PRJNA893346_CONTIG_22909|Betainfluenzavirus|CLUSTER3_Betainfluenzavirus|12|7 Zebrafish influenza B-like virus Novel PRJNA893346_CONTIG_22909|Betainfluenzavirus PRJNA893346_CONTIG_22909 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 PRJNA893346 22909 320 1.558704 4.9878528 Betainfluenzavirus 197912 Viruses Viruses 199.0 1.7100000000000002e-59 Betainfluenzavirus Non-phage NR PRJNA893346_P_NODE_22909_length_320_cov_1.558704_g22419_i0   QCT23030.1 polymerase PA, partial [Influenza B virus] QCT23030.1 11520 g22419 i0 88.7 14.90625 106 12 99.4 0 1 318 42 147 4770 199.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     Viruses   Viruses   199.0   1.7100000000000002e-59

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