RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

3 rows where bioproject = "PRJNA1108487"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_family_NTorNR 2

Category 2

tax_genus_NTorNR 1

bioproject 1

  • PRJNA1108487 · 3 ✖
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
10211 10211 PRJNA1108487_CONTIG_178|Betanodavirus|CLUSTER1_Betanodavirus|3|2 Redspotted grouper nervous necrosis virus Known PRJNA1108487_CONTIG_178|Betanodavirus PRJNA1108487_CONTIG_178 Betanodavirus 4 2 3 CLUSTER1_Betanodavirus|3|2 PRJNA799765_P_NODE_127_length_1457_cov_652.555398_g101_i0|Betanodavirus|NTclustered|0|NA 3 2 PRJNA1108487 178 1328 14.647012 194.5123194 Betanodavirus 143919 Viruses Viruses 2398.0 0.0 Betanodavirus Non-phage NTclustered PRJNA1108487_P_NODE_178_length_1328_cov_14.647012_g143_i0   Redspotted grouper nervous necrosis virus RNA 2, complete sequence gi|98960854|ref|NC_008041.1| 43763 g143 i0 99.247 96.0873494 1328 10 100.0 0 1 1328 11 1338 127604 2398.0 1.0 Viruses Riboviria Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae Betanodavirus Betanodavirus epinepheli Viruses;Riboviria;Orthornavirae;Kitrinoviricota;Magsaviricetes;Nodamuvirales;Nodaviridae;Betanodavirus;Redspotted grouper nervous necrosis virus Betanodavirus Orange-spotted grouper nervous necrosis virus gi|98960854|ref|NC_008041.1| Viruses Viruses Viruses Viruses 2398.0 678.0 0.0 2.6599999999999997e-244
10256 10256 PRJNA1108487_CONTIG_9875|Snakehead_retrovirus|CLUSTER1_Snakehead_retrovirus|2|1 Snakehead retrovirus Insufficient Evidence PRJNA1108487_CONTIG_9875|Snakehead_retrovirus PRJNA1108487_CONTIG_9875 Snakehead retrovirus 1 1 1 CLUSTER1_Snakehead_retrovirus|2|1 NC_001724_1_Snakehead_retrovirus_complete_genome 2 1 PRJNA1108487 9875 247 0.896552 2.21448344 Snakehead retrovirus 40270 Viruses Viruses 457.0 4.0500000000000005e-124 Snakehead retrovirus Non-phage NTclustered PRJNA1108487_P_NODE_9875_length_247_cov_0.896552_g9809_i0   Snakehead retrovirus, complete genome gi|9628892|ref|NC_001724.1| 40270 g9809 i0 100.0 2.0 247 0 100.0 0 1 247 8274 8520 494 457.0 1.0 Viruses Riboviria Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Snakehead retrovirus Viruses;Riboviria;Pararnavirae;Artverviricota;Revtraviricetes;Ortervirales;Retroviridae;Snakehead retrovirus Snakehead retrovirus Snakehead retrovirus gi|9628892|ref|NC_001724.1| Viruses Viruses Viruses Viruses 457.0 166.0 4.0500000000000005e-124 2.0699999999999998e-45
10284 10284 PRJNA1108487_CONTIG_17|Betanodavirus_epinepheli|CLUSTER1_Betanodavirus_epinepheli|1|1 Redspotted grouper nervous necrosis virus Known PRJNA1108487_CONTIG_17|Betanodavirus_epinepheli PRJNA1108487_CONTIG_17 Betanodavirus epinepheli 4 2 3 CLUSTER1_Betanodavirus_epinepheli|1|1 PRJNA1108487_P_NODE_17_length_3045_cov_11.845559_g13_i0|Betanodavirus_epinepheli|NTclustered|0|NA 1 1 PRJNA1108487 17 3045 11.845559 360.6972716 Betanodavirus epinepheli 3427237 Viruses Viruses 5502.0 0.0 Betanodavirus epinepheli Non-phage NTclustered PRJNA1108487_P_NODE_17_length_3045_cov_11.845559_g13_i0   Redspotted grouper nervous necrosis virus isolate China 1 RNA-dependent RNA polymerase gene, complete cds gi|156076357|gb|EF558368.1| 43763 g13 i0 99.278 99.07192118 3045 22 100.0 0 1 3045 3057 13 301674 5502.0 1.0 Viruses Riboviria Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae Betanodavirus Betanodavirus epinepheli Viruses;Riboviria;Orthornavirae;Kitrinoviricota;Magsaviricetes;Nodamuvirales;Nodaviridae;Betanodavirus;Redspotted grouper nervous necrosis virus Betanodavirus epinepheli Redspotted grouper nervous necrosis virus gi|156076357|gb|EF558368.1| Viruses Viruses Viruses Viruses 5502.0 1961.0 0.0 0.0

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