metadata: viruses_fish_associated_curated: 25 rows where Category = "Endogenous or not fish-associated" and tax_species

25 rows where Category = "Endogenous or not fish-associated" and tax_species_NTorNR = "Sea turtle neural virus 1"

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	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
8955	8955	PRJNA780940_CONTIG_793\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA780940_CONTIG_793\|Sea_turtle_neural_virus_1	PRJNA780940_CONTIG_793	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA780940	793	394	0.934579	3.68224126	Sea turtle neural virus 1	3112944	Viruses	Viruses	52.0	0.000105	Sea turtle neural virus 1	Non-phage	NR	PRJNA780940_S_NODE_793_length_394_cov_0.934579_g775_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g775	i0	52.4	0.319796954	42	20	32.0	389	264	456	497	126	52.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		52.0		0.000105
8967	8967	PRJNA474826_CONTIG_2052\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA474826_CONTIG_2052\|Sea_turtle_neural_virus_1	PRJNA474826_CONTIG_2052	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA474826	2052	339	1.830935	6.20686965	Sea turtle neural virus 1	3112944	Viruses	Viruses	47.8	0.00185	Sea turtle neural virus 1	Non-phage	NR	PRJNA474826_P_NODE_2052_length_339_cov_1.830935_g1917_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g1917	i0	58.8	0.300884956	34	14	30.1	332	231	464	497	102	47.8	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		47.8		0.00185
8968	8968	PRJNA723280_CONTIG_2108\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA723280_CONTIG_2108\|Sea_turtle_neural_virus_1	PRJNA723280_CONTIG_2108	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA723280	2108	218	3.420118	7.45585724	Sea turtle neural virus 1	3112944	Viruses	Viruses	50.4	5.06e-05	Sea turtle neural virus 1	Non-phage	NR	PRJNA723280_S_NODE_2108_length_218_cov_3.420118_g2088_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g2088	i0	52.5	0.550458716	40	19	55.0	5	124	458	497	120	50.4	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		50.4		5.06e-05
8970	8970	PRJNA588297_CONTIG_2408\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA588297_CONTIG_2408\|Sea_turtle_neural_virus_1	PRJNA588297_CONTIG_2408	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA588297	2408	306	1.326531	4.05918486	Sea turtle neural virus 1	3112944	Viruses	Viruses	44.3	0.0214	Sea turtle neural virus 1	Non-phage	NR	PRJNA588297_P_NODE_2408_length_306_cov_1.326531_g2349_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g2349	i0	59.4	0.31372549	32	13	31.4	304	209	466	497	96	44.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		44.3		0.0214
8973	8973	PRJNA1132896_CONTIG_2530\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA1132896_CONTIG_2530\|Sea_turtle_neural_virus_1	PRJNA1132896_CONTIG_2530	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA1132896	2530	346	1.380952	4.77809392	Sea turtle neural virus 1	3112944	Viruses	Viruses	49.3	0.000569	Sea turtle neural virus 1	Non-phage	NR	PRJNA1132896_P_NODE_2530_length_346_cov_1.380952_g2439_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g2439	i0	48.9	0.39017341	45	23	39.0	21	155	453	497	135	49.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		49.3		0.000569
8985	8985	PRJNA658591_CONTIG_3638\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA658591_CONTIG_3638\|Sea_turtle_neural_virus_1	PRJNA658591_CONTIG_3638	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA658591	3638	234	3.367568	7.88010912	Sea turtle neural virus 1	3112944	Viruses	Viruses	51.2	3.29e-05	Sea turtle neural virus 1	Non-phage	NR	PRJNA658591_S_NODE_3638_length_234_cov_3.367568_g3575_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g3575	i0	52.4	1.153846154	42	20	53.8	17	142	456	497	270	51.6	0.992248062	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		51.2		3.29e-05
8987	8987	PRJNA592212_CONTIG_4261\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA592212_CONTIG_4261\|Sea_turtle_neural_virus_1	PRJNA592212_CONTIG_4261	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA592212	4261	169	1.742424	2.94469656	Sea turtle neural virus 1	3112944	Viruses	Viruses	51.2	1.34e-05	Sea turtle neural virus 1	Non-phage	NR	PRJNA592212_S_NODE_4261_length_169_cov_1.742424_g4199_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g4199	i0	52.4	1.562130178	42	20	74.6	12	137	456	497	264	51.2	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		51.2		1.34e-05
8991	8991	PRJNA414225_CONTIG_4909\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA414225_CONTIG_4909\|Sea_turtle_neural_virus_1	PRJNA414225_CONTIG_4909	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA414225	4909	244	1.046154	2.55261576	Sea turtle neural virus 1	3112944	Viruses	Viruses	47.8	0.000641	Sea turtle neural virus 1	Non-phage	NR	PRJNA414225_P_NODE_4909_length_244_cov_1.046154_g4822_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g4822	i0	58.8	0.418032787	34	14	41.8	235	134	464	497	102	47.8	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		47.8		0.000641
9000	9000	PRJNA1047750_CONTIG_6248\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA1047750_CONTIG_6248\|Sea_turtle_neural_virus_1	PRJNA1047750_CONTIG_6248	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA1047750	6248	339	3.278195	11.11308105	Sea turtle neural virus 1	3112944	Viruses	Viruses	49.7	0.000391	Sea turtle neural virus 1	Non-phage	NR	PRJNA1047750_P_NODE_6248_length_339_cov_3.278195_g6044_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g6044	i0	52.5	0.353982301	40	19	35.4	335	216	458	497	120	49.7	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		49.7		0.000391
9003	9003	PRJNA883229_CONTIG_6467\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA883229_CONTIG_6467\|Sea_turtle_neural_virus_1	PRJNA883229_CONTIG_6467	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA883229	6467	282	1.277512	3.60258384	Sea turtle neural virus 1	3112944	Viruses	Viruses	43.1	0.0434	Sea turtle neural virus 1	Non-phage	NR	PRJNA883229_P_NODE_6467_length_282_cov_1.277512_g6421_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g6421	i0	60.0	0.319148936	30	12	31.9	282	193	468	497	90	43.1	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		43.1		0.0434
9008	9008	PRJNA706197_CONTIG_6824\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA706197_CONTIG_6824\|Sea_turtle_neural_virus_1	PRJNA706197_CONTIG_6824	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA706197	6824	220	1.435028	3.1570616	Sea turtle neural virus 1	3112944	Viruses	Viruses	52.0	1.51e-05	Sea turtle neural virus 1	Non-phage	NR	PRJNA706197_S_NODE_6824_length_220_cov_1.435028_g6810_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g6810	i0	52.4	0.572727273	42	20	57.3	2	127	456	497	126	52.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		52.0		1.51e-05
9018	9018	PRJNA898346_CONTIG_9123\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA898346_CONTIG_9123\|Sea_turtle_neural_virus_1	PRJNA898346_CONTIG_9123	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA898346	9123	159	2.151786	3.42133974	Sea turtle neural virus 1	3112944	Viruses	Viruses	41.2	0.0415	Sea turtle neural virus 1	Non-phage	NR	PRJNA898346_S_NODE_9123_length_159_cov_2.151786_g9020_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g9020	i0	66.7	1.0	27	9	50.9	6	86	471	497	159	41.6	0.990384615	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		41.2		0.0415
9041	9041	PRJNA701156_CONTIG_21125\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA701156_CONTIG_21125\|Sea_turtle_neural_virus_1	PRJNA701156_CONTIG_21125	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA701156	21125	246	0.890173	2.18982558	Sea turtle neural virus 1	3112944	Viruses	Viruses	50.1	9.8e-05	Sea turtle neural virus 1	Non-phage	NR	PRJNA701156_P_NODE_21125_length_246_cov_0.890173_g20983_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g20983	i0	53.8	0.475609756	39	18	47.6	3	119	459	497	117	50.1	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		50.1		9.8e-05
9049	9049	PRJNA515078_CONTIG_25660\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA515078_CONTIG_25660\|Sea_turtle_neural_virus_1	PRJNA515078_CONTIG_25660	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA515078	25660	172	0.851852	1.46518544	Sea turtle neural virus 1	3112944	Viruses	Viruses	51.2	1.46e-05	Sea turtle neural virus 1	Non-phage	NR	PRJNA515078_P_NODE_25660_length_172_cov_0.851852_g25427_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g25427	i0	52.4	1.534883721	42	20	73.3	162	37	456	497	264	51.2	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		51.2		1.46e-05
9057	9057	PRJNA879067_CONTIG_48881\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA879067_CONTIG_48881\|Sea_turtle_neural_virus_1	PRJNA879067_CONTIG_48881	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA879067	48881	534	4.288503	22.90060602	Sea turtle neural virus 1	3112944	Viruses	Viruses	47.8	0.00982	Sea turtle neural virus 1	Non-phage	NR	PRJNA879067_P_NODE_48881_length_534_cov_4.288503_g45402_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g45402	i0	58.8	0.191011236	34	14	19.1	501	400	464	497	102	47.8	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		47.8		0.00982
9058	9058	PRJNA924320_CONTIG_49188\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA924320_CONTIG_49188\|Sea_turtle_neural_virus_1	PRJNA924320_CONTIG_49188	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA924320	49188	165	1.698276	2.8021554	Sea turtle neural virus 1	3112944	Viruses	Viruses	47.8	0.000226	Sea turtle neural virus 1	Non-phage	NR	PRJNA924320_S_NODE_49188_length_165_cov_1.698276_g49046_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g49046	i0	58.8	0.618181818	34	14	61.8	159	58	464	497	102	47.8	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		47.8		0.000226
9061	9061	PRJNA600413_CONTIG_54673\|Sea_turtle_neural_virus_1\|CLUSTER1_Chuvivirus\|75\|72	Chuvivirus	Endogenous or not fish-associated	PRJNA600413_CONTIG_54673\|Sea_turtle_neural_virus_1	PRJNA600413_CONTIG_54673	Chuvivirus	116	110	4	CLUSTER1_Chuvivirus\|75\|72	PRJNA154389_P_NODE_886_length_652_cov_2.029268_g749_i0\|Chuvivirus\|NR\|1.57e-31\|NA	75	72	PRJNA600413	54673	202	1.0	2.02	Sea turtle neural virus 1	3112944	Viruses	Viruses	50.4	3.98e-05	Sea turtle neural virus 1	Non-phage	NR	PRJNA600413_P_NODE_54673_length_202_cov_1.000000_g53972_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g53972	i0	52.5	0.594059406	40	19	59.4	200	81	458	497	120	50.4	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus		Sea turtle neural virus 1			Viruses		Viruses		50.4		3.98e-05
10119	10119	PRJNA896643_CONTIG_2945\|Sea_turtle_neural_virus_1\|CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	Sea turtle neural virus 1	Endogenous or not fish-associated	PRJNA896643_CONTIG_2945\|Sea_turtle_neural_virus_1	PRJNA896643_CONTIG_2945	Sea turtle neural virus 1	8	8	2	CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0\|Sea_turtle_neural_virus_1\|NR\|0.0109\|NA	7	7	PRJNA896643	2945	267	2.778261	7.41795687	Sea turtle neural virus 1	3112944	Viruses	Viruses	44.3	0.0138	Sea turtle neural virus 1	Non-phage	NR	PRJNA896643_S_NODE_2945_length_267_cov_2.778261_g2875_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g2875	i0	59.4	0.359550562	32	13	36.0	2	97	466	497	96	44.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus;Sea turtle neural virus 1		Sea turtle neural virus 1			Viruses		Viruses		44.3		0.0138
10124	10124	PRJNA896758_CONTIG_5144\|Sea_turtle_neural_virus_1\|CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	Sea turtle neural virus 1	Endogenous or not fish-associated	PRJNA896758_CONTIG_5144\|Sea_turtle_neural_virus_1	PRJNA896758_CONTIG_5144	Sea turtle neural virus 1	8	8	2	CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0\|Sea_turtle_neural_virus_1\|NR\|0.0109\|NA	7	7	PRJNA896758	5144	501	1.724299	8.63873799	Sea turtle neural virus 1	3112944	Viruses	Viruses	49.7	0.00171	Sea turtle neural virus 1	Non-phage	NR	PRJNA896758_P_NODE_5144_length_501_cov_1.724299_g4756_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g4756	i0	52.4	0.251497006	42	20	25.1	501	376	456	497	126	49.7	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus;Sea turtle neural virus 1		Sea turtle neural virus 1			Viruses		Viruses		49.7		0.00171
10128	10128	PRJNA785164_CONTIG_8090\|Sea_turtle_neural_virus_1\|CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	Sea turtle neural virus 1	Endogenous or not fish-associated	PRJNA785164_CONTIG_8090\|Sea_turtle_neural_virus_1	PRJNA785164_CONTIG_8090	Sea turtle neural virus 1	8	8	2	CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0\|Sea_turtle_neural_virus_1\|NR\|0.0109\|NA	7	7	PRJNA785164	8090	802	3.625514	29.07662228	Sea turtle neural virus 1	3112944	Viruses	Viruses	49.3	0.0109	Sea turtle neural virus 1	Non-phage	NR	PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g7675	i0	52.5	0.149625935	40	19	15.0	800	681	458	497	120	49.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus;Sea turtle neural virus 1		Sea turtle neural virus 1			Viruses		Viruses		49.3		0.0109
10129	10129	PRJNA611476_CONTIG_8301\|Sea_turtle_neural_virus_1\|CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	Sea turtle neural virus 1	Endogenous or not fish-associated	PRJNA611476_CONTIG_8301\|Sea_turtle_neural_virus_1	PRJNA611476_CONTIG_8301	Sea turtle neural virus 1	8	8	2	CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0\|Sea_turtle_neural_virus_1\|NR\|0.0109\|NA	7	7	PRJNA611476	8301	673	2.145	14.43585	Sea turtle neural virus 1	3112944	Viruses	Viruses	49.3	0.0065	Sea turtle neural virus 1	Non-phage	NR	PRJNA611476_P_NODE_8301_length_673_cov_2.145000_g7527_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g7527	i0	52.5	0.178306092	40	19	17.8	673	554	458	497	120	49.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus;Sea turtle neural virus 1		Sea turtle neural virus 1			Viruses		Viruses		49.3		0.0065
10137	10137	PRJNA1188114_CONTIG_19010\|Sea_turtle_neural_virus_1\|CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	Sea turtle neural virus 1	Endogenous or not fish-associated	PRJNA1188114_CONTIG_19010\|Sea_turtle_neural_virus_1	PRJNA1188114_CONTIG_19010	Sea turtle neural virus 1	8	8	2	CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0\|Sea_turtle_neural_virus_1\|NR\|0.0109\|NA	7	7	PRJNA1188114	19010	161	1.589286	2.55875046	Sea turtle neural virus 1	3112944	Viruses	Viruses	48.5	0.000111	Sea turtle neural virus 1	Non-phage	NR	PRJNA1188114_P_NODE_19010_length_161_cov_1.589286_g18958_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g18958	i0	52.5	0.745341615	40	19	74.5	2	121	458	497	120	48.5	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus;Sea turtle neural virus 1		Sea turtle neural virus 1			Viruses		Viruses		48.5		0.000111
10145	10145	PRJNA715463_CONTIG_36045\|Sea_turtle_neural_virus_1\|CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	Sea turtle neural virus 1	Endogenous or not fish-associated	PRJNA715463_CONTIG_36045\|Sea_turtle_neural_virus_1	PRJNA715463_CONTIG_36045	Sea turtle neural virus 1	8	8	2	CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0\|Sea_turtle_neural_virus_1\|NR\|0.0109\|NA	7	7	PRJNA715463	36045	241	1.761905	4.24619105	Sea turtle neural virus 1	3112944	Viruses	Viruses	42.4	0.0478	Sea turtle neural virus 1	Non-phage	NR	PRJNA715463_P_NODE_36045_length_241_cov_1.761905_g35912_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g35912	i0	59.4	0.398340249	32	13	39.8	3	98	466	497	96	42.4	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus;Sea turtle neural virus 1		Sea turtle neural virus 1			Viruses		Viruses		42.4		0.0478
10150	10150	PRJNA1126198_CONTIG_458584\|Sea_turtle_neural_virus_1\|CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	Sea turtle neural virus 1	Endogenous or not fish-associated	PRJNA1126198_CONTIG_458584\|Sea_turtle_neural_virus_1	PRJNA1126198_CONTIG_458584	Sea turtle neural virus 1	8	8	2	CLUSTER1_Sea_turtle_neural_virus_1\|7\|7	PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0\|Sea_turtle_neural_virus_1\|NR\|0.0109\|NA	7	7	PRJNA1126198	458584	243	0.917647	2.22988221	Sea turtle neural virus 1	3112944	Viruses	Viruses	46.6	0.00158	Sea turtle neural virus 1	Non-phage	NR	PRJNA1126198_P_NODE_458584_length_243_cov_0.917647_g457863_i0	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	WET19891.1	3112944	g457863	i0	58.8	0.419753086	34	14	42.0	241	140	464	497	102	46.6	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus;Sea turtle neural virus 1		Sea turtle neural virus 1			Viruses		Viruses		46.6		0.00158
10471	10471	PRJNA293022_CONTIG_53269\|Sea_turtle_neural_virus_1\|CLUSTER2_Sea_turtle_neural_virus_1\|1\|1	Sea turtle neural virus 1	Endogenous or not fish-associated	PRJNA293022_CONTIG_53269\|Sea_turtle_neural_virus_1	PRJNA293022_CONTIG_53269	Sea turtle neural virus 1	8	8	2	CLUSTER2_Sea_turtle_neural_virus_1\|1\|1	PRJNA293022_P_NODE_53269_length_191_cov_1.232394_g52532_i0\|Sea_turtle_neural_virus_1\|NR\|2.18e-22\|NA	1	1	PRJNA293022	53269	191	1.232394	2.35387254	Sea turtle neural virus 1	3112944	Viruses	Viruses	99.4	2.18e-22	Sea turtle neural virus 1	Non-phage	NR	PRJNA293022_P_NODE_53269_length_191_cov_1.232394_g52532_i0	WET19893.1 MAG: polymerase [Sea turtle neural virus 1]	WET19893.1	3112944	g52532	i0	64.5	2.921465969	62	22	97.4	3	188	1143	1204	558	99.4	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Sea turtle neural virus 1	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Chuvivirus;Sea turtle neural virus 1	African cichlid piscichuvirus	Sea turtle neural virus 1	gi\|2561334976\|gb\|OR350343.1\|	Viruses	Viruses	Viruses	Viruses	67.6	99.4	5.87e-07	2.18e-22

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