RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

8 rows where bioproject = "PRJNA1011833" 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 · 8 ✖

bioproject 1

  • PRJNA1011833 · 8 ✖

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
350 350 PRJNA1011833_CONTIG_3895|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA1011833_CONTIG_3895|Sprivivirus_cyprinus PRJNA1011833_CONTIG_3895 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA1011833 3895 504 13.518438 68.13292752 Sprivivirus cyprinus 696863 Viruses Viruses 887.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA1011833_S_NODE_3895_length_504_cov_13.518438_g3495_i0   Spring viremia of carp virus isolate BJ0505-2, complete genome gi|158252063|gb|EU177782.1| 696863 g3495 i0 98.413 30.74404762 504 8 100.0 0 1 504 1389 886 15495 887.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|158252063|gb|EU177782.1| Viruses Viruses Viruses Viruses 887.0 293.0 0.0 6.46e-96
531 531 PRJNA1011833_CONTIG_6090|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA1011833_CONTIG_6090|Sprivivirus_cyprinus PRJNA1011833_CONTIG_6090 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA1011833 6090 439 10.704545 46.99295255 Sprivivirus cyprinus 696863 Viruses Viruses 778.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA1011833_S_NODE_6090_length_439_cov_10.704545_g5677_i0   Spring viraemia of carp virus isolate 566087-1 phosphoprotein (P) gene, partial cds; matrix (M) and glycoprotein (G) genes, complete cds; and RNA dependent RNA polymerase (L) gene, partial cds gi|387273543|gb|JQ666283.1| 696863 g5677 i0 98.633 47.3166287 439 6 100.0 0 1 439 396 834 20772 778.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|387273543|gb|JQ666283.1| Viruses Viruses Viruses Viruses 778.0 308.0 0.0 1.0899999999999999e-104
612 612 PRJNA1011833_CONTIG_7404|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA1011833_CONTIG_7404|Sprivivirus_cyprinus PRJNA1011833_CONTIG_7404 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA1011833 7404 412 2.861789 11.79057068 Sprivivirus cyprinus 696863 Viruses Viruses 723.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA1011833_S_NODE_7404_length_412_cov_2.861789_g6988_i0   Spring viremia of carp virus isolate 0504 glycoprotein (G) gene, complete cds gi|165940616|gb|EU370915.1| 696863 g6988 i0 100.0 48.30097087 391 0 95.0 0 1 391 1431 1821 19900 723.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|165940616|gb|EU370915.1| Viruses Viruses Viruses Viruses 723.0 202.0 0.0 5.079999999999999e-60
930 930 PRJNA1011833_CONTIG_11016|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA1011833_CONTIG_11016|Sprivivirus_cyprinus PRJNA1011833_CONTIG_11016 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA1011833 11016 356 10.29393 36.6463908 Sprivivirus cyprinus 696863 Viruses Viruses 625.0 1.5799999999999999e-174 Sprivivirus cyprinus Non-phage NTclustered PRJNA1011833_S_NODE_11016_length_356_cov_10.293930_g10597_i0   Spring viremia of carp virus strain OMG067 phosphoprotein (P) gene, complete cds gi|115503435|gb|DQ916053.1| 696863 g10597 i0 98.315 53.5758427 356 6 100.0 0 1 356 569 924 19073 625.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|115503435|gb|DQ916053.1| Viruses Viruses Viruses Viruses 625.0 230.0 1.5799999999999999e-174 2.95e-73
1306 1306 PRJNA1011833_CONTIG_18825|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA1011833_CONTIG_18825|Sprivivirus_cyprinus PRJNA1011833_CONTIG_18825 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA1011833 18825 279 1.758475 4.90614525 Sprivivirus cyprinus 696863 Viruses Viruses 516.0 7.58e-142 Sprivivirus cyprinus Non-phage NTclustered PRJNA1011833_S_NODE_18825_length_279_cov_1.758475_g18405_i0   Spring viraemia of carp virus isolate A1, complete genome gi|89280756|gb|DQ097384.2| 696863 g18405 i0 100.0 20.0 279 0 100.0 0 1 279 10707 10985 5580 516.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|89280756|gb|DQ097384.2| Viruses Viruses Viruses Viruses 516.0 183.0 7.58e-142 2.1e-51
1593 1593 PRJNA1011833_CONTIG_26426|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA1011833_CONTIG_26426|Sprivivirus_cyprinus PRJNA1011833_CONTIG_26426 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA1011833 26426 231 1.276596 2.94893676 Sprivivirus cyprinus 696863 Viruses Viruses 422.0 1.37e-113 Sprivivirus cyprinus Non-phage NTclustered PRJNA1011833_S_NODE_26426_length_231_cov_1.276596_g26006_i0   Spring viremia of carp virus strain 980619 phosphoprotein (P) gene, complete cds gi|124699170|gb|DQ916051.1| 696863 g26006 i0 99.567 49.74025974 231 1 100.0 0 1 231 462 232 11490 422.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|124699170|gb|DQ916051.1| Viruses Viruses Viruses Viruses 422.0 150.0 1.37e-113 6.63e-43
1824 1824 PRJNA1011833_CONTIG_35429|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA1011833_CONTIG_35429|Sprivivirus_cyprinus PRJNA1011833_CONTIG_35429 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA1011833 35429 196 2.509804 4.91921584 Sprivivirus cyprinus 696863 Viruses Viruses 331.0 1.94e-86 Sprivivirus cyprinus Non-phage NTclustered PRJNA1011833_S_NODE_35429_length_196_cov_2.509804_g35009_i0   Sprivivirus cyprinus isolate SVCV_2022, complete genome gi|2490825611|gb|OP495631.1| 696863 g35009 i0 98.404 20.1377551 188 3 96.0 0 9 196 555 368 3947 331.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|2490825611|gb|OP495631.1| Viruses Viruses Viruses Viruses 331.0 128.0 1.94e-86 1.29e-33
1825 1825 PRJNA1011833_CONTIG_39973|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA1011833_CONTIG_39973|Sprivivirus_cyprinus PRJNA1011833_CONTIG_39973 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA1011833 39973 184 1.361702 2.50553168 Sprivivirus cyprinus 696863 Viruses Viruses 335.0 1.39e-87 Sprivivirus cyprinus Non-phage NTclustered PRJNA1011833_S_NODE_39973_length_184_cov_1.361702_g39553_i0   Spring viremia of carp virus isolate 0504 glycoprotein (G) gene, complete cds gi|165940616|gb|EU370915.1| 696863 g39553 i0 99.457 64.69565217 184 1 100.0 0 1 184 542 359 11904 335.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|165940616|gb|EU370915.1| Viruses Viruses Viruses Viruses 335.0 134.0 1.39e-87 1.78e-37

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