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

11 rows where bioproject = "PRJNA784979" and tax_phylum = "Phixviricota"

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
765562	765562	PRJNA784979_S_NODE_2721_length_280_cov_1.047619_g2679_i0	PRJNA784979	2721	280	1.047619	2.9333332	Viruses	10239	Viruses	Viruses	112	8.84e-27	NR	QJB19036.1	2202559	g2679	i0	65.2	2.93571428571429	89	29	95.4	1	7	273	224	310	QJB19036.1 MAG: major capsid protein [Microvirus sp.]	diamond	822	113	0.991150442477876	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
765597	765597	PRJNA784979_S_NODE_9141_length_173_cov_2.354839_g9099_i0	PRJNA784979	9141	173	2.354839	4.07387147	Viruses	10239	Viruses	Viruses	107	1.8e-25	NR	QJB20026.1	2202559	g9099	i0	86	3	57	8	98.8	0	172	2	391	447	QJB20026.1 MAG: major capsid protein [Microvirus sp.]	diamond	519	108	0.990740740740741	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
16068056	16068056	PRJNA784979_S_NODE_2773_length_277_cov_1.482456_g2731_i0	PRJNA784979	2773	277	1.482456	4.10640312	Microviridae sp.	2202644	Viruses	Viruses	168	2.1799999999999998e-47	NR	AXH78032.1	2202644	g2731	i0	87.8	0.974729241877256	90	10	96.4	1	1	267	142	231	AXH78032.1 MAG: major capsid protein [Microviridae sp.]	diamond	270	168	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
16068059	16068059	PRJNA784979_S_NODE_3293_length_255_cov_1.509709_g3251_i0	PRJNA784979	3293	255	1.509709	3.84975795	Microvirus sp.	2202559	Viruses	Viruses	108	4.87e-19	NTclustered	gi\|2581532572\|gb\|OR350093.1\|	2202559	g3251	i0	76.498	3.61960784313725	217	40	84	8	7	219	3819	3610	MAG: Microvirus sp. isolate LSWO_53 clone LS326, complete genome	blastn	923	108	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
26864126	26864126	PRJNA784979_S_NODE_13881_length_155_cov_2.424528_g13839_i0	PRJNA784979	13881	155	2.424528	3.7580184	Microvirus sp.	2202559	Viruses	Viruses	54.7	4.51e-8	NR	QJB20030.1	2202559	g13839	i0	70	0.580645161290323	30	9	58.1	0	6	95	55	84	QJB20030.1 MAG: nonstructural protein [Microvirus sp.]	diamond	90	54.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
27116638	27116638	PRJNA784979_S_NODE_10522_length_167_cov_0.686441_g10480_i0	PRJNA784979	10522	167	0.686441	1.14635647	Microvirus sp.	2202559	Viruses	Viruses	78.6	8.79e-17	NR	WNK12609.1	2202559	g10480	i0	69.2	0.934131736526946	52	16	93.4	0	3	158	34	85	WNK12609.1 MAG: internal scaffolding protein [Microvirus sp.]	diamond	156	78.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
28421160	28421160	PRJNA784979_S_NODE_6046_length_201_cov_1.046053_g6004_i0	PRJNA784979	6046	201	1.046053	2.10256653	Viruses	10239	Viruses	Viruses	53.1	2.3e-6	NR	AZL83007.1	2494750	g6004	i0	50	2.94029850746269	62	31	92.5	0	195	10	68	129	AZL83007.1 DNA pilot protein [Apis mellifera associated microvirus 22]	diamond	591	53.5	0.992523364485981	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Apis mellifera associated microvirus 22
28506422	28506422	PRJNA784979_S_NODE_3467_length_249_cov_1.060000_g3425_i0	PRJNA784979	3467	249	1.06	2.6394	Flumine microvirus 11	2940828	Viruses	Viruses	111	1.2e-28	NR	UQB76403.1	2940828	g3425	i0	85	0.72289156626506	60	9	72.3	0	67	246	1	60	UQB76403.1 replication associated protein [Flumine microvirus 11]	diamond	180	111	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Flumine microvirus 11
28831315	28831315	PRJNA784979_S_NODE_10028_length_168_cov_1.176471_g9986_i0	PRJNA784979	10028	168	1.176471	1.97647128	Viruses	10239	Viruses	Viruses	49.7	2.34e-5	NR	QJB19797.1	2202559	g9986	i0	71.9	2.30357142857143	32	9	57.1	0	108	13	16	47	QJB19797.1 MAG: DNA pilot protein [Microvirus sp.]	diamond	387	49.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
28916644	28916644	PRJNA784979_S_NODE_6448_length_196_cov_1.666667_g6406_i0	PRJNA784979	6448	196	1.666667	3.26666732	Microviridae sp.	2202644	Viruses	Viruses	63.5	1.97e-10	NR	XOF06387.1	2202644	g6406	i0	67.3	0.795918367346939	52	17	79.6	0	2	157	68	119	XOF06387.1 MAG: hypothetical protein [Microviridae sp.]	diamond	156	63.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
31001608	31001608	PRJNA784979_S_NODE_7714_length_184_cov_1.740741_g7672_i0	PRJNA784979	7714	184	1.740741	3.20296344	Microviridae sp.	2202644	Viruses	Viruses	77.4	1.02e-14	NR	AXH78032.1	2202644	g7672	i0	80	2.18478260869565	45	9	73.4	0	136	2	1	45	AXH78032.1 MAG: major capsid protein [Microviridae sp.]	diamond	402	77.4	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);;