RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

10 rows where Category = "Endogenous or not fish-associated" and tax_species_NTorNR = "Psittaciform aveparvovirus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

  • Psittaciform aveparvovirus · 10 ✖

tax_genus_NTorNR 1

tax_family_NTorNR 1

Category 1

  • Endogenous or not fish-associated · 10 ✖
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
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
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  
10040 10040 PRJNA994052_CONTIG_19856|Psittaciform_aveparvovirus|CLUSTER1_Psittaciform_aveparvovirus|12|7 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA994052_CONTIG_19856|Psittaciform_aveparvovirus PRJNA994052_CONTIG_19856 Psittaciform aveparvovirus 19 12 2 CLUSTER1_Psittaciform_aveparvovirus|12|7 OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome 12 7 PRJNA994052 19856 309 21.555085 66.60521265 Psittaciform aveparvovirus 3042447 Viruses Viruses 484.0 2.3999999999999998e-132 Psittaciform aveparvovirus Non-phage NTclustered PRJNA994052_P_NODE_19856_length_309_cov_21.555085_g18633_i0   Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome gi|2496529060|gb|OP577480.1| 3042447 g18633 i0 95.946 1.566343042 296 7 96.0 1 13 308 1728 1438 484 484.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 484.0 93.6 2.3999999999999998e-132 3.88e-20
10043 10043 PRJNA800053_CONTIG_21839|Psittaciform_aveparvovirus|CLUSTER1_Psittaciform_aveparvovirus|12|7 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA800053_CONTIG_21839|Psittaciform_aveparvovirus PRJNA800053_CONTIG_21839 Psittaciform aveparvovirus 19 12 2 CLUSTER1_Psittaciform_aveparvovirus|12|7 OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome 12 7 PRJNA800053 21839 244 0.900585 2.1974274 Psittaciform aveparvovirus 3042447 Viruses Viruses 329.0 9.080000000000001e-86 Psittaciform aveparvovirus Non-phage NTclustered PRJNA800053_P_NODE_21839_length_244_cov_0.900585_g21675_i0   Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome gi|2496529060|gb|OP577480.1| 3042447 g21675 i0 91.322 0.991803279 242 19 99.0 2 4 244 1965 2205 242 329.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 329.0 158.0 9.080000000000001e-86 2.3e-45
10052 10052 PRJNA558770_CONTIG_73018|Psittaciform_aveparvovirus|CLUSTER1_Psittaciform_aveparvovirus|12|7 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA558770_CONTIG_73018|Psittaciform_aveparvovirus PRJNA558770_CONTIG_73018 Psittaciform aveparvovirus 19 12 2 CLUSTER1_Psittaciform_aveparvovirus|12|7 OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome 12 7 PRJNA558770 73018 243 3.653846 8.87884578 Psittaciform aveparvovirus 3042447 Viruses Viruses 416.0 6.74e-112 Psittaciform aveparvovirus Non-phage NTclustered PRJNA558770_P_NODE_73018_length_243_cov_3.653846_g71013_i0   Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome gi|2496529060|gb|OP577480.1| 3042447 g71013 i0 97.541 1.004115226 244 4 100.0 2 1 243 1770 2012 244 416.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 416.0 101.0 6.74e-112 1.54e-23
10057 10057 PRJNA630162_CONTIG_117271|Psittaciform_aveparvovirus|CLUSTER1_Psittaciform_aveparvovirus|12|7 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA630162_CONTIG_117271|Psittaciform_aveparvovirus PRJNA630162_CONTIG_117271 Psittaciform aveparvovirus 19 12 2 CLUSTER1_Psittaciform_aveparvovirus|12|7 OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome 12 7 PRJNA630162 117271 176 1.291339 2.27275664 Psittaciform aveparvovirus 3042447 Viruses Viruses 315.0 1.7199999999999998e-81 Psittaciform aveparvovirus Non-phage NTclustered PRJNA630162_P_NODE_117271_length_176_cov_1.291339_g115748_i0   Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome gi|2496529060|gb|OP577480.1| 3042447 g115748 i0 99.422 0.982954545 173 1 98.0 0 4 176 2044 1872 173 315.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 315.0 122.0 1.7199999999999998e-81 1.1100000000000001e-31
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
10069 10069 PRJNA670550_CONTIG_15873|Psittaciform_aveparvovirus|CLUSTER2_Psittaciform_aveparvovirus|11|8 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA670550_CONTIG_15873|Psittaciform_aveparvovirus PRJNA670550_CONTIG_15873 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 PRJNA670550 15873 188 1.625899 3.05669012 Psittaciform aveparvovirus 3042447 Viruses Viruses 296.0 6.74e-76 Psittaciform aveparvovirus Non-phage NTclustered PRJNA670550_P_NODE_15873_length_188_cov_1.625899_g15705_i0   Psittaciform aveparvovirus strain OBP1/FE1/29/2021, partial genome gi|2496529059|gb|OP577479.1| 3042447 g15705 i0 98.225 1.542553191 169 3 90.0 0 1 169 169 1 290 296.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|2496529059|gb|OP577479.1| Viruses   Viruses   296.0   6.74e-76  
10070 10070 PRJNA846486_CONTIG_20666|Psittaciform_aveparvovirus|CLUSTER2_Psittaciform_aveparvovirus|11|8 Psittaciform aveparvovirus Endogenous or not fish-associated PRJNA846486_CONTIG_20666|Psittaciform_aveparvovirus PRJNA846486_CONTIG_20666 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 PRJNA846486 20666 282 1.472103 4.15133046 Psittaciform aveparvovirus 3042447 Viruses Viruses 483.0 7.780000000000001e-132 Psittaciform aveparvovirus Non-phage NTclustered PRJNA846486_P_NODE_20666_length_282_cov_1.472103_g20570_i0   Psittaciform aveparvovirus strain OBP1/FE1/29/2021, partial genome gi|2496529059|gb|OP577479.1| 3042447 g20570 i0 99.621 1.872340426 264 1 94.0 0 19 282 333 70 528 483.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|2496529059|gb|OP577479.1| Viruses   Viruses   483.0   7.780000000000001e-132  
10218 10218 PRJNA312107_CONTIG_25980|Psittaciform_aveparvovirus|CLUSTER2_Psittacidae_aveparvovirus|3|3 Psittacidae aveparvovirus Endogenous or not fish-associated PRJNA312107_CONTIG_25980|Psittaciform_aveparvovirus PRJNA312107_CONTIG_25980 Psittacidae aveparvovirus 18 10 4 CLUSTER2_Psittacidae_aveparvovirus|3|3 PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0|Psittacidae_aveparvovirus|NR|1.21e-18|NA 3 3 PRJNA312107 25980 162 0.920354 1.49097348 Psittaciform aveparvovirus 3042447 Viruses Viruses 43.9 0.00498 Psittaciform aveparvovirus Non-phage NR PRJNA312107_P_NODE_25980_length_162_cov_0.920354_g25814_i0   WGL41068.1 replication protein [Psittaciform aveparvovirus] WGL41068.1 3042447 g25814 i0 37.0 1.0 54 26 94.4 2 156 4 9 57 162 43.9 1.0 Viruses Monodnaviria Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittaciform aveparvovirus Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus   Psittaciform aveparvovirus     Viruses   Viruses   43.9   0.00498

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