viruses_fish_associated_curated
5 rows where bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9484 | 9484 | PRJNA534016_CONTIG_10|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA534016_CONTIG_10|Barramundi_calicivirus_1 | PRJNA534016_CONTIG_10 | 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 | 10 | 3983 | 5.904859 | 235.190534 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 976.0 | 0.0 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA534016_P_NODE_10_length_3983_cov_5.904859_g6_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g6 | i0 | 45.7 | 0.866934472 | 1151 | 592 | 85.5 | 15 | 8 | 3412 | 1070 | 2203 | 3453 | 976.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 | 976.0 | 0.0 | ||||||||
| 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 | ||||||||
| 9489 | 9489 | PRJNA534016_CONTIG_1062|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA534016_CONTIG_1062|Barramundi_calicivirus_1 | PRJNA534016_CONTIG_1062 | 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 | 1062 | 802 | 2.296296 | 18.41629392 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 143.0 | 1.24e-34 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA534016_P_NODE_1062_length_802_cov_2.296296_g985_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g985 | i0 | 31.3 | 1.122194514 | 300 | 158 | 96.1 | 10 | 24 | 794 | 739 | 1033 | 900 | 143.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 | 143.0 | 1.24e-34 | ||||||||
| 9490 | 9490 | PRJNA534016_CONTIG_1366|Fujian_spotted_paddle-tail_newt_calicivirus|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA534016_CONTIG_1366|Fujian_spotted_paddle-tail_newt_calicivirus | PRJNA534016_CONTIG_1366 | 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 | 1366 | 704 | 1.855784 | 13.06471936 | Fujian spotted paddle-tail newt calicivirus | 2116168 | Viruses | Viruses | 70.1 | 1.02e-09 | Fujian spotted paddle-tail newt calicivirus | Non-phage | NR | PRJNA534016_P_NODE_1366_length_704_cov_1.855784_g1282_i0 | AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus] | AVM87224.1 | 2116168 | g1282 | i0 | 33.3 | 0.613636364 | 144 | 83 | 57.1 | 5 | 1 | 402 | 43 | 183 | 432 | 70.1 | 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 | 70.1 | 1.02e-09 | ||||||||
| 9492 | 9492 | PRJNA534016_CONTIG_3088|Dongbei_arctic_lamprey_calicivirus_2|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA534016_CONTIG_3088|Dongbei_arctic_lamprey_calicivirus_2 | PRJNA534016_CONTIG_3088 | 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 | 3088 | 465 | 1.372449 | 6.38188785 | Dongbei arctic lamprey calicivirus 2 | 2116167 | Viruses | Viruses | 113.0 | 8.250000000000001e-26 | Dongbei arctic lamprey calicivirus 2 | Non-phage | NR | PRJNA534016_P_NODE_3088_length_465_cov_1.372449_g2998_i0 | AVM87212.1 polyprotein [Dongbei arctic lamprey calicivirus 2] | AVM87212.1 | 2116167 | g2998 | i0 | 36.8 | 2.941935484 | 152 | 96 | 98.1 | 0 | 5 | 460 | 351 | 502 | 1368 | 113.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Dongbei arctic lamprey calicivirus 2 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Caliciviridae;Zebrafish gut calicivirus | Dongbei arctic lamprey calicivirus 2 | Viruses | Viruses | 113.0 | 8.250000000000001e-26 |
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);;