metadata: viruses_fish_associated_curated: 8 rows where clusterLCA_curated = "African cichlid piscichuvirus", tax_family_NTorNR = "Chuviridae" and tax_species_NTorNR = "Salarius guttatus piscichuvirus"

8 rows where clusterLCA_curated = "African cichlid piscichuvirus", tax_family_NTorNR = "Chuviridae" and tax_species_NTorNR = "Salarius guttatus piscichuvirus"

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_NR	taxoncategory_NR	taxoncategorysimple_NR	bits_NR	evalue_NR
8037	8037	PRJNA1089179_CONTIG_3297\|Salarius_guttatus_piscichuvirus\|CLUSTER1_African_cichlid_piscichuvirus\|150\|125	African cichlid piscichuvirus	Endogenous or not fish-associated	PRJNA1089179_CONTIG_3297\|Salarius_guttatus_piscichuvirus	PRJNA1089179_CONTIG_3297	African cichlid piscichuvirus	151	125	2	CLUSTER1_African_cichlid_piscichuvirus\|150\|125	PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0\|African_cichlid_piscichuvirus\|NR\|2.83e-43\|NA	150	125	PRJNA1089179	3297	446	4.080429	18.19871334	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	100.0	1.82e-21	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA1089179_P_NODE_3297_length_446_cov_4.080429_g3279_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g3279	i0	39.9	1.029147982	153	87	99.6	2	2	445	2	154	459	100.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	100.0	1.82e-21
8041	8041	PRJNA1129168_CONTIG_3680\|Piscichuvirus\|CLUSTER1_African_cichlid_piscichuvirus\|150\|125	African cichlid piscichuvirus	Endogenous or not fish-associated	PRJNA1129168_CONTIG_3680\|Piscichuvirus	PRJNA1129168_CONTIG_3680	African cichlid piscichuvirus	151	125	2	CLUSTER1_African_cichlid_piscichuvirus\|150\|125	PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0\|African_cichlid_piscichuvirus\|NR\|2.83e-43\|NA	150	125	PRJNA1129168	3680	227	3.266304	7.41451008	Piscichuvirus	2842963	Viruses	Viruses	51.6	2.32e-05	Piscichuvirus	Non-phage	NR	PRJNA1129168_S_NODE_3680_length_227_cov_3.266304_g3642_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g3642	i0	39.1	1.691629956	64	39	84.6	0	193	2	98	161	384	52.0	0.992307692	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus	Piscichuvirus	Viruses	Viruses	51.6	2.32e-05
8060	8060	PRJNA1193812_CONTIG_5782\|Piscichuvirus\|CLUSTER1_African_cichlid_piscichuvirus\|150\|125	African cichlid piscichuvirus	Endogenous or not fish-associated	PRJNA1193812_CONTIG_5782\|Piscichuvirus	PRJNA1193812_CONTIG_5782	African cichlid piscichuvirus	151	125	2	CLUSTER1_African_cichlid_piscichuvirus\|150\|125	PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0\|African_cichlid_piscichuvirus\|NR\|2.83e-43\|NA	150	125	PRJNA1193812	5782	167	1.806452	3.01677484	Piscichuvirus	2842963	Viruses	Viruses	41.2	0.048	Piscichuvirus	Non-phage	NR	PRJNA1193812_S_NODE_5782_length_167_cov_1.806452_g5707_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g5707	i0	37.7	1.904191617	53	33	95.2	0	7	165	98	150	318	41.6	0.990384615	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus	Piscichuvirus	Viruses	Viruses	41.2	0.048
8088	8088	PRJNA255848_CONTIG_12126\|Salarius_guttatus_piscichuvirus\|CLUSTER1_African_cichlid_piscichuvirus\|150\|125	African cichlid piscichuvirus	Endogenous or not fish-associated	PRJNA255848_CONTIG_12126\|Salarius_guttatus_piscichuvirus	PRJNA255848_CONTIG_12126	African cichlid piscichuvirus	151	125	2	CLUSTER1_African_cichlid_piscichuvirus\|150\|125	PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0\|African_cichlid_piscichuvirus\|NR\|2.83e-43\|NA	150	125	PRJNA255848	12126	292	3.748971	10.94699532	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	57.8	3.67e-07	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA255848_P_NODE_12126_length_292_cov_3.748971_g11808_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g11808	i0	43.8	1.428082192	73	40	74.0	1	5	220	10	82	417	57.8	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	57.8	3.67e-07
8090	8090	PRJNA596867_CONTIG_12363\|Salarius_guttatus_piscichuvirus\|CLUSTER1_African_cichlid_piscichuvirus\|150\|125	African cichlid piscichuvirus	Endogenous or not fish-associated	PRJNA596867_CONTIG_12363\|Salarius_guttatus_piscichuvirus	PRJNA596867_CONTIG_12363	African cichlid piscichuvirus	151	125	2	CLUSTER1_African_cichlid_piscichuvirus\|150\|125	PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0\|African_cichlid_piscichuvirus\|NR\|2.83e-43\|NA	150	125	PRJNA596867	12363	248	1.44	3.5712	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	62.8	3.55e-09	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA596867_P_NODE_12363_length_248_cov_1.440000_g12288_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g12288	i0	45.9	0.89516129	74	39	88.3	1	247	29	6	79	222	62.8	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	62.8	3.55e-09
8136	8136	PRJNA293022_CONTIG_40988\|Salarius_guttatus_piscichuvirus\|CLUSTER1_African_cichlid_piscichuvirus\|150\|125	African cichlid piscichuvirus	Endogenous or not fish-associated	PRJNA293022_CONTIG_40988\|Salarius_guttatus_piscichuvirus	PRJNA293022_CONTIG_40988	African cichlid piscichuvirus	151	125	2	CLUSTER1_African_cichlid_piscichuvirus\|150\|125	PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0\|African_cichlid_piscichuvirus\|NR\|2.83e-43\|NA	150	125	PRJNA293022	40988	218	1.349112	2.94106416	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	47.8	0.000472	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA293022_P_NODE_40988_length_218_cov_1.349112_g40251_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g40251	i0	37.3	1.032110092	75	43	97.7	2	215	3	58	132	225	47.8	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	47.8	0.000472
8139	8139	PRJNA940501_CONTIG_46163\|Salarius_guttatus_piscichuvirus\|CLUSTER1_African_cichlid_piscichuvirus\|150\|125	African cichlid piscichuvirus	Endogenous or not fish-associated	PRJNA940501_CONTIG_46163\|Salarius_guttatus_piscichuvirus	PRJNA940501_CONTIG_46163	African cichlid piscichuvirus	151	125	2	CLUSTER1_African_cichlid_piscichuvirus\|150\|125	PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0\|African_cichlid_piscichuvirus\|NR\|2.83e-43\|NA	150	125	PRJNA940501	46163	290	8.720648	25.2898792	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	66.6	2.72e-10	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA940501_S_NODE_46163_length_290_cov_8.720648_g45345_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g45345	i0	46.8	0.817241379	79	41	80.7	1	1	234	4	82	237	66.6	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	66.6	2.72e-10
8141	8141	PRJNA884104_CONTIG_51839\|Salarius_guttatus_piscichuvirus\|CLUSTER1_African_cichlid_piscichuvirus\|150\|125	African cichlid piscichuvirus	Endogenous or not fish-associated	PRJNA884104_CONTIG_51839\|Salarius_guttatus_piscichuvirus	PRJNA884104_CONTIG_51839	African cichlid piscichuvirus	151	125	2	CLUSTER1_African_cichlid_piscichuvirus\|150\|125	PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0\|African_cichlid_piscichuvirus\|NR\|2.83e-43\|NA	150	125	PRJNA884104	51839	290	4.046083	11.7336407	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	70.9	8.81e-12	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA884104_S_NODE_51839_length_290_cov_4.046083_g51096_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g51096	i0	48.1	0.837931034	81	41	82.8	1	289	50	2	82	243	70.9	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	70.9	8.81e-12

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