RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

4 rows where Category = "Known", bioproject = "PRJNA690234" 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 · 4 ✖

bioproject 1

  • PRJNA690234 · 4 ✖

Category 1

  • Known · 4 ✖
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
10 10 PRJNA690234_CONTIG_3|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA690234_CONTIG_3|Sprivivirus_cyprinus PRJNA690234_CONTIG_3 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA690234 3 6313 53.996635 3408.807568 Sprivivirus cyprinus 696863 Viruses Viruses 11293.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA690234_P_NODE_3_length_6313_cov_53.996635_g2_i0   Spring viraemia of carp virus isolate A1, complete genome gi|89280756|gb|DQ097384.2| 696863 g2 i0 98.955 21.86028829 6314 64 100.0 2 1 6313 11080 4768 138004 11293.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 11293.0 4164.0 0.0 0.0
17 17 PRJNA690234_CONTIG_5|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA690234_CONTIG_5|Sprivivirus_cyprinus PRJNA690234_CONTIG_5 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA690234 5 5428 1272.131653 69051.30612 Sprivivirus cyprinus 696863 Viruses Viruses 4505.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA690234_P_NODE_5_length_5428_cov_1272.131653_g4_i0   Spring viraemia of carp virus isolate A1, complete genome gi|89280756|gb|DQ097384.2| 696863 g4 i0 97.925 38.62269713 2603 50 100.0 4 2709 5307 2761 159 209644 4505.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 4505.0 767.0 0.0 3.1e-259
22 22 PRJNA690234_CONTIG_8|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA690234_CONTIG_8|Sprivivirus_cyprinus PRJNA690234_CONTIG_8 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA690234 8 4727 944.341427 44639.01925 Sprivivirus cyprinus 696863 Viruses Viruses 7978.0 0.0 Sprivivirus cyprinus Non-phage NTclustered PRJNA690234_P_NODE_8_length_4727_cov_944.341427_g4_i1   Spring viraemia of carp virus isolate A1, complete genome gi|89280756|gb|DQ097384.2| 696863 g4 i1 97.922 42.32896129 4620 72 100.0 6 122 4727 159 4768 200089 7978.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 7978.0 1019.0 0.0 0.0
1482 1482 PRJNA690234_CONTIG_22415|Sprivivirus_cyprinus|CLUSTER1_Sprivivirus_cyprinus|1869|13 Spring viraemia of carp virus Known PRJNA690234_CONTIG_22415|Sprivivirus_cyprinus PRJNA690234_CONTIG_22415 Sprivivirus cyprinus 1839 13 4 CLUSTER1_Sprivivirus_cyprinus|1869|13 OP495631_1_Sprivivirus_cyprinus_isolate_SVCV_2022_complete_genome 1869 13 PRJNA690234 22415 268 1.34359 3.6008212 Sprivivirus cyprinus 696863 Viruses Viruses 368.0 2.15e-97 Sprivivirus cyprinus Non-phage NTclustered PRJNA690234_P_NODE_22415_length_268_cov_1.343590_g22048_i0   Sprivivirus cyprinus strain 202238 nucleoprotein (NP), phosoprotein (P), matrix protein (M), glycoprotein (G), and polymerase protein (L) genes, complete cds gi|1063892400|gb|KU230365.1| 696863 g22048 i0 91.418 18.0 268 23 100.0 0 1 268 10614 10347 4824 368.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|1063892400|gb|KU230365.1| Viruses Viruses Viruses Viruses 368.0 145.0 2.15e-97 3.96e-38

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