metadata: contig_metadata: 11 rows where bioproject = "PRJNA206070" and tax

11 rows where bioproject = "PRJNA206070" 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
23318595	23318595	PRJNA206070_S_NODE_30379_length_153_cov_2.043103_g28503_i0	PRJNA206070	30379	153	2.043103	3.12594759	Dulem virus 233	3145710	Viruses	Viruses	78.6	8.91e-16	NR	XCD03252.1	3145710	g28503	i0	60	1.98039215686275	50	20	98	0	2	151	84	133	XCD03252.1 replication initiator protein [Dulem virus 233]	diamond	303	78.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus	Dulem virus 233
28810492	28810492	PRJNA206070_S_NODE_11048_length_349_cov_4.089744_g9172_i0	PRJNA206070	11048	349	4.089744	14.27320656	Microviridae sp.	2202644	Viruses	Viruses	106	4.8799999999999994e-24	NR	AXH76319.1	2202644	g9172	i0	67.1	0.679083094555874	79	22	67.9	1	101	337	419	493	AXH76319.1 MAG: major capsid protein [Microviridae sp.]	diamond	237	106	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
29491630	29491630	PRJNA206070_S_NODE_27610_length_162_cov_1.248000_g25734_i0	PRJNA206070	27610	162	1.248	2.02176	Viruses	10239	Viruses	Viruses	68.6	9.72e-12	NR	CAI9750303.1	2202559	g25734	i0	77.3	6.48148148148148	44	10	81.5	0	159	28	294	337	CAI9750303.1 major head protein, partial [Microvirus sp.]	diamond	1050	68.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
30358820	30358820	PRJNA206070_S_NODE_4092_length_957_cov_9.835870_g2441_i0	PRJNA206070	4092	957	9.83587	94.1292759	bajarodmic virus 953	3344344	Viruses	Viruses	79.7	1.33e-12	NR	XHH71191.1	3344344	g2441	i0	57.5	0.250783699059561	80	32	25.1	1	81	320	20	97	XHH71191.1 DNA pilot protein [bajarodmic virus 953]	diamond	240	79.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus	bajarodmic virus 953
30642514	30642514	PRJNA206070_S_NODE_12373_length_315_cov_2.384892_g10497_i0	PRJNA206070	12373	315	2.384892	7.5124098	Microviridae sp.	2202644	Viruses	Viruses	44.3	0.0237	NR	AXH76316.1	2202644	g10497	i0	47.1	0.647619047619048	68	27	64.8	3	235	32	75	133	AXH76316.1 MAG: hypothetical protein [Microviridae sp.]	diamond	204	44.3	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
30800545	30800545	PRJNA206070_S_NODE_26874_length_165_cov_1.179688_g24998_i0	PRJNA206070	26874	165	1.179688	1.9464852	Microviridae sp.	2202644	Viruses	Viruses	48.5	2.25e-5	NR	AYQ58191.1	2202644	g24998	i0	52	0.909090909090909	50	22	90.9	1	151	2	16	63	AYQ58191.1 hypothetical protein [Microviridae sp.]	diamond	150	48.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
31116367	31116367	PRJNA206070_S_NODE_2795_length_1722_cov_13.697923_g1467_i0	PRJNA206070	2795	1722	13.697923	235.87823406	Microvirus sp.	2202559	Viruses	Viruses	150	2.01e-35	NR	QRV61984.1	2202559	g1467	i0	38.1	0.35191637630662	202	102	33.8	4	622	41	17	203	QRV61984.1 replication initiator protein [Microvirus sp.]	diamond	606	150	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
32192129	32192129	PRJNA206070_S_NODE_8398_length_445_cov_6.389706_g6526_i0	PRJNA206070	8398	445	6.389706	28.4341917	Dulem virus 233	3145710	Viruses	Viruses	75.9	3.29e-13	NR	XCD03252.1	3145710	g6526	i0	49.3	0.465168539325843	69	34	45.8	1	220	17	8	76	XCD03252.1 replication initiator protein [Dulem virus 233]	diamond	207	75.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus	Dulem virus 233
32399813	32399813	PRJNA206070_S_NODE_3779_length_1069_cov_4.097868_g2193_i0	PRJNA206070	3779	1069	4.097868	43.80620892	Microvirus	10842	Viruses	Viruses	243	1.19e-70	NR	AXH76319.1	2202644	g2193	i0	62.8	1.02712815715622	183	67	51.4	1	52	600	505	686	AXH76319.1 MAG: major capsid protein [Microviridae sp.]	diamond	1098	243	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
32634397	32634397	PRJNA206070_S_NODE_2360_length_2223_cov_10.012351_g1191_i0	PRJNA206070	2360	2223	10.012351	222.57456273	Microvirus sp.	2202559	Viruses	Viruses	429	2.0899999999999996e-137	NR	QRV61985.1	2202559	g1191	i0	41	0.855600539811066	634	303	77.9	18	1783	53	7	626	QRV61985.1 major capsid protein [Microvirus sp.]	diamond	1902	429	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
32729163	32729163	PRJNA206070_S_NODE_17760_length_228_cov_2.387435_g15884_i0	PRJNA206070	17760	228	2.387435	5.4433518	Microviridae sp.	2202644	Viruses	Viruses	73.6	1.66e-13	NR	AXH76320.1	2202644	g15884	i0	50	0.973684210526316	74	34	97.4	2	2	223	127	197	AXH76320.1 MAG: replication initiator protein [Microviridae sp.]	diamond	222	73.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae 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);;