viruses_fish_associated_curated
10 rows where bioproject = "PRJEB14803"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3970 | 3970 | PRJEB14803_CONTIG_11018|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 | Zebrafish picornavirus 1 | Known | PRJEB14803_CONTIG_11018|Cyprivirus_A | PRJEB14803_CONTIG_11018 | Cyprivirus A | 1161 | 220 | 1 | CLUSTER1_Cyprivirus_A|1164|220 | PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA | 1164 | 220 | PRJEB14803 | 11018 | 383 | 1.62069 | 6.2072427 | Cyprivirus A | 2304617 | Viruses | Viruses | 652.0 | 0.0 | Cyprivirus A | Non-phage | NTclustered | PRJEB14803_P_NODE_11018_length_383_cov_1.620690_g10553_i0 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | gi|1990739381|tpg|BK011179.1| | 2563826 | g10553 | i0 | 97.389 | 3.075718016 | 383 | 10 | 100.0 | 0 | 1 | 383 | 7706 | 7324 | 1178 | 652.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cyprivirus A | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 | Cyprivirus A | Zebrafish picornavirus 1 | gi|1990739381|tpg|BK011179.1| | Viruses | Viruses | Viruses | Viruses | 652.0 | 256.0 | 0.0 | 3.2e-76 | ||
| 4119 | 4119 | PRJEB14803_CONTIG_18519|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 | Zebrafish picornavirus 1 | Known | PRJEB14803_CONTIG_18519|Cyprivirus_A | PRJEB14803_CONTIG_18519 | Cyprivirus A | 1161 | 220 | 1 | CLUSTER1_Cyprivirus_A|1164|220 | PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA | 1164 | 220 | PRJEB14803 | 18519 | 272 | 2.185654 | 5.94497888 | Cyprivirus A | 2304617 | Viruses | Viruses | 470.0 | 5.81e-128 | Cyprivirus A | Non-phage | NTclustered | PRJEB14803_P_NODE_18519_length_272_cov_2.185654_g18053_i0 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | gi|2500378199|ref|NC_076245.1| | 2563826 | g18053 | i0 | 97.794 | 3.0 | 272 | 6 | 100.0 | 0 | 1 | 272 | 6614 | 6343 | 816 | 470.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cyprivirus A | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 | Cyprivirus A | Zebrafish picornavirus 1 | gi|2500378199|ref|NC_076245.1| | Viruses | Viruses | Viruses | Viruses | 470.0 | 184.0 | 5.81e-128 | 1.42e-51 | ||
| 4217 | 4217 | PRJEB14803_CONTIG_33134|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 | Zebrafish picornavirus 1 | Known | PRJEB14803_CONTIG_33134|Cyprivirus_A | PRJEB14803_CONTIG_33134 | Cyprivirus A | 1161 | 220 | 1 | CLUSTER1_Cyprivirus_A|1164|220 | PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA | 1164 | 220 | PRJEB14803 | 33134 | 186 | 1.324503 | 2.46357558 | Cyprivirus A | 2304617 | Viruses | Viruses | 322.0 | 1.0999999999999999e-83 | Cyprivirus A | Non-phage | NTclustered | PRJEB14803_P_NODE_33134_length_186_cov_1.324503_g32668_i0 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | gi|1812398529|gb|MN524064.1| | 2563826 | g32668 | i0 | 97.849 | 3.0 | 186 | 4 | 100.0 | 0 | 1 | 186 | 6279 | 6094 | 558 | 322.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cyprivirus A | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 | Cyprivirus A | Zebrafish picornavirus 1 | gi|1812398529|gb|MN524064.1| | Viruses | Viruses | Viruses | Viruses | 322.0 | 124.0 | 1.0999999999999999e-83 | 4.4999999999999995e-31 | ||
| 4262 | 4262 | PRJEB14803_CONTIG_46839|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 | Zebrafish picornavirus 1 | Known | PRJEB14803_CONTIG_46839|Cyprivirus_A | PRJEB14803_CONTIG_46839 | Cyprivirus A | 1161 | 220 | 1 | CLUSTER1_Cyprivirus_A|1164|220 | PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0|Cyprivirus_A|NTclustered|0|NA | 1164 | 220 | PRJEB14803 | 46839 | 151 | 1.37931 | 2.0827581 | Cyprivirus A | 2304617 | Viruses | Viruses | 257.0 | 2.43e-64 | Cyprivirus A | Non-phage | NTclustered | PRJEB14803_P_NODE_46839_length_151_cov_1.379310_g46373_i0 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | gi|1812398529|gb|MN524064.1| | 2563826 | g46373 | i0 | 97.351 | 3.0 | 151 | 4 | 100.0 | 0 | 1 | 151 | 4820 | 4970 | 453 | 257.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cyprivirus A | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1 | Cyprivirus A | Zebrafish picornavirus 1 | gi|1812398529|gb|MN524064.1| | Viruses | Viruses | Viruses | Viruses | 257.0 | 102.0 | 2.43e-64 | 7.46e-24 | ||
| 9844 | 9844 | PRJEB14803_CONTIG_37692|Pimephales_minnow_adintovirus|CLUSTER3_Pimephales_minnow_adintovirus|19|15 | Pimephales minnow adintovirus | Endogenous or not fish-associated | PRJEB14803_CONTIG_37692|Pimephales_minnow_adintovirus | PRJEB14803_CONTIG_37692 | Pimephales minnow adintovirus | 168 | 104 | 20 | CLUSTER3_Pimephales_minnow_adintovirus|19|15 | PRJEB66218_P_NODE_46828_length_500_cov_1.141230_g44412_i0|Pimephales_minnow_adintovirus|NR|1e-20|NA | 19 | 15 | PRJEB14803 | 37692 | 172 | 0.956204 | 1.64467088 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 67.4 | 1.05e-11 | Pimephales minnow adintovirus | Non-phage | NR | PRJEB14803_P_NODE_37692_length_172_cov_0.956204_g37226_i0 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | DAC81394.1 | 2609864 | g37226 | i0 | 50.0 | 0.976744186 | 56 | 28 | 97.7 | 0 | 2 | 169 | 41 | 96 | 168 | 67.4 | 1.0 | Viruses | Varidnaviria | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Pimephales minnow adintovirus | Pimephales minnow adintovirus | Viruses | Viruses | 67.4 | 1.05e-11 | ||||||||
| 9877 | 9877 | PRJEB14803_CONTIG_25023|Pimephales_minnow_adintovirus|CLUSTER4_Pimephales_minnow_adintovirus|18|15 | Pimephales minnow adintovirus | Endogenous or not fish-associated | PRJEB14803_CONTIG_25023|Pimephales_minnow_adintovirus | PRJEB14803_CONTIG_25023 | Pimephales minnow adintovirus | 168 | 104 | 20 | CLUSTER4_Pimephales_minnow_adintovirus|18|15 | PRJNA523184_P_NODE_1012_length_470_cov_4.248276_g948_i0|Pimephales_minnow_adintovirus|NR|7.76e-34|NA | 18 | 15 | PRJEB14803 | 25023 | 223 | 1.180851 | 2.63329773 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 85.1 | 2.13e-19 | Pimephales minnow adintovirus | Non-phage | NR | PRJEB14803_P_NODE_25023_length_223_cov_1.180851_g24557_i0 | DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] | DAC81395.1 | 2609864 | g24557 | i0 | 55.4 | 0.995515695 | 74 | 33 | 99.6 | 0 | 2 | 223 | 15 | 88 | 222 | 85.1 | 1.0 | Viruses | Varidnaviria | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Pimephales minnow adintovirus | Pimephales minnow adintovirus | Viruses | Viruses | 85.1 | 2.13e-19 | ||||||||
| 10086 | 10086 | PRJEB14803_CONTIG_19958|Pimephales_minnow_adintovirus|CLUSTER6_Pimephales_minnow_adintovirus|10|9 | Pimephales minnow adintovirus | Endogenous or not fish-associated | PRJEB14803_CONTIG_19958|Pimephales_minnow_adintovirus | PRJEB14803_CONTIG_19958 | Pimephales minnow adintovirus | 168 | 104 | 20 | CLUSTER6_Pimephales_minnow_adintovirus|10|9 | PRJEB66218_P_NODE_83127_length_345_cov_0.922535_g80700_i0|Pimephales_minnow_adintovirus|NR|3.45e-17|NA | 10 | 9 | PRJEB14803 | 19958 | 259 | 3.366071 | 8.71812389 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 90.1 | 3.5e-21 | Pimephales minnow adintovirus | Non-phage | NR | PRJEB14803_P_NODE_19958_length_259_cov_3.366071_g19492_i0 | DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] | DAC81395.1 | 2609864 | g19492 | i0 | 62.4 | 0.984555985 | 85 | 32 | 98.5 | 0 | 257 | 3 | 4 | 88 | 255 | 90.1 | 1.0 | Viruses | Varidnaviria | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Pimephales minnow adintovirus | Pimephales minnow adintovirus | Viruses | Viruses | 90.1 | 3.5e-21 | ||||||||
| 10170 | 10170 | PRJEB14803_CONTIG_23672|Pimephales_minnow_adintovirus|CLUSTER7_Pimephales_minnow_adintovirus|5|5 | Pimephales minnow adintovirus | Endogenous or not fish-associated | PRJEB14803_CONTIG_23672|Pimephales_minnow_adintovirus | PRJEB14803_CONTIG_23672 | Pimephales minnow adintovirus | 168 | 104 | 20 | CLUSTER7_Pimephales_minnow_adintovirus|5|5 | PRJEB673_P_NODE_3515_length_532_cov_2.076459_g3194_i0|Pimephales_minnow_adintovirus|NR|1.09e-50|NA | 4 | 4 | PRJEB14803 | 23672 | 231 | 1.658163 | 3.83035653 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 99.4 | 1.05e-22 | Pimephales minnow adintovirus | Non-phage | NR | PRJEB14803_P_NODE_23672_length_231_cov_1.658163_g23206_i0 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | DAC81401.1 | 2609864 | g23206 | i0 | 70.7 | 2.922077922 | 75 | 22 | 97.4 | 0 | 6 | 230 | 19 | 93 | 675 | 99.4 | 1.0 | Viruses | Varidnaviria | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Pimephales minnow adintovirus | Pimephales minnow adintovirus | Viruses | Viruses | 99.4 | 1.05e-22 | ||||||||
| 10262 | 10262 | PRJEB14803_CONTIG_15406|Pimephales_minnow_adintovirus|CLUSTER13_Pimephales_minnow_adintovirus|2|2 | Pimephales minnow adintovirus | Endogenous or not fish-associated | PRJEB14803_CONTIG_15406|Pimephales_minnow_adintovirus | PRJEB14803_CONTIG_15406 | Pimephales minnow adintovirus | 168 | 104 | 20 | CLUSTER13_Pimephales_minnow_adintovirus|2|2 | PRJEB14803_P_NODE_15406_length_307_cov_5.761029_g14940_i0|Pimephales_minnow_adintovirus|NR|1.49e-19|NA | 2 | 2 | PRJEB14803 | 15406 | 307 | 5.761029 | 17.68635903 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 90.9 | 1.49e-19 | Pimephales minnow adintovirus | Non-phage | NR | PRJEB14803_P_NODE_15406_length_307_cov_5.761029_g14940_i0 | DAC81400.1 TPA_asm: penton [Pimephales minnow adintovirus] | DAC81400.1 | 2609864 | g14940 | i0 | 45.5 | 0.986970684 | 101 | 55 | 98.7 | 0 | 303 | 1 | 93 | 193 | 303 | 90.9 | 1.0 | Viruses | Varidnaviria | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Pimephales minnow adintovirus | Pimephales minnow adintovirus | Viruses | Viruses | 90.9 | 1.49e-19 | ||||||||
| 10415 | 10415 | PRJEB14803_CONTIG_19352|Cyvirus_cyprinidallo3|CLUSTER82_Cyvirus_cyprinidallo3|1|1 | Cyprinid herpesvirus 3 | Known | PRJEB14803_CONTIG_19352|Cyvirus_cyprinidallo3 | PRJEB14803_CONTIG_19352 | Cyvirus cyprinidallo3 | 186 | 4 | 92 | CLUSTER82_Cyvirus_cyprinidallo3|1|1 | PRJEB14803_P_NODE_19352_length_265_cov_1.330435_g18886_i0|Cyvirus_cyprinidallo3|NTclustered|1.06e-40|NA | 1 | 1 | PRJEB14803 | 19352 | 265 | 1.330435 | 3.52565275 | Cyvirus cyprinidallo3 | 3050271 | Viruses | Viruses | 180.0 | 1.06e-40 | Cyvirus cyprinidallo3 | Non-phage | NTclustered | PRJEB14803_P_NODE_19352_length_265_cov_1.330435_g18886_i0 | Cyprinid herpesvirus 3 isolate J2_101110, complete genome | gi|1063455788|gb|KX544843.1| | 180230 | g18886 | i0 | 85.799 | 44.6 | 169 | 24 | 64.0 | 0 | 3 | 171 | 244411 | 244243 | 11819 | 180.0 | 1.0 | Viruses | Duplodnaviria | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Alloherpesviridae | Cyvirus | Cyvirus cyprinidallo3 | Viruses;Duplodnaviria;Heunggongvirae;Peploviricota;Herviviricetes;Herpesvirales;Alloherpesviridae;Cyvirus;Cyprinid herpesvirus 3 | Cyvirus cyprinidallo3 | Fungi | gi|1063455788|gb|KX544843.1| | Viruses | Fungi | Viruses | Fungi | 180.0 | 151.0 | 1.06e-40 | 2e-40 |
Advanced export
JSON shape: default, array, newline-delimited
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);;