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

8 rows where bioproject = "PRJNA1115053"

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
2976	2976	PRJNA1115053_CONTIG_17420\|Zebrafish_picornavirus_2\|CLUSTER1_Zebrafish_picornavirus_2\|1382\|320	Danio blood picornavirus/Zebrafish picornavirus 2	Novel	PRJNA1115053_CONTIG_17420\|Zebrafish_picornavirus_2	PRJNA1115053_CONTIG_17420	Zebrafish picornavirus 2	1369	320	1	CLUSTER1_Zebrafish_picornavirus_2\|1382\|320	PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0\|Zebrafish_picornavirus_2\|NR\|0\|NA	1370	320	PRJNA1115053	17420	481	60.929224	293.0695674	Zebrafish picornavirus 2	3063761	Viruses	Viruses	640.0	7.86e-179	Zebrafish picornavirus 2	Non-phage	NTclustered	PRJNA1115053_S_NODE_17420_length_481_cov_60.929224_g15634_i0	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	gi\|2551699335\|gb\|OK619588.1\|	3063761	g15634	i0	90.776	0.991683992	477	43	99.0	1	1	477	6633	7108	477	640.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 2	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2	Zebrafish picornavirus 2	Zebrafish picornavirus 2	gi\|2551699335\|gb\|OK619588.1\|	Viruses	Viruses	Viruses	Viruses	640.0	244.0	7.86e-179	1.35e-71
3196	3196	PRJNA1115053_CONTIG_295181\|Zebrafish_picornavirus_2\|CLUSTER1_Zebrafish_picornavirus_2\|1382\|320	Danio blood picornavirus/Zebrafish picornavirus 2	Novel	PRJNA1115053_CONTIG_295181\|Zebrafish_picornavirus_2	PRJNA1115053_CONTIG_295181	Zebrafish picornavirus 2	1369	320	1	CLUSTER1_Zebrafish_picornavirus_2\|1382\|320	PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0\|Zebrafish_picornavirus_2\|NR\|0\|NA	1370	320	PRJNA1115053	295181	162	2.571429	4.16571498	Zebrafish picornavirus 2	3063761	Viruses	Viruses	239.0	9.64e-59	Zebrafish picornavirus 2	Non-phage	NTclustered	PRJNA1115053_S_NODE_295181_length_162_cov_2.571429_g293364_i0	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	gi\|2551699335\|gb\|OK619588.1\|	3063761	g293364	i0	93.21	1.0	162	11	100.0	0	1	162	4595	4434	162	239.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 2	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2	Zebrafish picornavirus 2	Zebrafish picornavirus 2	gi\|2551699335\|gb\|OK619588.1\|	Viruses	Viruses	Viruses	Viruses	239.0	108.0	9.64e-59	5.860000000000001e-26
3197	3197	PRJNA1115053_CONTIG_323226\|Zebrafish_picornavirus_2\|CLUSTER1_Zebrafish_picornavirus_2\|1382\|320	Danio blood picornavirus/Zebrafish picornavirus 2	Novel	PRJNA1115053_CONTIG_323226\|Zebrafish_picornavirus_2	PRJNA1115053_CONTIG_323226	Zebrafish picornavirus 2	1369	320	1	CLUSTER1_Zebrafish_picornavirus_2\|1382\|320	PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0\|Zebrafish_picornavirus_2\|NR\|0\|NA	1370	320	PRJNA1115053	323226	155	2.401786	3.7227683	Zebrafish picornavirus 2	3063761	Viruses	Viruses	231.0	1.53e-56	Zebrafish picornavirus 2	Non-phage	NTclustered	PRJNA1115053_S_NODE_323226_length_155_cov_2.401786_g321409_i0	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	gi\|2551699335\|gb\|OK619588.1\|	3063761	g321409	i0	94.079	0.980645161	152	9	98.0	0	4	155	2298	2147	152	231.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 2	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2	Zebrafish picornavirus 2	Zebrafish picornavirus 2	gi\|2551699335\|gb\|OK619588.1\|	Viruses	Viruses	Viruses	Viruses	231.0	103.0	1.53e-56	4.1899999999999995e-24
3198	3198	PRJNA1115053_CONTIG_338679\|Zebrafish_picornavirus_2\|CLUSTER1_Zebrafish_picornavirus_2\|1382\|320	Danio blood picornavirus/Zebrafish picornavirus 2	Novel	PRJNA1115053_CONTIG_338679\|Zebrafish_picornavirus_2	PRJNA1115053_CONTIG_338679	Zebrafish picornavirus 2	1369	320	1	CLUSTER1_Zebrafish_picornavirus_2\|1382\|320	PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0\|Zebrafish_picornavirus_2\|NR\|0\|NA	1370	320	PRJNA1115053	338679	153	0.872727	1.33527231	Zebrafish picornavirus 2	3063761	Viruses	Viruses	255.0	8.900000000000001e-64	Zebrafish picornavirus 2	Non-phage	NTclustered	PRJNA1115053_S_NODE_338679_length_153_cov_0.872727_g336862_i0	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	gi\|2551699335\|gb\|OK619588.1\|	3063761	g336862	i0	96.753	1.006535948	154	4	100.0	1	1	153	2457	2304	154	255.0	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 2	Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2	Zebrafish picornavirus 2	Zebrafish picornavirus 2	gi\|2551699335\|gb\|OK619588.1\|	Viruses	Viruses	Viruses	Viruses	255.0	90.1	8.900000000000001e-64	2.27e-19
9419	9419	PRJNA1115053_CONTIG_332335\|Pimephales_minnow_adintovirus\|CLUSTER1_Pimephales_minnow_adintovirus\|59\|59	Pimephales minnow adintovirus	Endogenous or not fish-associated	PRJNA1115053_CONTIG_332335\|Pimephales_minnow_adintovirus	PRJNA1115053_CONTIG_332335	Pimephales minnow adintovirus	168	104	20	CLUSTER1_Pimephales_minnow_adintovirus\|59\|59	PRJNA551453_P_NODE_4881_length_284_cov_1.883117_g4799_i0\|Pimephales_minnow_adintovirus\|NR\|1.25e-07\|NA	52	52	PRJNA1115053	332335	153	1.9	2.907	Pimephales minnow adintovirus	2609864	Viruses	Viruses	56.2	1.24e-07	Pimephales minnow adintovirus	Non-phage	NR	PRJNA1115053_S_NODE_332335_length_153_cov_1.900000_g330518_i0	DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus]	DAC81394.1	2609864	g330518	i0	68.6	0.68627451	35	11	68.6	0	105	1	7	41	105	56.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		56.2		1.24e-07
10112	10112	PRJNA1115053_CONTIG_264227\|Larimichthys_croaker_adintovirus\|CLUSTER1_Larimichthys_croaker_adintovirus\|8\|6	Larimichthys croaker adintovirus	Insufficient Evidence	PRJNA1115053_CONTIG_264227\|Larimichthys_croaker_adintovirus	PRJNA1115053_CONTIG_264227	Larimichthys croaker adintovirus	19	14	10	CLUSTER1_Larimichthys_croaker_adintovirus\|8\|6	PRJNA1249042_S_NODE_6306_length_354_cov_2.350482_g6092_i0\|Adintovirus_corythoichthys13919\|NR\|1.1e-28\|NA	7	6	PRJNA1115053	264227	171	1.703125	2.91234375	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	90.5	9.22e-20	Larimichthys croaker adintovirus	Non-phage	NR	PRJNA1115053_S_NODE_264227_length_171_cov_1.703125_g262410_i0	DAC81309.1 TPA_asm: integrase [Larimichthys croaker adintovirus]	DAC81309.1	2609857	g262410	i0	75.0	2.929824561	56	14	98.2	0	3	170	155	210	501	90.5	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		90.5		9.22e-20
10113	10113	PRJNA1115053_CONTIG_303031\|Larimichthys_croaker_adintovirus\|CLUSTER1_Larimichthys_croaker_adintovirus\|8\|6	Larimichthys croaker adintovirus	Insufficient Evidence	PRJNA1115053_CONTIG_303031\|Larimichthys_croaker_adintovirus	PRJNA1115053_CONTIG_303031	Larimichthys croaker adintovirus	19	14	10	CLUSTER1_Larimichthys_croaker_adintovirus\|8\|6	PRJNA1249042_S_NODE_6306_length_354_cov_2.350482_g6092_i0\|Adintovirus_corythoichthys13919\|NR\|1.1e-28\|NA	7	6	PRJNA1115053	303031	160	2.461538	3.9384608	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	69.3	4.42e-12	Larimichthys croaker adintovirus	Non-phage	NR	PRJNA1115053_S_NODE_303031_length_160_cov_2.461538_g301214_i0	DAC81309.1 TPA_asm: integrase [Larimichthys croaker adintovirus]	DAC81309.1	2609857	g301214	i0	60.8	1.9125	51	20	95.6	0	153	1	230	280	306	69.3	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		69.3		4.42e-12
10163	10163	PRJNA1115053_CONTIG_84497\|Astyanax_tetra_cavefish_adintovirus\|CLUSTER2_Astyanax_tetra_cavefish_adintovirus\|6\|5	Astyanax tetra cavefish adintovirus	Insufficient Evidence	PRJNA1115053_CONTIG_84497\|Astyanax_tetra_cavefish_adintovirus	PRJNA1115053_CONTIG_84497	Astyanax tetra cavefish adintovirus	22	15	8	CLUSTER2_Astyanax_tetra_cavefish_adintovirus\|6\|5	PRJNA1034995_S_NODE_12562_length_616_cov_22.815009_g12451_i0\|Astyanax_tetra_cavefish_adintovirus\|NR\|1.35e-05\|NA	6	5	PRJNA1115053	84497	277	1.747863	4.84158051	Astyanax tetra cavefish adintovirus	2609866	Viruses	Viruses	45.1	0.00388	Astyanax tetra cavefish adintovirus	Non-phage	NR	PRJNA1115053_S_NODE_84497_length_277_cov_1.747863_g82680_i0	DAC81251.1 TPA_asm: Bcl2 [Astyanax tetra cavefish adintovirus]	DAC81251.1	2609866	g82680	i0	26.6	0.693140794	64	47	69.3	0	25	216	65	128	192	45.1	1.0	Viruses	Varidnaviria	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Astyanax tetra cavefish adintovirus	Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Astyanax tetra cavefish adintovirus		Astyanax tetra cavefish adintovirus			Viruses		Viruses		45.1		0.00388

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