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

8 rows where Category = "Endogenous or not fish-associated" and bioproject = "PRJEB64798"

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
9796	9796	PRJEB64798_CONTIG_174738\|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	PRJEB64798_CONTIG_174738\|Fish-associated_parvo-like_hybrid_virus	PRJEB64798_CONTIG_174738	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	PRJEB64798	174738	176	17.377953	30.58519728	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	315.0	1.7199999999999998e-81	Fish-associated parvo-like hybrid virus	Non-phage	NTclustered	PRJEB64798_P_NODE_174738_length_176_cov_17.377953_g172972_i0	MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds	gi\|2413975758\|gb\|OP933682.1\|	3003968	g172972	i0	100.0	1.9375	170	0	97.0	0	2	171	2000	2169	341	315.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	315.0	73.9	1.7199999999999998e-81	1e-13
10018	10018	PRJEB64798_CONTIG_1247\|Fish-associated_picorna-like_virus_3\|CLUSTER1_Fish-associated_picorna-like_virus_3\|12\|3	Fish-associated picorna-like virus 3	Endogenous or not fish-associated	PRJEB64798_CONTIG_1247\|Fish-associated_picorna-like_virus_3	PRJEB64798_CONTIG_1247	Fish-associated picorna-like virus 3	12	3	1	CLUSTER1_Fish-associated_picorna-like_virus_3\|12\|3	PRJEB64798_P_NODE_1247_length_1574_cov_19.076721_g909_i0\|Fish-associated_picorna-like_virus_3\|NR\|4.87e-42\|NA	12	3	PRJEB64798	1247	1574	19.076721	300.2675885	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	173.0	4.8699999999999995e-42	Fish-associated picorna-like virus 3	Non-phage	NR	PRJEB64798_P_NODE_1247_length_1574_cov_19.076721_g909_i0	WAQ80627.1 MAG: hypothetical protein [Fish-associated picorna-like virus 3]	WAQ80627.1	3003959	g909	i0	39.1	1.019695044	261	148	48.4	6	793	32	2011	2267	1605	173.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Fish-associated picorna-like virus 3	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Fish-associated picorna-like virus 3		Fish-associated picorna-like virus 3			Viruses		Viruses		173.0		4.8699999999999995e-42
10050	10050	PRJEB64798_CONTIG_64252\|Aveparvovirus\|CLUSTER1_Psittaciform_aveparvovirus\|12\|7	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJEB64798_CONTIG_64252\|Aveparvovirus	PRJEB64798_CONTIG_64252	Psittaciform aveparvovirus	19	12	2	CLUSTER1_Psittaciform_aveparvovirus\|12\|7	OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome	12	7	PRJEB64798	64252	242	9.849741	23.83637322	Aveparvovirus	1511864	Viruses	Viruses	283.0	7.1e-72	Aveparvovirus	Non-phage	NTclustered	PRJEB64798_P_NODE_64252_length_242_cov_9.849741_g62487_i0	Parvoviridae sp. isolate SpinColumn17, partial genome	gi\|2814138549\|gb\|PQ313132.1\|	1940570	g62487	i0	88.789	1.842975207	223	15	88.0	2	30	242	1449	1227	446	283.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Parvoviridae sp.	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus	Aveparvovirus	Psittaciform aveparvovirus	gi\|2814138549\|gb\|PQ313132.1\|	Viruses	Viruses	Viruses	Viruses	283.0	64.7	7.1e-72	6.31e-10
10059	10059	PRJEB64798_CONTIG_212750\|Picornavirales_sp.\|CLUSTER1_Fish-associated_picorna-like_virus_3\|12\|3	Fish-associated picorna-like virus 3	Endogenous or not fish-associated	PRJEB64798_CONTIG_212750\|Picornavirales_sp.	PRJEB64798_CONTIG_212750	Fish-associated picorna-like virus 3	12	3	1	CLUSTER1_Fish-associated_picorna-like_virus_3\|12\|3	PRJEB64798_P_NODE_1247_length_1574_cov_19.076721_g909_i0\|Fish-associated_picorna-like_virus_3\|NR\|4.87e-42\|NA	12	3	PRJEB64798	212750	164	1.713043	2.80939052	Picornavirales sp.	1955153	Viruses	Viruses	50.4	2.43e-05	Picornavirales sp.	Non-phage	NR	PRJEB64798_P_NODE_212750_length_164_cov_1.713043_g210984_i0	XCM68446.1 MAG: structural polyprotein, partial [Picornavirales sp.]	XCM68446.1	1955153	g210984	i0	52.1	0.87804878	48	23	87.8	0	149	6	213	260	144	50.4	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Picornavirales sp.	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Fish-associated picorna-like virus 3		Picornavirales sp.			Viruses		Viruses		50.4		2.43e-05
10252	10252	PRJEB64798_CONTIG_6282\|Flumine_Astrovirus_3\|CLUSTER1_Flumine_Astrovirus_3\|2\|1	Flumine Astrovirus 3	Endogenous or not fish-associated	PRJEB64798_CONTIG_6282\|Flumine_Astrovirus_3	PRJEB64798_CONTIG_6282	Flumine Astrovirus 3	6	2	5	CLUSTER1_Flumine_Astrovirus_3\|2\|1	PRJEB64798_P_NODE_6282_length_781_cov_14.681694_g5068_i0\|Flumine_Astrovirus_3\|NR\|1.32e-19\|NA	2	1	PRJEB64798	6282	781	14.681694	114.6640301	Flumine Astrovirus 3	2940955	Viruses	Viruses	99.4	1.32e-19	Flumine Astrovirus 3	Non-phage	NR	PRJEB64798_P_NODE_6282_length_781_cov_14.681694_g5068_i0	UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3]	UQB76172.1	2940955	g5068	i0	37.8	0.518565941	135	73	47.6	2	410	781	9	143	405	99.4	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Flumine Astrovirus 3	Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3		Flumine Astrovirus 3			Viruses		Viruses		99.4		1.32e-19
10265	10265	PRJEB64798_CONTIG_27348\|Flumine_Astrovirus_3\|CLUSTER1_Flumine_Astrovirus_3\|2\|1	Flumine Astrovirus 3	Endogenous or not fish-associated	PRJEB64798_CONTIG_27348\|Flumine_Astrovirus_3	PRJEB64798_CONTIG_27348	Flumine Astrovirus 3	6	2	5	CLUSTER1_Flumine_Astrovirus_3\|2\|1	PRJEB64798_P_NODE_6282_length_781_cov_14.681694_g5068_i0\|Flumine_Astrovirus_3\|NR\|1.32e-19\|NA	2	1	PRJEB64798	27348	376	10.954128	41.18752128	Flumine Astrovirus 3	2940955	Viruses	Viruses	106.0	5.74e-24	Flumine Astrovirus 3	Non-phage	NR	PRJEB64798_P_NODE_27348_length_376_cov_10.954128_g25593_i0	UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3]	UQB76172.1	2940955	g25593	i0	43.8	0.965425532	121	66	95.7	2	363	4	119	238	363	106.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Flumine Astrovirus 3	Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3		Flumine Astrovirus 3			Viruses		Viruses		106.0		5.74e-24
10371	10371	PRJEB64798_CONTIG_3959\|Flumine_Astrovirus_3\|CLUSTER2_Flumine_Astrovirus_3\|1\|1	Flumine Astrovirus 3	Endogenous or not fish-associated	PRJEB64798_CONTIG_3959\|Flumine_Astrovirus_3	PRJEB64798_CONTIG_3959	Flumine Astrovirus 3	6	2	5	CLUSTER2_Flumine_Astrovirus_3\|1\|1	PRJEB64798_P_NODE_3959_length_956_cov_10.364939_g3087_i0\|Flumine_Astrovirus_3\|NR\|3.68e-89\|NA	1	1	PRJEB64798	3959	956	10.364939	99.08881684	Flumine Astrovirus 3	2940955	Viruses	Viruses	287.0	3.68e-89	Flumine Astrovirus 3	Non-phage	NR	PRJEB64798_P_NODE_3959_length_956_cov_10.364939_g3087_i0	UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3]	UQB76172.1	2940955	g3087	i0	48.6	0.988493724	315	157	98.5	3	10	951	225	535	945	287.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Flumine Astrovirus 3	Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3		Flumine Astrovirus 3			Viruses		Viruses		287.0		3.68e-89
10477	10477	PRJEB64798_CONTIG_74732\|Flumine_Astrovirus_3\|CLUSTER5_Flumine_Astrovirus_3\|1\|1	Flumine Astrovirus 3	Endogenous or not fish-associated	PRJEB64798_CONTIG_74732\|Flumine_Astrovirus_3	PRJEB64798_CONTIG_74732	Flumine Astrovirus 3	6	2	5	CLUSTER5_Flumine_Astrovirus_3\|1\|1	PRJEB64798_P_NODE_74732_length_223_cov_4.143678_g72967_i0\|Flumine_Astrovirus_3\|NR\|4.95e-28\|NA	1	1	PRJEB64798	74732	223	4.143678	9.24040194	Flumine Astrovirus 3	2940955	Viruses	Viruses	115.0	4.95e-28	Flumine Astrovirus 3	Non-phage	NR	PRJEB64798_P_NODE_74732_length_223_cov_4.143678_g72967_i0	UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3]	UQB76172.1	2940955	g72967	i0	69.9	0.98206278	73	22	98.2	0	3	221	471	543	219	115.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Flumine Astrovirus 3	Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3		Flumine Astrovirus 3			Viruses		Viruses		115.0		4.95e-28

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