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

10 rows where analysis = "diamond", bioproject = "PRJNA683669" 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
27283477	27283477	PRJNA683669_P_NODE_5443_length_553_cov_1.591667_g5215_i0	PRJNA683669	5443	553	1.591667	8.80191851	Phenuiviridae	1980418	Viruses	Viruses	71.2	4.55e-12	NR	YP_009665189.1	426788	g5215	i0	39.1	2.81012658227848	110	65	59.7	1	406	77	27	134	YP_009665189.1 N protein, partial [Frijoles virus VP-161A]	diamond	1554	71.2	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Phenuiviridae	Phlebovirus	Phlebovirus limboense
28345410	28345410	PRJNA683669_P_NODE_18966_length_296_cov_2.331839_g18734_i0	PRJNA683669	18966	296	2.331839	6.90224344	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	168	6.65e-46	NR	XCM67837.1	3003959	g18734	i0	73.5	0.993243243243243	98	26	99.3	0	3	296	1423	1520	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	294	168	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28345417	28345417	PRJNA683669_P_NODE_23586_length_266_cov_1.637306_g23354_i0	PRJNA683669	23586	266	1.637306	4.35523396	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	95.9	1.03e-20	NR	XCM67837.1	3003959	g23354	i0	49.4	0.981203007518797	87	44	98.1	0	261	1	1305	1391	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	261	95.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28408642	28408642	PRJNA683669_P_NODE_26026_length_251_cov_0.865169_g25794_i0	PRJNA683669	26026	251	0.865169	2.17157419	Atrato Picorna-like virus	2689353	Viruses	Viruses	82.8	3.36e-16	NR	QHA33691.1	2689353	g25794	i0	48.1	2.92828685258964	79	41	94.4	0	13	249	2468	2546	QHA33691.1 polyprotein, partial [Atrato Picorna-like virus]	diamond	735	82.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Atrato Picorna-like virus
30366946	30366946	PRJNA683669_P_NODE_52_length_3275_cov_5.090256_g43_i0	PRJNA683669	52	3275	5.090256	166.705884	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	607	9.069999999999999e-197	NR	XCM67838.1	3003959	g43	i0	34.9	0.924274809160305	1009	567	87.2	18	297	3152	46	1021	XCM67838.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	3027	607	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30808896	30808896	PRJNA683669_P_NODE_4974_length_579_cov_2.784585_g4747_i0	PRJNA683669	4974	579	2.784585	16.12274715	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	275	1.1199999999999999e-81	NR	XCM67837.1	3003959	g4747	i0	65.6	0.994818652849741	192	66	99.5	0	2	577	1521	1712	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	576	275	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31187691	31187691	PRJNA683669_P_NODE_335_length_1885_cov_2.080022_g281_i0	PRJNA683669	335	1885	2.080022	39.2084147	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	628	9.83e-204	NR	XCM67837.1	3003959	g281	i0	55.7	0.905570291777188	569	244	90.1	4	1758	61	310	873	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	1707	628	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31219277	31219277	PRJNA683669_P_NODE_7175_length_477_cov_1.898515_g6944_i0	PRJNA683669	7175	477	1.898515	9.05591655	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	142	1.09e-35	NR	XCM67837.1	3003959	g6944	i0	42.2	1.0125786163522	161	90	100	2	477	1	1035	1194	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	483	142	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31504456	31504456	PRJNA683669_P_NODE_2996_length_758_cov_1.572263_g2791_i0	PRJNA683669	2996	758	1.572263	11.91775354	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	137	1.0699999999999999e-32	NR	XCM67837.1	3003959	g2791	i0	54.5	0.530343007915567	134	57	52.2	3	756	361	129	260	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	402	137	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32674123	32674123	PRJNA683669_P_NODE_13140_length_357_cov_1.355634_g12909_i0	PRJNA683669	13140	357	1.355634	4.83961338	Downy mildew lesion associated splipalmivirus 6	2719531	Viruses	Viruses	50.8	1.92e-4	NR	WNA22215.1	2719531	g12909	i0	35.2	0.739495798319328	88	57	73.9	0	69	332	275	362	WNA22215.1 MAG: RdRp [Downy mildew lesion associated splipalmivirus 6]	diamond	264	50.8	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Downy mildew lesion associated splipalmivirus 6

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