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

6 rows where analysis = "diamond", bioproject = "PRJNA1111082" 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
1490002	1490002	PRJNA1111082_P_NODE_2522_length_474_cov_1.723192_g2477_i0	PRJNA1111082	2522	474	1.723192	8.16793008	Microvirus sp.	2202559	Viruses	Viruses	285	2.0300000000000002e-91	NR	QJB19364.1	2202559	g2477	i0	87	0.974683544303797	154	20	97.5	0	464	3	372	525	QJB19364.1 MAG: major capsid protein [Microvirus sp.]	diamond	462	285	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
23167645	23167645	PRJNA1111082_P_NODE_2259_length_495_cov_4.843602_g2214_i0	PRJNA1111082	2259	495	4.843602	23.9758299	Microvirus sp.	2202559	Viruses	Viruses	193	1.0299999999999995e-55	NR	WNK13752.1	2202559	g2214	i0	64.4	1.95757575757576	160	56	97	1	481	2	128	286	WNK13752.1 MAG: major capsid protein [Microvirus sp.]	diamond	969	193	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
27162386	27162386	PRJNA1111082_P_NODE_11242_length_248_cov_2.497143_g11197_i0	PRJNA1111082	11242	248	2.497143	6.19291464	Microviridae sp.	2202644	Viruses	Viruses	140	2.3499999999999997e-37	NR	DAZ92347.1	2202644	g11197	i0	90.7	0.907258064516129	75	7	90.7	0	225	1	216	290	DAZ92347.1 TPA_asm: major capsid protein [Microviridae sp.]	diamond	225	140	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
28678563	28678563	PRJNA1111082_P_NODE_2767_length_457_cov_2.567708_g2722_i0	PRJNA1111082	2767	457	2.567708	11.73442556	Microvirus sp.	2202559	Viruses	Viruses	117	2.9799999999999997e-30	NR	WNK12592.1	2202559	g2722	i0	56.4	0.663019693654267	101	44	66.3	0	456	154	39	139	WNK12592.1 MAG: internal scaffolding protein [Microvirus sp.]	diamond	303	117	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
28867816	28867816	PRJNA1111082_P_NODE_6948_length_306_cov_0.927039_g6903_i0	PRJNA1111082	6948	306	0.927039	2.83673934	Microvirus sp.	2202559	Viruses	Viruses	198	2.2300000000000003e-58	NR	QJB19270.1	2202559	g6903	i0	96	0.990196078431373	101	4	99	0	1	303	395	495	QJB19270.1 MAG: major capsid protein [Microvirus sp.]	diamond	303	198	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
31837635	31837635	PRJNA1111082_P_NODE_7497_length_295_cov_1.531532_g7452_i0	PRJNA1111082	7497	295	1.531532	4.5180194	Microvirus sp.	2202559	Viruses	Viruses	137	2.17e-37	NR	QJB19831.1	2202559	g7452	i0	64.4	1.0271186440678	101	33	99.7	1	295	2	92	192	QJB19831.1 MAG: replication initiator protein [Microvirus sp.]	diamond	303	137	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);;