RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

6 rows where Category = "Novel", bioproject = "PRJNA690124" and clusterLCA_curated = "Zebrafish influenza-like virus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_family_NTorNR 1

clusterLCA_curated 1

  • Zebrafish influenza-like virus · 6 ✖

bioproject 1

  • PRJNA690124 · 6 ✖

Category 1

  • Novel · 6 ✖

tax_genus_NTorNR 0

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
10184 10184 PRJNA690124_CONTIG_3829|Siamese_algae-eater_influenza-like_virus|CLUSTER1_Siamese_algae-eater_influenza-like_virus|4|3 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_3829|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_3829 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER1_Siamese_algae-eater_influenza-like_virus|4|3 PRJNA690124_P_NODE_3829_length_802_cov_1.341564_g3518_i0|Siamese_algae-eater_influenza-like_virus|NR|2.39e-35|NA 4 3 PRJNA690124 3829 802 1.341564 10.75934328 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 137.0 2.3900000000000002e-35 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_3829_length_802_cov_1.341564_g3518_i0   QOE76807.1 matrix protein [Siamese algae-eater influenza-like virus] QOE76807.1 2777035 g3518 i0 41.0 0.703241895 188 109 70.0 2 3 563 68 254 564 137.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   137.0   2.3900000000000002e-35
10263 10263 PRJNA690124_CONTIG_15411|Siamese_algae-eater_influenza-like_virus|CLUSTER2_Siamese_algae-eater_influenza-like_virus|2|2 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_15411|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_15411 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER2_Siamese_algae-eater_influenza-like_virus|2|2 PRJNA690124_P_NODE_15411_length_411_cov_1.834320_g15045_i0|Siamese_algae-eater_influenza-like_virus|NR|5.91e-24|NA 2 2 PRJNA690124 15411 411 1.83432 7.5390552 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 107.0 5.91e-24 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_15411_length_411_cov_1.834320_g15045_i0   QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus] QOE76804.1 2777035 g15045 i0 38.5 0.98540146 135 82 98.5 1 5 409 404 537 405 107.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   107.0   5.91e-24
10271 10271 PRJNA690124_CONTIG_35319|Siamese_algae-eater_influenza-like_virus|CLUSTER4_Siamese_algae-eater_influenza-like_virus|2|2 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_35319|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_35319 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER4_Siamese_algae-eater_influenza-like_virus|2|2 PRJNA690124_P_NODE_35319_length_280_cov_0.956522_g34953_i0|Siamese_algae-eater_influenza-like_virus|NR|4.83e-19|NA 2 2 PRJNA690124 35319 280 0.956522 2.6782616 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 91.3 4.83e-19 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_35319_length_280_cov_0.956522_g34953_i0   QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus] QOE76804.1 2777035 g34953 i0 48.9 0.964285714 90 46 96.4 0 280 11 317 406 270 91.3 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   91.3   4.83e-19
10418 10418 PRJNA690124_CONTIG_20269|Siamese_algae-eater_influenza-like_virus|CLUSTER5_Siamese_algae-eater_influenza-like_virus|1|1 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_20269|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_20269 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER5_Siamese_algae-eater_influenza-like_virus|1|1 PRJNA690124_P_NODE_20269_length_361_cov_1.222222_g19903_i0|Siamese_algae-eater_influenza-like_virus|NR|9.69e-34|NA 1 1 PRJNA690124 20269 361 1.222222 4.41222142 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 133.0 9.689999999999999e-34 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_20269_length_361_cov_1.222222_g19903_i0   QOE76806.1 hemagglutinin [Siamese algae-eater influenza-like virus] QOE76806.1 2777035 g19903 i0 58.5 1.022160665 123 44 99.7 3 361 2 275 393 369 133.0 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   133.0   9.689999999999999e-34
10447 10447 PRJNA690124_CONTIG_34936|Siamese_algae-eater_influenza-like_virus|CLUSTER7_Siamese_algae-eater_influenza-like_virus|1|1 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_34936|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_34936 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER7_Siamese_algae-eater_influenza-like_virus|1|1 PRJNA690124_P_NODE_34936_length_281_cov_1.495192_g34570_i0|Siamese_algae-eater_influenza-like_virus|NR|2e-14|NA 1 1 PRJNA690124 34936 281 1.495192 4.20148952 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 78.2 2e-14 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_34936_length_281_cov_1.495192_g34570_i0   QOE76806.1 hemagglutinin [Siamese algae-eater influenza-like virus] QOE76806.1 2777035 g34570 i0 37.6 0.992882562 93 58 99.3 0 2 280 47 139 279 78.2 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   78.2   2e-14
10452 10452 PRJNA690124_CONTIG_37976|Siamese_algae-eater_influenza-like_virus|CLUSTER8_Siamese_algae-eater_influenza-like_virus|1|1 Zebrafish influenza-like virus Novel PRJNA690124_CONTIG_37976|Siamese_algae-eater_influenza-like_virus PRJNA690124_CONTIG_37976 Siamese algae-eater influenza-like virus 14 4 9 CLUSTER8_Siamese_algae-eater_influenza-like_virus|1|1 PRJNA690124_P_NODE_37976_length_270_cov_1.187817_g37610_i0|Siamese_algae-eater_influenza-like_virus|NR|1.29e-14|NA 1 1 PRJNA690124 37976 270 1.187817 3.2071059 Siamese algae-eater influenza-like virus 2777035 Viruses Viruses 78.6 1.29e-14 Siamese algae-eater influenza-like virus Non-phage NR PRJNA690124_P_NODE_37976_length_270_cov_1.187817_g37610_i0   QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus] QOE76804.1 2777035 g37610 i0 55.9 0.755555556 68 30 75.6 0 249 46 55 122 204 78.6 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Siamese algae-eater influenza-like virus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus   Siamese algae-eater influenza-like virus     Viruses   Viruses   78.6   1.29e-14

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