RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

7 rows where bioproject = "PRJNA799765" and clusterLCA_curated = "Spring viraemia of carp virus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

tax_genus_NTorNR 1

tax_family_NTorNR 1

clusterLCA_curated 1

  • Spring viraemia of carp virus · 7 ✖

bioproject 1

  • PRJNA799765 · 7 ✖

Category 1

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
42 42 PRJNA799765_CONTIG_17|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA799765_CONTIG_17|Sprivivirus_cyprinus PRJNA799765_CONTIG_17 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA799765 17 3035 3.488614 105.8794349 Sprivivirus cyprinus 696863 Viruses Viruses 5600.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA799765_P_NODE_17_length_3035_cov_3.488614_g13_i0   Spring Viremia of Carp complete genome, genomic RNA gi|15211934|emb|AJ318079.1| 696863 g13 i0 99.967 19.99868204 3035 1 100.0 0 1 3035 11001 7967 60696 5600.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Sprivivirus Sprivivirus cyprinus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Mononegavirales;Rhabdoviridae;Sprivivirus;Spring viraemia of carp virus Sprivivirus cyprinus Sprivivirus cyprinus gi|15211934|emb|AJ318079.1| Viruses Viruses Viruses Viruses 5600.0 2009.0 0.0 0.0
76 76 PRJNA799765_CONTIG_160|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA799765_CONTIG_160|Sprivivirus_cyprinus PRJNA799765_CONTIG_160 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA799765 160 1331 56.935257 757.8082707 Sprivivirus cyprinus 696863 Viruses Viruses 2449.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA799765_P_NODE_160_length_1331_cov_56.935257_g124_i0   Spring Viremia of Carp complete genome, genomic RNA gi|15211934|emb|AJ318079.1| 696863 g124 i0 100.0 24.68895567 1326 0 99.0 0 1 1326 69 1394 32861 2449.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Sprivivirus Sprivivirus cyprinus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Mononegavirales;Rhabdoviridae;Sprivivirus;Spring viraemia of carp virus Sprivivirus cyprinus Sprivivirus cyprinus gi|15211934|emb|AJ318079.1| Viruses Viruses Viruses Viruses 2449.0 837.0 0.0 9.51e-305
97 97 PRJNA799765_CONTIG_366|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA799765_CONTIG_366|Sprivivirus_cyprinus PRJNA799765_CONTIG_366 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA799765 366 943 36.690157 345.9881805 Sprivivirus cyprinus 696863 Viruses Viruses 1735.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA799765_P_NODE_366_length_943_cov_36.690157_g297_i0   Spring Viremia of Carp complete genome, genomic RNA gi|15211934|emb|AJ318079.1| 696863 g297 i0 99.894 53.94485684 943 0 100.0 1 1 943 1400 2341 50870 1735.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Sprivivirus Sprivivirus cyprinus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Mononegavirales;Rhabdoviridae;Sprivivirus;Spring viraemia of carp virus Sprivivirus cyprinus Sprivivirus cyprinus gi|15211934|emb|AJ318079.1| Viruses Viruses Viruses Viruses 1735.0 410.0 0.0 5.65e-141
117 117 PRJNA799765_CONTIG_641|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA799765_CONTIG_641|Sprivivirus_cyprinus PRJNA799765_CONTIG_641 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA799765 641 707 1.913374 13.52755418 Sprivivirus cyprinus 696863 Viruses Viruses 1306.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA799765_P_NODE_641_length_707_cov_1.913374_g544_i0   Spring Viremia of Carp complete genome, genomic RNA gi|15211934|emb|AJ318079.1| 696863 g544 i0 100.0 26.40311174 707 0 100.0 0 1 707 6410 7116 18667 1306.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Sprivivirus Sprivivirus cyprinus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Mononegavirales;Rhabdoviridae;Sprivivirus;Spring viraemia of carp virus Sprivivirus cyprinus Sprivivirus cyprinus gi|15211934|emb|AJ318079.1| Viruses Viruses Viruses Viruses 1306.0 476.0 0.0 1.25e-151
159 159 PRJNA799765_CONTIG_1238|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA799765_CONTIG_1238|Sprivivirus_cyprinus PRJNA799765_CONTIG_1238 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA799765 1238 477 2.121495 10.11953115 Sprivivirus cyprinus 696863 Viruses Viruses 881.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA799765_P_NODE_1238_length_477_cov_2.121495_g1128_i0   Spring Viremia of Carp complete genome, genomic RNA gi|15211934|emb|AJ318079.1| 696863 g1128 i0 100.0 20.0 477 0 100.0 0 1 477 5681 5205 9540 881.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Sprivivirus Sprivivirus cyprinus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Mononegavirales;Rhabdoviridae;Sprivivirus;Spring viraemia of carp virus Sprivivirus cyprinus Sprivivirus cyprinus gi|15211934|emb|AJ318079.1| Viruses Viruses Viruses Viruses 881.0 321.0 0.0 2.95e-98
210 210 PRJNA799765_CONTIG_2139|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA799765_CONTIG_2139|Sprivivirus_cyprinus PRJNA799765_CONTIG_2139 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA799765 2139 346 1.390572 4.81137912 Sprivivirus cyprinus 696863 Viruses Viruses 640.0 5.5e-179 Sprivivirus cyprinus Non-phage NTclustered PRJNA799765_P_NODE_2139_length_346_cov_1.390572_g2029_i0   Spring Viremia of Carp complete genome, genomic RNA gi|15211934|emb|AJ318079.1| 696863 g2029 i0 100.0 20.04624277 346 0 100.0 0 1 346 6211 5866 6936 640.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Sprivivirus Sprivivirus cyprinus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Mononegavirales;Rhabdoviridae;Sprivivirus;Spring viraemia of carp virus Sprivivirus cyprinus Sprivivirus cyprinus gi|15211934|emb|AJ318079.1| Viruses Viruses Viruses Viruses 640.0 243.0 5.5e-179 5.13e-72
288 288 PRJNA799765_CONTIG_2937|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA799765_CONTIG_2937|Sprivivirus_cyprinus PRJNA799765_CONTIG_2937 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA799765 2937 287 1.310924 3.76235188 Sprivivirus cyprinus 696863 Viruses Viruses 531.0 2.8e-146 Sprivivirus cyprinus Non-phage NTclustered PRJNA799765_P_NODE_2937_length_287_cov_1.310924_g2827_i0   Spring Viremia of Carp complete genome, genomic RNA gi|15211934|emb|AJ318079.1| 696863 g2827 i0 100.0 19.99651568 287 0 100.0 0 1 287 7986 7700 5739 531.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Sprivivirus Sprivivirus cyprinus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Mononegavirales;Rhabdoviridae;Sprivivirus;Spring viraemia of carp virus Sprivivirus cyprinus Sprivivirus cyprinus gi|15211934|emb|AJ318079.1| Viruses Viruses Viruses Viruses 531.0 193.0 2.8e-146 1.0199999999999998e-54

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