metadata: contig_metadata: 17 rows where bioproject = "PRJNA760904" and tax

17 rows where bioproject = "PRJNA760904" 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
27242724	27242724	PRJNA760904_P_NODE_5323_length_371_cov_1.654362_g5266_i0	PRJNA760904	5323	371	1.654362	6.13768302	Picornaviridae sp.	1530251	Viruses	Viruses	130	1.4399999999999999e-32	NR	URG14993.1	1530251	g5266	i0	80.6	0.582210242587601	72	8	53.4	1	369	172	92	163	URG14993.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	216	130	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
27410718	27410718	PRJNA760904_P_NODE_17643_length_246_cov_0.890173_g17586_i0	PRJNA760904	17643	246	0.890173	2.18982558	Viruses	10239	Viruses	Viruses	43.1	0.0282	NR	ULG00012.1	2715102	g17586	i0	31.3	1.91463414634146	80	55	97.6	0	245	6	730	809	ULG00012.1 MAG: hypothetical protein 2 [Marnaviridae sp.]	diamond	471	43.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
27779790	27779790	PRJNA760904_P_NODE_13804_length_257_cov_1.434783_g13747_i0	PRJNA760904	13804	257	1.434783	3.68739231	Avian associated picorna-like virus 32	3066390	Viruses	Viruses	61.2	1.39e-8	NR	WPR16526.1	3066390	g13747	i0	36.3	1.06225680933852	91	51	98.1	2	257	6	715	805	WPR16526.1 MAG: RNA-dependent RNA polymerase, partial [Avian associated picorna-like virus 32]	diamond	273	61.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Avian associated picorna-like virus 32
27937637	27937637	PRJNA760904_P_NODE_8245_length_311_cov_1.294118_g8188_i0	PRJNA760904	8245	311	1.294118	4.02470698	Fusarium solani virus 1	1511847	Viruses	Viruses	112	1.7700000000000002e-26	NR	NP_624350.1	1511847	g8188	i0	49	1.7556270096463	100	49	96.5	1	311	12	274	371	NP_624350.1 RNA-dependent RNA polymerase [Fusarium solani virus 1]	diamond	546	112	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Gammapartitivirus	Gammapartitivirus fusarii
28916077	28916077	PRJNA760904_P_NODE_21128_length_234_cov_2.037267_g21071_i0	PRJNA760904	21128	234	2.037267	4.76720478	Picornaviridae sp.	1530251	Viruses	Viruses	150	1.3899999999999999e-40	NR	URG14993.1	1530251	g21071	i0	91	1	78	7	100	0	1	234	479	556	URG14993.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	234	150	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29074413	29074413	PRJNA760904_P_NODE_8628_length_305_cov_1.659483_g8571_i0	PRJNA760904	8628	305	1.659483	5.06142315	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	125	6.879999999999999e-31	NR	XCM68103.1	3003959	g8571	i0	60.2	0.963934426229508	98	39	96.4	0	305	12	305	402	XCM68103.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.]	diamond	294	125	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29295220	29295220	PRJNA760904_P_NODE_969_length_772_cov_3.067239_g919_i0	PRJNA760904	969	772	3.067239	23.67908508	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	330	7.969999999999999e-104	NR	XCM68104.1	3003959	g919	i0	65.2	0.983160621761658	253	85	97.9	3	4	759	194	444	XCM68104.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	759	330	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29516048	29516048	PRJNA760904_P_NODE_15890_length_249_cov_0.875000_g15833_i0	PRJNA760904	15890	249	0.875	2.17875	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	81.3	1.11e-15	NR	XCM68248.1	3003959	g15833	i0	45.8	2	83	44	98.8	1	247	2	843	925	XCM68248.1 MAG: structural polyprotein, partial [Picornavirales sp.]	diamond	498	81.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29895262	29895262	PRJNA760904_P_NODE_12731_length_265_cov_1.630208_g12674_i0	PRJNA760904	12731	265	1.630208	4.3200512	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	133	8.01e-34	NR	XCM68104.1	3003959	g12674	i0	69	0.984905660377358	87	27	98.5	0	265	5	118	204	XCM68104.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	261	133	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30716494	30716494	PRJNA760904_P_NODE_13794_length_257_cov_1.559783_g13737_i0	PRJNA760904	13794	257	1.559783	4.00864231	Picornaviridae sp.	1530251	Viruses	Viruses	157	2.5299999999999992e-43	NR	URG14993.1	1530251	g13737	i0	89.4	0.992217898832685	85	9	99.2	0	256	2	315	399	URG14993.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	255	157	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
31064397	31064397	PRJNA760904_P_NODE_3895_length_422_cov_2.022923_g3838_i0	PRJNA760904	3895	422	2.022923	8.53673506	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	119	4.43e-28	NR	XCM68104.1	3003959	g3838	i0	50	0.938388625592417	132	65	93.1	1	2	394	733	864	XCM68104.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	396	119	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31095689	31095689	PRJNA760904_P_NODE_9015_length_298_cov_2.448889_g8958_i0	PRJNA760904	9015	298	2.448889	7.29768922	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	130	9.999999999999999e-33	NR	XCM68388.1	3003959	g8958	i0	65.7	1.02684563758389	102	30	98.7	2	3	296	139	239	XCM68388.1 MAG: helicase, partial [Picornavirales sp.]	diamond	306	130	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32266340	32266340	PRJNA760904_P_NODE_1198_length_701_cov_2.636943_g1145_i0	PRJNA760904	1198	701	2.636943	18.48497043	Fusarium solani virus 1	1511847	Viruses	Viruses	94.4	3.4e-18	NR	NP_624350.1	1511847	g1145	i0	35.8	3.36804564907275	179	106	73.2	4	518	6	42	219	NP_624350.1 RNA-dependent RNA polymerase [Fusarium solani virus 1]	diamond	2361	94.4	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Gammapartitivirus	Gammapartitivirus fusarii
32298102	32298102	PRJNA760904_P_NODE_10779_length_281_cov_1.288462_g10722_i0	PRJNA760904	10779	281	1.288462	3.62057822	Qianjiang picorna-like virus 26	3348750	Viruses	Viruses	47	0.00198	NR	XHA88479.1	3348750	g10722	i0	42.6	0.99288256227758	47	26	49.1	1	17	154	2510	2556	XHA88479.1 MAG: polyprotein [Qianjiang picorna-like virus 26]	diamond	279	47	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 26
32392638	32392638	PRJNA760904_P_NODE_16819_length_247_cov_1.787356_g16762_i0	PRJNA760904	16819	247	1.787356	4.41476932	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	67.8	5.79e-11	NR	XCM68103.1	3003959	g16762	i0	55.8	0.631578947368421	52	23	63.2	0	158	3	153	204	XCM68103.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.]	diamond	156	67.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32676697	32676697	PRJNA760904_P_NODE_8820_length_302_cov_1.253275_g8763_i0	PRJNA760904	8820	302	1.253275	3.7848905	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	115	1.5600000000000002e-27	NR	XCM68103.1	3003959	g8763	i0	54.3	1.04304635761589	105	42	99.3	2	3	302	180	283	XCM68103.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.]	diamond	315	115	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32875419	32875419	PRJNA760904_P_NODE_12160_length_270_cov_1.111675_g12103_i0	PRJNA760904	12160	270	1.111675	3.0015225	Locarnavirus	2560169	Viruses	Viruses	84.7	8.76e-17	NR	XCM68250.1	1955153	g12103	i0	47.9	2.34444444444444	71	37	78.9	0	56	268	385	455	XCM68250.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	633	84.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Picornavirales 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);;