RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

7 rows where bioproject = "PRJNA450343" and clusterLCA_curated = "Zebrafish rhabdo-like virus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

clusterLCA_curated 1

  • Zebrafish rhabdo-like virus · 7 ✖

bioproject 1

  • PRJNA450343 · 7 ✖

Category 1

tax_genus_NTorNR 0

tax_family_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
9811 9811 PRJNA450343_CONTIG_1661|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA450343_CONTIG_1661|Salmovirus_WFRC1 PRJNA450343_CONTIG_1661 Salmovirus WFRC1 37 9 6 CLUSTER1_Salmovirus_WFRC1|20|6 PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0|Salmovirus_WFRC1|NR|7.9e-107|NA 20 6 PRJNA450343 1661 428 2.48285 10.626598 Salmovirus WFRC1 1981916 Viruses Viruses 133.0 2.24e-33 Salmovirus WFRC1 Non-phage NR PRJNA450343_P_NODE_1661_length_428_cov_2.482850_g1593_i0   YP_009361865.1 protease [Salmovirus WFRC1] YP_009361865.1 1981916 g1593 i0 49.3 1.023364486 146 68 99.5 3 2 427 288 431 438 133.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   133.0   2.24e-33
9812 9812 PRJNA450343_CONTIG_2346|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA450343_CONTIG_2346|Salmovirus_WFRC1 PRJNA450343_CONTIG_2346 Salmovirus WFRC1 37 9 6 CLUSTER1_Salmovirus_WFRC1|20|6 PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0|Salmovirus_WFRC1|NR|7.9e-107|NA 20 6 PRJNA450343 2346 355 2.660131 9.44346505 Salmovirus WFRC1 1981916 Viruses Viruses 118.0 4.86e-28 Salmovirus WFRC1 Non-phage NR PRJNA450343_P_NODE_2346_length_355_cov_2.660131_g2278_i0   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g2278 i0 50.0 0.997183099 118 59 99.7 0 354 1 288 405 354 118.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   118.0   4.86e-28
9813 9813 PRJNA450343_CONTIG_3220|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA450343_CONTIG_3220|Salmovirus_WFRC1 PRJNA450343_CONTIG_3220 Salmovirus WFRC1 37 9 6 CLUSTER1_Salmovirus_WFRC1|20|6 PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0|Salmovirus_WFRC1|NR|7.9e-107|NA 20 6 PRJNA450343 3220 298 3.421687 10.19662726 Salmovirus WFRC1 1981916 Viruses Viruses 58.9 1.45e-07 Salmovirus WFRC1 Non-phage NR PRJNA450343_P_NODE_3220_length_298_cov_3.421687_g3152_i0   YP_009361865.1 protease [Salmovirus WFRC1] YP_009361865.1 1981916 g3152 i0 39.5 0.765100671 76 46 76.5 0 2 229 53 128 228 58.9 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   58.9   1.45e-07
9814 9814 PRJNA450343_CONTIG_6412|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA450343_CONTIG_6412|Salmovirus_WFRC1 PRJNA450343_CONTIG_6412 Salmovirus WFRC1 37 9 6 CLUSTER1_Salmovirus_WFRC1|20|6 PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0|Salmovirus_WFRC1|NR|7.9e-107|NA 20 6 PRJNA450343 6412 211 1.432099 3.02172889 Salmovirus WFRC1 1981916 Viruses Viruses 49.3 0.000122 Salmovirus WFRC1 Non-phage NR PRJNA450343_P_NODE_6412_length_211_cov_1.432099_g6344_i0   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g6344 i0 40.6 0.981042654 69 39 98.1 1 210 4 7 73 207 49.3 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   49.3   0.000122
9815 9815 PRJNA450343_CONTIG_9151|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA450343_CONTIG_9151|Salmovirus_WFRC1 PRJNA450343_CONTIG_9151 Salmovirus WFRC1 37 9 6 CLUSTER1_Salmovirus_WFRC1|20|6 PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0|Salmovirus_WFRC1|NR|7.9e-107|NA 20 6 PRJNA450343 9151 180 1.938931 3.4900758 Salmovirus WFRC1 1981916 Viruses Viruses 46.6 0.000688 Salmovirus WFRC1 Non-phage NR PRJNA450343_P_NODE_9151_length_180_cov_1.938931_g9083_i0   YP_009361865.1 protease [Salmovirus WFRC1] YP_009361865.1 1981916 g9083 i0 50.0 0.733333333 44 22 73.3 0 39 170 13 56 132 46.6 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   46.6   0.000688
9816 9816 PRJNA450343_CONTIG_9943|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA450343_CONTIG_9943|Salmovirus_WFRC1 PRJNA450343_CONTIG_9943 Salmovirus WFRC1 37 9 6 CLUSTER1_Salmovirus_WFRC1|20|6 PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0|Salmovirus_WFRC1|NR|7.9e-107|NA 20 6 PRJNA450343 9943 172 2.073171 3.56585412 Salmovirus WFRC1 1981916 Viruses Viruses 79.7 1.33e-15 Salmovirus WFRC1 Non-phage NR PRJNA450343_P_NODE_9943_length_172_cov_2.073171_g9875_i0   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g9875 i0 57.9 0.994186047 57 24 99.4 0 172 2 144 200 171 79.7 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   79.7   1.33e-15
10080 10080 PRJNA450343_CONTIG_529|Salmovirus_WFRC1|CLUSTER2_Salmovirus_WFRC1|10|5 Zebrafish rhabdo-like virus Novel PRJNA450343_CONTIG_529|Salmovirus_WFRC1 PRJNA450343_CONTIG_529 Salmovirus WFRC1 37 9 6 CLUSTER2_Salmovirus_WFRC1|10|5 PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0|Salmovirus_WFRC1|NR|7.69e-84|NA 10 5 PRJNA450343 529 787 1.876694 14.76958178 Salmovirus WFRC1 1981916 Viruses Viruses 234.0 1.1199999999999999e-67 Salmovirus WFRC1 Non-phage NR PRJNA450343_P_NODE_529_length_787_cov_1.876694_g482_i0   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g482 i0 50.6 0.972045743 255 117 94.2 3 15 755 432 685 765 234.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   234.0   1.1199999999999999e-67

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