metadata: viruses_fish_associated_curated: 14 rows where Category = "Endogenous or not fish-associated" and bioproject = "PRJNA800053"

14 rows where Category = "Endogenous or not fish-associated" and bioproject = "PRJNA800053"

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
8026	8026	PRJNA800053_CONTIG_2323\|African_cichlid_piscichuvirus\|CLUSTER1_African_cichlid_piscichuvirus\|150\|125	African cichlid piscichuvirus	Endogenous or not fish-associated	PRJNA800053_CONTIG_2323\|African_cichlid_piscichuvirus	PRJNA800053_CONTIG_2323	African cichlid piscichuvirus	151	125	2	CLUSTER1_African_cichlid_piscichuvirus\|150\|125	PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0\|African_cichlid_piscichuvirus\|NR\|2.83e-43\|NA	150	125	PRJNA800053	2323	565	2.894309	16.35284585	African cichlid piscichuvirus	3065075	Viruses	Viruses	92.0	8.18e-18	African cichlid piscichuvirus	Non-phage	NR	PRJNA800053_P_NODE_2323_length_565_cov_2.894309_g2166_i0	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	WLN26256.1	3065075	g2166	i0	50.0	0.488495575	92	46	48.8	0	264	539	229	320	276	92.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus		African cichlid piscichuvirus			Viruses		Viruses		92.0		8.18e-18
9785	9785	PRJNA800053_CONTIG_926\|Fish-associated_parvo-like_hybrid_virus\|CLUSTER1_Fish-associated_parvo-like_hybrid_virus\|21\|14	Fish-associated parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_926\|Fish-associated_parvo-like_hybrid_virus	PRJNA800053_CONTIG_926	Fish-associated parvo-like hybrid virus	35	19	4	CLUSTER1_Fish-associated_parvo-like_hybrid_virus\|21\|14	MT138265_1_MAG_Nicoomyvirus_lizumae_isolate_par077par1_genomic_sequence	21	14	PRJNA800053	926	813	5.85	47.5605	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	1469.0	0.0	Fish-associated parvo-like hybrid virus	Non-phage	NTclustered	PRJNA800053_P_NODE_926_length_813_cov_5.850000_g799_i0	MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds	gi\|2413975758\|gb\|OP933682.1\|	3003968	g799	i0	99.262	8.18696187	813	6	100.0	0	1	813	961	1773	6656	1469.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Fish-associated parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus	Parvo-like hybrid virus UC4	gi\|2413975758\|gb\|OP933682.1\|	Viruses	Viruses	Viruses	Viruses	1469.0	530.0	0.0	8.689999999999999e-188
9954	9954	PRJNA800053_CONTIG_1555\|Shotokuvirae\|CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	Fish-associated parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_1555\|Shotokuvirae	PRJNA800053_CONTIG_1555	Fish-associated parvo-like hybrid virus	35	19	4	CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0\|Fish-associated_parvo-like_hybrid_virus\|NTclustered\|0\|NA	14	7	PRJNA800053	1555	659	3.387372	22.32278148	Shotokuvirae	2732092	Viruses	Viruses	278.0	1.7399999999999998e-89	Shotokuvirae	Non-phage	NR	PRJNA800053_P_NODE_1555_length_659_cov_3.387372_g1407_i0	AGV22413.1 replication protein [Parvo-like hybrid virus UC9]	AGV22413.1	1395620	g1407	i0	71.3	3.268588771	181	51	82.4	1	619	77	3	182	2154	278.0	1.0	Viruses	Monodnaviria	Shotokuvirae						Nicoomyvirus moldensis	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus		Shotokuvirae			Viruses		Viruses		278.0		1.7399999999999998e-89
9962	9962	PRJNA800053_CONTIG_5510\|Fish-associated_parvo-like_hybrid_virus\|CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	Fish-associated parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_5510\|Fish-associated_parvo-like_hybrid_virus	PRJNA800053_CONTIG_5510	Fish-associated parvo-like hybrid virus	35	19	4	CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0\|Fish-associated_parvo-like_hybrid_virus\|NTclustered\|0\|NA	14	7	PRJNA800053	5510	390	2.596215	10.1252385	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	472.0	2.41e-128	Fish-associated parvo-like hybrid virus	Non-phage	NTclustered	PRJNA800053_P_NODE_5510_length_390_cov_2.596215_g5347_i0	MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds	gi\|2413975758\|gb\|OP933682.1\|	3003968	g5347	i0	98.864	1.987179487	264	3	100.0	0	1	264	956	693	775	472.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Fish-associated parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus	Grus japonensis parvo-like hybrid virus	gi\|2413975758\|gb\|OP933682.1\|	Viruses	Viruses	Viruses	Viruses	472.0	68.2	2.41e-128	2.07e-10
9963	9963	PRJNA800053_CONTIG_10244\|Fish-associated_parvo-like_hybrid_virus\|CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	Fish-associated parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_10244\|Fish-associated_parvo-like_hybrid_virus	PRJNA800053_CONTIG_10244	Fish-associated parvo-like hybrid virus	35	19	4	CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0\|Fish-associated_parvo-like_hybrid_virus\|NTclustered\|0\|NA	14	7	PRJNA800053	10244	305	1.413793	4.31206865	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	564.0	2.95e-156	Fish-associated parvo-like hybrid virus	Non-phage	NTclustered	PRJNA800053_P_NODE_10244_length_305_cov_1.413793_g10080_i0	MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds	gi\|2413975758\|gb\|OP933682.1\|	3003968	g10080	i0	100.0	1.0	305	0	100.0	0	1	305	3114	2810	305	564.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Fish-associated parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus	gi\|2413975758\|gb\|OP933682.1\|	Viruses	Viruses	Viruses	Viruses	564.0	171.0	2.95e-156	3.52e-50
9964	9964	PRJNA800053_CONTIG_10647\|Fish-associated_parvo-like_hybrid_virus\|CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	Fish-associated parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_10647\|Fish-associated_parvo-like_hybrid_virus	PRJNA800053_CONTIG_10647	Fish-associated parvo-like hybrid virus	35	19	4	CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0\|Fish-associated_parvo-like_hybrid_virus\|NTclustered\|0\|NA	14	7	PRJNA800053	10647	300	1.933921	5.801763	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	457.0	5.06e-124	Fish-associated parvo-like hybrid virus	Non-phage	NTclustered	PRJNA800053_P_NODE_10647_length_300_cov_1.933921_g10483_i0	MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds	gi\|2413975758\|gb\|OP933682.1\|	3003968	g10483	i0	94.295	0.993333333	298	17	99.0	0	1	298	2815	2518	298	457.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Fish-associated parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus	gi\|2413975758\|gb\|OP933682.1\|	Viruses	Viruses	Viruses	Viruses	457.0	207.0	5.06e-124	2.3200000000000002e-64
9965	9965	PRJNA800053_CONTIG_12375\|Nicoomyvirus_moldensis\|CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	Fish-associated parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_12375\|Nicoomyvirus_moldensis	PRJNA800053_CONTIG_12375	Fish-associated parvo-like hybrid virus	35	19	4	CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0\|Fish-associated_parvo-like_hybrid_virus\|NTclustered\|0\|NA	14	7	PRJNA800053	12375	284	1.819905	5.1685302	Nicoomyvirus moldensis	3431103	Viruses	Viruses	359.0	1.38e-94	Nicoomyvirus moldensis	Non-phage	NTclustered	PRJNA800053_P_NODE_12375_length_284_cov_1.819905_g12211_i0	MAG: Parvo-like hybrid virus UC4 isolate par077par1 genomic sequence	gi\|1836405723\|gb\|MT138265.1\|	1395615	g12211	i0	89.474	1.003521127	285	28	100.0	2	1	284	1897	1614	285	359.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Nicoomyvirus moldensis	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus	Nicoomyvirus moldensis	Parvo-like hybrid virus UC4	gi\|1836405723\|gb\|MT138265.1\|	Viruses	Viruses	Viruses	Viruses	359.0	175.0	1.38e-94	2.49e-51
9969	9969	PRJNA800053_CONTIG_24906\|Fish-associated_parvo-like_hybrid_virus\|CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	Fish-associated parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_24906\|Fish-associated_parvo-like_hybrid_virus	PRJNA800053_CONTIG_24906	Fish-associated parvo-like hybrid virus	35	19	4	CLUSTER2_Fish-associated_parvo-like_hybrid_virus\|14\|7	PRJNA784979_S_NODE_320_length_2507_cov_3.719284_g317_i0\|Fish-associated_parvo-like_hybrid_virus\|NTclustered\|0\|NA	14	7	PRJNA800053	24906	226	3.673203	8.30143878	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	298.0	2.34e-76	Fish-associated parvo-like hybrid virus	Non-phage	NTclustered	PRJNA800053_P_NODE_24906_length_226_cov_3.673203_g24742_i0	MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds	gi\|2413975758\|gb\|OP933682.1\|	3003968	g24742	i0	90.95	0.977876106	221	20	98.0	0	4	224	2508	2288	221	298.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Fish-associated parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus	gi\|2413975758\|gb\|OP933682.1\|	Viruses	Viruses	Viruses	Viruses	298.0	147.0	2.34e-76	2.23e-41
10043	10043	PRJNA800053_CONTIG_21839\|Psittaciform_aveparvovirus\|CLUSTER1_Psittaciform_aveparvovirus\|12\|7	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA800053_CONTIG_21839\|Psittaciform_aveparvovirus	PRJNA800053_CONTIG_21839	Psittaciform aveparvovirus	19	12	2	CLUSTER1_Psittaciform_aveparvovirus\|12\|7	OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome	12	7	PRJNA800053	21839	244	0.900585	2.1974274	Psittaciform aveparvovirus	3042447	Viruses	Viruses	329.0	9.080000000000001e-86	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA800053_P_NODE_21839_length_244_cov_0.900585_g21675_i0	Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome	gi\|2496529060\|gb\|OP577480.1\|	3042447	g21675	i0	91.322	0.991803279	242	19	99.0	2	4	244	1965	2205	242	329.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittaciform aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus	Psittaciform aveparvovirus	Psittaciform aveparvovirus	gi\|2496529060\|gb\|OP577480.1\|	Viruses	Viruses	Viruses	Viruses	329.0	158.0	9.080000000000001e-86	2.3e-45
10068	10068	PRJNA800053_CONTIG_7218\|parvo-like_hybrid_virus\|CLUSTER2_Psittaciform_aveparvovirus\|11\|8	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA800053_CONTIG_7218\|parvo-like_hybrid_virus	PRJNA800053_CONTIG_7218	Psittaciform aveparvovirus	19	12	2	CLUSTER2_Psittaciform_aveparvovirus\|11\|8	PRJNA642647_P_NODE_4_length_3343_cov_14.130067_g3_i0\|Psittaciform_aveparvovirus\|NTclustered\|0\|NA	11	8	PRJNA800053	7218	351	1.097122	3.85089822	parvo-like hybrid virus	3367306	Viruses	Viruses	436.0	7.8400000000000005e-118	parvo-like hybrid virus	Non-phage	NTclustered	PRJNA800053_P_NODE_7218_length_351_cov_1.097122_g7054_i0	Parvo-like hybrid virus isolate SpinColumn05, partial genome	gi\|2814138511\|gb\|PQ313120.1\|	3367306	g7054	i0	99.174	2.01994302	242	2	69.0	0	109	350	2881	2640	709	436.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus	parvo-like hybrid virus	Phoenicopteridae parvo-like hybrid virus	gi\|2814138511\|gb\|PQ313120.1\|	Viruses	Viruses	Viruses	Viruses	436.0	160.0	7.8400000000000005e-118	2.37e-44
10139	10139	PRJNA800053_CONTIG_21524\|Fish-associated_parvo-like_virus\|CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus\|7\|3	Luscinia sibilans parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_21524\|Fish-associated_parvo-like_virus	PRJNA800053_CONTIG_21524	Luscinia sibilans parvo-like hybrid virus	8	5	4	CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus\|7\|3	OP933679_1_MAG_Fish_associated_parvo_like_virus_isolate_fi099par1_genomic_sequence_sequence	7	3	PRJNA800053	21524	244	2.146199	5.23672556	Fish-associated parvo-like virus	3003969	Viruses	Viruses	429.0	8.699999999999999e-116	Fish-associated parvo-like virus	Non-phage	NTclustered	PRJNA800053_P_NODE_21524_length_244_cov_2.146199_g21360_i0	MAG: Fish-associated parvo-like virus isolate fi099par1 genomic sequence, sequence	gi\|2416706441\|gb\|OP933679.1\|	3003969	g21360	i0	99.16	1.950819672	238	2	98.0	0	4	241	1027	790	476	429.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Fish-associated parvo-like virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Luscinia sibilans parvo-like hybrid virus	Fish-associated parvo-like virus	parvo-like hybrid virus	gi\|2416706441\|gb\|OP933679.1\|	Viruses	Viruses	Viruses	Viruses	429.0	140.0	8.699999999999999e-116	1.06e-37
10140	10140	PRJNA800053_CONTIG_24367\|parvo-like_hybrid_virus\|CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus\|7\|3	Luscinia sibilans parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_24367\|parvo-like_hybrid_virus	PRJNA800053_CONTIG_24367	Luscinia sibilans parvo-like hybrid virus	8	5	4	CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus\|7\|3	OP933679_1_MAG_Fish_associated_parvo_like_virus_isolate_fi099par1_genomic_sequence_sequence	7	3	PRJNA800053	24367	235	6.759259	15.88425865	parvo-like hybrid virus	3367306	Viruses	Viruses	418.0	1.8e-112	parvo-like hybrid virus	Non-phage	NTclustered	PRJNA800053_P_NODE_24367_length_235_cov_6.759259_g24203_i0	Parvo-like hybrid virus isolate SpinColumn11, partial genome	gi\|2814138527\|gb\|PQ313126.1\|	3367306	g24203	i0	99.563	1.94893617	229	1	97.0	0	4	232	1136	1364	458	418.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Luscinia sibilans parvo-like hybrid virus	parvo-like hybrid virus	parvo-like hybrid virus	gi\|2814138527\|gb\|PQ313126.1\|	Viruses	Viruses	Viruses	Viruses	418.0	128.0	1.8e-112	3.18e-33
10141	10141	PRJNA800053_CONTIG_25208\|Fish-associated_parvo-like_virus\|CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus\|7\|3	Luscinia sibilans parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_25208\|Fish-associated_parvo-like_virus	PRJNA800053_CONTIG_25208	Luscinia sibilans parvo-like hybrid virus	8	5	4	CLUSTER1_Luscinia_sibilans_parvo-like_hybrid_virus\|7\|3	OP933679_1_MAG_Fish_associated_parvo_like_virus_isolate_fi099par1_genomic_sequence_sequence	7	3	PRJNA800053	25208	206	4.067669	8.37939814	Fish-associated parvo-like virus	3003969	Viruses	Viruses	322.0	1.24e-83	Fish-associated parvo-like virus	Non-phage	NTclustered	PRJNA800053_P_NODE_25208_length_206_cov_4.067669_g25044_i0	MAG: Fish-associated parvo-like virus isolate fi099par1 genomic sequence, sequence	gi\|2416706441\|gb\|OP933679.1\|	3003969	g25044	i0	94.811	1.029126214	212	2	99.0	1	4	206	2938	2727	212	322.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Fish-associated parvo-like virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Luscinia sibilans parvo-like hybrid virus	Fish-associated parvo-like virus	Fish-associated parvo-like virus	gi\|2416706441\|gb\|OP933679.1\|	Viruses	Viruses	Viruses	Viruses	322.0	119.0	1.24e-83	1.37e-29
10261	10261	PRJNA800053_CONTIG_14866\|Phoenicopterus_roseus_parvo-like_hybrid_virus\|CLUSTER1_Phoenicopterus_roseus_parvo-like_hybrid_virus\|2\|2	Phoenicopterus roseus parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA800053_CONTIG_14866\|Phoenicopterus_roseus_parvo-like_hybrid_virus	PRJNA800053_CONTIG_14866	Phoenicopterus roseus parvo-like hybrid virus	3	2	2	CLUSTER1_Phoenicopterus_roseus_parvo-like_hybrid_virus\|2\|2	PRJNA800053_P_NODE_14866_length_266_cov_1.585492_g14702_i0\|Phoenicopterus_roseus_parvo-like_hybrid_virus\|NR\|5.02e-11\|NA	2	2	PRJNA800053	14866	266	1.585492	4.21740872	Phoenicopterus roseus parvo-like hybrid virus	2794530	Viruses	Viruses	68.2	5.02e-11	Phoenicopterus roseus parvo-like hybrid virus	Non-phage	NR	PRJNA800053_P_NODE_14866_length_266_cov_1.585492_g14702_i0	QTE03705.1 MAG: capsid protein, partial [Phoenicopterus roseus parvo-like hybrid virus]	QTE03705.1	2794530	g14702	i0	39.5	0.969924812	86	52	97.0	0	5	262	273	358	258	68.2	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Phoenicopterus roseus parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Phoenicopterus roseus parvo-like hybrid virus		Phoenicopterus roseus parvo-like hybrid virus			Viruses		Viruses		68.2		5.02e-11

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