viruses_fish_associated_curated
3 rows where tax_family_NTorNR = "Parvoviridae" and tax_species_NTorNR = "Phoenicopteridae parvo-like hybrid virus"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10381 | 10381 | PRJNA784979_CONTIG_5641|Phoenicopteridae_parvo-like_hybrid_virus|CLUSTER1_Phoenicopteridae_parvo-like_hybrid_virus|1|1 | Phoenicopteridae parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA784979_CONTIG_5641|Phoenicopteridae_parvo-like_hybrid_virus | PRJNA784979_CONTIG_5641 | Phoenicopteridae parvo-like hybrid virus | 3 | 3 | 3 | CLUSTER1_Phoenicopteridae_parvo-like_hybrid_virus|1|1 | PRJNA784979_S_NODE_5641_length_206_cov_1.146497_g5599_i0|Phoenicopteridae_parvo-like_hybrid_virus|NR|1.69e-05|NA | 1 | 1 | PRJNA784979 | 5641 | 206 | 1.146497 | 2.36178382 | Phoenicopteridae parvo-like hybrid virus | 2794528 | Viruses | Viruses | 51.6 | 1.69e-05 | Phoenicopteridae parvo-like hybrid virus | Non-phage | NR | PRJNA784979_S_NODE_5641_length_206_cov_1.146497_g5599_i0 | QTE03745.1 MAG: hypothetical protein [Phoenicopteridae parvo-like hybrid virus] | QTE03745.1 | 2794528 | g5599 | i0 | 40.3 | 0.975728155 | 67 | 38 | 94.7 | 1 | 198 | 4 | 169 | 235 | 201 | 51.6 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Phoenicopteridae parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Phoenicopteridae parvo-like hybrid virus | Phoenicopteridae parvo-like hybrid virus | Viruses | Viruses | 51.6 | 1.69e-05 | ||||||||
| 10462 | 10462 | PRJEB29441_CONTIG_45230|Phoenicopteridae_parvo-like_hybrid_virus|CLUSTER2_Phoenicopteridae_parvo-like_hybrid_virus|1|1 | Phoenicopteridae parvo-like hybrid virus | Endogenous or not fish-associated | PRJEB29441_CONTIG_45230|Phoenicopteridae_parvo-like_hybrid_virus | PRJEB29441_CONTIG_45230 | Phoenicopteridae parvo-like hybrid virus | 3 | 3 | 3 | CLUSTER2_Phoenicopteridae_parvo-like_hybrid_virus|1|1 | PRJEB29441_P_NODE_45230_length_162_cov_1.353982_g44789_i0|Phoenicopteridae_parvo-like_hybrid_virus|NR|1.86e-11|NA | 1 | 1 | PRJEB29441 | 45230 | 162 | 1.353982 | 2.19345084 | Phoenicopteridae parvo-like hybrid virus | 2794528 | Viruses | Viruses | 67.8 | 1.86e-11 | Phoenicopteridae parvo-like hybrid virus | Non-phage | NR | PRJEB29441_P_NODE_45230_length_162_cov_1.353982_g44789_i0 | QTE03908.1 MAG: capsid protein [Phoenicopteridae parvo-like hybrid virus] | QTE03908.1 | 2794528 | g44789 | i0 | 58.5 | 2.962962963 | 53 | 22 | 98.1 | 0 | 4 | 162 | 12 | 64 | 480 | 67.8 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Phoenicopteridae parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Phoenicopteridae parvo-like hybrid virus | Phoenicopteridae parvo-like hybrid virus | Viruses | Viruses | 67.8 | 1.86e-11 | ||||||||
| 10476 | 10476 | PRJNA556992_CONTIG_72584|Phoenicopteridae_parvo-like_hybrid_virus|CLUSTER3_Phoenicopteridae_parvo-like_hybrid_virus|1|1 | Phoenicopteridae parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA556992_CONTIG_72584|Phoenicopteridae_parvo-like_hybrid_virus | PRJNA556992_CONTIG_72584 | Phoenicopteridae parvo-like hybrid virus | 3 | 3 | 3 | CLUSTER3_Phoenicopteridae_parvo-like_hybrid_virus|1|1 | PRJNA556992_P_NODE_72584_length_448_cov_4.661333_g70408_i0|Phoenicopteridae_parvo-like_hybrid_virus|NR|2.29e-08|NA | 1 | 1 | PRJNA556992 | 72584 | 448 | 4.661333 | 20.88277184 | Phoenicopteridae parvo-like hybrid virus | 2794528 | Viruses | Viruses | 63.2 | 2.29e-08 | Phoenicopteridae parvo-like hybrid virus | Non-phage | NR | PRJNA556992_P_NODE_72584_length_448_cov_4.661333_g70408_i0 | QTE03745.1 MAG: hypothetical protein [Phoenicopteridae parvo-like hybrid virus] | QTE03745.1 | 2794528 | g70408 | i0 | 32.9 | 0.9375 | 140 | 70 | 90.4 | 3 | 413 | 9 | 144 | 264 | 420 | 63.2 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Phoenicopteridae parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Phoenicopteridae parvo-like hybrid virus | Phoenicopteridae parvo-like hybrid virus | Viruses | Viruses | 63.2 | 2.29e-08 |
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);;