RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

7 rows where tax_genus_NTorNR = "Deltainfluenzavirus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

tax_genus_NTorNR 1

  • Deltainfluenzavirus · 7 ✖

tax_family_NTorNR 1

clusterLCA_curated 1

bioproject 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
10230 10230 PRJNA939369_CONTIG_211|Deltainfluenzavirus|CLUSTER1_Deltainfluenzavirus|2|1 Deltainfluenzavirus Endogenous or not fish-associated PRJNA939369_CONTIG_211|Deltainfluenzavirus PRJNA939369_CONTIG_211 Deltainfluenzavirus 7 1 7 CLUSTER1_Deltainfluenzavirus|2|1 NC_036616_1_Influenza_D_virus_D_swine_Oklahoma_1334_2011_segment_1_polymerase_PB2_PB2_gene_complete_cds 2 1 PRJNA939369 211 2346 12.398592 290.8709683 Deltainfluenzavirus 1511083 Viruses Viruses 4294.0 0.0 Deltainfluenzavirus Non-phage NTclustered PRJNA939369_S_NODE_211_length_2346_cov_12.398592_g90_i0   Influenza D virus (D/swine/Oklahoma/1334/2011) segment 1 polymerase PB2 (PB2) gene, complete cds gi|1328406492|ref|NC_036616.1| 1173138 g90 i0 99.702 99.56180733 2346 7 100.0 0 1 2346 12 2357 233572 4316.0 0.994902688 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Deltainfluenzavirus Deltainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Deltainfluenzavirus Deltainfluenzavirus Influenza D virus gi|1328406492|ref|NC_036616.1| Viruses Viruses Viruses Viruses 4294.0 1519.0 0.0 0.0
10231 10231 PRJNA939369_CONTIG_219|Deltainfluenzavirus|CLUSTER2_Deltainfluenzavirus|2|1 Deltainfluenzavirus Endogenous or not fish-associated PRJNA939369_CONTIG_219|Deltainfluenzavirus PRJNA939369_CONTIG_219 Deltainfluenzavirus 7 1 7 CLUSTER2_Deltainfluenzavirus|2|1 MN165245_1_Influenza_D_virus_D_bovine_Italy_12002_1_2018_segment_2_polymerase_PB1_PB1_gene_complete_cds 2 1 PRJNA939369 219 2316 13.310299 308.2665248 Deltainfluenzavirus 1511083 Viruses Viruses 4261.0 0.0 Deltainfluenzavirus Non-phage NTclustered PRJNA939369_S_NODE_219_length_2316_cov_13.310299_g94_i0   Influenza D virus (D/bovine/Italy/12002-1/2018) segment 2 polymerase PB1 (PB1) gene, complete cds gi|1707337734|gb|MN165245.1| 1511084 g94 i0 99.87 99.50345423 2316 3 100.0 0 1 2316 2322 7 230450 4272.0 0.997425094 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Deltainfluenzavirus Deltainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Deltainfluenzavirus Deltainfluenzavirus Influenza D virus (D/swine/Italy/254578/2 gi|1707337734|gb|MN165245.1| Viruses Viruses Viruses Viruses 4261.0 1491.0 0.0 0.0
10232 10232 PRJNA939369_CONTIG_239|Deltainfluenzavirus|CLUSTER3_Deltainfluenzavirus|2|1 Deltainfluenzavirus Endogenous or not fish-associated PRJNA939369_CONTIG_239|Deltainfluenzavirus PRJNA939369_CONTIG_239 Deltainfluenzavirus 7 1 7 CLUSTER3_Deltainfluenzavirus|2|1 NC_036619_1_Influenza_D_virus_D_swine_Oklahoma_1334_2011_segment_3_polymerase_3_P3_gene_complete_cds 2 1 PRJNA939369 239 2188 13.160757 287.9573632 Deltainfluenzavirus 1511083 Viruses Viruses 3988.0 0.0 Deltainfluenzavirus Non-phage NTclustered PRJNA939369_S_NODE_239_length_2188_cov_13.160757_g109_i0   Influenza D virus (D/swine/Oklahoma/1334/2011) segment 3 polymerase 3 (P3) gene, complete cds gi|1328406498|ref|NC_036619.1| 1173138 g109 i0 99.588 98.84232176 2186 9 99.0 0 3 2188 2 2187 216267 4026.0 0.990561351 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Deltainfluenzavirus Deltainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Deltainfluenzavirus Deltainfluenzavirus Influenza D virus (D/bovine/Kansas/13-21/2 gi|1328406498|ref|NC_036619.1| Viruses Viruses Viruses Viruses 3988.0 1398.0 0.0 0.0
10233 10233 PRJNA939369_CONTIG_267|Deltainfluenzavirus|CLUSTER4_Deltainfluenzavirus|2|1 Deltainfluenzavirus Endogenous or not fish-associated PRJNA939369_CONTIG_267|Deltainfluenzavirus PRJNA939369_CONTIG_267 Deltainfluenzavirus 7 1 7 CLUSTER4_Deltainfluenzavirus|2|1 MT349585_1_Influenza_D_virus_D_bovine_Italy_188812_1_2017_hemagglutinin_esterase_gene_complete_cds 2 1 PRJNA939369 267 2041 12.819614 261.6483217 Deltainfluenzavirus 1511083 Viruses Viruses 3716.0 0.0 Deltainfluenzavirus Non-phage NTclustered PRJNA939369_S_NODE_267_length_2041_cov_12.819614_g130_i0   Influenza D virus (D/bovine/Italy/188812-1/2017) hemagglutinin-esterase gene, complete cds gi|1847502554|gb|MT349585.1| 1511084 g130 i0 99.51 98.5188633 2041 10 100.0 0 1 2041 2041 1 201077 3718.0 0.999462076 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Deltainfluenzavirus Deltainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Deltainfluenzavirus Deltainfluenzavirus Influenza D virus gi|1847502554|gb|MT349585.1| Viruses Viruses Viruses Viruses 3716.0 1300.0 0.0 0.0
10234 10234 PRJNA939369_CONTIG_363|Deltainfluenzavirus|CLUSTER5_Deltainfluenzavirus|2|1 Deltainfluenzavirus Endogenous or not fish-associated PRJNA939369_CONTIG_363|Deltainfluenzavirus PRJNA939369_CONTIG_363 Deltainfluenzavirus 7 1 7 CLUSTER5_Deltainfluenzavirus|2|1 MZ264975_1_Influenza_D_virus_D_bovine_Italy_287448_2015_segment_5_nucleocapsid_protein_NP_gene_complete_cds 2 1 PRJNA939369 363 1768 25.59882 452.5871376 Deltainfluenzavirus 1511083 Viruses Viruses 3230.0 0.0 Deltainfluenzavirus Non-phage NTclustered PRJNA939369_S_NODE_363_length_1768_cov_25.598820_g200_i0   Influenza D virus (D/bovine/Italy/287448/2015) segment 5 nucleocapsid protein (NP) gene, complete cds gi|2050655392|gb|MZ264975.1| 1511084 g200 i0 99.66 98.39649321 1767 6 99.0 0 2 1768 2 1768 173965 3241.0 0.996605986 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Deltainfluenzavirus Deltainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Deltainfluenzavirus Deltainfluenzavirus Phaeobacter inhibens gi|2050655392|gb|MZ264975.1| Viruses Bacteria Viruses Bacteria 3230.0 1097.0 0.0 0.0
10237 10237 PRJNA939369_CONTIG_661|Deltainfluenzavirus|CLUSTER6_Deltainfluenzavirus|2|1 Deltainfluenzavirus Endogenous or not fish-associated PRJNA939369_CONTIG_661|Deltainfluenzavirus PRJNA939369_CONTIG_661 Deltainfluenzavirus 7 1 7 CLUSTER6_Deltainfluenzavirus|2|1 PRJNA939369_S_NODE_661_length_1284_cov_12.716763_g420_i0|Deltainfluenzavirus|NTclustered|0|NA 2 1 PRJNA939369 661 1284 12.716763 163.2832369 Deltainfluenzavirus 1511083 Viruses Viruses 2213.0 0.0 Deltainfluenzavirus Non-phage NTclustered PRJNA939369_S_NODE_661_length_1284_cov_12.716763_g420_i0   Influenza D virus (D/swine/Oklahoma/1334/2011) segment 6 P42 (P42) gene, complete cds gi|1328406500|ref|NC_036620.1| 1173138 g420 i0 99.669 93.03816199 1210 4 94.0 0 1 1210 1211 2 119461 2224.0 0.995053957 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Deltainfluenzavirus Deltainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Deltainfluenzavirus Deltainfluenzavirus Phaeobacter inhibens gi|1328406500|ref|NC_036620.1| Viruses Bacteria Viruses Bacteria 2213.0 743.0 0.0 1.6700000000000002e-269
10240 10240 PRJNA939369_CONTIG_1544|Deltainfluenzavirus|CLUSTER7_Deltainfluenzavirus|2|1 Deltainfluenzavirus Endogenous or not fish-associated PRJNA939369_CONTIG_1544|Deltainfluenzavirus PRJNA939369_CONTIG_1544 Deltainfluenzavirus 7 1 7 CLUSTER7_Deltainfluenzavirus|2|1 NC_036621_1_Influenza_D_virus_D_swine_Oklahoma_1334_2011_segment_7_nonstructural_protein_2_NS2_and_nonstructural_protein_1_NS1_genes_complete_cds 2 1 PRJNA939369 1544 862 34.152091 294.3910244 Deltainfluenzavirus 1511083 Viruses Viruses 1580.0 0.0 Deltainfluenzavirus Non-phage NTclustered PRJNA939369_S_NODE_1544_length_862_cov_34.152091_g1198_i0   Influenza D virus (D/swine/Oklahoma/1334/2011) segment 7 nonstructural protein 2 (NS2) and nonstructural protein 1 (NS1) genes, complete cds gi|1328406502|ref|NC_036621.1| 1173138 g1198 i0 99.768 99.17865429 861 2 99.0 0 1 861 861 1 85492 1580.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Deltainfluenzavirus Deltainfluenzavirus influenzae Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Deltainfluenzavirus Deltainfluenzavirus Phaeobacter inhibens gi|1328406502|ref|NC_036621.1| Viruses Bacteria Viruses Bacteria 1580.0 491.0 0.0 1.31e-174

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