viruses_fish_associated_curated
7 rows where bioproject = "PRJNA1199330" and clusterLCA_curated = "Zebrafish gut calicivirus"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9491 | 9491 | PRJNA1199330_CONTIG_1822|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA1199330_CONTIG_1822|Barramundi_calicivirus_1 | PRJNA1199330_CONTIG_1822 | Barramundi calicivirus 1 | 48 | 14 | 1 | CLUSTER1_Barramundi_calicivirus_1|53|15 | PRJNA738523_P_NODE_1_length_7247_cov_15.105241_g0_i0|Barramundi_calicivirus_1|NR|0|NA | 49 | 15 | PRJNA1199330 | 1822 | 1556 | 1.947404 | 30.30160624 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 203.0 | 3.73e-52 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA1199330_P_NODE_1822_length_1556_cov_1.947404_g1591_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g1591 | i0 | 34.0 | 0.726863753 | 377 | 233 | 71.7 | 8 | 3 | 1118 | 1838 | 2203 | 1131 | 203.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Barramundi calicivirus 1 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Barramundi calicivirus 1 | Viruses | Viruses | 203.0 | 3.73e-52 | ||||||||
| 9500 | 9500 | PRJNA1199330_CONTIG_15882|Fujian_spotted_paddle-tail_newt_calicivirus|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA1199330_CONTIG_15882|Fujian_spotted_paddle-tail_newt_calicivirus | PRJNA1199330_CONTIG_15882 | Barramundi calicivirus 1 | 48 | 14 | 1 | CLUSTER1_Barramundi_calicivirus_1|53|15 | PRJNA738523_P_NODE_1_length_7247_cov_15.105241_g0_i0|Barramundi_calicivirus_1|NR|0|NA | 49 | 15 | PRJNA1199330 | 15882 | 513 | 2.897727 | 14.86533951 | Fujian spotted paddle-tail newt calicivirus | 2116168 | Viruses | Viruses | 68.9 | 5.06e-10 | Fujian spotted paddle-tail newt calicivirus | Non-phage | NR | PRJNA1199330_P_NODE_15882_length_513_cov_2.897727_g15192_i0 | AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus] | AVM87224.1 | 2116168 | g15192 | i0 | 31.4 | 1.005847953 | 172 | 101 | 92.4 | 7 | 491 | 18 | 34 | 202 | 516 | 68.9 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Fujian spotted paddle-tail newt calicivirus | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Fujian spotted paddle-tail newt calicivirus | Viruses | Viruses | 68.9 | 5.06e-10 | ||||||||
| 9501 | 9501 | PRJNA1199330_CONTIG_17562|Ameiurus_nebulosus_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA1199330_CONTIG_17562|Ameiurus_nebulosus_calicivirus_1 | PRJNA1199330_CONTIG_17562 | Barramundi calicivirus 1 | 48 | 14 | 1 | CLUSTER1_Barramundi_calicivirus_1|53|15 | PRJNA738523_P_NODE_1_length_7247_cov_15.105241_g0_i0|Barramundi_calicivirus_1|NR|0|NA | 49 | 15 | PRJNA1199330 | 17562 | 488 | 1.448193 | 7.06718184 | Ameiurus nebulosus calicivirus 1 | 2894560 | Viruses | Viruses | 77.8 | 3.35e-13 | Ameiurus nebulosus calicivirus 1 | Non-phage | NR | PRJNA1199330_P_NODE_17562_length_488_cov_1.448193_g16870_i0 | UFQ21768.1 polyprotein [Ameiurus nebulosus calicivirus 1] | UFQ21768.1 | 2894560 | g16870 | i0 | 35.9 | 1.026639344 | 167 | 85 | 92.8 | 7 | 19 | 471 | 975 | 1135 | 501 | 77.8 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Ameiurus nebulosus calicivirus 1 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Ameiurus nebulosus calicivirus 1 | Viruses | Viruses | 77.8 | 3.35e-13 | ||||||||
| 9515 | 9515 | PRJNA1199330_CONTIG_27683|Newt_calicivirus|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA1199330_CONTIG_27683|Newt_calicivirus | PRJNA1199330_CONTIG_27683 | Barramundi calicivirus 1 | 48 | 14 | 1 | CLUSTER1_Barramundi_calicivirus_1|53|15 | PRJNA738523_P_NODE_1_length_7247_cov_15.105241_g0_i0|Barramundi_calicivirus_1|NR|0|NA | 49 | 15 | PRJNA1199330 | 27683 | 392 | 0.968652 | 3.79711584 | Newt calicivirus | 2961777 | Viruses | Viruses | 184.0 | 7.470000000000001e-51 | Newt calicivirus | Non-phage | NR | PRJNA1199330_P_NODE_27683_length_392_cov_0.968652_g26987_i0 | DAZ91097.1 TPA_asm: nonstructural protein, partial [Newt calicivirus] | DAZ91097.1 | 2961777 | g26987 | i0 | 62.9 | 3.015306122 | 132 | 47 | 99.5 | 1 | 3 | 392 | 1784 | 1915 | 1182 | 184.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Newt calicivirus | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Newt calicivirus | Viruses | Viruses | 184.0 | 7.470000000000001e-51 | ||||||||
| 9516 | 9516 | PRJNA1199330_CONTIG_30351|Zhejiang_gunthers_frog_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA1199330_CONTIG_30351|Zhejiang_gunthers_frog_calicivirus_1 | PRJNA1199330_CONTIG_30351 | Barramundi calicivirus 1 | 48 | 14 | 1 | CLUSTER1_Barramundi_calicivirus_1|53|15 | PRJNA738523_P_NODE_1_length_7247_cov_15.105241_g0_i0|Barramundi_calicivirus_1|NR|0|NA | 49 | 15 | PRJNA1199330 | 30351 | 375 | 2.311258 | 8.6672175 | Zhejiang gunthers frog calicivirus 1 | 2116158 | Viruses | Viruses | 94.4 | 1.47e-19 | Zhejiang gunthers frog calicivirus 1 | Non-phage | NR | PRJNA1199330_P_NODE_30351_length_375_cov_2.311258_g29655_i0 | AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] | AVM87226.1 | 2116158 | g29655 | i0 | 42.5 | 1.792 | 106 | 60 | 84.0 | 1 | 359 | 45 | 294 | 399 | 672 | 94.4 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Zhejiang gunthers frog calicivirus 1 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Zhejiang gunthers frog calicivirus 1 | Viruses | Viruses | 94.4 | 1.47e-19 | ||||||||
| 9518 | 9518 | PRJNA1199330_CONTIG_35715|Zhejiang_gunthers_frog_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA1199330_CONTIG_35715|Zhejiang_gunthers_frog_calicivirus_1 | PRJNA1199330_CONTIG_35715 | Barramundi calicivirus 1 | 48 | 14 | 1 | CLUSTER1_Barramundi_calicivirus_1|53|15 | PRJNA738523_P_NODE_1_length_7247_cov_15.105241_g0_i0|Barramundi_calicivirus_1|NR|0|NA | 49 | 15 | PRJNA1199330 | 35715 | 346 | 2.758242 | 9.54351732 | Zhejiang gunthers frog calicivirus 1 | 2116158 | Viruses | Viruses | 132.0 | 6.31e-33 | Zhejiang gunthers frog calicivirus 1 | Non-phage | NR | PRJNA1199330_P_NODE_35715_length_346_cov_2.758242_g35016_i0 | AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] | AVM87226.1 | 2116158 | g35016 | i0 | 54.4 | 3.841040462 | 114 | 52 | 98.8 | 0 | 346 | 5 | 81 | 194 | 1329 | 132.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Zhejiang gunthers frog calicivirus 1 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Zhejiang gunthers frog calicivirus 1 | Viruses | Viruses | 132.0 | 6.31e-33 | ||||||||
| 9519 | 9519 | PRJNA1199330_CONTIG_36221|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA1199330_CONTIG_36221|Barramundi_calicivirus_1 | PRJNA1199330_CONTIG_36221 | Barramundi calicivirus 1 | 48 | 14 | 1 | CLUSTER1_Barramundi_calicivirus_1|53|15 | PRJNA738523_P_NODE_1_length_7247_cov_15.105241_g0_i0|Barramundi_calicivirus_1|NR|0|NA | 49 | 15 | PRJNA1199330 | 36221 | 344 | 1.151292 | 3.96044448 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 89.0 | 7.84e-18 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA1199330_P_NODE_36221_length_344_cov_1.151292_g35522_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g35522 | i0 | 38.7 | 0.968023256 | 111 | 67 | 95.9 | 1 | 12 | 341 | 210 | 320 | 333 | 89.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Barramundi calicivirus 1 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Barramundi calicivirus 1 | Viruses | Viruses | 89.0 | 7.84e-18 |
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);;