viruses_fish_associated_curated
3 rows where bioproject = "PRJNA982106" and clusterLCA_curated = "Zebrafish picornavirus 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3842 | 3842 | PRJNA982106_CONTIG_6661|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 | Zebrafish picornavirus 1 | Known | PRJNA982106_CONTIG_6661|Cyprivirus_A | PRJNA982106_CONTIG_6661 | 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 | PRJNA982106 | 6661 | 372 | 1.334448 | 4.96414656 | Cyprivirus A | 2304617 | Viruses | Viruses | 568.0 | 2.8400000000000003e-157 | Cyprivirus A | Non-phage | NTclustered | PRJNA982106_P_NODE_6661_length_372_cov_1.334448_g6421_i0 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | gi|1990739381|tpg|BK011179.1| | 2563826 | g6421 | i0 | 94.324 | 2.994623656 | 370 | 21 | 99.0 | 0 | 1 | 370 | 2651 | 3020 | 1114 | 568.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 | 568.0 | 234.0 | 2.8400000000000003e-157 | 1.33e-68 | ||
| 3949 | 3949 | PRJNA982106_CONTIG_10242|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 | Zebrafish picornavirus 1 | Known | PRJNA982106_CONTIG_10242|Cyprivirus_A | PRJNA982106_CONTIG_10242 | 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 | PRJNA982106 | 10242 | 324 | 1.521912 | 4.93099488 | Cyprivirus A | 2304617 | Viruses | Viruses | 549.0 | 8.849999999999999e-152 | Cyprivirus A | Non-phage | NTclustered | PRJNA982106_P_NODE_10242_length_324_cov_1.521912_g10002_i0 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | gi|2500378199|ref|NC_076245.1| | 2563826 | g10002 | i0 | 97.222 | 3.0 | 324 | 9 | 100.0 | 0 | 1 | 324 | 7073 | 6750 | 972 | 549.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 | 549.0 | 216.0 | 8.849999999999999e-152 | 1.03e-62 | ||
| 4045 | 4045 | PRJNA982106_CONTIG_14105|Cyprivirus_A|CLUSTER1_Cyprivirus_A|1164|220 | Zebrafish picornavirus 1 | Known | PRJNA982106_CONTIG_14105|Cyprivirus_A | PRJNA982106_CONTIG_14105 | 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 | PRJNA982106 | 14105 | 290 | 1.410138 | 4.0894002 | Cyprivirus A | 2304617 | Viruses | Viruses | 492.0 | 1.3399999999999998e-134 | Cyprivirus A | Non-phage | NTclustered | PRJNA982106_P_NODE_14105_length_290_cov_1.410138_g13865_i0 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | gi|2500378199|ref|NC_076245.1| | 2563826 | g13865 | i0 | 97.561 | 2.95862069 | 287 | 7 | 99.0 | 0 | 4 | 290 | 2576 | 2290 | 858 | 492.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 | 492.0 | 197.0 | 1.3399999999999998e-134 | 2.57e-56 |
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);;