metadata: viruses_fish_associated_curated: 20 rows where Category = "Endogenous or not fish-associated" and tax_genus

20 rows where Category = "Endogenous or not fish-associated" and tax_genus_NTorNR = "Aveparvovirus"

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
9905	9905	PRJNA283169_CONTIG_1049\|Psittacidae_aveparvovirus\|CLUSTER1_Psittacidae_aveparvovirus\|15\|6	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA283169_CONTIG_1049\|Psittacidae_aveparvovirus	PRJNA283169_CONTIG_1049	Psittacidae aveparvovirus	18	10	4	CLUSTER1_Psittacidae_aveparvovirus\|15\|6	MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence	15	6	PRJNA283169	1049	260	0.132701	0.3450226	Psittacidae aveparvovirus	2794556	Viruses	Viruses	152.0	1.06e-41	Psittacidae aveparvovirus	Non-phage	NR	PRJNA283169_S_NODE_1049_length_260_cov_0.132701_g1035_i0	QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus]	QTE03752.1	2794556	g1035	i0	82.4	0.980769231	85	15	98.1	0	5	259	334	418	255	152.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus		Psittacidae aveparvovirus			Viruses		Viruses		152.0		1.06e-41
9912	9912	PRJNA784979_CONTIG_3690\|Psittacidae_aveparvovirus\|CLUSTER1_Psittacidae_aveparvovirus\|15\|6	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA784979_CONTIG_3690\|Psittacidae_aveparvovirus	PRJNA784979_CONTIG_3690	Psittacidae aveparvovirus	18	10	4	CLUSTER1_Psittacidae_aveparvovirus\|15\|6	MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence	15	6	PRJNA784979	3690	242	1.948187	4.71461254	Psittacidae aveparvovirus	2794556	Viruses	Viruses	327.0	3.23e-85	Psittacidae aveparvovirus	Non-phage	NTclustered	PRJNA784979_S_NODE_3690_length_242_cov_1.948187_g3648_i0	MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence	gi\|2015372674\|gb\|MW046380.1\|	2794556	g3648	i0	91.561	1.946280992	237	20	98.0	0	6	242	1647	1883	471	327.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus	Psittacidae aveparvovirus	Psittacidae aveparvovirus	gi\|2015372674\|gb\|MW046380.1\|	Viruses	Viruses	Viruses	Viruses	327.0	159.0	3.23e-85	3.87e-45
9913	9913	PRJNA407368_CONTIG_4786\|Psittacidae_aveparvovirus\|CLUSTER1_Psittacidae_aveparvovirus\|15\|6	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA407368_CONTIG_4786\|Psittacidae_aveparvovirus	PRJNA407368_CONTIG_4786	Psittacidae aveparvovirus	18	10	4	CLUSTER1_Psittacidae_aveparvovirus\|15\|6	MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence	15	6	PRJNA407368	4786	257	3.061404	7.86780828	Psittacidae aveparvovirus	2794556	Viruses	Viruses	263.0	9.92e-66	Psittacidae aveparvovirus	Non-phage	NTclustered	PRJNA407368_S_NODE_4786_length_257_cov_3.061404_g4684_i0	MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence	gi\|2015372674\|gb\|MW046380.1\|	2794556	g4684	i0	94.675	0.929961089	169	9	92.0	0	21	189	681	513	239	263.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus	Psittacidae aveparvovirus	Psittacidae aveparvovirus	gi\|2015372674\|gb\|MW046380.1\|	Viruses	Viruses	Viruses	Viruses	263.0	104.0	9.92e-66	9.870000000000001e-26
9919	9919	PRJNA407368_CONTIG_7698\|Psittacidae_aveparvovirus\|CLUSTER1_Psittacidae_aveparvovirus\|15\|6	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA407368_CONTIG_7698\|Psittacidae_aveparvovirus	PRJNA407368_CONTIG_7698	Psittacidae aveparvovirus	18	10	4	CLUSTER1_Psittacidae_aveparvovirus\|15\|6	MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence	15	6	PRJNA407368	7698	186	2.382166	4.43082876	Psittacidae aveparvovirus	2794556	Viruses	Viruses	289.0	1.11e-73	Psittacidae aveparvovirus	Non-phage	NTclustered	PRJNA407368_S_NODE_7698_length_186_cov_2.382166_g7596_i0	MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence	gi\|2015372674\|gb\|MW046380.1\|	2794556	g7596	i0	94.624	1.0	186	10	100.0	0	1	186	469	284	186	289.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus	Psittacidae aveparvovirus	Psittacidae aveparvovirus	gi\|2015372674\|gb\|MW046380.1\|	Viruses	Viruses	Viruses	Viruses	289.0	112.0	1.11e-73	2.62e-29
9926	9926	PRJNA309466_CONTIG_15363\|Psittacidae_aveparvovirus\|CLUSTER1_Psittacidae_aveparvovirus\|15\|6	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA309466_CONTIG_15363\|Psittacidae_aveparvovirus	PRJNA309466_CONTIG_15363	Psittacidae aveparvovirus	18	10	4	CLUSTER1_Psittacidae_aveparvovirus\|15\|6	MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence	15	6	PRJNA309466	15363	169	3.391667	5.73191723	Psittacidae aveparvovirus	2794556	Viruses	Viruses	254.0	3.6e-63	Psittacidae aveparvovirus	Non-phage	NTclustered	PRJNA309466_P_NODE_15363_length_169_cov_3.391667_g15306_i0	MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence	gi\|2015372674\|gb\|MW046380.1\|	2794556	g15306	i0	94.545	0.976331361	165	8	98.0	1	1	165	817	654	165	254.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus	Psittacidae aveparvovirus	Psittacidae aveparvovirus	gi\|2015372674\|gb\|MW046380.1\|	Viruses	Viruses	Viruses	Viruses	254.0	84.7	3.6e-63	1.33e-18
9930	9930	PRJNA474426_CONTIG_20814\|Psittacidae_aveparvovirus\|CLUSTER1_Psittacidae_aveparvovirus\|15\|6	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA474426_CONTIG_20814\|Psittacidae_aveparvovirus	PRJNA474426_CONTIG_20814	Psittacidae aveparvovirus	18	10	4	CLUSTER1_Psittacidae_aveparvovirus\|15\|6	MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence	15	6	PRJNA474426	20814	218	2.763314	6.02402452	Psittacidae aveparvovirus	2794556	Viruses	Viruses	248.0	2.29e-61	Psittacidae aveparvovirus	Non-phage	NTclustered	PRJNA474426_P_NODE_20814_length_218_cov_2.763314_g20609_i0	MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence	gi\|2015372674\|gb\|MW046380.1\|	2794556	g20609	i0	87.215	1.004587156	219	26	100.0	2	1	218	1536	1753	219	248.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus	Psittacidae aveparvovirus	Psittacidae aveparvovirus	gi\|2015372674\|gb\|MW046380.1\|	Viruses	Viruses	Viruses	Viruses	248.0	140.0	2.29e-61	4.96e-38
9937	9937	PRJNA558770_CONTIG_41702\|Psittacidae_aveparvovirus\|CLUSTER1_Psittacidae_aveparvovirus\|15\|6	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA558770_CONTIG_41702\|Psittacidae_aveparvovirus	PRJNA558770_CONTIG_41702	Psittacidae aveparvovirus	18	10	4	CLUSTER1_Psittacidae_aveparvovirus\|15\|6	MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence	15	6	PRJNA558770	41702	329	8.064626	26.53261954	Psittacidae aveparvovirus	2794556	Viruses	Viruses	440.0	5.66e-119	Psittacidae aveparvovirus	Non-phage	NTclustered	PRJNA558770_P_NODE_41702_length_329_cov_8.064626_g39704_i0	MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence	gi\|2015372674\|gb\|MW046380.1\|	2794556	g39704	i0	91.562	0.972644377	320	25	97.0	2	1	319	347	29	320	440.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus	Psittacidae aveparvovirus		gi\|2015372674\|gb\|MW046380.1\|	Viruses		Viruses		440.0		5.66e-119
10012	10012	PRJNA642647_CONTIG_547\|Psittaciform_aveparvovirus\|CLUSTER1_Psittaciform_aveparvovirus\|12\|7	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA642647_CONTIG_547\|Psittaciform_aveparvovirus	PRJNA642647_CONTIG_547	Psittaciform aveparvovirus	19	12	2	CLUSTER1_Psittaciform_aveparvovirus\|12\|7	OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome	12	7	PRJNA642647	547	480	4.988713	23.9458224	Psittaciform aveparvovirus	3042447	Viruses	Viruses	749.0	0.0	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA642647_P_NODE_547_length_480_cov_4.988713_g498_i0	Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome	gi\|2496529060\|gb\|OP577480.1\|	3042447	g498	i0	94.969	0.99375	477	24	99.0	0	1	477	2085	1609	477	749.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	749.0	311.0	0.0	9.159999999999999e-104
10028	10028	PRJNA642647_CONTIG_5747\|Psittaciform_aveparvovirus\|CLUSTER1_Psittaciform_aveparvovirus\|12\|7	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA642647_CONTIG_5747\|Psittaciform_aveparvovirus	PRJNA642647_CONTIG_5747	Psittaciform aveparvovirus	19	12	2	CLUSTER1_Psittaciform_aveparvovirus\|12\|7	OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome	12	7	PRJNA642647	5747	159	1.467213	2.33286867	Psittaciform aveparvovirus	3042447	Viruses	Viruses	220.0	3.4099999999999998e-53	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA642647_P_NODE_5747_length_159_cov_1.467213_g5697_i0	Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome	gi\|2496529060\|gb\|OP577480.1\|	3042447	g5697	i0	99.18	1.232704403	122	1	77.0	0	1	122	142	21	196	220.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittaciform aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus	Psittaciform aveparvovirus		gi\|2496529060\|gb\|OP577480.1\|	Viruses		Viruses		220.0		3.4099999999999998e-53
10040	10040	PRJNA994052_CONTIG_19856\|Psittaciform_aveparvovirus\|CLUSTER1_Psittaciform_aveparvovirus\|12\|7	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA994052_CONTIG_19856\|Psittaciform_aveparvovirus	PRJNA994052_CONTIG_19856	Psittaciform aveparvovirus	19	12	2	CLUSTER1_Psittaciform_aveparvovirus\|12\|7	OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome	12	7	PRJNA994052	19856	309	21.555085	66.60521265	Psittaciform aveparvovirus	3042447	Viruses	Viruses	484.0	2.3999999999999998e-132	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA994052_P_NODE_19856_length_309_cov_21.555085_g18633_i0	Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome	gi\|2496529060\|gb\|OP577480.1\|	3042447	g18633	i0	95.946	1.566343042	296	7	96.0	1	13	308	1728	1438	484	484.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	484.0	93.6	2.3999999999999998e-132	3.88e-20
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
10052	10052	PRJNA558770_CONTIG_73018\|Psittaciform_aveparvovirus\|CLUSTER1_Psittaciform_aveparvovirus\|12\|7	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA558770_CONTIG_73018\|Psittaciform_aveparvovirus	PRJNA558770_CONTIG_73018	Psittaciform aveparvovirus	19	12	2	CLUSTER1_Psittaciform_aveparvovirus\|12\|7	OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome	12	7	PRJNA558770	73018	243	3.653846	8.87884578	Psittaciform aveparvovirus	3042447	Viruses	Viruses	416.0	6.74e-112	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA558770_P_NODE_73018_length_243_cov_3.653846_g71013_i0	Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome	gi\|2496529060\|gb\|OP577480.1\|	3042447	g71013	i0	97.541	1.004115226	244	4	100.0	2	1	243	1770	2012	244	416.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	416.0	101.0	6.74e-112	1.54e-23
10057	10057	PRJNA630162_CONTIG_117271\|Psittaciform_aveparvovirus\|CLUSTER1_Psittaciform_aveparvovirus\|12\|7	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA630162_CONTIG_117271\|Psittaciform_aveparvovirus	PRJNA630162_CONTIG_117271	Psittaciform aveparvovirus	19	12	2	CLUSTER1_Psittaciform_aveparvovirus\|12\|7	OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome	12	7	PRJNA630162	117271	176	1.291339	2.27275664	Psittaciform aveparvovirus	3042447	Viruses	Viruses	315.0	1.7199999999999998e-81	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA630162_P_NODE_117271_length_176_cov_1.291339_g115748_i0	Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome	gi\|2496529060\|gb\|OP577480.1\|	3042447	g115748	i0	99.422	0.982954545	173	1	98.0	0	4	176	2044	1872	173	315.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	315.0	122.0	1.7199999999999998e-81	1.1100000000000001e-31
10063	10063	PRJNA642647_CONTIG_4\|Psittaciform_aveparvovirus\|CLUSTER2_Psittaciform_aveparvovirus\|11\|8	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA642647_CONTIG_4\|Psittaciform_aveparvovirus	PRJNA642647_CONTIG_4	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	PRJNA642647	4	3343	14.130067	472.3681398	Psittaciform aveparvovirus	3042447	Viruses	Viruses	5782.0	0.0	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA642647_P_NODE_4_length_3343_cov_14.130067_g3_i0	Psittaciform aveparvovirus strain OBP1/FE1/29/2021, partial genome	gi\|2496529059\|gb\|OP577479.1\|	3042447	g3	i0	99.466	2.784624589	3183	16	95.0	1	1	3182	116	3298	9309	5782.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittaciform aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus	Psittaciform aveparvovirus	Phoenicopteridae parvo-like hybrid virus	gi\|2496529059\|gb\|OP577479.1\|	Viruses	Viruses	Viruses	Viruses	5782.0	811.0	0.0	1.82e-285
10069	10069	PRJNA670550_CONTIG_15873\|Psittaciform_aveparvovirus\|CLUSTER2_Psittaciform_aveparvovirus\|11\|8	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA670550_CONTIG_15873\|Psittaciform_aveparvovirus	PRJNA670550_CONTIG_15873	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	PRJNA670550	15873	188	1.625899	3.05669012	Psittaciform aveparvovirus	3042447	Viruses	Viruses	296.0	6.74e-76	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA670550_P_NODE_15873_length_188_cov_1.625899_g15705_i0	Psittaciform aveparvovirus strain OBP1/FE1/29/2021, partial genome	gi\|2496529059\|gb\|OP577479.1\|	3042447	g15705	i0	98.225	1.542553191	169	3	90.0	0	1	169	169	1	290	296.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittaciform aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus	Psittaciform aveparvovirus		gi\|2496529059\|gb\|OP577479.1\|	Viruses		Viruses		296.0		6.74e-76
10070	10070	PRJNA846486_CONTIG_20666\|Psittaciform_aveparvovirus\|CLUSTER2_Psittaciform_aveparvovirus\|11\|8	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA846486_CONTIG_20666\|Psittaciform_aveparvovirus	PRJNA846486_CONTIG_20666	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	PRJNA846486	20666	282	1.472103	4.15133046	Psittaciform aveparvovirus	3042447	Viruses	Viruses	483.0	7.780000000000001e-132	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA846486_P_NODE_20666_length_282_cov_1.472103_g20570_i0	Psittaciform aveparvovirus strain OBP1/FE1/29/2021, partial genome	gi\|2496529059\|gb\|OP577479.1\|	3042447	g20570	i0	99.621	1.872340426	264	1	94.0	0	19	282	333	70	528	483.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittaciform aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus	Psittaciform aveparvovirus		gi\|2496529059\|gb\|OP577479.1\|	Viruses		Viruses		483.0		7.780000000000001e-132
10217	10217	PRJNA630162_CONTIG_16732\|Psittacidae_aveparvovirus\|CLUSTER2_Psittacidae_aveparvovirus\|3\|3	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA630162_CONTIG_16732\|Psittacidae_aveparvovirus	PRJNA630162_CONTIG_16732	Psittacidae aveparvovirus	18	10	4	CLUSTER2_Psittacidae_aveparvovirus\|3\|3	PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0\|Psittacidae_aveparvovirus\|NR\|1.21e-18\|NA	3	3	PRJNA630162	16732	457	2.938725	13.42997325	Psittacidae aveparvovirus	2794556	Viruses	Viruses	92.0	1.21e-18	Psittacidae aveparvovirus	Non-phage	NR	PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0	QTE03751.1 MAG: replication protein [Psittacidae aveparvovirus]	QTE03751.1	2794556	g15229	i0	39.3	0.800875274	122	58	78.1	3	97	453	16	124	366	92.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus		Psittacidae aveparvovirus			Viruses		Viruses		92.0		1.21e-18
10218	10218	PRJNA312107_CONTIG_25980\|Psittaciform_aveparvovirus\|CLUSTER2_Psittacidae_aveparvovirus\|3\|3	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA312107_CONTIG_25980\|Psittaciform_aveparvovirus	PRJNA312107_CONTIG_25980	Psittacidae aveparvovirus	18	10	4	CLUSTER2_Psittacidae_aveparvovirus\|3\|3	PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0\|Psittacidae_aveparvovirus\|NR\|1.21e-18\|NA	3	3	PRJNA312107	25980	162	0.920354	1.49097348	Psittaciform aveparvovirus	3042447	Viruses	Viruses	43.9	0.00498	Psittaciform aveparvovirus	Non-phage	NR	PRJNA312107_P_NODE_25980_length_162_cov_0.920354_g25814_i0	WGL41068.1 replication protein [Psittaciform aveparvovirus]	WGL41068.1	3042447	g25814	i0	37.0	1.0	54	26	94.4	2	156	4	9	57	162	43.9	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittaciform aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus		Psittaciform aveparvovirus			Viruses		Viruses		43.9		0.00498
10311	10311	PRJNA489308_CONTIG_214\|Psittacidae_aveparvovirus\|CLUSTER3_Psittacidae_aveparvovirus\|1\|1	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA489308_CONTIG_214\|Psittacidae_aveparvovirus	PRJNA489308_CONTIG_214	Psittacidae aveparvovirus	18	10	4	CLUSTER3_Psittacidae_aveparvovirus\|1\|1	PRJNA489308_P_NODE_214_length_1473_cov_66.962857_g184_i0\|Psittacidae_aveparvovirus\|NR\|1.74e-86\|NA	1	1	PRJNA489308	214	1473	66.962857	986.3628836	Psittacidae aveparvovirus	2794556	Viruses	Viruses	285.0	1.74e-86	Psittacidae aveparvovirus	Non-phage	NR	PRJNA489308_P_NODE_214_length_1473_cov_66.962857_g184_i0	QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus]	QTE03752.1	2794556	g184	i0	45.3	1.50509165	369	187	73.5	9	1110	28	165	526	2217	285.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus	Flumine parvovirus 18	Psittacidae aveparvovirus	gi\|2235497426\|gb\|OM954002.1\|	Viruses	Viruses	Viruses	Viruses	121.0	285.0	4.0900000000000002e-22	1.74e-86
10489	10489	PRJEB10140_CONTIG_251847\|Psittacidae_aveparvovirus\|CLUSTER4_Psittacidae_aveparvovirus\|1\|1	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJEB10140_CONTIG_251847\|Psittacidae_aveparvovirus	PRJEB10140_CONTIG_251847	Psittacidae aveparvovirus	18	10	4	CLUSTER4_Psittacidae_aveparvovirus\|1\|1	PRJEB10140_P_NODE_251847_length_168_cov_0.873950_g234538_i0\|Psittacidae_aveparvovirus\|NR\|3.45e-16\|NA	1	1	PRJEB10140	251847	168	0.87395	1.468236	Psittacidae aveparvovirus	2794556	Viruses	Viruses	81.3	3.45e-16	Psittacidae aveparvovirus	Non-phage	NR	PRJEB10140_P_NODE_251847_length_168_cov_0.873950_g234538_i0	QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus]	QTE03752.1	2794556	g234538	i0	61.8	0.982142857	55	21	98.2	0	166	2	305	359	165	81.3	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus		Psittacidae aveparvovirus			Viruses		Viruses		81.3		3.45e-16

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