RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

12 rows where bioproject = "PRJNA715463"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 2

tax_family_NTorNR 2

tax_genus_NTorNR 1

bioproject 1

  • PRJNA715463 · 12 ✖
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
4651 4651 PRJNA715463_CONTIG_4274|Carp_edema_virus|CLUSTER1_Carp_edema_virus|632|87 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_4274|Carp_edema_virus PRJNA715463_CONTIG_4274 Carp edema virus 4680 143 36 CLUSTER1_Carp_edema_virus|632|87 PRJNA1075480_S_NODE_3_length_24555_cov_43.250551_g1_i0|Carp_edema_virus|NR|0|NA 629 87 PRJNA715463 4274 389 1.848101 7.18911289 Carp edema virus 1653087 Viruses Viruses 176.0 2.5e-49 Carp edema virus Non-phage NR PRJNA715463_P_NODE_4274_length_389_cov_1.848101_g4141_i0   BCT22642.1 trimeric virion coat protein [Carp edema virus] BCT22642.1 1653087 g4141 i0 63.3 0.98714653 128 47 98.7 0 388 5 430 557 384 176.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   176.0   2.5e-49
4876 4876 PRJNA715463_CONTIG_27376|Carp_edema_virus|CLUSTER1_Carp_edema_virus|632|87 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_27376|Carp_edema_virus PRJNA715463_CONTIG_27376 Carp edema virus 4680 143 36 CLUSTER1_Carp_edema_virus|632|87 PRJNA1075480_S_NODE_3_length_24555_cov_43.250551_g1_i0|Carp_edema_virus|NR|0|NA 629 87 PRJNA715463 27376 249 2.545455 6.33818295 Carp edema virus 1653087 Viruses Viruses 101.0 6.77e-24 Carp edema virus Non-phage NR PRJNA715463_P_NODE_27376_length_249_cov_2.545455_g27243_i0   BCT22641.1 myristylated IMV envelope protein [Carp edema virus] BCT22641.1 1653087 g27243 i0 63.0 0.975903614 81 30 97.6 0 243 1 1 81 243 101.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   101.0   6.77e-24
5462 5462 PRJNA715463_CONTIG_26634|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_26634|Carp_edema_virus PRJNA715463_CONTIG_26634 Carp edema virus 4680 143 36 CLUSTER2_Carp_edema_virus|553|75 LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome 552 75 PRJNA715463 26634 250 1.689266 4.223165 Carp edema virus 1653087 Viruses Viruses 81.3 5.33e-16 Carp edema virus Non-phage NR PRJNA715463_P_NODE_26634_length_250_cov_1.689266_g26501_i0   BCT22680.1 DNA-directed RNA polymerase, 35 kD subunit [Carp edema virus] BCT22680.1 1653087 g26501 i0 51.3 0.912 76 37 91.2 0 19 246 205 280 228 81.3 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   81.3   5.33e-16
5464 5464 PRJNA715463_CONTIG_27152|Carp_edema_virus|CLUSTER2_Carp_edema_virus|553|75 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_27152|Carp_edema_virus PRJNA715463_CONTIG_27152 Carp edema virus 4680 143 36 CLUSTER2_Carp_edema_virus|553|75 LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome 552 75 PRJNA715463 27152 250 0.870056 2.17514 Carp edema virus 1653087 Viruses Viruses 55.8 3.27e-07 Carp edema virus Non-phage NR PRJNA715463_P_NODE_27152_length_250_cov_0.870056_g27019_i0   UZH43387.1 DNA-binding virion core protein, partial [Carp edema virus] UZH43387.1 1653087 g27019 i0 46.8 1.488 62 32 74.4 1 223 38 112 172 372 55.8 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   55.8   3.27e-07
6651 6651 PRJNA715463_CONTIG_8188|Carp_edema_virus|CLUSTER6_Carp_edema_virus|274|111 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_8188|Carp_edema_virus PRJNA715463_CONTIG_8188 Carp edema virus 4680 143 36 CLUSTER6_Carp_edema_virus|274|111 PRJNA1075480_S_NODE_10_length_11763_cov_107.476048_g4_i0|Carp_edema_virus|NR|0|NA 264 107 PRJNA715463 8188 310 4.49789 13.943459 Carp edema virus 1653087 Viruses Viruses 59.3 1.1e-07 Carp edema virus Non-phage NR PRJNA715463_P_NODE_8188_length_310_cov_4.497890_g8055_i0   BCT22626.1 putative DNA-binding virion core protein [Carp edema virus] BCT22626.1 1653087 g8055 i0 36.9 0.812903226 84 43 71.6 1 10 231 229 312 252 59.3 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   59.3   1.1e-07
6873 6873 PRJNA715463_CONTIG_13336|Carp_edema_virus|CLUSTER7_Carp_edema_virus|191|60 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_13336|Carp_edema_virus PRJNA715463_CONTIG_13336 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 PRJNA715463 13336 280 2.971014 8.3188392 Carp edema virus 1653087 Viruses Viruses 43.9 0.0236 Carp edema virus Non-phage NR PRJNA715463_P_NODE_13336_length_280_cov_2.971014_g13203_i0   BCT22653.1 4a protein [Carp edema virus] BCT22653.1 1653087 g13203 i0 37.1 0.664285714 62 33 62.1 3 247 74 14 73 186 43.9 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   43.9   0.0236
6898 6898 PRJNA715463_CONTIG_40600|Carp_edema_virus|CLUSTER7_Carp_edema_virus|191|60 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_40600|Carp_edema_virus PRJNA715463_CONTIG_40600 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 PRJNA715463 40600 212 4.18705 8.876546 Carp edema virus 1653087 Viruses Viruses 61.2 7.36e-09 Carp edema virus Non-phage NR PRJNA715463_P_NODE_40600_length_212_cov_4.187050_g40467_i0   BCT22659.1 divergent Flap Endonuclease [Carp edema virus] BCT22659.1 1653087 g40467 i0 38.4 1.033018868 73 42 99.1 1 211 2 381 453 219 61.2 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   61.2   7.36e-09
7189 7189 PRJNA715463_CONTIG_17390|Carp_edema_virus|CLUSTER8_Carp_edema_virus|189|52 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_17390|Carp_edema_virus PRJNA715463_CONTIG_17390 Carp edema virus 4680 143 36 CLUSTER8_Carp_edema_virus|189|52 PRJEB2894_P_NODE_1_length_11775_cov_16.335690_g0_i0|Carp_edema_virus|NR|0|NA 189 52 PRJNA715463 17390 269 1.571429 4.22714401 Carp edema virus 1653087 Viruses Viruses 119.0 8.52e-30 Carp edema virus Non-phage NR PRJNA715463_P_NODE_17390_length_269_cov_1.571429_g17257_i0   BCT22672.1 sialidase [Carp edema virus] BCT22672.1 1653087 g17257 i0 62.5 0.981412639 88 33 98.1 0 6 269 96 183 264 119.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   119.0   8.52e-30
7917 7917 PRJNA715463_CONTIG_3978|Carp_edema_virus|CLUSTER13_Carp_edema_virus|165|64 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_3978|Carp_edema_virus PRJNA715463_CONTIG_3978 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 PRJNA715463 3978 399 1.834356 7.31908044 Carp edema virus 1653087 Viruses Viruses 49.3 0.00108 Carp edema virus Non-phage NR PRJNA715463_P_NODE_3978_length_399_cov_1.834356_g3845_i0   BCT22597.1 peptidase M60-like family [Carp edema virus] BCT22597.1 1653087 g3845 i0 48.8 0.323308271 43 20 32.3 1 189 61 6 46 129 49.3 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   49.3   0.00108
7980 7980 PRJNA715463_CONTIG_25423|Carp_edema_virus|CLUSTER13_Carp_edema_virus|165|64 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_25423|Carp_edema_virus PRJNA715463_CONTIG_25423 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 PRJNA715463 25423 251 2.269663 5.69685413 Carp edema virus 1653087 Viruses Viruses 66.2 1.67e-10 Carp edema virus Non-phage NR PRJNA715463_P_NODE_25423_length_251_cov_2.269663_g25290_i0   BCT22598.1 hypothetical protein [Carp edema virus] BCT22598.1 1653087 g25290 i0 42.7 0.896414343 75 43 89.6 0 6 230 113 187 225 66.2 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   66.2   1.67e-10
8746 8746 PRJNA715463_CONTIG_18780|Carp_edema_virus|CLUSTER16_Carp_edema_virus|89|60 Zebrafish jaw poxvirus Novel PRJNA715463_CONTIG_18780|Carp_edema_virus PRJNA715463_CONTIG_18780 Carp edema virus 4680 143 36 CLUSTER16_Carp_edema_virus|89|60 PRJNA318414_P_NODE_16_length_10532_cov_251.265543_g13_i0|Carp_edema_virus|NR|5.62e-42|NA 79 59 PRJNA715463 18780 266 1.404145 3.7350257 Carp edema virus 1653087 Viruses Viruses 66.6 2.5e-11 Carp edema virus Non-phage NR PRJNA715463_P_NODE_18780_length_266_cov_1.404145_g18647_i0   BCT22744.1 hypothetical protein [Carp edema virus] BCT22744.1 1653087 g18647 i0 62.3 0.597744361 53 20 59.8 0 9 167 3 55 159 66.6 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   66.6   2.5e-11
10145 10145 PRJNA715463_CONTIG_36045|Sea_turtle_neural_virus_1|CLUSTER1_Sea_turtle_neural_virus_1|7|7 Sea turtle neural virus 1 Endogenous or not fish-associated PRJNA715463_CONTIG_36045|Sea_turtle_neural_virus_1 PRJNA715463_CONTIG_36045 Sea turtle neural virus 1 8 8 2 CLUSTER1_Sea_turtle_neural_virus_1|7|7 PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0|Sea_turtle_neural_virus_1|NR|0.0109|NA 7 7 PRJNA715463 36045 241 1.761905 4.24619105 Sea turtle neural virus 1 3112944 Viruses Viruses 42.4 0.0478 Sea turtle neural virus 1 Non-phage NR PRJNA715463_P_NODE_36045_length_241_cov_1.761905_g35912_i0   WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] WET19891.1 3112944 g35912 i0 59.4 0.398340249 32 13 39.8 0 3 98 466 497 96 42.4 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Sea turtle neural virus 1 Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus;Sea turtle neural virus 1   Sea turtle neural virus 1     Viruses   Viruses   42.4   0.0478

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