metadata: contig_metadata: 4 rows where bioproject = "PRJNA1059246", tax_phylum = "Lenarviricota" and tax

4 rows where bioproject = "PRJNA1059246", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"

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
26718404	26718404	PRJNA1059246_P_NODE_21101_length_493_cov_1.976190_g20482_i0	PRJNA1059246	21101	493	1.97619	9.7426167	Sclerotinia sclerotiorum narnavirus 1	2822897	Viruses	Viruses	47	0.00951	NR	QZE12035.1	2822897	g20482	i0	29.2	0.979716024340771	161	85	95.5	5	477	7	75	210	QZE12035.1 MAG: hypothetical protein [Sclerotinia sclerotiorum narnavirus 1]	diamond	483	47	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Sclerotinia sclerotiorum narnavirus 1
26741923	26741923	PRJNA1059246_P_NODE_55901_length_271_cov_1.151515_g55275_i0	PRJNA1059246	55901	271	1.151515	3.12060565	Narnavirus	186767	Viruses	Viruses	70.9	6.42e-12	NR	QED22729.1	2601606	g55275	i0	43.1	5.00369003690037	72	41	79.7	0	9	224	264	335	QED22729.1 RNA-dependent RNA polymerase, partial [Botryosphaeria dothidea narnavirus 1]	diamond	1356	71.2	0.995786516853933	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Botryosphaeria dothidea narnavirus 1
27280171	27280171	PRJNA1059246_P_NODE_45043_length_312_cov_0.966527_g44417_i0	PRJNA1059246	45043	312	0.966527	3.01556424	Wolframvirales	2732502	Viruses	Viruses	70.1	2.13e-11	NR	WNA22212.1	2719525	g44417	i0	34.9	3.02884615384615	106	66	99	2	4	312	479	584	WNA22212.1 MAG: RdRp [Downy mildew lesion associated splipalmivirus 4]	diamond	945	70.5	0.994326241134752	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus italiense
31078217	31078217	PRJNA1059246_P_NODE_42755_length_322_cov_2.626506_g42129_i0	PRJNA1059246	42755	322	2.626506	8.45734932	Hebei narnavirus 5	3371271	Viruses	Viruses	67	2.76e-10	NR	XHY85189.1	3371271	g42129	i0	44.1	0.549689440993789	59	33	55	0	182	6	66	124	XHY85189.1 MAG: RNA-dependent RNA polymerase [Hebei narnavirus 5]	diamond	177	67	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Hebei narnavirus 5

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