viruses_fish_associated_curated
5 rows where clusterLCA_curated = "Zebrafish gut calicivirus", tax_family_NTorNR = "Caliciviridae" and tax_species_NTorNR = "Zhejiang gunthers frog calicivirus 1"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9488 | 9488 | PRJNA534016_CONTIG_718|Zhejiang_gunthers_frog_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA534016_CONTIG_718|Zhejiang_gunthers_frog_calicivirus_1 | PRJNA534016_CONTIG_718 | 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 | PRJNA534016 | 718 | 968 | 2.803352 | 27.13644736 | Zhejiang gunthers frog calicivirus 1 | 2116158 | Viruses | Viruses | 260.0 | 1.81e-74 | Zhejiang gunthers frog calicivirus 1 | Non-phage | NR | PRJNA534016_P_NODE_718_length_968_cov_2.803352_g646_i0 | AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] | AVM87226.1 | 2116158 | g646 | i0 | 44.7 | 0.963842975 | 311 | 167 | 95.8 | 4 | 964 | 38 | 92 | 399 | 933 | 260.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 | 260.0 | 1.81e-74 | ||||||||
| 9495 | 9495 | PRJNA893346_CONTIG_10663|Zhejiang_gunthers_frog_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA893346_CONTIG_10663|Zhejiang_gunthers_frog_calicivirus_1 | PRJNA893346_CONTIG_10663 | 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 | PRJNA893346 | 10663 | 482 | 1.070905 | 5.1617621 | Zhejiang gunthers frog calicivirus 1 | 2116158 | Viruses | Viruses | 114.0 | 7.450000000000001e-26 | Zhejiang gunthers frog calicivirus 1 | Non-phage | NR | PRJNA893346_P_NODE_10663_length_482_cov_1.070905_g10179_i0 | AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] | AVM87226.1 | 2116158 | g10179 | i0 | 36.3 | 0.995850622 | 160 | 102 | 99.6 | 0 | 480 | 1 | 330 | 489 | 480 | 114.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 | 114.0 | 7.450000000000001e-26 | ||||||||
| 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 | ||||||||
| 9524 | 9524 | PRJNA599026_CONTIG_67814|Zhejiang_gunthers_frog_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA599026_CONTIG_67814|Zhejiang_gunthers_frog_calicivirus_1 | PRJNA599026_CONTIG_67814 | 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 | PRJNA599026 | 67814 | 162 | 0.902655 | 1.4623011 | Zhejiang gunthers frog calicivirus 1 | 2116158 | Viruses | Viruses | 56.6 | 1.55e-07 | Zhejiang gunthers frog calicivirus 1 | Non-phage | NR | PRJNA599026_S_NODE_67814_length_162_cov_0.902655_g67358_i0 | AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] | AVM87226.1 | 2116158 | g67358 | i0 | 55.1 | 0.907407407 | 49 | 21 | 90.7 | 1 | 152 | 6 | 267 | 314 | 147 | 56.6 | 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 | 56.6 | 1.55e-07 |
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);;