metadata: viruses_fish_associated_curated: 14 rows where Category = "Novel" and tax_species_NTorNR = "Siamese algae-eater influenza-like virus"

14 rows where Category = "Novel" and tax_species_NTorNR = "Siamese algae-eater influenza-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_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
10184	10184	PRJNA690124_CONTIG_3829\|Siamese_algae-eater_influenza-like_virus\|CLUSTER1_Siamese_algae-eater_influenza-like_virus\|4\|3	Zebrafish influenza-like virus	Novel	PRJNA690124_CONTIG_3829\|Siamese_algae-eater_influenza-like_virus	PRJNA690124_CONTIG_3829	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER1_Siamese_algae-eater_influenza-like_virus\|4\|3	PRJNA690124_P_NODE_3829_length_802_cov_1.341564_g3518_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|2.39e-35\|NA	4	3	PRJNA690124	3829	802	1.341564	10.75934328	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	137.0	2.3900000000000002e-35	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA690124_P_NODE_3829_length_802_cov_1.341564_g3518_i0	QOE76807.1 matrix protein [Siamese algae-eater influenza-like virus]	QOE76807.1	2777035	g3518	i0	41.0	0.703241895	188	109	70.0	2	3	563	68	254	564	137.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		137.0		2.3900000000000002e-35
10187	10187	PRJNA509052_CONTIG_4848\|Siamese_algae-eater_influenza-like_virus\|CLUSTER1_Siamese_algae-eater_influenza-like_virus\|4\|3	Zebrafish influenza-like virus	Novel	PRJNA509052_CONTIG_4848\|Siamese_algae-eater_influenza-like_virus	PRJNA509052_CONTIG_4848	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER1_Siamese_algae-eater_influenza-like_virus\|4\|3	PRJNA690124_P_NODE_3829_length_802_cov_1.341564_g3518_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|2.39e-35\|NA	4	3	PRJNA509052	4848	304	1.796537	5.46147248	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	94.4	4.41e-21	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA509052_P_NODE_4848_length_304_cov_1.796537_g4784_i0	QOE76807.1 matrix protein [Siamese algae-eater influenza-like virus]	QOE76807.1	2777035	g4784	i0	49.5	2.911184211	99	49	96.7	1	295	2	32	130	885	94.4	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		94.4		4.41e-21
10191	10191	PRJNA893346_CONTIG_7675\|Siamese_algae-eater_influenza-like_virus\|CLUSTER1_Siamese_algae-eater_influenza-like_virus\|4\|3	Zebrafish influenza-like virus	Novel	PRJNA893346_CONTIG_7675\|Siamese_algae-eater_influenza-like_virus	PRJNA893346_CONTIG_7675	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER1_Siamese_algae-eater_influenza-like_virus\|4\|3	PRJNA690124_P_NODE_3829_length_802_cov_1.341564_g3518_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|2.39e-35\|NA	4	3	PRJNA893346	7675	576	1.337972	7.70671872	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	95.5	3.23e-20	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA893346_P_NODE_7675_length_576_cov_1.337972_g7199_i0	QOE76807.1 matrix protein [Siamese algae-eater influenza-like virus]	QOE76807.1	2777035	g7199	i0	39.2	0.677083333	130	78	67.7	1	8	397	126	254	390	95.5	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		95.5		3.23e-20
10199	10199	PRJNA893346_CONTIG_24399\|Siamese_algae-eater_influenza-like_virus\|CLUSTER1_Siamese_algae-eater_influenza-like_virus\|4\|3	Zebrafish influenza-like virus	Novel	PRJNA893346_CONTIG_24399\|Siamese_algae-eater_influenza-like_virus	PRJNA893346_CONTIG_24399	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER1_Siamese_algae-eater_influenza-like_virus\|4\|3	PRJNA690124_P_NODE_3829_length_802_cov_1.341564_g3518_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|2.39e-35\|NA	4	3	PRJNA893346	24399	309	0.915254	2.82813486	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	97.4	3e-22	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA893346_P_NODE_24399_length_309_cov_0.915254_g23909_i0	QOE76807.1 matrix protein [Siamese algae-eater influenza-like virus]	QOE76807.1	2777035	g23909	i0	48.0	0.990291262	102	52	98.1	1	5	307	4	105	306	97.4	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		97.4		3e-22
10263	10263	PRJNA690124_CONTIG_15411\|Siamese_algae-eater_influenza-like_virus\|CLUSTER2_Siamese_algae-eater_influenza-like_virus\|2\|2	Zebrafish influenza-like virus	Novel	PRJNA690124_CONTIG_15411\|Siamese_algae-eater_influenza-like_virus	PRJNA690124_CONTIG_15411	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER2_Siamese_algae-eater_influenza-like_virus\|2\|2	PRJNA690124_P_NODE_15411_length_411_cov_1.834320_g15045_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|5.91e-24\|NA	2	2	PRJNA690124	15411	411	1.83432	7.5390552	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	107.0	5.91e-24	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA690124_P_NODE_15411_length_411_cov_1.834320_g15045_i0	QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus]	QOE76804.1	2777035	g15045	i0	38.5	0.98540146	135	82	98.5	1	5	409	404	537	405	107.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		107.0		5.91e-24
10264	10264	PRJNA482207_CONTIG_16496\|Siamese_algae-eater_influenza-like_virus\|CLUSTER3_Siamese_algae-eater_influenza-like_virus\|2\|1	Zebrafish influenza-like virus	Novel	PRJNA482207_CONTIG_16496\|Siamese_algae-eater_influenza-like_virus	PRJNA482207_CONTIG_16496	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER3_Siamese_algae-eater_influenza-like_virus\|2\|1	MT926384_1_Siamese_algae_eater_influenza_like_virus_strain_SAEILV_fish_T1K_hemagglutinin_HA_gene_complete_cds	2	1	PRJNA482207	16496	272	1.40201	3.8134672	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	401.0	2.1500000000000002e-107	Siamese algae-eater influenza-like virus	Non-phage	NTclustered	PRJNA482207_P_NODE_16496_length_272_cov_1.402010_g16386_i0	Siamese algae-eater influenza-like virus strain SAEILV/fish-T1K hemagglutinin (HA) gene, complete cds	gi\|1912436624\|gb\|MT926384.1\|	2777035	g16386	i0	93.358	0.996323529	271	18	99.0	0	1	271	565	835	271	401.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus	Siamese algae-eater influenza-like virus	Siamese algae-eater influenza-like virus	gi\|1912436624\|gb\|MT926384.1\|	Viruses	Viruses	Viruses	Viruses	401.0	178.0	2.1500000000000002e-107	4.83e-51
10267	10267	PRJNA893346_CONTIG_30634\|Siamese_algae-eater_influenza-like_virus\|CLUSTER2_Siamese_algae-eater_influenza-like_virus\|2\|2	Zebrafish influenza-like virus	Novel	PRJNA893346_CONTIG_30634\|Siamese_algae-eater_influenza-like_virus	PRJNA893346_CONTIG_30634	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER2_Siamese_algae-eater_influenza-like_virus\|2\|2	PRJNA690124_P_NODE_15411_length_411_cov_1.834320_g15045_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|5.91e-24\|NA	2	2	PRJNA893346	30634	268	0.861538	2.30892184	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	73.2	9.78e-13	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA893346_P_NODE_30634_length_268_cov_0.861538_g30144_i0	QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus]	QOE76804.1	2777035	g30144	i0	37.9	0.973880597	87	54	97.4	0	264	4	438	524	261	73.2	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		73.2		9.78e-13
10271	10271	PRJNA690124_CONTIG_35319\|Siamese_algae-eater_influenza-like_virus\|CLUSTER4_Siamese_algae-eater_influenza-like_virus\|2\|2	Zebrafish influenza-like virus	Novel	PRJNA690124_CONTIG_35319\|Siamese_algae-eater_influenza-like_virus	PRJNA690124_CONTIG_35319	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER4_Siamese_algae-eater_influenza-like_virus\|2\|2	PRJNA690124_P_NODE_35319_length_280_cov_0.956522_g34953_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|4.83e-19\|NA	2	2	PRJNA690124	35319	280	0.956522	2.6782616	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	91.3	4.83e-19	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA690124_P_NODE_35319_length_280_cov_0.956522_g34953_i0	QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus]	QOE76804.1	2777035	g34953	i0	48.9	0.964285714	90	46	96.4	0	280	11	317	406	270	91.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		91.3		4.83e-19
10272	10272	PRJNA893346_CONTIG_37756\|Siamese_algae-eater_influenza-like_virus\|CLUSTER4_Siamese_algae-eater_influenza-like_virus\|2\|2	Zebrafish influenza-like virus	Novel	PRJNA893346_CONTIG_37756\|Siamese_algae-eater_influenza-like_virus	PRJNA893346_CONTIG_37756	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER4_Siamese_algae-eater_influenza-like_virus\|2\|2	PRJNA690124_P_NODE_35319_length_280_cov_0.956522_g34953_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|4.83e-19\|NA	2	2	PRJNA893346	37756	244	0.900585	2.1974274	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	76.6	4.15e-14	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA893346_P_NODE_37756_length_244_cov_0.900585_g37266_i0	QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus]	QOE76804.1	2777035	g37266	i0	45.6	0.971311475	79	43	97.1	0	242	6	315	393	237	76.6	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		76.6		4.15e-14
10418	10418	PRJNA690124_CONTIG_20269\|Siamese_algae-eater_influenza-like_virus\|CLUSTER5_Siamese_algae-eater_influenza-like_virus\|1\|1	Zebrafish influenza-like virus	Novel	PRJNA690124_CONTIG_20269\|Siamese_algae-eater_influenza-like_virus	PRJNA690124_CONTIG_20269	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER5_Siamese_algae-eater_influenza-like_virus\|1\|1	PRJNA690124_P_NODE_20269_length_361_cov_1.222222_g19903_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|9.69e-34\|NA	1	1	PRJNA690124	20269	361	1.222222	4.41222142	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	133.0	9.689999999999999e-34	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA690124_P_NODE_20269_length_361_cov_1.222222_g19903_i0	QOE76806.1 hemagglutinin [Siamese algae-eater influenza-like virus]	QOE76806.1	2777035	g19903	i0	58.5	1.022160665	123	44	99.7	3	361	2	275	393	369	133.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		133.0		9.689999999999999e-34
10426	10426	PRJNA893346_CONTIG_21480\|Siamese_algae-eater_influenza-like_virus\|CLUSTER6_Siamese_algae-eater_influenza-like_virus\|1\|1	Zebrafish influenza-like virus	Novel	PRJNA893346_CONTIG_21480\|Siamese_algae-eater_influenza-like_virus	PRJNA893346_CONTIG_21480	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER6_Siamese_algae-eater_influenza-like_virus\|1\|1	PRJNA893346_P_NODE_21480_length_332_cov_1.138996_g20991_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|5.85e-35\|NA	1	1	PRJNA893346	21480	332	1.138996	3.78146672	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	135.0	5.85e-35	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA893346_P_NODE_21480_length_332_cov_1.138996_g20991_i0	QOE76805.1 neuraminidase [Siamese algae-eater influenza-like virus]	QOE76805.1	2777035	g20991	i0	67.3	0.885542169	98	31	88.6	1	2	295	354	450	294	135.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		135.0		5.85e-35
10447	10447	PRJNA690124_CONTIG_34936\|Siamese_algae-eater_influenza-like_virus\|CLUSTER7_Siamese_algae-eater_influenza-like_virus\|1\|1	Zebrafish influenza-like virus	Novel	PRJNA690124_CONTIG_34936\|Siamese_algae-eater_influenza-like_virus	PRJNA690124_CONTIG_34936	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER7_Siamese_algae-eater_influenza-like_virus\|1\|1	PRJNA690124_P_NODE_34936_length_281_cov_1.495192_g34570_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|2e-14\|NA	1	1	PRJNA690124	34936	281	1.495192	4.20148952	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	78.2	2e-14	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA690124_P_NODE_34936_length_281_cov_1.495192_g34570_i0	QOE76806.1 hemagglutinin [Siamese algae-eater influenza-like virus]	QOE76806.1	2777035	g34570	i0	37.6	0.992882562	93	58	99.3	0	2	280	47	139	279	78.2	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		78.2		2e-14
10452	10452	PRJNA690124_CONTIG_37976\|Siamese_algae-eater_influenza-like_virus\|CLUSTER8_Siamese_algae-eater_influenza-like_virus\|1\|1	Zebrafish influenza-like virus	Novel	PRJNA690124_CONTIG_37976\|Siamese_algae-eater_influenza-like_virus	PRJNA690124_CONTIG_37976	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER8_Siamese_algae-eater_influenza-like_virus\|1\|1	PRJNA690124_P_NODE_37976_length_270_cov_1.187817_g37610_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|1.29e-14\|NA	1	1	PRJNA690124	37976	270	1.187817	3.2071059	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	78.6	1.29e-14	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA690124_P_NODE_37976_length_270_cov_1.187817_g37610_i0	QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus]	QOE76804.1	2777035	g37610	i0	55.9	0.755555556	68	30	75.6	0	249	46	55	122	204	78.6	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		78.6		1.29e-14
10456	10456	PRJNA893346_CONTIG_40207\|Siamese_algae-eater_influenza-like_virus\|CLUSTER9_Siamese_algae-eater_influenza-like_virus\|1\|1	Zebrafish influenza-like virus	Novel	PRJNA893346_CONTIG_40207\|Siamese_algae-eater_influenza-like_virus	PRJNA893346_CONTIG_40207	Siamese algae-eater influenza-like virus	14	4	9	CLUSTER9_Siamese_algae-eater_influenza-like_virus\|1\|1	PRJNA893346_P_NODE_40207_length_232_cov_2.157233_g39717_i0\|Siamese_algae-eater_influenza-like_virus\|NR\|1.1e-24\|NA	1	1	PRJNA893346	40207	232	2.157233	5.00478056	Siamese algae-eater influenza-like virus	2777035	Viruses	Viruses	105.0	1.0999999999999998e-24	Siamese algae-eater influenza-like virus	Non-phage	NR	PRJNA893346_P_NODE_40207_length_232_cov_2.157233_g39717_i0	QOE76805.1 neuraminidase [Siamese algae-eater influenza-like virus]	QOE76805.1	2777035	g39717	i0	62.3	0.995689655	77	29	99.6	0	231	1	200	276	231	105.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Siamese algae-eater influenza-like virus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Insthoviricetes;Articulavirales;Orthomyxoviridae;Zebrafish influenza-like virus		Siamese algae-eater influenza-like virus			Viruses		Viruses		105.0		1.0999999999999998e-24

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