RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

8 rows where Category = "Novel", bioproject = "PRJNA1002816" and clusterLCA_curated = "Zebrafish jaw poxvirus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

tax_family_NTorNR 1

clusterLCA_curated 1

  • Zebrafish jaw poxvirus · 8 ✖

bioproject 1

  • PRJNA1002816 · 8 ✖

Category 1

  • Novel · 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
5324 5324 PRJNA1002816_CONTIG_7446|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 Zebrafish jaw poxvirus Novel PRJNA1002816_CONTIG_7446|Carp_edema_virus PRJNA1002816_CONTIG_7446 Carp edema virus 4680 143 36 CLUSTER2_Carp_edema_virus|553|75 LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome 552 75 PRJNA1002816 7446 415 0.824561 3.42192815 Carp edema virus 1653087 Viruses Viruses 246.0 9e-73 Carp edema virus Non-phage NR PRJNA1002816_P_NODE_7446_length_415_cov_0.824561_g7286_i0   BCT22673.1 DNA-dependent RNA polymerase subunit rpo132 [Carp edema virus] BCT22673.1 1653087 g7286 i0 83.3 0.997590361 138 23 99.8 0 2 415 1023 1160 414 246.0 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus Thermoplasmatales archaeon Carp edema virus gi|2107746366|gb|CP070836.1| Archaea Viruses Archaea Viruses 60.2 246.0 0.000238 9e-73
5422 5422 PRJNA1002816_CONTIG_17001|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 Zebrafish jaw poxvirus Novel PRJNA1002816_CONTIG_17001|Carp_edema_virus PRJNA1002816_CONTIG_17001 Carp edema virus 4680 143 36 CLUSTER2_Carp_edema_virus|553|75 LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome 552 75 PRJNA1002816 17001 256 1.672131 4.28065536 Carp edema virus 1653087 Viruses Viruses 152.0 1.69e-40 Carp edema virus Non-phage NR PRJNA1002816_P_NODE_17001_length_256_cov_1.672131_g16841_i0   BCT22673.1 DNA-dependent RNA polymerase subunit rpo132 [Carp edema virus] BCT22673.1 1653087 g16841 i0 84.5 0.984375 84 13 98.4 0 3 254 104 187 252 152.0 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus   Carp edema virus     Viruses   Viruses   152.0   1.69e-40
5430 5430 PRJNA1002816_CONTIG_18829|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 Zebrafish jaw poxvirus Novel PRJNA1002816_CONTIG_18829|Carp_edema_virus PRJNA1002816_CONTIG_18829 Carp edema virus 4680 143 36 CLUSTER2_Carp_edema_virus|553|75 LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome 552 75 PRJNA1002816 18829 247 0.885057 2.18609079 Carp edema virus 1653087 Viruses Viruses 110.0 7.53e-26 Carp edema virus Non-phage NR PRJNA1002816_P_NODE_18829_length_247_cov_0.885057_g18669_i0   BCT22634.1 early transcription factor [Carp edema virus] BCT22634.1 1653087 g18669 i0 65.4 0.983805668 81 28 98.4 0 245 3 623 703 243 110.0 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus   Carp edema virus     Viruses   Viruses   110.0   7.53e-26
5439 5439 PRJNA1002816_CONTIG_20008|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 Zebrafish jaw poxvirus Novel PRJNA1002816_CONTIG_20008|Carp_edema_virus PRJNA1002816_CONTIG_20008 Carp edema virus 4680 143 36 CLUSTER2_Carp_edema_virus|553|75 LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome 552 75 PRJNA1002816 20008 243 1.811765 4.40258895 Carp edema virus 1653087 Viruses Viruses 60.5 5.07e-09 Carp edema virus Non-phage NR PRJNA1002816_P_NODE_20008_length_243_cov_1.811765_g19848_i0   UZH43387.1 DNA-binding virion core protein, partial [Carp edema virus] UZH43387.1 1653087 g19848 i0 39.2 1.950617284 79 47 97.5 1 239 3 76 153 474 60.5 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus   Carp edema virus     Viruses   Viruses   60.5   5.07e-09
6881 6881 PRJNA1002816_CONTIG_17332|Carp_edema_virus|CLUSTER7_Carp_edema_virus|191|60 Zebrafish jaw poxvirus Novel PRJNA1002816_CONTIG_17332|Carp_edema_virus PRJNA1002816_CONTIG_17332 Carp edema virus 4680 143 36 CLUSTER7_Carp_edema_virus|191|60 PRJNA318414_P_NODE_4_length_21553_cov_145.486805_g3_i0|Carp_edema_virus|NR|0|NA 184 57 PRJNA1002816 17332 252 1.72067 4.3360884 Carp edema virus 1653087 Viruses Viruses 48.5 0.000384 Carp edema virus Non-phage NR PRJNA1002816_P_NODE_17332_length_252_cov_1.720670_g17172_i0   BCT22653.1 4a protein [Carp edema virus] BCT22653.1 1653087 g17172 i0 35.4 0.976190476 82 49 96.4 3 250 8 59 137 246 48.5 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus   Carp edema virus     Viruses   Viruses   48.5   0.000384
7800 7800 PRJNA1002816_CONTIG_19211|Carp_edema_virus|CLUSTER12_Carp_edema_virus|176|54 Zebrafish jaw poxvirus Novel PRJNA1002816_CONTIG_19211|Carp_edema_virus PRJNA1002816_CONTIG_19211 Carp edema virus 4680 143 36 CLUSTER12_Carp_edema_virus|176|54 PRJNA318414_P_NODE_15_length_10645_cov_116.245761_g12_i0|Carp_edema_virus|NR|2.1e-150|NA 175 54 PRJNA1002816 19211 246 0.890173 2.18982558 Carp edema virus 1653087 Viruses Viruses 72.0 7.59e-13 Carp edema virus Non-phage NR PRJNA1002816_P_NODE_19211_length_246_cov_0.890173_g19051_i0   BCT22614.1 virion assembly protein [Carp edema virus] BCT22614.1 1653087 g19051 i0 51.5 0.804878049 66 31 80.5 1 245 48 124 188 198 72.0 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus   Carp edema virus     Viruses   Viruses   72.0   7.59e-13
7937 7937 PRJNA1002816_CONTIG_8231|Carp_edema_virus|CLUSTER13_Carp_edema_virus|165|64 Zebrafish jaw poxvirus Novel PRJNA1002816_CONTIG_8231|Carp_edema_virus PRJNA1002816_CONTIG_8231 Carp edema virus 4680 143 36 CLUSTER13_Carp_edema_virus|165|64 PRJNA1075480_S_NODE_19_length_10478_cov_35.577415_g8_i0|Carp_edema_virus|NR|1.04e-246|NA 165 64 PRJNA1002816 8231 393 1.08125 4.2493125 Carp edema virus 1653087 Viruses Viruses 78.2 4.57e-15 Carp edema virus Non-phage NR PRJNA1002816_P_NODE_8231_length_393_cov_1.081250_g8071_i0   BCT22600.1 hypothetical protein [Carp edema virus] BCT22600.1 1653087 g8071 i0 39.3 0.893129771 117 68 87.8 2 26 370 62 177 351 78.2 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus Ananas comosus Carp edema virus gi|1885270526|emb|LR862145.1| Plants Viruses Plants Viruses 54.7 78.2 0.01 4.57e-15
8834 8834 PRJNA1002816_CONTIG_15133|Carp_edema_virus|CLUSTER18_Carp_edema_virus|87|53 Zebrafish jaw poxvirus Novel PRJNA1002816_CONTIG_15133|Carp_edema_virus PRJNA1002816_CONTIG_15133 Carp edema virus 4680 143 36 CLUSTER18_Carp_edema_virus|87|53 PRJNA854078_P_NODE_15_length_5165_cov_11.858209_g9_i0|Carp_edema_virus|NR|2.41e-94|NA 86 52 PRJNA1002816 15133 279 1.417476 3.95475804 Carp edema virus 1653087 Viruses Viruses 97.1 4.02e-22 Carp edema virus Non-phage NR PRJNA1002816_P_NODE_15133_length_279_cov_1.417476_g14973_i0   BCT22606.1 hypothetical protein AL387_gp060 [Carp edema virus] BCT22606.1 1653087 g14973 i0 45.1 0.88172043 82 45 88.2 0 1 246 182 263 246 97.1 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Carp edema virus Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus   Carp edema virus     Viruses   Viruses   97.1   4.02e-22

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