metadata: viruses_fish_associated_curated: 8 rows where bioproject = "PRJNA556992"

8 rows where bioproject = "PRJNA556992"

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
4991	4991	PRJNA556992_CONTIG_1021973\|Carp_edema_virus\|CLUSTER1_Carp_edema_virus\|632\|87	Zebrafish jaw poxvirus	Novel	PRJNA556992_CONTIG_1021973\|Carp_edema_virus	PRJNA556992_CONTIG_1021973	Carp edema virus	4680	143	36	CLUSTER1_Carp_edema_virus\|632\|87	PRJNA1075480_S_NODE_3_length_24555_cov_43.250551_g1_i0\|Carp_edema_virus\|NR\|0\|NA	629	87	PRJNA556992	1021973	228	3.393548	7.73728944	Carp edema virus	1653087	Viruses	Viruses	108.0	2.83e-25	Carp edema virus	Non-phage	NR	PRJNA556992_P_NODE_1021973_length_228_cov_3.393548_g1019783_i0	BCT22639.1 DNA topoisomerase 2 [Carp edema virus]	BCT22639.1	1653087	g1019783	i0	69.3	0.986842105	75	21	98.7	1	226	2	724	796	225	108.0	1.0	Viruses	Varidnaviria	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Carp edema virus	Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus		Carp edema virus			Viruses		Viruses		108.0		2.83e-25
10051	10051	PRJNA556992_CONTIG_71210\|Adintovirus_anguilla1\|CLUSTER2_Adintovirus_anguilla1\|12\|3	Adintovirus anguilla10665	Endogenous or not fish-associated	PRJNA556992_CONTIG_71210\|Adintovirus_anguilla1	PRJNA556992_CONTIG_71210	Adintovirus anguilla1	34	19	10	CLUSTER2_Adintovirus_anguilla1\|12\|3	PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0\|Adintovirus_anguilla1\|NR\|1.27e-11\|NA	12	3	PRJNA556992	71210	451	3.492063	15.74920413	Adintovirus anguilla1	3115889	Viruses	Viruses	74.7	1.93e-13	Adintovirus anguilla1	Non-phage	NR	PRJNA556992_P_NODE_71210_length_451_cov_3.492063_g69035_i0	DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665]	DBA49783.1	3115889	g69035	i0	31.1	0.87804878	132	81	85.8	4	449	63	42	166	396	74.7	1.0	Viruses	Varidnaviria	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Adintovirus anguilla10665	Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665		Adintovirus anguilla1			Viruses		Viruses		74.7		1.93e-13
10071	10071	PRJNA556992_CONTIG_33478\|Parvoviridae_sp.\|CLUSTER2_Psittaciform_aveparvovirus\|11\|8	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA556992_CONTIG_33478\|Parvoviridae_sp.	PRJNA556992_CONTIG_33478	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	PRJNA556992	33478	601	4.880682	29.33289882	Parvoviridae sp.	1940570	Viruses	Viruses	300.0	1.69e-98	Parvoviridae sp.	Non-phage	NR	PRJNA556992_P_NODE_33478_length_601_cov_4.880682_g31362_i0	XNT21000.1 MAG: replication protein [Parvoviridae sp.]	XNT21000.1	1940570	g31362	i0	70.5	1.996672213	200	57	99.8	1	2	601	52	249	1200	300.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Parvoviridae sp.	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus	Flumine parvovirus 11	Parvoviridae sp.	gi\|2235497401\|gb\|OM953996.1\|	Viruses	Viruses	Viruses	Viruses	255.0	300.0	4.22e-63	1.69e-98
10277	10277	PRJNA556992_CONTIG_316701\|Pimephales_minnow_adintovirus\|CLUSTER14_Pimephales_minnow_adintovirus\|2\|2	Pimephales minnow adintovirus	Endogenous or not fish-associated	PRJNA556992_CONTIG_316701\|Pimephales_minnow_adintovirus	PRJNA556992_CONTIG_316701	Pimephales minnow adintovirus	168	104	20	CLUSTER14_Pimephales_minnow_adintovirus\|2\|2	PRJNA556992_P_NODE_316701_length_286_cov_2.755869_g314512_i0\|Pimephales_minnow_adintovirus\|NR\|8.34e-15\|NA	2	2	PRJNA556992	316701	286	2.755869	7.88178534	Pimephales minnow adintovirus	2609864	Viruses	Viruses	79.3	8.34e-15	Pimephales minnow adintovirus	Non-phage	NR	PRJNA556992_P_NODE_316701_length_286_cov_2.755869_g314512_i0	DAC81392.1 TPA_asm: PolB-N [Pimephales minnow adintovirus]	DAC81392.1	2609864	g314512	i0	46.2	3.902097902	93	50	97.6	0	284	6	515	607	1116	79.3	1.0	Viruses	Varidnaviria	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Pimephales minnow adintovirus	Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Pimephales minnow adintovirus		Pimephales minnow adintovirus			Viruses		Viruses		79.3		8.34e-15
10476	10476	PRJNA556992_CONTIG_72584\|Phoenicopteridae_parvo-like_hybrid_virus\|CLUSTER3_Phoenicopteridae_parvo-like_hybrid_virus\|1\|1	Phoenicopteridae parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA556992_CONTIG_72584\|Phoenicopteridae_parvo-like_hybrid_virus	PRJNA556992_CONTIG_72584	Phoenicopteridae parvo-like hybrid virus	3	3	3	CLUSTER3_Phoenicopteridae_parvo-like_hybrid_virus\|1\|1	PRJNA556992_P_NODE_72584_length_448_cov_4.661333_g70408_i0\|Phoenicopteridae_parvo-like_hybrid_virus\|NR\|2.29e-08\|NA	1	1	PRJNA556992	72584	448	4.661333	20.88277184	Phoenicopteridae parvo-like hybrid virus	2794528	Viruses	Viruses	63.2	2.29e-08	Phoenicopteridae parvo-like hybrid virus	Non-phage	NR	PRJNA556992_P_NODE_72584_length_448_cov_4.661333_g70408_i0	QTE03745.1 MAG: hypothetical protein [Phoenicopteridae parvo-like hybrid virus]	QTE03745.1	2794528	g70408	i0	32.9	0.9375	140	70	90.4	3	413	9	144	264	420	63.2	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Phoenicopteridae parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Phoenicopteridae parvo-like hybrid virus		Phoenicopteridae parvo-like hybrid virus			Viruses		Viruses		63.2		2.29e-08
10493	10493	PRJNA556992_CONTIG_425390\|Larimichthys_croaker_adintovirus\|CLUSTER8_Larimichthys_croaker_adintovirus\|1\|1	Larimichthys croaker adintovirus	Insufficient Evidence	PRJNA556992_CONTIG_425390\|Larimichthys_croaker_adintovirus	PRJNA556992_CONTIG_425390	Larimichthys croaker adintovirus	19	14	10	CLUSTER8_Larimichthys_croaker_adintovirus\|1\|1	PRJNA556992_P_NODE_425390_length_274_cov_1.781095_g423201_i0\|Larimichthys_croaker_adintovirus\|NR\|5.71e-34\|NA	1	1	PRJNA556992	425390	274	1.781095	4.8802003	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	129.0	5.7099999999999995e-34	Larimichthys croaker adintovirus	Non-phage	NR	PRJNA556992_P_NODE_425390_length_274_cov_1.781095_g423201_i0	DAC81309.1 TPA_asm: integrase [Larimichthys croaker adintovirus]	DAC81309.1	2609857	g423201	i0	69.2	2.989051095	91	28	99.6	0	273	1	66	156	819	129.0	1.0	Viruses	Varidnaviria	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Larimichthys croaker adintovirus	Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Larimichthys croaker adintovirus		Larimichthys croaker adintovirus			Viruses		Viruses		129.0		5.7099999999999995e-34
10494	10494	PRJNA556992_CONTIG_1001715\|Larimichthys_croaker_adintovirus\|CLUSTER9_Larimichthys_croaker_adintovirus\|1\|1	Larimichthys croaker adintovirus	Insufficient Evidence	PRJNA556992_CONTIG_1001715\|Larimichthys_croaker_adintovirus	PRJNA556992_CONTIG_1001715	Larimichthys croaker adintovirus	19	14	10	CLUSTER9_Larimichthys_croaker_adintovirus\|1\|1	PRJNA556992_P_NODE_1001715_length_230_cov_3.732484_g999525_i0\|Larimichthys_croaker_adintovirus\|NR\|6.07e-20\|NA	1	1	PRJNA556992	1001715	230	3.732484	8.5847132	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	88.6	6.07e-20	Larimichthys croaker adintovirus	Non-phage	NR	PRJNA556992_P_NODE_1001715_length_230_cov_3.732484_g999525_i0	DAC81313.1 TPA_asm: adenain [Larimichthys croaker adintovirus]	DAC81313.1	2609857	g999525	i0	57.1	0.913043478	70	30	91.3	0	2	211	87	156	210	88.6	1.0	Viruses	Varidnaviria	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Larimichthys croaker adintovirus	Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Larimichthys croaker adintovirus		Larimichthys croaker adintovirus			Viruses		Viruses		88.6		6.07e-20
10495	10495	PRJNA556992_CONTIG_1104782\|Larimichthys_croaker_adintovirus\|CLUSTER10_Larimichthys_croaker_adintovirus\|1\|1	Larimichthys croaker adintovirus	Insufficient Evidence	PRJNA556992_CONTIG_1104782\|Larimichthys_croaker_adintovirus	PRJNA556992_CONTIG_1104782	Larimichthys croaker adintovirus	19	14	10	CLUSTER10_Larimichthys_croaker_adintovirus\|1\|1	PRJNA556992_P_NODE_1104782_length_211_cov_8.036232_g1102591_i0\|Larimichthys_croaker_adintovirus\|NR\|1.05e-24\|NA	1	1	PRJNA556992	1104782	211	8.036232	16.95644952	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	104.0	1.05e-24	Larimichthys croaker adintovirus	Non-phage	NR	PRJNA556992_P_NODE_1104782_length_211_cov_8.036232_g1102591_i0	DAC81309.1 TPA_asm: integrase [Larimichthys croaker adintovirus]	DAC81309.1	2609857	g1102591	i0	69.1	4.848341232	68	21	96.7	0	6	209	30	97	1023	104.0	1.0	Viruses	Varidnaviria	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Larimichthys croaker adintovirus	Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Larimichthys croaker adintovirus		Larimichthys croaker adintovirus			Viruses		Viruses		104.0		1.05e-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);;