metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA559720" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA559720" and tax_kingdom = "Orthornavirae"

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
15846281	15846281	PRJNA559720_P_NODE_1133_length_887_cov_1.783784_g1053_i0	PRJNA559720	1133	887	1.783784	15.82216408	Picornaviridae sp.	1530251	Viruses	Viruses	352	1.52e-111	NR	URG14823.1	1530251	g1053	i0	55.2	1.00450958286359	297	131	99.8	1	885	1	360	656	URG14823.1 MAG: capsid protein [Picornaviridae sp.]	diamond	891	352	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
27584436	27584436	PRJNA559720_P_NODE_1684_length_768_cov_2.746763_g1579_i0	PRJNA559720	1684	768	2.746763	21.09513984	Liverwort associated bunyavirus 4	2933082	Viruses	Viruses	50.8	0.00406	NR	CAI5383880.1	2933082	g1579	i0	30.4	0.48828125	125	78	47.7	2	369	4	179	297	CAI5383880.1 RNA-dependent RNA polymerase, partial [Liverwort associated bunyavirus 4]	diamond	375	50.8	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Liverwort associated bunyavirus 4
28815561	28815561	PRJNA559720_P_NODE_10908_length_291_cov_0.967890_g10769_i0	PRJNA559720	10908	291	0.96789	2.8165599	Burswood narna-like virus	3118308	Viruses	Viruses	75.5	2.05e-13	NR	WVL03117.1	3118308	g10769	i0	44.8	0.989690721649485	96	42	99	1	2	289	606	690	WVL03117.1 RdRp [Burswood narna-like virus]	diamond	288	75.5	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Burswood narna-like virus
28815565	28815565	PRJNA559720_P_NODE_13908_length_250_cov_0.870056_g13769_i0	PRJNA559720	13908	250	0.870056	2.17514	Aulacomnium heterostichum bunyavirus 1	2933070	Viruses	Viruses	57.4	2.94e-7	NR	CAI5383856.1	2933070	g13769	i0	43.1	1.788	72	38	84	2	247	38	1560	1630	CAI5383856.1 RNA-dependent RNA polymerase [Aulacomnium heterostichum bunyavirus 1]	diamond	447	57.4	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Aulacomnium heterostichum bunyavirus 1
29163417	29163417	PRJNA559720_P_NODE_13269_length_254_cov_1.276243_g13130_i0	PRJNA559720	13269	254	1.276243	3.24165722	Phytophthora cinnamomi ormycovirus 7-5	3239326	Viruses	Viruses	45.1	0.00636	NR	XDO01624.1	3239326	g13130	i0	34.5	0.992125984251969	84	55	99.2	0	253	2	320	403	XDO01624.1 hypothetical protein [Phytophthora cinnamomi ormycovirus 7-5]	diamond	252	45.1	1	Viruses	Orthornavirae		Orpoviricetes	Bormycovirales	Alphaormycoviridae	Phormycovirus	Phormycovirus phytophthorae
30363736	30363736	PRJNA559720_P_NODE_4132_length_511_cov_1.582192_g3998_i0	PRJNA559720	4132	511	1.582192	8.08500112	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	188	1.2e-51	NR	AVM87439.1	3063761	g3998	i0	51.4	1.01565557729941	173	77	97.5	1	498	1	933	1105	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	519	188	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
30363743	30363743	PRJNA559720_P_NODE_8832_length_334_cov_0.885057_g8693_i0	PRJNA559720	8832	334	0.885057	2.95609038	Neofusicoccum parvum narnavirus 1	2587532	Viruses	Viruses	59.7	1.19e-7	NR	WAK75278.1	2587532	g8693	i0	36	1.79640718562874	100	61	89.8	1	29	328	2	98	WAK75278.1 MAG: RNA-dependent RNA polymerase, partial [Neofusicoccum parvum narnavirus 1]	diamond	600	59.7	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Neofusicoccum parvum narnavirus 1
30647415	30647415	PRJNA559720_P_NODE_2893_length_605_cov_1.563910_g2771_i0	PRJNA559720	2893	605	1.56391	9.4616555000000009	Ustilaginoidea virens narna-like virus 3	2972018	Viruses	Viruses	69.3	7.97e-10	NR	UVX28911.1	2972018	g2771	i0	32.3	0.813223140495868	164	92	74.4	6	2	451	839	997	UVX28911.1 MAG: RNA dependent RNA polymerase [Ustilaginoidea virens narna-like virus 3]	diamond	492	69.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Ustilaginoidea virens narna-like virus 3
30837234	30837234	PRJNA559720_P_NODE_16014_length_242_cov_0.911243_g15875_i0	PRJNA559720	16014	242	0.911243	2.20520806	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	102	2.7499999999999995e-23	NR	YP_010796394.1	RQ13	g15875	i0	57	1.94628099173554	79	34	97.9	0	238	2	2244	2322	YP_010796394.1 polyprotein [Wenling triplecross lizardfish picornavirus]	diamond	471	102	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Symapivirus	Zebrafish jaw picornavirus
32671017	32671017	PRJNA559720_P_NODE_4300_length_502_cov_2.771562_g4163_i0	PRJNA559720	4300	502	2.771562	13.91324124	Picornaviridae sp.	1530251	Viruses	Viruses	205	3.999999999999999e-58	NR	URG14823.1	1530251	g4163	i0	70.5	0.872509960159363	146	43	87.3	0	1	438	729	874	URG14823.1 MAG: capsid protein [Picornaviridae sp.]	diamond	438	205	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae 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);;