metadata: viruses_fish_associated_curated: 5 rows where bioproject = "PRJNA793147" and clusterLCA_curated = "Zebrafish influenza B-like virus"

5 rows where bioproject = "PRJNA793147" and clusterLCA_curated = "Zebrafish influenza B-like virus"

descending

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	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
9924	9924	PRJNA793147_CONTIG_13275\|Influenza_B_virus_(B/Taiwan/5\|CLUSTER1_Betainfluenzavirus_influenzae\|15\|8	Zebrafish influenza B-like virus	Novel	PRJNA793147_CONTIG_13275\|Influenza_B_virus_(B/Taiwan/5	PRJNA793147_CONTIG_13275	Betainfluenzavirus influenzae	80	13	8	CLUSTER1_Betainfluenzavirus_influenzae\|15\|8	PRJNA897077_P_NODE_539_length_1214_cov_128.316389_g477_i0\|Betainfluenzavirus\|NTclustered\|0\|NA	15	8	PRJNA793147	13275	469	2.98	13.9762	Influenza B virus (B/Taiwan/5	11520	Viruses	Viruses	127.0	1.3e-34	Influenza B virus (B/Taiwan/5	Non-phage	NR	PRJNA793147_P_NODE_13275_length_469_cov_2.980000_g13009_i0	ACB06477.1 BM2 protein [Influenza B virus (B/Taiwan/500/2005)]	ACB06477.1	491242	g13009	i0	50.0	2.059701493	106	53	67.8	0	407	90	4	109	966	127.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Betainfluenzavirus influenzae	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus		Influenza B virus (B/Taiwan/5			Viruses		Viruses		127.0		1.3e-34
9925	9925	PRJNA793147_CONTIG_14816\|Wuhan_spiny_eel_influenza_virus\|CLUSTER1_Wuhan_spiny_eel_influenza_virus\|15\|11	Zebrafish influenza B-like virus	Novel	PRJNA793147_CONTIG_14816\|Wuhan_spiny_eel_influenza_virus	PRJNA793147_CONTIG_14816	Wuhan spiny eel influenza virus	80	13	8	CLUSTER1_Wuhan_spiny_eel_influenza_virus\|15\|11	PRJNA345071_P_NODE_21_length_1869_cov_841.831292_g15_i0\|Wuhan_spiny_eel_influenza_virus\|NR\|2.51e-251\|NA	15	11	PRJNA793147	14816	441	1.932796	8.52363036	Wuhan spiny eel influenza virus	2116483	Viruses	Viruses	169.0	1.7399999999999998e-46	Wuhan spiny eel influenza virus	Non-phage	NR	PRJNA793147_P_NODE_14816_length_441_cov_1.932796_g14550_i0	AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus]	AVM87624.1	2116483	g14550	i0	63.4	0.911564626	134	49	91.2	0	439	38	435	568	402	169.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Wuhan spiny eel influenza virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus		Wuhan spiny eel influenza virus			Viruses		Viruses		169.0		1.7399999999999998e-46
9970	9970	PRJNA793147_CONTIG_25678\|Wuhan_spiny_eel_influenza_virus\|CLUSTER2_Wuhan_spiny_eel_influenza_virus\|14\|10	Zebrafish influenza B-like virus	Novel	PRJNA793147_CONTIG_25678\|Wuhan_spiny_eel_influenza_virus	PRJNA793147_CONTIG_25678	Wuhan spiny eel influenza virus	80	13	8	CLUSTER2_Wuhan_spiny_eel_influenza_virus\|14\|10	PRJEB2368_P_NODE_284_length_1571_cov_81.546284_g203_i0\|Wuhan_spiny_eel_influenza_virus\|NR\|1.26e-192\|NA	14	10	PRJNA793147	25678	329	1.107692	3.64430668	Wuhan spiny eel influenza virus	2116483	Viruses	Viruses	50.1	0.000259	Wuhan spiny eel influenza virus	Non-phage	NR	PRJNA793147_P_NODE_25678_length_329_cov_1.107692_g25412_i0	AVM87625.1 NA [Wuhan spiny eel influenza virus]	AVM87625.1	2116483	g25412	i0	47.4	0.88449848	97	46	83.9	3	277	2	1	97	291	50.1	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Wuhan spiny eel influenza virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus		Wuhan spiny eel influenza virus			Viruses		Viruses		50.1		0.000259
9971	9971	PRJNA793147_CONTIG_40044\|Wuhan_spiny_eel_influenza_virus\|CLUSTER2_Wuhan_spiny_eel_influenza_virus\|14\|10	Zebrafish influenza B-like virus	Novel	PRJNA793147_CONTIG_40044\|Wuhan_spiny_eel_influenza_virus	PRJNA793147_CONTIG_40044	Wuhan spiny eel influenza virus	80	13	8	CLUSTER2_Wuhan_spiny_eel_influenza_virus\|14\|10	PRJEB2368_P_NODE_284_length_1571_cov_81.546284_g203_i0\|Wuhan_spiny_eel_influenza_virus\|NR\|1.26e-192\|NA	14	10	PRJNA793147	40044	266	1.461929	3.88873114	Wuhan spiny eel influenza virus	2116483	Viruses	Viruses	132.0	1.37e-34	Wuhan spiny eel influenza virus	Non-phage	NR	PRJNA793147_P_NODE_40044_length_266_cov_1.461929_g39778_i0	7XVR_A Chain A, Neuraminidase [Wuhan spiny eel influenza virus]	7XVR_A	2116483	g39778	i0	70.5	1.984962406	88	26	99.2	0	266	3	300	387	528	132.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Wuhan spiny eel influenza virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus					Viruses		Viruses		132.0		1.37e-34
10034	10034	PRJNA793147_CONTIG_14675\|Betainfluenzavirus_influenzae\|CLUSTER3_Betainfluenzavirus_influenzae\|12\|7	Zebrafish influenza B-like virus	Novel	PRJNA793147_CONTIG_14675\|Betainfluenzavirus_influenzae	PRJNA793147_CONTIG_14675	Betainfluenzavirus influenzae	80	13	8	CLUSTER3_Betainfluenzavirus_influenzae\|12\|7	PRJEB2368_P_NODE_544_length_1151_cov_155.050269_g412_i0\|Betainfluenzavirus_influenzae\|NTclustered\|9.55e-147\|NA	12	7	PRJNA793147	14675	443	2.930481	12.98203083	Betainfluenzavirus influenzae	2955465	Viruses	Viruses	396.0	1.72e-105	Betainfluenzavirus influenzae	Non-phage	NTclustered	PRJNA793147_P_NODE_14675_length_443_cov_2.930481_g14409_i0	Influenza B virus (B/reassortant/NYMC BX-43(Lee/1940 x Hong Kong/259/2010)) nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds	gi\|384038769\|gb\|CY115203.1\|	1171657	g14409	i0	85.204	88.60496614	392	50	88.0	7	56	443	637	1024	39252	396.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Betainfluenzavirus influenzae	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Betainfluenzavirus;Zebrafish influenza B-like virus	Betainfluenzavirus influenzae	Influenza B virus (B/Lee/194	gi\|384038769\|gb\|CY115203.1\|	Viruses	Viruses	Viruses	Viruses	396.0	172.0	1.72e-105	1.6099999999999998e-52

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);;