metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA609258" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA609258" and tax_superkingdom = "Viruses"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
22264587	22264587	PRJNA609258_P_NODE_418_length_2018_cov_5.794344_g379_i0	PRJNA609258	418	2018	5.794344	116.92986192	brine shrimp iflavirus 2	2900463	Viruses	Viruses	965	0	NR	UNI73846.1	2900463	g379	i0	67.7	0.985629335976214	663	207	98.6	3	3	1991	2364	3019	UNI73846.1 MAG: RNA-dependent RNA polymerase [brine shrimp iflavirus 2]	diamond	1989	965	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	brine shrimp iflavirus 2
26605090	26605090	PRJNA609258_P_NODE_1_length_7232_cov_13.570191_g0_i0	PRJNA609258	1	7232	13.570191	981.39621312	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	1524	0	NR	XBS25272.1	RQ08	g0	i0	39.9	0.936670353982301	2258	1225	90.8	44	89	6658	10	2203	XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1]	diamond	6774	1524	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
26985141	26985141	PRJNA609258_P_NODE_4702_length_903_cov_1.701205_g4408_i0	PRJNA609258	4702	903	1.701205	15.36188115	brine shrimp iflavirus 2	2900463	Viruses	Viruses	225	1.39e-62	NR	UNI73846.1	2900463	g4408	i0	43.8	0.933554817275748	281	147	92	5	46	876	2016	2289	UNI73846.1 MAG: RNA-dependent RNA polymerase [brine shrimp iflavirus 2]	diamond	843	225	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	brine shrimp iflavirus 2
27048570	27048570	PRJNA609258_P_NODE_2222_length_1232_cov_1.504745_g2035_i0	PRJNA609258	2222	1232	1.504745	18.5384584	Shuangao Insect Virus 3	1608077	Viruses	Viruses	167	4.61e-41	NR	AJG39286.1	1608077	g2035	i0	28.9	0.825487012987013	339	238	82.3	3	1221	208	644	980	AJG39286.1 glycoprotein precursor [Shuangao Insect Virus 3]	diamond	1017	167	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Peribunyaviridae		Shuangao Insect Virus 3
27522449	27522449	PRJNA609258_P_NODE_54863_length_247_cov_1.356322_g54478_i0	PRJNA609258	54863	247	1.356322	3.35011534	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	94.4	2.7e-20	NR	AVM87439.1	3063761	g54478	i0	60.6	0.801619433198381	66	26	80.2	0	200	3	1065	1130	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	198	94.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
28090770	28090770	PRJNA609258_P_NODE_44525_length_272_cov_1.020101_g44140_i0	PRJNA609258	44525	272	1.020101	2.77467472	brine shrimp iflavirus 2	2900463	Viruses	Viruses	132	2.29e-33	NR	UNI73846.1	2900463	g44140	i0	64.8	1.00367647058824	91	31	99.3	1	2	271	1630	1720	UNI73846.1 MAG: RNA-dependent RNA polymerase [brine shrimp iflavirus 2]	diamond	273	132	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	brine shrimp iflavirus 2
29132924	29132924	PRJNA609258_P_NODE_26529_length_365_cov_1.082192_g26144_i0	PRJNA609258	26529	365	1.082192	3.9500008	Narnavirus sp.	2587225	Viruses	Viruses	147	4.2999999999999997e-38	NR	CAK7594502.1	2587225	g26144	i0	55.5	0.978082191780822	119	52	97	1	362	9	104	222	CAK7594502.1 RNA-dependent RNA polymerase, partial [Narnavirus sp.]	diamond	357	147	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus sp.
30617139	30617139	PRJNA609258_P_NODE_1193_length_1521_cov_3.020718_g1086_i0	PRJNA609258	1193	1521	3.020718	45.94512078	Galbut virus	1654579	Viruses	Viruses	349	2.56e-111	NR	QMI58115.1	1654579	g1086	i0	39.1	0.978303747534517	496	293	97.2	6	33	1511	5	494	QMI58115.1 putative capsid protein [Galbut virus]	diamond	1488	349	1	Viruses							Galbut virus
30964953	30964953	PRJNA609258_P_NODE_26894_length_362_cov_1.349481_g26509_i0	PRJNA609258	26894	362	1.349481	4.88512122	Narnavirus sp.	2587225	Viruses	Viruses	165	1.87e-44	NR	CAK7594499.1	2587225	g26509	i0	64.2	0.994475138121547	120	41	99.4	1	361	2	308	425	CAK7594499.1 RNA-dependent RNA polymerase [Narnavirus sp.]	diamond	360	165	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus sp.
31122414	31122414	PRJNA609258_P_NODE_40115_length_290_cov_0.963134_g39730_i0	PRJNA609258	40115	290	0.963134	2.7930886	Galbut virus	1654579	Viruses	Viruses	102	4.89e-23	NR	WYZ56572.1	1654579	g39730	i0	57.8	0.858620689655172	83	35	85.9	0	290	42	344	426	WYZ56572.1 hypothetical protein, partial [Galbut virus]	diamond	249	102	1	Viruses							Galbut virus
31153993	31153993	PRJNA609258_P_NODE_21255_length_412_cov_1.684366_g20871_i0	PRJNA609258	21255	412	1.684366	6.93958792	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	119	4.2e-28	NR	AVM87439.1	3063761	g20871	i0	55.4	0.735436893203884	101	45	73.5	0	109	411	928	1028	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	303	119	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
31312427	31312427	PRJNA609258_P_NODE_6735_length_761_cov_4.507267_g6393_i0	PRJNA609258	6735	761	4.507267	34.30030187	Chaq virus	1654364	Viruses	Viruses	219	1.7099999999999998e-66	NR	AWY11087.1	1654364	g6393	i0	72.8	1.07227332457293	136	37	53.6	0	446	39	39	174	AWY11087.1 hypothetical protein [Chaq virus]	diamond	816	219	1	Viruses							Chaq virus
31913445	31913445	PRJNA609258_P_NODE_2217_length_1232_cov_3.449525_g2030_i0	PRJNA609258	2217	1232	3.449525	42.498148	Narnavirus sp.	2587225	Viruses	Viruses	65.1	1.58e-8	NR	CAK8705411.1	2587225	g2030	i0	34.4	0.730519480519481	128	73	30.7	3	1139	762	4	122	CAK8705411.1 uncharacterized [Narnavirus sp.]	diamond	900	65.1	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus sp.

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;