metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA564013" 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
550209	550209	PRJNA564013_P_NODE_2781_length_1843_cov_8.554994_g2046_i0	PRJNA564013	2781	1843	8.554994	157.66853942	Microviridae sp.	2202644	Viruses	Viruses	516	2.14e-172	NR	AXH73345.1	2202644	g2046	i0	52.3	2.55236028214867	518	241	84.3	4	1778	225	7	518	AXH73345.1 MAG: major capsid protein [Microviridae sp.]	diamond	4704	516	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
27110671	27110671	PRJNA564013_P_NODE_21842_length_792_cov_19.630643_g19522_i0	PRJNA564013	21842	792	19.630643	155.47469256	Microvirus sp.	2202559	Viruses	Viruses	143	1.4e-38	NR	QJB21229.1	2202559	g19522	i0	56.7	0.962121212121212	127	53	47.3	1	157	531	7	133	QJB21229.1 MAG: hypothetical protein [Microvirus sp.]	diamond	762	143	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
29510708	29510708	PRJNA564013_P_NODE_91270_length_426_cov_9.619178_g88437_i0	PRJNA564013	91270	426	9.619178	40.97769828	Microvirus sp.	2202559	Viruses	Viruses	68.9	1.29e-12	NR	QJB21244.1	2202559	g88437	i0	81	0.295774647887324	42	8	29.6	0	293	418	1	42	QJB21244.1 MAG: hypothetical protein [Microvirus sp.]	diamond	126	68.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
29984519	29984519	PRJNA564013_P_NODE_304591_length_222_cov_6.403727_g301739_i0	PRJNA564013	304591	222	6.403727	14.21627394	Microvirus sp.	2202559	Viruses	Viruses	64.3	6.87e-10	NR	QJB21242.1	2202559	g301739	i0	52.5	0.797297297297297	59	28	79.7	0	177	1	274	332	QJB21242.1 MAG: replication initiator protein [Microvirus sp.]	diamond	177	64.3	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
31248280	31248280	PRJNA564013_P_NODE_25235_length_747_cov_2.962099_g22800_i0	PRJNA564013	25235	747	2.962099	22.12687953	Microviridae sp.	2202644	Viruses	Viruses	84.3	6.44e-15	NR	AXH73040.1	2202644	g22800	i0	43.4	0.48995983935743	122	69	49	0	539	174	5	126	AXH73040.1 MAG: DNA pilot protein [Microviridae sp.]	diamond	366	84.3	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
31406572	31406572	PRJNA564013_P_NODE_242656_length_267_cov_8.883495_g239804_i0	PRJNA564013	242656	267	8.883495	23.71893165	Microvirus sp.	2202559	Viruses	Viruses	61.2	1.55e-8	NR	QJB21225.1	2202559	g239804	i0	41	2.60674157303371	78	41	85.4	2	28	255	128	202	QJB21225.1 MAG: major capsid protein [Microvirus sp.]	diamond	696	61.2	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus 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);;