RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

6 rows where Category = "Novel" and bioproject = "PRJNA982106"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_family_NTorNR 2

tax_genus_NTorNR 1

bioproject 1

  • PRJNA982106 · 6 ✖

Category 1

  • Novel · 6 ✖
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
1924 1924 PRJNA982106_CONTIG_5|Zebrafish_picornavirus_2|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA982106_CONTIG_5|Zebrafish_picornavirus_2 PRJNA982106_CONTIG_5 Zebrafish picornavirus 2 1369 320 1 CLUSTER1_Zebrafish_picornavirus_2|1382|320 PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0|Zebrafish_picornavirus_2|NR|0|NA 1370 320 PRJNA982106 5 7162 11.49076 822.9682312 Zebrafish picornavirus 2 3063761 Viruses Viruses 2844.0 0.0 Zebrafish picornavirus 2 Non-phage NTclustered PRJNA982106_P_NODE_5_length_7162_cov_11.490760_g2_i0   Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds gi|2551699335|gb|OK619588.1| 3063761 g2 i0 96.205 0.665875454 1739 61 67.0 5 5426 7162 5329 7064 4769 2844.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 2 Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2 Zebrafish picornavirus 2 Zebrafish picornavirus 2 gi|2551699335|gb|OK619588.1| Viruses Viruses Viruses Viruses 2844.0 2485.0 0.0 0.0
3056 3056 PRJNA982106_CONTIG_28299|Zebrafish_picornavirus_2|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA982106_CONTIG_28299|Zebrafish_picornavirus_2 PRJNA982106_CONTIG_28299 Zebrafish picornavirus 2 1369 320 1 CLUSTER1_Zebrafish_picornavirus_2|1382|320 PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0|Zebrafish_picornavirus_2|NR|0|NA 1370 320 PRJNA982106 28299 244 1.614035 3.9382454 Zebrafish picornavirus 2 3063761 Viruses Viruses 324.0 4.22e-84 Zebrafish picornavirus 2 Non-phage NTclustered PRJNA982106_P_NODE_28299_length_244_cov_1.614035_g28059_i0   Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds gi|2551699335|gb|OK619588.1| 3063761 g28059 i0 90.612 1.004098361 245 21 100.0 2 1 244 5862 6105 245 324.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 2 Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2 Zebrafish picornavirus 2 Zebrafish picornavirus 2 gi|2551699335|gb|OK619588.1| Viruses Viruses Viruses Viruses 324.0 146.0 4.22e-84 1.58e-38
9866 9866 PRJNA982106_CONTIG_2961|Betainfluenzavirus|CLUSTER1_Betainfluenzavirus|18|9 Zebrafish influenza B-like virus Novel PRJNA982106_CONTIG_2961|Betainfluenzavirus PRJNA982106_CONTIG_2961 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 PRJNA982106 2961 508 1.482759 7.53241572 Betainfluenzavirus 197912 Viruses Viruses 291.0 2.4099999999999998e-95 Betainfluenzavirus Non-phage NR PRJNA982106_P_NODE_2961_length_508_cov_1.482759_g2722_i0   AXG64379.1 nucleoprotein, partial [Influenza B virus] AXG64379.1 11520 g2722 i0 87.6 6.986220472 169 21 99.8 0 2 508 18 186 3549 291.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   291.0   2.4099999999999998e-95
9927 9927 PRJNA982106_CONTIG_16846|Betainfluenzavirus|CLUSTER1_Betainfluenzavirus_influenzae|15|8 Zebrafish influenza B-like virus Novel PRJNA982106_CONTIG_16846|Betainfluenzavirus PRJNA982106_CONTIG_16846 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 PRJNA982106 16846 272 1.683417 4.57889424 Betainfluenzavirus 197912 Viruses Viruses 222.0 1.8e-53 Betainfluenzavirus Non-phage NTclustered PRJNA982106_P_NODE_16846_length_272_cov_1.683417_g16606_i0   Influenza B virus (B/California/78/2019) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds gi|1808629704|gb|MT049059.1| 11520 g16606 i0 82.129 96.80147059 263 44 96.0 3 7 268 344 604 26330 222.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|1808629704|gb|MT049059.1| Viruses Viruses Viruses Viruses 222.0 157.0 1.8e-53 3.12e-46
9958 9958 PRJNA982106_CONTIG_2476|Wuhan_spiny_eel_influenza_virus|CLUSTER2_Wuhan_spiny_eel_influenza_virus|14|10 Zebrafish influenza B-like virus Novel PRJNA982106_CONTIG_2476|Wuhan_spiny_eel_influenza_virus PRJNA982106_CONTIG_2476 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 PRJNA982106 2476 552 1.202505 6.6378276 Wuhan spiny eel influenza virus 2116483 Viruses Viruses 217.0 7.87e-66 Wuhan spiny eel influenza virus Non-phage NR PRJNA982106_P_NODE_2476_length_552_cov_1.202505_g2238_i0   7XVR_A Chain A, Neuraminidase [Wuhan spiny eel influenza virus] 7XVR_A 2116483 g2238 i0 61.7 1.989130435 183 70 99.5 0 550 2 172 354 1098 217.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         Viruses   Viruses   217.0   7.87e-66
10035 10035 PRJNA982106_CONTIG_16850|Betainfluenzavirus|CLUSTER3_Betainfluenzavirus|12|7 Zebrafish influenza B-like virus Novel PRJNA982106_CONTIG_16850|Betainfluenzavirus PRJNA982106_CONTIG_16850 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 PRJNA982106 16850 272 1.547739 4.20985008 Betainfluenzavirus 197912 Viruses Viruses 173.0 2.7799999999999995e-48 Betainfluenzavirus Non-phage NR PRJNA982106_P_NODE_16850_length_272_cov_1.547739_g16610_i0   NP_056659.1 polymerase PA [Influenza B virus (B/Lee/1940)] NP_056659.1 518987 g16610 i0 92.2 18.86029412 90 7 99.3 0 3 272 570 659 5130 173.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   173.0   2.7799999999999995e-48

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