RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

7 rows where bioproject = "PRJNA1150539"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_family_NTorNR 4

tax_genus_NTorNR 1

bioproject 1

  • PRJNA1150539 · 7 ✖
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
3015 3015 PRJNA1150539_CONTIG_21561|Zebrafish_picornavirus_2|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA1150539_CONTIG_21561|Zebrafish_picornavirus_2 PRJNA1150539_CONTIG_21561 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 PRJNA1150539 21561 377 1.013158 3.81960566 Zebrafish picornavirus 2 3063761 Viruses Viruses 186.0 1.29e-51 Zebrafish picornavirus 2 Non-phage NR PRJNA1150539_S_NODE_21561_length_377_cov_1.013158_g20965_i0   WKU61618.1 polyprotein [Zebrafish picornavirus 2] WKU61618.1 3063761 g20965 i0 96.7 0.724137931 91 3 72.4 0 376 104 2130 2220 273 186.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     Viruses   Viruses   186.0   1.29e-51
6211 6211 PRJNA1150539_CONTIG_100836|Carp_edema_virus|CLUSTER4_Carp_edema_virus|348|78 Zebrafish jaw poxvirus Novel PRJNA1150539_CONTIG_100836|Carp_edema_virus PRJNA1150539_CONTIG_100836 Carp edema virus 4680 143 36 CLUSTER4_Carp_edema_virus|348|78 PRJNA1075480_S_NODE_1_length_24682_cov_102.472876_g0_i0|Carp_edema_virus|NR|2.31e-98|NA 331 77 PRJNA1150539 100836 243 0.905882 2.20129326 Carp edema virus 1653087 Viruses Viruses 73.2 5.75e-14 Carp edema virus Non-phage NR PRJNA1150539_S_NODE_100836_length_243_cov_0.905882_g100240_i0   BCT22576.1 deoxyuridine triphosphatase [Carp edema virus] BCT22576.1 1653087 g100240 i0 53.1 1.0 81 37 98.8 1 2 241 86 166 243 73.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   73.2   5.75e-14
9250 9250 PRJNA1150539_CONTIG_92434|Hardyhead_chuvirus|CLUSTER1_Salarius_guttatus_piscichuvirus|63|56 Salarius guttatus piscichuvirus Endogenous or not fish-associated PRJNA1150539_CONTIG_92434|Hardyhead_chuvirus PRJNA1150539_CONTIG_92434 Salarius guttatus piscichuvirus 67 58 5 CLUSTER1_Salarius_guttatus_piscichuvirus|63|56 PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0|Salarius_guttatus_piscichuvirus|NR|7.17e-28|NA 63 56 PRJNA1150539 92434 251 0.865169 2.17157419 Hardyhead chuvirus 2830721 Viruses Viruses 52.8 1.25e-05 Hardyhead chuvirus Non-phage NR PRJNA1150539_S_NODE_92434_length_251_cov_0.865169_g91838_i0   YP_010840939.1 L protein [Hardyhead chuvirus] YP_010840939.1 2830721 g91838 i0 40.7 1.027888446 86 47 98.0 2 246 1 24 109 258 52.8 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Piscichuvirus craterocephali Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus   Hardyhead chuvirus     Viruses   Viruses   52.8   1.25e-05
9986 9986 PRJNA1150539_CONTIG_16621|Adintovirus_anguilla1|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1150539_CONTIG_16621|Adintovirus_anguilla1 PRJNA1150539_CONTIG_16621 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA1150539 16621 396 2.439628 9.66092688 Adintovirus anguilla1 3115889 Viruses Viruses 65.1 3.06e-10 Adintovirus anguilla1 Non-phage NR PRJNA1150539_S_NODE_16621_length_396_cov_2.439628_g16026_i0   DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] DBA49781.1 3115889 g16026 i0 62.2 0.340909091 45 17 34.1 0 269 135 7 51 135 65.1 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   65.1   3.06e-10
10132 10132 PRJNA1150539_CONTIG_13470|Polintoviricetes|CLUSTER1_Astyanax_tetra_cavefish_adintovirus|7|6 Astyanax tetra cavefish adintovirus Insufficient Evidence PRJNA1150539_CONTIG_13470|Polintoviricetes PRJNA1150539_CONTIG_13470 Astyanax tetra cavefish adintovirus 22 15 8 CLUSTER1_Astyanax_tetra_cavefish_adintovirus|7|6 PRJNA1150539_S_NODE_13470_length_412_cov_4.790560_g12875_i0|Polintoviricetes|NR|4.65e-24|NA 7 6 PRJNA1150539 13470 412 4.79056 19.7371072 Polintoviricetes 2842244 Viruses Viruses 102.0 4.65e-24 Polintoviricetes Non-phage NR PRJNA1150539_S_NODE_13470_length_412_cov_4.790560_g12875_i0   YP_010796956.1 FtsK [Terrapene box turtle adintovirus] YP_010796956.1 2597808 g12875 i0 53.8 1.871359223 93 33 62.6 2 412 155 134 223 771 103.0 0.990291262 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes       Betadintovirus terrapene Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Astyanax tetra cavefish adintovirus   Polintoviricetes     Viruses   Viruses   102.0   4.65e-24
10221 10221 PRJNA1150539_CONTIG_33506|Astyanax_tetra_cavefish_adintovirus|CLUSTER3_Astyanax_tetra_cavefish_adintovirus|3|3 Astyanax tetra cavefish adintovirus Insufficient Evidence PRJNA1150539_CONTIG_33506|Astyanax_tetra_cavefish_adintovirus PRJNA1150539_CONTIG_33506 Astyanax tetra cavefish adintovirus 22 15 8 CLUSTER3_Astyanax_tetra_cavefish_adintovirus|3|3 PRJNA1150539_S_NODE_33506_length_344_cov_2.450185_g32910_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.21e-43|NA 2 2 PRJNA1150539 33506 344 2.450185 8.4286364 Astyanax tetra cavefish adintovirus 2609866 Viruses Viruses 155.0 1.21e-43 Astyanax tetra cavefish adintovirus Non-phage NR PRJNA1150539_S_NODE_33506_length_344_cov_2.450185_g32910_i0   DAC81252.1 TPA_asm: integrase [Astyanax tetra cavefish adintovirus] DAC81252.1 2609866 g32910 i0 74.0 2.625 100 26 87.2 0 309 10 145 244 903 155.0 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Astyanax tetra cavefish adintovirus Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Astyanax tetra cavefish adintovirus   Astyanax tetra cavefish adintovirus     Viruses   Viruses   155.0   1.21e-43
10480 10480 PRJNA1150539_CONTIG_80848|Pimephales_minnow_adintovirus|CLUSTER19_Pimephales_minnow_adintovirus|1|1 Pimephales minnow adintovirus Endogenous or not fish-associated PRJNA1150539_CONTIG_80848|Pimephales_minnow_adintovirus PRJNA1150539_CONTIG_80848 Pimephales minnow adintovirus 168 104 20 CLUSTER19_Pimephales_minnow_adintovirus|1|1 PRJNA1150539_S_NODE_80848_length_265_cov_1.244792_g80252_i0|Pimephales_minnow_adintovirus|NR|3.42e-08|NA 1 1 PRJNA1150539 80848 265 1.244792 3.2986988 Pimephales minnow adintovirus 2609864 Viruses Viruses 58.5 3.42e-08 Pimephales minnow adintovirus Non-phage NR PRJNA1150539_S_NODE_80848_length_265_cov_1.244792_g80252_i0   DAC81397.1 TPA_asm: adenain [Pimephales minnow adintovirus] DAC81397.1 2609864 g80252 i0 46.3 1.833962264 54 29 61.1 0 58 219 71 124 486 58.5 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Pimephales minnow adintovirus   Pimephales minnow adintovirus     Viruses   Viruses   58.5   3.42e-08

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