RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

4 rows where Category = "Known", bioproject = "PRJNA939369" and clusterLCA_curated = "Singapore grouper 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

  • Singapore grouper virus · 4 ✖

bioproject 1

  • PRJNA939369 · 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
9704 9704 PRJNA939369_CONTIG_1964|Ranavirus|CLUSTER1_Ranavirus_epinephelus1|34|2 Singapore grouper virus Known PRJNA939369_CONTIG_1964|Ranavirus PRJNA939369_CONTIG_1964 Ranavirus epinephelus1 38 2 10 CLUSTER1_Ranavirus_epinephelus1|34|2 OM793601_1_Singapore_grouper_iridovirus_complete_genome 34 2 PRJNA939369 1964 783 2.305634 18.05311422 Ranavirus 10492 Viruses Viruses 1441.0 0.0 Ranavirus Non-phage NTclustered PRJNA939369_S_NODE_1964_length_783_cov_2.305634_g1596_i0   Largemouth bass virus isolate LMBV-FS001, complete genome gi|2456245202|gb|ON936874.1| 176656 g1596 i0 99.872 10.39463602 783 1 100.0 0 1 783 38641 37859 8139 1441.0 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae Ranavirus Ranavirus micropterus1 Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Megaviricetes;Pimascovirales;Iridoviridae;Ranavirus;Singapore grouper virus Ranavirus Mandarin fish ranavirus gi|2456245202|gb|ON936874.1| Viruses Viruses Viruses Viruses 1441.0 523.0 0.0 7.979999999999999e-176
9713 9713 PRJNA939369_CONTIG_4697|Ranavirus|CLUSTER1_Ranavirus_epinephelus1|34|2 Singapore grouper virus Known PRJNA939369_CONTIG_4697|Ranavirus PRJNA939369_CONTIG_4697 Ranavirus epinephelus1 38 2 10 CLUSTER1_Ranavirus_epinephelus1|34|2 OM793601_1_Singapore_grouper_iridovirus_complete_genome 34 2 PRJNA939369 4697 556 1.745342 9.70410152 Ranavirus 10492 Viruses Viruses 1020.0 0.0 Ranavirus Non-phage NTclustered PRJNA939369_S_NODE_4697_length_556_cov_1.745342_g4283_i0   Largemouth bass virus isolate LMBV-FS001, complete genome gi|2456245202|gb|ON936874.1| 176656 g4283 i0 99.82 12.22122302 555 1 99.0 0 2 556 32418 32972 6795 1020.0 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae Ranavirus Ranavirus micropterus1 Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Megaviricetes;Pimascovirales;Iridoviridae;Ranavirus;Singapore grouper virus Ranavirus Mandarin fish ranavirus gi|2456245202|gb|ON936874.1| Viruses Viruses Viruses Viruses 1020.0 333.0 0.0 1.21e-111
9718 9718 PRJNA939369_CONTIG_5126|Ranavirus|CLUSTER1_Ranavirus_epinephelus1|34|2 Singapore grouper virus Known PRJNA939369_CONTIG_5126|Ranavirus PRJNA939369_CONTIG_5126 Ranavirus epinephelus1 38 2 10 CLUSTER1_Ranavirus_epinephelus1|34|2 OM793601_1_Singapore_grouper_iridovirus_complete_genome 34 2 PRJNA939369 5126 537 1.931034 10.36965258 Ranavirus 10492 Viruses Viruses 992.0 0.0 Ranavirus Non-phage NTclustered PRJNA939369_S_NODE_5126_length_537_cov_1.931034_g4710_i0   Largemouth bass virus isolate LMBV-FS001, complete genome gi|2456245202|gb|ON936874.1| 176656 g4710 i0 100.0 8.016759777 537 0 100.0 0 1 537 81610 81074 4305 992.0 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae Ranavirus Ranavirus micropterus1 Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Megaviricetes;Pimascovirales;Iridoviridae;Ranavirus;Singapore grouper virus Ranavirus Mandarin fish ranavirus gi|2456245202|gb|ON936874.1| Viruses Viruses Viruses Viruses 992.0 290.0 0.0 2.18e-96
9728 9728 PRJNA939369_CONTIG_10995|Ranavirus|CLUSTER1_Ranavirus_epinephelus1|34|2 Singapore grouper virus Known PRJNA939369_CONTIG_10995|Ranavirus PRJNA939369_CONTIG_10995 Ranavirus epinephelus1 38 2 10 CLUSTER1_Ranavirus_epinephelus1|34|2 OM793601_1_Singapore_grouper_iridovirus_complete_genome 34 2 PRJNA939369 10995 411 1.713018 7.04050398 Ranavirus 10492 Viruses Viruses 760.0 0.0 Ranavirus Non-phage NTclustered PRJNA939369_S_NODE_10995_length_411_cov_1.713018_g10578_i0   Largemouth bass virus strain Pine 14-204, complete genome gi|1835269580|gb|MK681856.1| 176656 g10578 i0 100.0 8.253041363 411 0 100.0 0 1 411 41689 41279 3392 760.0 1.0 Viruses Varidnaviria Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae Ranavirus Ranavirus micropterus1 Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Megaviricetes;Pimascovirales;Iridoviridae;Ranavirus;Singapore grouper virus Ranavirus Largemouth bass virus gi|1835269580|gb|MK681856.1| Viruses Viruses Viruses Viruses 760.0 283.0 0.0 1.34e-85

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