metadata: contig_metadata: 6 rows where bioproject = "PRJNA615175" and tax

6 rows where bioproject = "PRJNA615175" and tax_kingdom = "Sangervirae"

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
3146033	3146033	PRJNA615175_P_NODE_4963_length_693_cov_3.169355_g4801_i0	PRJNA615175	4963	693	3.169355	21.96363015	Microviridae sp.	2202644	Viruses	Viruses	63.5	1.3e-7	NR	AXH76550.1	2202644	g4801	i0	58.7	0.199134199134199	46	19	19.9	0	556	693	1	46	AXH76550.1 MAG: major capsid protein [Microviridae sp.]	diamond	138	63.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
27269890	27269890	PRJNA615175_P_NODE_143_length_2533_cov_4.561789_g129_i0	PRJNA615175	143	2533	4.561789	115.55011537	Microviridae sp.	2202644	Viruses	Viruses	351	2.4999999999999994e-110	NR	AXH73229.1	2202644	g129	i0	47.8	2.21121200157916	366	154	43.1	3	1499	408	1	331	AXH73229.1 MAG: replication initiator protein [Microviridae sp.]	diamond	5601	351	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
27901392	27901392	PRJNA615175_P_NODE_9485_length_479_cov_1.896552_g9317_i0	PRJNA615175	9485	479	1.896552	9.08448408	Malazfec virus 5	3112671	Viruses	Viruses	96.3	9.76e-20	NR	WVR22137.1	3112671	g9317	i0	75	1.69102296450939	60	15	37.6	0	478	299	593	652	WVR22137.1 MAG: major capsid protein [Malazfec virus 5]	diamond	810	96.3	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus	Malazfec virus 5
29259028	29259028	PRJNA615175_P_NODE_6569_length_594_cov_2.596929_g6404_i0	PRJNA615175	6569	594	2.596929	15.42575826	Microviridae sp.	2202644	Viruses	Viruses	273	8.060000000000001e-85	NR	AXH75328.1	2202644	g6404	i0	65.3	4.02020202020202	202	62	100	3	1	594	435	632	AXH75328.1 MAG: major capsid protein [Microviridae sp.]	diamond	2388	273	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
29827472	29827472	PRJNA615175_P_NODE_1091_length_1378_cov_4.294253_g1006_i0	PRJNA615175	1091	1378	4.294253	59.17480634	Microviridae sp.	2202644	Viruses	Viruses	168	9.189999999999999e-43	NR	AXH76181.1	2202644	g1006	i0	56.4	0.709724238026125	165	67	35.9	2	5	499	197	356	AXH76181.1 MAG: replication initiator protein [Microviridae sp.]	diamond	978	168	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
32166945	32166945	PRJNA615175_P_NODE_2318_length_1008_cov_3.436364_g2199_i0	PRJNA615175	2318	1008	3.436364	34.63854912	Flyfo microvirus Tbat2_116	2907267	Viruses	Viruses	217	4.16e-61	NR	UIB81444.1	2907267	g2199	i0	40.9	0.99702380952381	335	176	95.8	9	966	1	129	454	UIB81444.1 major capsid protein [Flyfo microvirus Tbat2_116]	diamond	1005	217	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Flyfo microvirus Tbat2_116

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