metadata: viruses_fish_associated_curated: 11 rows where bioproject = "PRJNA1011844"

11 rows where bioproject = "PRJNA1011844"

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
4339	4339	PRJNA1011844_CONTIG_110093\|Cyprivirus_A\|CLUSTER1_Cyprivirus_A\|1164\|220	Zebrafish picornavirus 1	Known	PRJNA1011844_CONTIG_110093\|Cyprivirus_A	PRJNA1011844_CONTIG_110093	Cyprivirus A	1161	220	1	CLUSTER1_Cyprivirus_A\|1164\|220	PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0\|Cyprivirus_A\|NTclustered\|0\|NA	1164	220	PRJNA1011844	110093	302	3.978166	12.01406132	Cyprivirus A	2304617	Viruses	Viruses	479.0	1.0900000000000001e-130	Cyprivirus A	Non-phage	NTclustered	PRJNA1011844_P_NODE_110093_length_302_cov_3.978166_g101518_i0	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	gi\|1812398529\|gb\|MN524064.1\|	2563826	g101518	i0	97.173	2.867549669	283	8	94.0	0	4	286	2936	2654	866	479.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Cyprivirus A	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1	Cyprivirus A	Zebrafish picornavirus 1	gi\|1812398529\|gb\|MN524064.1\|	Viruses	Viruses	Viruses	Viruses	479.0	183.0	1.0900000000000001e-130	2.95e-51
4340	4340	PRJNA1011844_CONTIG_111076\|Cyprivirus_A\|CLUSTER1_Cyprivirus_A\|1164\|220	Zebrafish picornavirus 1	Known	PRJNA1011844_CONTIG_111076\|Cyprivirus_A	PRJNA1011844_CONTIG_111076	Cyprivirus A	1161	220	1	CLUSTER1_Cyprivirus_A\|1164\|220	PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0\|Cyprivirus_A\|NTclustered\|0\|NA	1164	220	PRJNA1011844	111076	300	2.647577	7.942731	Cyprivirus A	2304617	Viruses	Viruses	486.0	6.46e-133	Cyprivirus A	Non-phage	NTclustered	PRJNA1011844_P_NODE_111076_length_300_cov_2.647577_g102501_i0	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	gi\|2500378199\|ref\|NC_076245.1\|	2563826	g102501	i0	96.599	2.94	294	9	98.0	1	7	300	7113	7405	882	486.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Cyprivirus A	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1	Cyprivirus A	Zebrafish picornavirus 1	gi\|2500378199\|ref\|NC_076245.1\|	Viruses	Viruses	Viruses	Viruses	486.0	195.0	6.46e-133	1.88e-55
4349	4349	PRJNA1011844_CONTIG_129672\|Cyprivirus_A\|CLUSTER1_Cyprivirus_A\|1164\|220	Zebrafish picornavirus 1	Known	PRJNA1011844_CONTIG_129672\|Cyprivirus_A	PRJNA1011844_CONTIG_129672	Cyprivirus A	1161	220	1	CLUSTER1_Cyprivirus_A\|1164\|220	PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0\|Cyprivirus_A\|NTclustered\|0\|NA	1164	220	PRJNA1011844	129672	270	1.477157	3.9883239	Cyprivirus A	2304617	Viruses	Viruses	429.0	9.78e-116	Cyprivirus A	Non-phage	NTclustered	PRJNA1011844_P_NODE_129672_length_270_cov_1.477157_g121094_i0	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	gi\|2500378199\|ref\|NC_076245.1\|	2563826	g121094	i0	96.875	2.840740741	256	8	95.0	0	12	267	6240	6495	767	429.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Cyprivirus A	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1	Cyprivirus A	Zebrafish picornavirus 1	gi\|2500378199\|ref\|NC_076245.1\|	Viruses	Viruses	Viruses	Viruses	429.0	172.0	9.78e-116	2.1400000000000002e-47
4350	4350	PRJNA1011844_CONTIG_138730\|Cyprivirus_A\|CLUSTER1_Cyprivirus_A\|1164\|220	Zebrafish picornavirus 1	Known	PRJNA1011844_CONTIG_138730\|Cyprivirus_A	PRJNA1011844_CONTIG_138730	Cyprivirus A	1161	220	1	CLUSTER1_Cyprivirus_A\|1164\|220	PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0\|Cyprivirus_A\|NTclustered\|0\|NA	1164	220	PRJNA1011844	138730	259	1.38172	3.5786548	Cyprivirus A	2304617	Viruses	Viruses	322.0	1.6299999999999999e-83	Cyprivirus A	Non-phage	NTclustered	PRJNA1011844_P_NODE_138730_length_259_cov_1.381720_g130152_i0	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	gi\|1812398529\|gb\|MN524064.1\|	2563826	g130152	i0	90.535	2.822393822	243	23	94.0	0	17	259	5017	5259	731	322.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Cyprivirus A	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1	Cyprivirus A	Zebrafish picornavirus 1	gi\|1812398529\|gb\|MN524064.1\|	Viruses	Viruses	Viruses	Viruses	322.0	153.0	1.6299999999999999e-83	7.32e-41
4354	4354	PRJNA1011844_CONTIG_152621\|Cyprivirus_A\|CLUSTER1_Cyprivirus_A\|1164\|220	Zebrafish picornavirus 1	Known	PRJNA1011844_CONTIG_152621\|Cyprivirus_A	PRJNA1011844_CONTIG_152621	Cyprivirus A	1161	220	1	CLUSTER1_Cyprivirus_A\|1164\|220	PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0\|Cyprivirus_A\|NTclustered\|0\|NA	1164	220	PRJNA1011844	152621	246	3.514451	8.64554946	Cyprivirus A	2304617	Viruses	Viruses	385.0	1.93e-102	Cyprivirus A	Non-phage	NTclustered	PRJNA1011844_P_NODE_152621_length_246_cov_3.514451_g144041_i0	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	gi\|2500378199\|ref\|NC_076245.1\|	2563826	g144041	i0	96.552	2.837398374	232	8	94.0	0	11	242	2282	2513	698	385.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Cyprivirus A	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Zebrafish picornavirus 1	Cyprivirus A	Zebrafish picornavirus 1	gi\|2500378199\|ref\|NC_076245.1\|	Viruses	Viruses	Viruses	Viruses	385.0	159.0	1.93e-102	4.29e-43
9780	9780	PRJNA1011844_CONTIG_66165\|Pimephales_minnow_adintovirus\|CLUSTER2_Pimephales_minnow_adintovirus\|26\|21	Pimephales minnow adintovirus	Endogenous or not fish-associated	PRJNA1011844_CONTIG_66165\|Pimephales_minnow_adintovirus	PRJNA1011844_CONTIG_66165	Pimephales minnow adintovirus	168	104	20	CLUSTER2_Pimephales_minnow_adintovirus\|26\|21	PRJNA812715_P_NODE_14567_length_975_cov_4.294900_g13176_i0\|Pimephales_minnow_adintovirus\|NR\|8.15e-07\|NA	25	20	PRJNA1011844	66165	479	2.568966	12.30534714	Pimephales minnow adintovirus	2609864	Viruses	Viruses	52.0	0.000171	Pimephales minnow adintovirus	Non-phage	NR	PRJNA1011844_P_NODE_66165_length_479_cov_2.568966_g57734_i0	DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus]	DAC81404.1	2609864	g57734	i0	29.0	1.872651357	100	70	62.0	1	109	405	25	124	897	52.0	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		52.0		0.000171
9849	9849	PRJNA1011844_CONTIG_127958\|Pimephales_minnow_adintovirus\|CLUSTER3_Pimephales_minnow_adintovirus\|19\|15	Pimephales minnow adintovirus	Endogenous or not fish-associated	PRJNA1011844_CONTIG_127958\|Pimephales_minnow_adintovirus	PRJNA1011844_CONTIG_127958	Pimephales minnow adintovirus	168	104	20	CLUSTER3_Pimephales_minnow_adintovirus\|19\|15	PRJEB66218_P_NODE_46828_length_500_cov_1.141230_g44412_i0\|Pimephales_minnow_adintovirus\|NR\|1e-20\|NA	19	15	PRJNA1011844	127958	272	2.427136	6.60180992	Pimephales minnow adintovirus	2609864	Viruses	Viruses	86.7	1.78e-18	Pimephales minnow adintovirus	Non-phage	NR	PRJNA1011844_P_NODE_127958_length_272_cov_2.427136_g119380_i0	DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus]	DAC81394.1	2609864	g119380	i0	52.9	1.863970588	85	40	93.8	0	13	267	89	173	507	87.4	0.991990847	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		86.7		1.78e-18
9850	9850	PRJNA1011844_CONTIG_134740\|Pimephales_minnow_adintovirus\|CLUSTER3_Pimephales_minnow_adintovirus\|19\|15	Pimephales minnow adintovirus	Endogenous or not fish-associated	PRJNA1011844_CONTIG_134740\|Pimephales_minnow_adintovirus	PRJNA1011844_CONTIG_134740	Pimephales minnow adintovirus	168	104	20	CLUSTER3_Pimephales_minnow_adintovirus\|19\|15	PRJEB66218_P_NODE_46828_length_500_cov_1.141230_g44412_i0\|Pimephales_minnow_adintovirus\|NR\|1e-20\|NA	19	15	PRJNA1011844	134740	263	4.915789	12.92852507	Pimephales minnow adintovirus	2609864	Viruses	Viruses	78.2	2.79e-15	Pimephales minnow adintovirus	Non-phage	NR	PRJNA1011844_P_NODE_134740_length_263_cov_4.915789_g126162_i0	DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus]	DAC81394.1	2609864	g126162	i0	51.2	1.950570342	84	41	95.8	0	10	261	91	174	513	78.6	0.994910941	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		78.2		2.79e-15
9881	9881	PRJNA1011844_CONTIG_148736\|Pimephales_minnow_adintovirus\|CLUSTER4_Pimephales_minnow_adintovirus\|18\|15	Pimephales minnow adintovirus	Endogenous or not fish-associated	PRJNA1011844_CONTIG_148736\|Pimephales_minnow_adintovirus	PRJNA1011844_CONTIG_148736	Pimephales minnow adintovirus	168	104	20	CLUSTER4_Pimephales_minnow_adintovirus\|18\|15	PRJNA523184_P_NODE_1012_length_470_cov_4.248276_g948_i0\|Pimephales_minnow_adintovirus\|NR\|7.76e-34\|NA	18	15	PRJNA1011844	148736	249	1.431818	3.56522682	Pimephales minnow adintovirus	2609864	Viruses	Viruses	75.1	2.67e-15	Pimephales minnow adintovirus	Non-phage	NR	PRJNA1011844_P_NODE_148736_length_249_cov_1.431818_g140157_i0	DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus]	DAC81395.1	2609864	g140157	i0	50.6	0.951807229	79	39	95.2	0	7	243	5	83	237	75.1	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		75.1		2.67e-15
9940	9940	PRJNA1011844_CONTIG_121595\|Pimephales_minnow_adintovirus\|CLUSTER5_Pimephales_minnow_adintovirus\|15\|11	Pimephales minnow adintovirus	Endogenous or not fish-associated	PRJNA1011844_CONTIG_121595\|Pimephales_minnow_adintovirus	PRJNA1011844_CONTIG_121595	Pimephales minnow adintovirus	168	104	20	CLUSTER5_Pimephales_minnow_adintovirus\|15\|11	PRJNA745923_S_NODE_10260_length_324_cov_1.163701_g9928_i0\|Pimephales_minnow_adintovirus\|NR\|6.57e-29\|NA	15	11	PRJNA1011844	121595	281	1.971154	5.53894274	Pimephales minnow adintovirus	2609864	Viruses	Viruses	71.2	1.5e-12	Pimephales minnow adintovirus	Non-phage	NR	PRJNA1011844_P_NODE_121595_length_281_cov_1.971154_g113018_i0	DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus]	DAC81394.1	2609864	g113018	i0	54.8	0.779359431	73	33	77.9	0	225	7	7	79	219	71.2	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		71.2		1.5e-12
10224	10224	PRJNA1011844_CONTIG_119137\|Pimephales_minnow_adintovirus\|CLUSTER10_Pimephales_minnow_adintovirus\|3\|3	Pimephales minnow adintovirus	Endogenous or not fish-associated	PRJNA1011844_CONTIG_119137\|Pimephales_minnow_adintovirus	PRJNA1011844_CONTIG_119137	Pimephales minnow adintovirus	168	104	20	CLUSTER10_Pimephales_minnow_adintovirus\|3\|3	PRJNA1011844_P_NODE_119137_length_285_cov_1.259434_g110560_i0\|Pimephales_minnow_adintovirus\|NR\|5.54e-07\|NA	3	3	PRJNA1011844	119137	285	1.259434	3.5893869	Pimephales minnow adintovirus	2609864	Viruses	Viruses	54.3	5.54e-07	Pimephales minnow adintovirus	Non-phage	NR	PRJNA1011844_P_NODE_119137_length_285_cov_1.259434_g110560_i0	DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus]	DAC81395.1	2609864	g110560	i0	51.0	0.515789474	49	24	51.6	0	256	110	60	108	147	54.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		54.3		5.54e-07

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