metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_phylum = "Pisuviricota"

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_species
5237743	5237743	PRJEB73599_P_NODE_5_length_6284_cov_7.841886_g2_i0	PRJEB73599	5	6284	7.841886	492.78411624	Qianjiang marna-like virus 54	3347701	Viruses	Viruses	944	4.08e-291	NR	XHA88140.1	3347701	g2	i0	48.1	0.506524506683641	1061	518	49.6	14	5880	2767	686	1736	XHA88140.1 MAG: polyprotein [Qianjiang marna-like virus 54]	diamond	3183	944	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Qianjiang marna-like virus 54
27792375	27792375	PRJEB73599_P_NODE_124_length_1914_cov_3.293369_g88_i0	PRJEB73599	124	1914	3.293369	63.03508266	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	537	1.1899999999999995e-169	NR	XHA88175.1	3003959	g88	i0	44.2	0.996865203761755	636	347	98.9	7	1893	1	878	1510	XHA88175.1 MAG: polyprotein [Qianjiang marna-like virus 71]	diamond	1908	537	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Fish-associated picorna-like virus 3
27950231	27950231	PRJEB73599_P_NODE_9125_length_169_cov_1.785714_g8838_i0	PRJEB73599	9125	169	1.785714	3.01785666	Marnaviridae sp.	2715102	Viruses	Viruses	101	3.389999999999999e-23	NR	ULF99991.1	2715102	g8838	i0	82.1	0.994082840236686	56	10	99.4	0	2	169	2905	2960	ULF99991.1 MAG: hypothetical protein [Marnaviridae sp.]	diamond	168	101	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Marnaviridae sp.
28455521	28455521	PRJEB73599_P_NODE_8786_length_175_cov_1.842466_g8499_i0	PRJEB73599	8786	175	1.842466	3.2243155	Crogonang virus 69	3063080	Viruses	Viruses	106	6.45e-25	NR	WPR18350.1	3063080	g8499	i0	86.2	1.98857142857143	58	8	99.4	0	174	1	601	658	WPR18350.1 MAG: capsid protein [Crogonang virus 69]	diamond	348	106	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Crogonang virus 69
29433823	29433823	PRJEB73599_P_NODE_70_length_2346_cov_3.078981_g47_i0	PRJEB73599	70	2346	3.078981	72.23289426	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	295	1.1e-80	NR	XHA88175.1	3003959	g47	i0	43.9	0.818414322250639	319	179	40.8	0	1389	2345	202	520	XHA88175.1 MAG: polyprotein [Qianjiang marna-like virus 71]	diamond	1920	295	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Fish-associated picorna-like virus 3
30658827	30658827	PRJEB73599_P_NODE_7113_length_216_cov_1.636364_g6826_i0	PRJEB73599	7113	216	1.636364	3.53454624	Viruses	10239	Viruses	Viruses	135	4.05e-35	NR	URG14941.1	1530251	g6826	i0	80.3	4.93055555555556	71	14	98.6	0	3	215	211	281	URG14941.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	1065	136	0.992647058823529	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
32088838	32088838	PRJEB73599_P_NODE_2378_length_477_cov_2.689732_g2113_i0	PRJEB73599	2378	477	2.689732	12.83002164	Qianjiang marna-like virus 141	3347565	Viruses	Viruses	63.9	1.95e-8	NR	XHA88296.1	3347565	g2113	i0	30.5	1.19496855345912	190	98	98.1	7	469	2	531	720	XHA88296.1 MAG: polyprotein, partial [Qianjiang marna-like virus 141]	diamond	570	63.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Qianjiang marna-like virus 141
32120658	32120658	PRJEB73599_P_NODE_798_length_847_cov_2.193154_g642_i0	PRJEB73599	798	847	2.193154	18.57601438	Herophile durna-like virus	2912704	Viruses	Viruses	149	6.459999999999999e-37	NR	DAZ87252.1	2912704	g642	i0	40.4	0.701298701298701	198	112	68.7	4	1	582	373	568	DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus]	diamond	594	149	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales		Herophile durna-like virus

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