RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

14 rows where bioproject = "PRJNA830699"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

clusterLCA_curated 1

bioproject 1

  • PRJNA830699 · 14 ✖

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
9798 9798 PRJNA830699_CONTIG_25|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_25|Salmovirus_WFRC1 PRJNA830699_CONTIG_25 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 PRJNA830699 25 1799 7.716949 138.8279125 Salmovirus WFRC1 1981916 Viruses Viruses 478.0 6.62e-156 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_25_length_1799_cov_7.716949_g14_i0   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g14 i0 53.2 0.773763202 464 199 76.9 5 1384 2 96 544 1392 478.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   478.0   6.62e-156
9799 9799 PRJNA830699_CONTIG_27|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_27|Salmovirus_WFRC1 PRJNA830699_CONTIG_27 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 PRJNA830699 27 1767 7.802647 137.8727725 Salmovirus WFRC1 1981916 Viruses Viruses 513.0 1.05e-169 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_27_length_1767_cov_7.802647_g14_i1   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g14 i1 49.8 0.950764007 560 233 89.8 8 180 1766 2 544 1680 513.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   513.0   1.05e-169
9802 9802 PRJNA830699_CONTIG_63|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_63|Salmovirus_WFRC1 PRJNA830699_CONTIG_63 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 PRJNA830699 63 1444 8.031802 115.9792209 Salmovirus WFRC1 1981916 Viruses Viruses 503.0 9.34e-168 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_63_length_1444_cov_8.031802_g14_i2   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g14 i2 53.1 1.005540166 484 209 99.9 5 1 1443 76 544 1452 503.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   503.0   9.34e-168
9803 9803 PRJNA830699_CONTIG_69|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_69|Salmovirus_WFRC1 PRJNA830699_CONTIG_69 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 PRJNA830699 69 1396 8.231895 114.9172542 Salmovirus WFRC1 1981916 Viruses Viruses 491.0 3.35e-163 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_69_length_1396_cov_8.231895_g14_i3   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g14 i3 53.4 1.005730659 468 200 99.9 5 1 1395 92 544 1404 491.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   491.0   3.35e-163
9804 9804 PRJNA830699_CONTIG_252|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_252|Salmovirus_WFRC1 PRJNA830699_CONTIG_252 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 PRJNA830699 252 918 8.984252 82.47543336 Salmovirus WFRC1 1981916 Viruses Viruses 246.0 1.31e-71 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_252_length_918_cov_8.984252_g14_i4   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g14 i4 48.4 0.905228758 277 128 90.5 4 917 87 284 545 831 246.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   246.0   1.31e-71
9805 9805 PRJNA830699_CONTIG_268|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_268|Salmovirus_WFRC1 PRJNA830699_CONTIG_268 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 PRJNA830699 268 890 8.824623 78.5391447 Salmovirus WFRC1 1981916 Viruses Viruses 247.0 4.92e-72 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_268_length_890_cov_8.824623_g14_i5   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g14 i5 48.6 0.930337079 276 127 93.0 4 889 62 284 544 828 247.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   247.0   4.92e-72
9806 9806 PRJNA830699_CONTIG_307|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_307|Salmovirus_WFRC1 PRJNA830699_CONTIG_307 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 PRJNA830699 307 844 7.766871 65.55239124 Salmovirus WFRC1 1981916 Viruses Viruses 152.0 1.22e-38 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_307_length_844_cov_7.766871_g142_i0   YP_009361865.1 protease [Salmovirus WFRC1] YP_009361865.1 1981916 g142 i0 42.5 0.753554502 212 109 73.9 5 626 3 224 426 636 152.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   152.0   1.22e-38
9807 9807 PRJNA830699_CONTIG_467|Salmovirus_WFRC1|CLUSTER1_Salmovirus_WFRC1|20|6 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_467|Salmovirus_WFRC1 PRJNA830699_CONTIG_467 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 PRJNA830699 467 706 10.509601 74.19778306 Salmovirus WFRC1 1981916 Viruses Viruses 94.7 2.74e-18 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_467_length_706_cov_10.509601_g223_i0   YP_009361865.1 protease [Salmovirus WFRC1] YP_009361865.1 1981916 g223 i0 42.2 0.492917847 116 67 49.3 0 507 160 13 128 348 94.7 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   94.7   2.74e-18
10073 10073 PRJNA830699_CONTIG_161|Salmovirus_WFRC1|CLUSTER2_Salmovirus_WFRC1|10|5 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_161|Salmovirus_WFRC1 PRJNA830699_CONTIG_161 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 PRJNA830699 161 1100 5.049486 55.544346 Salmovirus WFRC1 1981916 Viruses Viruses 119.0 1.97e-25 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_161_length_1100_cov_5.049486_g78_i0   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g78 i0 36.2 0.542727273 199 115 51.8 6 2 571 593 788 597 119.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   119.0   1.97e-25
10074 10074 PRJNA830699_CONTIG_200|Salmovirus_WFRC1|CLUSTER2_Salmovirus_WFRC1|10|5 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_200|Salmovirus_WFRC1 PRJNA830699_CONTIG_200 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 PRJNA830699 200 998 5.296182 52.85589636 Salmovirus WFRC1 1981916 Viruses Viruses 119.0 9.490000000000001e-26 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_200_length_998_cov_5.296182_g78_i1   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g78 i1 36.2 0.598196393 199 115 57.1 6 2 571 593 788 597 119.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   119.0   9.490000000000001e-26
10075 10075 PRJNA830699_CONTIG_222|Salmovirus_WFRC1|CLUSTER2_Salmovirus_WFRC1|10|5 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_222|Salmovirus_WFRC1 PRJNA830699_CONTIG_222 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 PRJNA830699 222 977 5.489451 53.63193627 Salmovirus WFRC1 1981916 Viruses Viruses 119.0 8.09e-26 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_222_length_977_cov_5.489451_g78_i2   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g78 i2 36.2 0.611054248 199 115 58.3 6 2 571 593 788 597 119.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   119.0   8.09e-26
10076 10076 PRJNA830699_CONTIG_233|Salmovirus_WFRC1|CLUSTER2_Salmovirus_WFRC1|10|5 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_233|Salmovirus_WFRC1 PRJNA830699_CONTIG_233 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 PRJNA830699 233 950 5.499457 52.2448415 Salmovirus WFRC1 1981916 Viruses Viruses 125.0 6.900000000000001e-28 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_233_length_950_cov_5.499457_g78_i3   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g78 i3 36.0 0.701052632 222 121 67.3 7 942 304 579 788 666 125.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   125.0   6.900000000000001e-28
10077 10077 PRJNA830699_CONTIG_254|Salmovirus_WFRC1|CLUSTER2_Salmovirus_WFRC1|10|5 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_254|Salmovirus_WFRC1 PRJNA830699_CONTIG_254 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 PRJNA830699 254 915 5.756208 52.6693032 Salmovirus WFRC1 1981916 Viruses Viruses 119.0 5.02e-26 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_254_length_915_cov_5.756208_g78_i4   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g78 i4 35.5 0.66557377 203 119 63.6 6 31 612 589 788 609 119.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   119.0   5.02e-26
10078 10078 PRJNA830699_CONTIG_258|Salmovirus_WFRC1|CLUSTER2_Salmovirus_WFRC1|10|5 Zebrafish rhabdo-like virus Novel PRJNA830699_CONTIG_258|Salmovirus_WFRC1 PRJNA830699_CONTIG_258 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 PRJNA830699 258 910 5.900114 53.6910374 Salmovirus WFRC1 1981916 Viruses Viruses 119.0 4.78e-26 Salmovirus WFRC1 Non-phage NR PRJNA830699_P_NODE_258_length_910_cov_5.900114_g78_i5   YP_009361866.1 polyprotein [Salmovirus WFRC1] YP_009361866.1 1981916 g78 i5 36.2 0.656043956 199 115 62.6 6 2 571 593 788 597 119.0 1.0 Viruses               Salmovirus WFRC1 Viruses;Zebrafish rhabdo-like virus   Salmovirus WFRC1     Viruses   Viruses   119.0   4.78e-26

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