viruses_fish_associated_curated
10 rows where bioproject = "PRJNA595113" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9493 | 9493 | PRJNA595113_CONTIG_3972|Salovirus_sp.|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_3972|Salovirus_sp. | PRJNA595113_CONTIG_3972 | 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 | PRJNA595113 | 3972 | 329 | 2.185714 | 7.19099906 | Salovirus sp. | 2809835 | Viruses | Viruses | 60.5 | 6.42e-08 | Salovirus sp. | Non-phage | NR | PRJNA595113_S_NODE_3972_length_329_cov_2.185714_g3825_i0 | WRW35011.1 polyprotein [Salovirus sp.] | WRW35011.1 | 2809835 | g3825 | i0 | 45.8 | 1.541033435 | 72 | 39 | 65.7 | 0 | 1 | 216 | 2083 | 2154 | 507 | 60.5 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Salovirus | Salovirus sp. | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Salovirus sp. | Viruses | Viruses | 60.5 | 6.42e-08 | |||||||
| 9494 | 9494 | PRJNA595113_CONTIG_7347|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_7347|Barramundi_calicivirus_1 | PRJNA595113_CONTIG_7347 | 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 | PRJNA595113 | 7347 | 255 | 1.237864 | 3.1565532 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 104.0 | 9.74e-24 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA595113_S_NODE_7347_length_255_cov_1.237864_g7200_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g7200 | i0 | 52.9 | 1.905882353 | 85 | 40 | 100.0 | 0 | 1 | 255 | 1440 | 1524 | 486 | 104.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 | 104.0 | 9.74e-24 | ||||||||
| 9496 | 9496 | PRJNA595113_CONTIG_10787|Ameiurus_nebulosus_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_10787|Ameiurus_nebulosus_calicivirus_1 | PRJNA595113_CONTIG_10787 | 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 | PRJNA595113 | 10787 | 219 | 1.441176 | 3.15617544 | Ameiurus nebulosus calicivirus 1 | 2894560 | Viruses | Viruses | 58.5 | 7.36e-08 | Ameiurus nebulosus calicivirus 1 | Non-phage | NR | PRJNA595113_S_NODE_10787_length_219_cov_1.441176_g10640_i0 | UFQ21768.1 polyprotein [Ameiurus nebulosus calicivirus 1] | UFQ21768.1 | 2894560 | g10640 | i0 | 56.5 | 0.630136986 | 46 | 20 | 63.0 | 0 | 8 | 145 | 975 | 1020 | 138 | 58.5 | 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 | 58.5 | 7.36e-08 | ||||||||
| 9497 | 9497 | PRJNA595113_CONTIG_11891|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_11891|Barramundi_calicivirus_1 | PRJNA595113_CONTIG_11891 | 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 | PRJNA595113 | 11891 | 211 | 1.283951 | 2.70913661 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 60.1 | 1.86e-08 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA595113_S_NODE_11891_length_211_cov_1.283951_g11744_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g11744 | i0 | 44.1 | 0.966824645 | 68 | 33 | 96.7 | 1 | 206 | 3 | 1064 | 1126 | 204 | 60.1 | 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 | 60.1 | 1.86e-08 | ||||||||
| 9499 | 9499 | PRJNA595113_CONTIG_15729|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_15729|Barramundi_calicivirus_1 | PRJNA595113_CONTIG_15729 | 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 | PRJNA595113 | 15729 | 190 | 1.085106 | 2.0617014 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 91.3 | 1.45e-19 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA595113_S_NODE_15729_length_190_cov_1.085106_g15582_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g15582 | i0 | 66.1 | 0.978947368 | 62 | 21 | 97.9 | 0 | 3 | 188 | 1298 | 1359 | 186 | 91.3 | 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 | 91.3 | 1.45e-19 | ||||||||
| 9502 | 9502 | PRJNA595113_CONTIG_17837|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_17837|Barramundi_calicivirus_1 | PRJNA595113_CONTIG_17837 | 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 | PRJNA595113 | 17837 | 181 | 1.545455 | 2.79727355 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 73.2 | 2.94e-13 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA595113_S_NODE_17837_length_181_cov_1.545455_g17690_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g17690 | i0 | 64.7 | 0.845303867 | 51 | 18 | 84.5 | 0 | 179 | 27 | 448 | 498 | 153 | 73.2 | 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 | 73.2 | 2.94e-13 | ||||||||
| 9503 | 9503 | PRJNA595113_CONTIG_19243|Longfin_eel_calicivirus|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_19243|Longfin_eel_calicivirus | PRJNA595113_CONTIG_19243 | 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 | PRJNA595113 | 19243 | 176 | 1.204724 | 2.12031424 | Longfin eel calicivirus | 3108886 | Viruses | Viruses | 58.2 | 5.49e-08 | Longfin eel calicivirus | Non-phage | NR | PRJNA595113_S_NODE_19243_length_176_cov_1.204724_g19096_i0 | WQH26042.1 MAG: polyprotein, partial [Longfin eel calicivirus] | WQH26042.1 | 3108886 | g19096 | i0 | 50.8 | 2.948863636 | 59 | 27 | 97.2 | 1 | 175 | 5 | 225 | 283 | 519 | 58.2 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Longfin eel calicivirus | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Longfin eel calicivirus | Viruses | Viruses | 58.2 | 5.49e-08 | ||||||||
| 9506 | 9506 | PRJNA595113_CONTIG_20931|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_20931|Barramundi_calicivirus_1 | PRJNA595113_CONTIG_20931 | 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 | PRJNA595113 | 20931 | 170 | 2.165289 | 3.6809913 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 57.8 | 6.94e-08 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA595113_S_NODE_20931_length_170_cov_2.165289_g20784_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g20784 | i0 | 50.9 | 0.935294118 | 53 | 25 | 93.5 | 1 | 3 | 161 | 1838 | 1889 | 159 | 57.8 | 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 | 57.8 | 6.94e-08 | ||||||||
| 9507 | 9507 | PRJNA595113_CONTIG_20975|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_20975|Barramundi_calicivirus_1 | PRJNA595113_CONTIG_20975 | 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 | PRJNA595113 | 20975 | 170 | 1.68595 | 2.866115 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 52.0 | 7.62e-06 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA595113_S_NODE_20975_length_170_cov_1.685950_g20828_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g20828 | i0 | 57.5 | 1.323529412 | 40 | 17 | 70.6 | 0 | 49 | 168 | 1394 | 1433 | 225 | 52.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 | 52.0 | 7.62e-06 | ||||||||
| 9509 | 9509 | PRJNA595113_CONTIG_22286|Beihai_conger_calicivirus|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA595113_CONTIG_22286|Beihai_conger_calicivirus | PRJNA595113_CONTIG_22286 | 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 | PRJNA595113 | 22286 | 167 | 0.864407 | 1.44355969 | Beihai conger calicivirus | 2116161 | Viruses | Viruses | 47.4 | 0.000314 | Beihai conger calicivirus | Non-phage | NR | PRJNA595113_S_NODE_22286_length_167_cov_0.864407_g22139_i0 | AVM87195.1 polyprotein [Beihai conger calicivirus] | AVM87195.1 | 2116161 | g22139 | i0 | 50.9 | 0.988023952 | 55 | 24 | 97.0 | 2 | 4 | 165 | 1078 | 1130 | 165 | 47.4 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Beihai conger calicivirus | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Beihai conger calicivirus | Viruses | Viruses | 47.4 | 0.000314 |
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);;