metadata: contig_metadata: 7 rows where bioproject = "PRJNA543299" and tax

7 rows where bioproject = "PRJNA543299" 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_species
19635680	19635680	PRJNA543299_P_NODE_17996_length_177_cov_1.593750_g17839_i0	PRJNA543299	17996	177	1.59375	2.8209375	Wigfec virus K19_94	2985971	Viruses	Viruses	139	1.1199999999999999e-28	NTclustered	gi\|2316504403\|gb\|OP549801.1\|	2985971	g17839	i0	83.007	1.7909604519774	153	26	86	0	6	158	1632	1480	MAG: Wigfec virus K19_94, complete genome	blastn	317	139	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Wigfec virus K19_94
27646767	27646767	PRJNA543299_P_NODE_18884_length_173_cov_1.112903_g18727_i0	PRJNA543299	18884	173	1.112903	1.92532219	Microviridae sp.	2202644	Viruses	Viruses	115	8.31e-30	NR	AXH76776.1	2202644	g18727	i0	89.5	1.97687861271676	57	6	98.8	0	172	2	200	256	AXH76776.1 MAG: replication initiator protein [Microviridae sp.]	diamond	342	115	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
30488660	30488660	PRJNA543299_P_NODE_23973_length_163_cov_0.894737_g23816_i0	PRJNA543299	23973	163	0.894737	1.45842131	Microvirus sp.	2202559	Viruses	Viruses	67	3.47e-11	NR	WNK14811.1	2202559	g23816	i0	55.8	1.91411042944785	52	23	95.7	0	157	2	4	55	WNK14811.1 MAG: major capsid protein [Microvirus sp.]	diamond	312	67	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
30646382	30646382	PRJNA543299_P_NODE_23793_length_163_cov_0.894737_g23636_i0	PRJNA543299	23793	163	0.894737	1.45842131	Ariapismic virus 246	3376488	Viruses	Viruses	91.7	1.62e-20	NR	XJW05561.1	3376488	g23636	i0	67.9	2.92638036809816	53	17	97.5	0	161	3	196	248	XJW05561.1 MAG: replication initiator protein [Ariapismic virus 246]	diamond	477	91.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Ariapismic virus 246
31816253	31816253	PRJNA543299_P_NODE_12917_length_208_cov_1.603774_g12760_i0	PRJNA543299	12917	208	1.603774	3.33584992	Microviridae sp.	2202644	Viruses	Viruses	97.1	3.36e-23	NR	QRQ90126.1	2202644	g12760	i0	72.9	6.02884615384615	70	17	98.1	1	204	1	111	180	QRQ90126.1 MAG: major capsid protein, partial [Microviridae sp.]	diamond	1254	97.1	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
32669984	32669984	PRJNA543299_P_NODE_11440_length_221_cov_1.087209_g11283_i0	PRJNA543299	11440	221	1.087209	2.40273189	Microvirus sp.	2202559	Viruses	Viruses	49.7	9.88e-5	NR	QJB19370.1	2202559	g11283	i0	84	1.09954751131222	25	4	33.9	0	75	1	2	26	QJB19370.1 MAG: major capsid protein [Microvirus sp.]	diamond	243	49.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
32795772	32795772	PRJNA543299_P_NODE_26280_length_161_cov_0.910714_g26123_i0	PRJNA543299	26280	161	0.910714	1.46624954	Arizlama microvirus	2859450	Viruses	Viruses	79.7	4.67e-16	NR	QXP08101.1	2859450	g26123	i0	71.2	1.93788819875776	52	15	96.9	0	6	161	150	201	QXP08101.1 MAG: replication initiator protein [Arizlama microvirus]	diamond	312	79.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Arizlama microvirus

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