viruses_fish_associated_curated
5 rows where bioproject = "PRJNA484127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9482 | 9482 | PRJNA484127_CONTIG_7|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA484127_CONTIG_7|Barramundi_calicivirus_1 | PRJNA484127_CONTIG_7 | 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 | PRJNA484127 | 7 | 5013 | 9.52996 | 477.7368948 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 1168.0 | 0.0 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA484127_P_NODE_7_length_5013_cov_9.529960_g6_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g6 | i0 | 41.6 | 0.935368043 | 1563 | 830 | 89.9 | 27 | 5004 | 496 | 664 | 2203 | 4689 | 1168.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 | 1168.0 | 0.0 | ||||||||
| 9486 | 9486 | PRJNA484127_CONTIG_412|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA484127_CONTIG_412|Barramundi_calicivirus_1 | PRJNA484127_CONTIG_412 | 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 | PRJNA484127 | 412 | 1418 | 5.441636 | 77.16239848 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 340.0 | 6.36e-100 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA484127_P_NODE_412_length_1418_cov_5.441636_g357_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g357 | i0 | 43.3 | 0.985895628 | 466 | 245 | 96.9 | 11 | 1376 | 3 | 199 | 653 | 1398 | 340.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 | 340.0 | 6.36e-100 | ||||||||
| 9508 | 9508 | PRJNA484127_CONTIG_21642|Barramundi_calicivirus_1|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA484127_CONTIG_21642|Barramundi_calicivirus_1 | PRJNA484127_CONTIG_21642 | 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 | PRJNA484127 | 21642 | 286 | 1.403756 | 4.01474216 | Barramundi calicivirus 1 | 3162777 | Viruses | Viruses | 84.0 | 2.14e-16 | Barramundi calicivirus 1 | Non-phage | NR | PRJNA484127_P_NODE_21642_length_286_cov_1.403756_g21493_i0 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | XBS25272.1 | 3162777 | g21493 | i0 | 46.3 | 0.996503497 | 95 | 50 | 99.7 | 1 | 286 | 2 | 1827 | 1920 | 285 | 84.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 | 84.0 | 2.14e-16 | ||||||||
| 9511 | 9511 | PRJNA484127_CONTIG_24235|Dongbei_arctic_lamprey_calicivirus_2|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA484127_CONTIG_24235|Dongbei_arctic_lamprey_calicivirus_2 | PRJNA484127_CONTIG_24235 | 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 | PRJNA484127 | 24235 | 274 | 1.164179 | 3.18985046 | Dongbei arctic lamprey calicivirus 2 | 2116167 | Viruses | Viruses | 82.8 | 4.64e-16 | Dongbei arctic lamprey calicivirus 2 | Non-phage | NR | PRJNA484127_P_NODE_24235_length_274_cov_1.164179_g24086_i0 | AVM87212.1 polyprotein [Dongbei arctic lamprey calicivirus 2] | AVM87212.1 | 2116167 | g24086 | i0 | 52.3 | 0.941605839 | 86 | 39 | 94.2 | 2 | 261 | 4 | 688 | 771 | 258 | 82.8 | 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 | 82.8 | 4.64e-16 | ||||||||
| 9522 | 9522 | PRJNA484127_CONTIG_39772|Fujian_spotted_paddle-tail_newt_calicivirus|CLUSTER1_Barramundi_calicivirus_1|53|15 | Zebrafish gut calicivirus | Novel | PRJNA484127_CONTIG_39772|Fujian_spotted_paddle-tail_newt_calicivirus | PRJNA484127_CONTIG_39772 | 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 | PRJNA484127 | 39772 | 234 | 4.279503 | 10.01403702 | Fujian spotted paddle-tail newt calicivirus | 2116168 | Viruses | Viruses | 42.4 | 0.0465 | Fujian spotted paddle-tail newt calicivirus | Non-phage | NR | PRJNA484127_P_NODE_39772_length_234_cov_4.279503_g39623_i0 | AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus] | AVM87224.1 | 2116168 | g39623 | i0 | 37.8 | 0.948717949 | 74 | 39 | 89.7 | 4 | 211 | 2 | 34 | 104 | 222 | 42.4 | 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 | 42.4 | 0.0465 |
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);;