RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

7 rows where Category = "Endogenous or not fish-associated" and bioproject = "PRJNA642647"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_genus_NTorNR 1

tax_family_NTorNR 1

bioproject 1

  • PRJNA642647 · 7 ✖

Category 1

  • Endogenous or not fish-associated · 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
9959 9959 PRJNA642647_CONTIG_2813|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 PRJNA642647_CONTIG_2813|Fish-associated_parvo-like_hybrid_virus PRJNA642647_CONTIG_2813 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 PRJNA642647 2813 207 2.694118 5.57682426 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 281.0 2.12e-71 Fish-associated parvo-like hybrid virus Non-phage NTclustered PRJNA642647_P_NODE_2813_length_207_cov_2.694118_g2763_i0   MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds gi|2413975758|gb|OP933682.1| 3003968 g2763 i0 89.72 3.632850242 214 11 98.0 1 2 204 1712 1499 752 281.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 281.0 83.6 2.12e-71 6.87e-17
10012 10012 PRJNA642647_CONTIG_547|Psittaciform_aveparvovirus|CLUSTER1_Psittaciform_aveparvovirus|12|7 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA642647_CONTIG_547|Psittaciform_aveparvovirus PRJNA642647_CONTIG_547 Psittaciform aveparvovirus 19 12 2 CLUSTER1_Psittaciform_aveparvovirus|12|7 OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome 12 7 PRJNA642647 547 480 4.988713 23.9458224 Psittaciform aveparvovirus 3042447 Viruses Viruses 749.0 0.0 Psittaciform aveparvovirus Non-phage NTclustered PRJNA642647_P_NODE_547_length_480_cov_4.988713_g498_i0   Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome gi|2496529060|gb|OP577480.1| 3042447 g498 i0 94.969 0.99375 477 24 99.0 0 1 477 2085 1609 477 749.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittaciform aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus Psittaciform aveparvovirus Psittaciform aveparvovirus gi|2496529060|gb|OP577480.1| Viruses Viruses Viruses Viruses 749.0 311.0 0.0 9.159999999999999e-104
10021 10021 PRJNA642647_CONTIG_1768|Aveparvovirus|CLUSTER1_Psittaciform_aveparvovirus|12|7 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA642647_CONTIG_1768|Aveparvovirus PRJNA642647_CONTIG_1768 Psittaciform aveparvovirus 19 12 2 CLUSTER1_Psittaciform_aveparvovirus|12|7 OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome 12 7 PRJNA642647 1768 261 1.303571 3.40232031 Aveparvovirus 1511864 Viruses Viruses 470.0 5.539999999999999e-128 Aveparvovirus Non-phage NTclustered PRJNA642647_P_NODE_1768_length_261_cov_1.303571_g1718_i0   Parvoviridae sp. isolate SpinColumn17, partial genome gi|2814138549|gb|PQ313132.1| 1940570 g1718 i0 99.611 1.969348659 257 1 98.0 0 2 258 160 416 514 470.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Parvoviridae sp. Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus Aveparvovirus Psittaciform aveparvovirus gi|2814138549|gb|PQ313132.1| Viruses Viruses Viruses Viruses 470.0 125.0 5.539999999999999e-128 2.6300000000000004e-32
10028 10028 PRJNA642647_CONTIG_5747|Psittaciform_aveparvovirus|CLUSTER1_Psittaciform_aveparvovirus|12|7 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA642647_CONTIG_5747|Psittaciform_aveparvovirus PRJNA642647_CONTIG_5747 Psittaciform aveparvovirus 19 12 2 CLUSTER1_Psittaciform_aveparvovirus|12|7 OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome 12 7 PRJNA642647 5747 159 1.467213 2.33286867 Psittaciform aveparvovirus 3042447 Viruses Viruses 220.0 3.4099999999999998e-53 Psittaciform aveparvovirus Non-phage NTclustered PRJNA642647_P_NODE_5747_length_159_cov_1.467213_g5697_i0   Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome gi|2496529060|gb|OP577480.1| 3042447 g5697 i0 99.18 1.232704403 122 1 77.0 0 1 122 142 21 196 220.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittaciform aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus Psittaciform aveparvovirus   gi|2496529060|gb|OP577480.1| Viruses   Viruses   220.0   3.4099999999999998e-53  
10063 10063 PRJNA642647_CONTIG_4|Psittaciform_aveparvovirus|CLUSTER2_Psittaciform_aveparvovirus|11|8 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA642647_CONTIG_4|Psittaciform_aveparvovirus PRJNA642647_CONTIG_4 Psittaciform aveparvovirus 19 12 2 CLUSTER2_Psittaciform_aveparvovirus|11|8 PRJNA642647_P_NODE_4_length_3343_cov_14.130067_g3_i0|Psittaciform_aveparvovirus|NTclustered|0|NA 11 8 PRJNA642647 4 3343 14.130067 472.3681398 Psittaciform aveparvovirus 3042447 Viruses Viruses 5782.0 0.0 Psittaciform aveparvovirus Non-phage NTclustered PRJNA642647_P_NODE_4_length_3343_cov_14.130067_g3_i0   Psittaciform aveparvovirus strain OBP1/FE1/29/2021, partial genome gi|2496529059|gb|OP577479.1| 3042447 g3 i0 99.466 2.784624589 3183 16 95.0 1 1 3182 116 3298 9309 5782.0 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittaciform aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus Psittaciform aveparvovirus Phoenicopteridae parvo-like hybrid virus gi|2496529059|gb|OP577479.1| Viruses Viruses Viruses Viruses 5782.0 811.0 0.0 1.82e-285
10250 10250 PRJNA642647_CONTIG_4759|Phoenicopterus_roseus_parvo-like_hybrid_virus|CLUSTER1_Phoenicopterus_roseus_parvo-like_hybrid_virus|2|2 Phoenicopterus roseus parvo-like hybrid virus Endogenous or not fish-associated PRJNA642647_CONTIG_4759|Phoenicopterus_roseus_parvo-like_hybrid_virus PRJNA642647_CONTIG_4759 Phoenicopterus roseus parvo-like hybrid virus 3 2 2 CLUSTER1_Phoenicopterus_roseus_parvo-like_hybrid_virus|2|2 PRJNA800053_P_NODE_14866_length_266_cov_1.585492_g14702_i0|Phoenicopterus_roseus_parvo-like_hybrid_virus|NR|5.02e-11|NA 2 2 PRJNA642647 4759 167 8.284615 13.83530705 Phoenicopterus roseus parvo-like hybrid virus 2794530 Viruses Viruses 53.9 1.49e-06 Phoenicopterus roseus parvo-like hybrid virus Non-phage NR PRJNA642647_P_NODE_4759_length_167_cov_8.284615_g4709_i0   QTE03705.1 MAG: capsid protein, partial [Phoenicopterus roseus parvo-like hybrid virus] QTE03705.1 2794530 g4709 i0 42.6 0.97005988 54 31 97.0 0 6 167 268 321 162 53.9 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Phoenicopterus roseus parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Phoenicopterus roseus parvo-like hybrid virus   Phoenicopterus roseus parvo-like hybrid virus     Viruses   Viruses   53.9   1.49e-06
10386 10386 PRJNA642647_CONTIG_6259|Phoenicopterus_roseus_parvo-like_hybrid_virus|CLUSTER2_Phoenicopterus_roseus_parvo-like_hybrid_virus|1|1 Phoenicopterus roseus parvo-like hybrid virus Endogenous or not fish-associated PRJNA642647_CONTIG_6259|Phoenicopterus_roseus_parvo-like_hybrid_virus PRJNA642647_CONTIG_6259 Phoenicopterus roseus parvo-like hybrid virus 3 2 2 CLUSTER2_Phoenicopterus_roseus_parvo-like_hybrid_virus|1|1 PRJNA642647_P_NODE_6259_length_153_cov_0.982759_g6209_i0|Phoenicopterus_roseus_parvo-like_hybrid_virus|NR|0.0147|NA 1 1 PRJNA642647 6259 153 0.982759 1.50362127 Phoenicopterus roseus parvo-like hybrid virus 2794530 Viruses Viruses 42.4 0.0147 Phoenicopterus roseus parvo-like hybrid virus Non-phage NR PRJNA642647_P_NODE_6259_length_153_cov_0.982759_g6209_i0   QTE03705.1 MAG: capsid protein, partial [Phoenicopterus roseus parvo-like hybrid virus] QTE03705.1 2794530 g6209 i0 46.7 0.882352941 45 24 88.2 0 149 15 162 206 135 42.4 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Phoenicopterus roseus parvo-like hybrid virus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Phoenicopterus roseus parvo-like hybrid virus   Phoenicopterus roseus parvo-like hybrid virus     Viruses   Viruses   42.4   0.0147

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