RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

9 rows where Category = "Endogenous or not fish-associated" and bioproject = "PRJNA784979"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_genus_NTorNR 2

tax_family_NTorNR 2

bioproject 1

  • PRJNA784979 · 9 ✖

Category 1

  • Endogenous or not fish-associated · 9 ✖
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
9783 9783 PRJNA784979_CONTIG_534|Fish-associated_parvo-like_hybrid_virus|CLUSTER1_Fish-associated_parvo-like_hybrid_virus|21|14 Fish-associated parvo-like hybrid virus Endogenous or not fish-associated PRJNA784979_CONTIG_534|Fish-associated_parvo-like_hybrid_virus PRJNA784979_CONTIG_534 Fish-associated parvo-like hybrid virus 35 19 4 CLUSTER1_Fish-associated_parvo-like_hybrid_virus|21|14 MT138265_1_MAG_Nicoomyvirus_lizumae_isolate_par077par1_genomic_sequence 21 14 PRJNA784979 534 995 4.679704 46.5630548 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 1622.0 0.0 Fish-associated parvo-like hybrid virus Non-phage NTclustered PRJNA784979_S_NODE_534_length_995_cov_4.679704_g517_i0   MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds gi|2413975758|gb|OP933682.1| 3003968 g517 i0 99.662 7.115577889 887 3 89.0 0 104 990 796 1682 7080 1622.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Fish-associated parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus Fish-associated parvo-like hybrid virus Parvo-like hybrid virus UC4 gi|2413975758|gb|OP933682.1| Viruses Viruses Viruses Viruses 1622.0 538.0 0.0 6.36e-190
9784 9784 PRJNA784979_CONTIG_749|Fish-associated_parvo-like_hybrid_virus|CLUSTER1_Fish-associated_parvo-like_hybrid_virus|21|14 Fish-associated parvo-like hybrid virus Endogenous or not fish-associated PRJNA784979_CONTIG_749|Fish-associated_parvo-like_hybrid_virus PRJNA784979_CONTIG_749 Fish-associated parvo-like hybrid virus 35 19 4 CLUSTER1_Fish-associated_parvo-like_hybrid_virus|21|14 MT138265_1_MAG_Nicoomyvirus_lizumae_isolate_par077par1_genomic_sequence 21 14 PRJNA784979 749 710 3.258699 23.1367629 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 156.0 5.2600000000000004e-33 Fish-associated parvo-like hybrid virus Non-phage NTclustered PRJNA784979_S_NODE_749_length_710_cov_3.258699_g712_i0   MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds gi|2413975758|gb|OP933682.1| 3003968 g712 i0 89.062 0.538028169 128 10 18.0 4 49 174 79 204 382 156.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Fish-associated parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus Fish-associated parvo-like hybrid virus   gi|2413975758|gb|OP933682.1| Viruses   Viruses   156.0   5.2600000000000004e-33  
9912 9912 PRJNA784979_CONTIG_3690|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA784979_CONTIG_3690|Psittacidae_aveparvovirus PRJNA784979_CONTIG_3690 Psittacidae aveparvovirus 18 10 4 CLUSTER1_Psittacidae_aveparvovirus|15|6 MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence 15 6 PRJNA784979 3690 242 1.948187 4.71461254 Psittacidae aveparvovirus 2794556 Viruses Viruses 327.0 3.23e-85 Psittacidae aveparvovirus Non-phage NTclustered PRJNA784979_S_NODE_3690_length_242_cov_1.948187_g3648_i0   MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence gi|2015372674|gb|MW046380.1| 2794556 g3648 i0 91.561 1.946280992 237 20 98.0 0 6 242 1647 1883 471 327.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus Psittacidae aveparvovirus Psittacidae aveparvovirus gi|2015372674|gb|MW046380.1| Viruses Viruses Viruses Viruses 327.0 159.0 3.23e-85 3.87e-45
9950 9950 PRJNA784979_CONTIG_320|Fish-associated_parvo-like_hybrid_virus|CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 Fish-associated parvo-like hybrid virus Endogenous or not fish-associated PRJNA784979_CONTIG_320|Fish-associated_parvo-like_hybrid_virus PRJNA784979_CONTIG_320 Fish-associated parvo-like hybrid virus 35 19 4 CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA 14 7 PRJNA784979 320 2507 3.719284 93.24244988 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 1037.0 0.0 Fish-associated parvo-like hybrid virus Non-phage NTclustered PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0   MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds gi|2413975758|gb|OP933682.1| 3003968 g317 i0 82.309 2.573195054 1204 205 48.0 8 1273 2472 2049 850 6451 1037.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Fish-associated parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus Fish-associated parvo-like hybrid virus Parvo-like hybrid virus UC4 gi|2413975758|gb|OP933682.1| Viruses Viruses Viruses Viruses 1037.0 753.0 0.0 1.8e-266
9951 9951 PRJNA784979_CONTIG_398|Fish-associated_parvo-like_hybrid_virus|CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 Fish-associated parvo-like hybrid virus Endogenous or not fish-associated PRJNA784979_CONTIG_398|Fish-associated_parvo-like_hybrid_virus PRJNA784979_CONTIG_398 Fish-associated parvo-like hybrid virus 35 19 4 CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA 14 7 PRJNA784979 398 1631 4.404551 71.83822681 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 2645.0 0.0 Fish-associated parvo-like hybrid virus Non-phage NTclustered PRJNA784979_S_NODE_398_length_1631_cov_4.404551_g391_i0   MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds gi|2413975758|gb|OP933682.1| 3003968 g391 i0 96.782 1.579399142 1585 51 97.0 0 47 1631 3225 1641 2576 2645.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Fish-associated parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus Fish-associated parvo-like hybrid virus Fish-associated parvo-like hybrid virus gi|2413975758|gb|OP933682.1| Viruses Viruses Viruses Viruses 2645.0 679.0 0.0 3.6099999999999996e-243
9967 9967 PRJNA784979_CONTIG_12709|Grus_japonensis_parvo-like_hybrid_virus|CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 Fish-associated parvo-like hybrid virus Endogenous or not fish-associated PRJNA784979_CONTIG_12709|Grus_japonensis_parvo-like_hybrid_virus PRJNA784979_CONTIG_12709 Fish-associated parvo-like hybrid virus 35 19 4 CLUSTER2_Fish-associated_parvo-like_hybrid_virus|14|7 PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA 14 7 PRJNA784979 12709 162 1.283186 2.07876132 Grus japonensis parvo-like hybrid virus 2794511 Viruses Viruses 72.4 2.95e-13 Grus japonensis parvo-like hybrid virus Non-phage NR PRJNA784979_S_NODE_12709_length_162_cov_1.283186_g12667_i0   QTZ83196.1 MAG: capsid protein [Grus japonensis parvo-like hybrid virus] QTZ83196.1 2794511 g12667 i0 72.1 0.796296296 43 12 79.6 0 24 152 22 64 129 72.4 1.0 Viruses Monodnaviria Shotokuvirae Cressdnaviricota Arfiviricetes Lineavirales Oomyviridae Nicoomyvirus Nicoomyvirus peneszensis Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus   Grus japonensis parvo-like hybrid virus     Viruses   Viruses   72.4   2.95e-13
10179 10179 PRJNA784979_CONTIG_744|Fish-associated_parvo-like_hybrid_virus|CLUSTER3_Fish-associated_parvo-like_hybrid_virus|4|4 Fish-associated parvo-like hybrid virus Endogenous or not fish-associated PRJNA784979_CONTIG_744|Fish-associated_parvo-like_hybrid_virus PRJNA784979_CONTIG_744 Fish-associated parvo-like hybrid virus 35 19 4 CLUSTER3_Fish-associated_parvo-like_hybrid_virus|4|4 PRJNA784979_S_NODE_744_length_713_cov_4.688253_g709_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|0|NA 4 4 PRJNA784979 744 713 4.688253 33.42724389 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 1279.0 0.0 Fish-associated parvo-like hybrid virus Non-phage NTclustered PRJNA784979_S_NODE_744_length_713_cov_4.688253_g709_i0   MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds gi|2413975758|gb|OP933682.1| 3003968 g709 i0 99.021 1.256661992 715 3 100.0 4 1 713 747 35 896 1279.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Fish-associated parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus Fish-associated parvo-like hybrid virus   gi|2413975758|gb|OP933682.1| Viruses   Viruses   1279.0   0.0  
10381 10381 PRJNA784979_CONTIG_5641|Phoenicopteridae_parvo-like_hybrid_virus|CLUSTER1_Phoenicopteridae_parvo-like_hybrid_virus|1|1 Phoenicopteridae parvo-like hybrid virus Endogenous or not fish-associated PRJNA784979_CONTIG_5641|Phoenicopteridae_parvo-like_hybrid_virus PRJNA784979_CONTIG_5641 Phoenicopteridae parvo-like hybrid virus 3 3 3 CLUSTER1_Phoenicopteridae_parvo-like_hybrid_virus|1|1 PRJNA784979_S_NODE_5641_length_206_cov_1.146497_g5599_i0|Phoenicopteridae_parvo-like_hybrid_virus|NR|1.69e-05|NA 1 1 PRJNA784979 5641 206 1.146497 2.36178382 Phoenicopteridae parvo-like hybrid virus 2794528 Viruses Viruses 51.6 1.69e-05 Phoenicopteridae parvo-like hybrid virus Non-phage NR PRJNA784979_S_NODE_5641_length_206_cov_1.146497_g5599_i0   QTE03745.1 MAG: hypothetical protein [Phoenicopteridae parvo-like hybrid virus] QTE03745.1 2794528 g5599 i0 40.3 0.975728155 67 38 94.7 1 198 4 169 235 201 51.6 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Phoenicopteridae parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Phoenicopteridae parvo-like hybrid virus   Phoenicopteridae parvo-like hybrid virus     Viruses   Viruses   51.6   1.69e-05
10387 10387 PRJNA784979_CONTIG_6771|Fish-associated_parvo-like_hybrid_virus|CLUSTER4_Fish-associated_parvo-like_hybrid_virus|1|1 Fish-associated parvo-like hybrid virus Endogenous or not fish-associated PRJNA784979_CONTIG_6771|Fish-associated_parvo-like_hybrid_virus PRJNA784979_CONTIG_6771 Fish-associated parvo-like hybrid virus 35 19 4 CLUSTER4_Fish-associated_parvo-like_hybrid_virus|1|1 PRJNA784979_S_NODE_6771_length_193_cov_1.576389_g6729_i0|Fish-associated_parvo-like_hybrid_virus|NTclustered|5.62e-47|NA 1 1 PRJNA784979 6771 193 1.576389 3.04243077 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 200.0 5.620000000000001e-47 Fish-associated parvo-like hybrid virus Non-phage NTclustered PRJNA784979_S_NODE_6771_length_193_cov_1.576389_g6729_i0   MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds gi|2413975758|gb|OP933682.1| 3003968 g6729 i0 85.714 0.979274611 189 27 98.0 0 1 189 1518 1330 189 200.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Fish-associated parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus Fish-associated parvo-like hybrid virus Parvo-like hybrid virus UC4 gi|2413975758|gb|OP933682.1| Viruses Viruses Viruses Viruses 200.0 127.0 5.620000000000001e-47 2.24e-33

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