viruses_fish_associated_curated
3 rows where bioproject = "PRJNA474911" and tax_species_NTorNR = "Wuhan sharpbelly 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2605 | 2605 | PRJNA474911_CONTIG_3527|Wuhan_sharpbelly_picornavirus_1|CLUSTER1_Zebrafish_picornavirus_2|1382|320 | Danio blood picornavirus/Zebrafish picornavirus 2 | Novel | PRJNA474911_CONTIG_3527|Wuhan_sharpbelly_picornavirus_1 | PRJNA474911_CONTIG_3527 | Zebrafish picornavirus 2 | 1369 | 320 | 1 | CLUSTER1_Zebrafish_picornavirus_2|1382|320 | PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0|Zebrafish_picornavirus_2|NR|0|NA | 1370 | 320 | PRJNA474911 | 3527 | 318 | 0.996109 | 3.16762662 | Wuhan sharpbelly picornavirus 1 | 2116200 | Viruses | Viruses | 121.0 | 1.9300000000000002e-29 | Wuhan sharpbelly picornavirus 1 | Non-phage | NR | PRJNA474911_P_NODE_3527_length_318_cov_0.996109_g3401_i0 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | AVM87439.1 | 2116200 | g3401 | i0 | 51.9 | 1.018867925 | 108 | 47 | 100.0 | 2 | 318 | 1 | 1461 | 1565 | 324 | 121.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Wuhan sharpbelly picornavirus 1 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2 | Wuhan sharpbelly picornavirus 1 | Viruses | Viruses | 121.0 | 1.9300000000000002e-29 | |||||||||
| 2635 | 2635 | PRJNA474911_CONTIG_4020|Wuhan_sharpbelly_picornavirus_1|CLUSTER1_Zebrafish_picornavirus_2|1382|320 | Danio blood picornavirus/Zebrafish picornavirus 2 | Novel | PRJNA474911_CONTIG_4020|Wuhan_sharpbelly_picornavirus_1 | PRJNA474911_CONTIG_4020 | Zebrafish picornavirus 2 | 1369 | 320 | 1 | CLUSTER1_Zebrafish_picornavirus_2|1382|320 | PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0|Zebrafish_picornavirus_2|NR|0|NA | 1370 | 320 | PRJNA474911 | 4020 | 293 | 1.103448 | 3.23310264 | Wuhan sharpbelly picornavirus 1 | 2116200 | Viruses | Viruses | 161.0 | 1.7100000000000001e-43 | Wuhan sharpbelly picornavirus 1 | Non-phage | NR | PRJNA474911_P_NODE_4020_length_293_cov_1.103448_g3893_i0 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | AVM87439.1 | 2116200 | g3893 | i0 | 80.2 | 1.976109215 | 96 | 19 | 98.3 | 0 | 2 | 289 | 1206 | 1301 | 579 | 161.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Wuhan sharpbelly picornavirus 1 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2 | Wuhan sharpbelly picornavirus 1 | Viruses | Viruses | 161.0 | 1.7100000000000001e-43 | |||||||||
| 2834 | 2834 | PRJNA474911_CONTIG_8512|Wuhan_sharpbelly_picornavirus_1|CLUSTER1_Zebrafish_picornavirus_2|1382|320 | Danio blood picornavirus/Zebrafish picornavirus 2 | Novel | PRJNA474911_CONTIG_8512|Wuhan_sharpbelly_picornavirus_1 | PRJNA474911_CONTIG_8512 | Zebrafish picornavirus 2 | 1369 | 320 | 1 | CLUSTER1_Zebrafish_picornavirus_2|1382|320 | PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0|Zebrafish_picornavirus_2|NR|0|NA | 1370 | 320 | PRJNA474911 | 8512 | 190 | 2.302326 | 4.3744194 | Wuhan sharpbelly picornavirus 1 | 2116200 | Viruses | Viruses | 52.4 | 7.23e-06 | Wuhan sharpbelly picornavirus 1 | Non-phage | NR | PRJNA474911_P_NODE_8512_length_190_cov_2.302326_g8385_i0 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | AVM87439.1 | 2116200 | g8385 | i0 | 27.8 | 1.815789474 | 115 | 28 | 94.7 | 1 | 3 | 182 | 730 | 844 | 345 | 52.4 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Wuhan sharpbelly picornavirus 1 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2 | Wuhan sharpbelly picornavirus 1 | Viruses | Viruses | 52.4 | 7.23e-06 |
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);;