metadata: contig_metadata: 5 rows where bioproject = "PRJNA356682", tax_phylum = "Pisuviricota" and tax

5 rows where bioproject = "PRJNA356682", tax_phylum = "Pisuviricota" 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
28148821	28148821	PRJNA356682_P_NODE_3185_length_817_cov_4.658602_g2565_i0	PRJNA356682	3185	817	4.658602	38.06077834	Beihai sipunculid worm virus 6	1922678	Viruses	Viruses	114	2.5699999999999997e-24	NR	YP_009333562.1	1922678	g2565	i0	35.2	0.793145654834761	216	127	77.5	5	817	185	535	742	YP_009333562.1 polyprotein [Beihai sipunculid worm virus 6]	diamond	648	114	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae	Deltahypovirus	Deltahypovirus sipunculidi
28180060	28180060	PRJNA356682_P_NODE_906_length_1678_cov_7.350779_g569_i0	PRJNA356682	906	1678	7.350779	123.34607162	Sichuan sediment hypo-like virus 1	2824573	Viruses	Viruses	325	1.24e-95	NR	QYF49601.1	2824573	g569	i0	34.3	1.99165673420739	571	354	99.6	8	6	1676	180	743	QYF49601.1 MAG: polyprotein, partial [Sichuan sediment hypo-like virus 1]	diamond	3342	325	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae		Sichuan sediment hypo-like virus 1
28386784	28386784	PRJNA356682_P_NODE_3086_length_831_cov_8.138522_g2473_i0	PRJNA356682	3086	831	8.138522	67.63111782	Deltahypovirus	2948675	Viruses	Viruses	145	2.8099999999999997e-35	NR	YP_009333562.1	1922678	g2473	i0	35.9	1.88086642599278	259	156	93.1	7	7	780	2379	2628	YP_009333562.1 polyprotein [Beihai sipunculid worm virus 6]	diamond	1563	145	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae	Deltahypovirus	Deltahypovirus sipunculidi
30548726	30548726	PRJNA356682_P_NODE_6913_length_535_cov_5.138528_g6226_i0	PRJNA356682	6913	535	5.138528	27.4911248	Jiangsu sediment hypo-like virus 2	2824572	Viruses	Viruses	66.6	3.92e-9	NR	QYF49615.1	2824572	g6226	i0	31.5	0.71214953271028	127	78	67.3	5	66	425	1114	1238	QYF49615.1 MAG: polyprotein [Jiangsu sediment hypo-like virus 2]	diamond	381	66.6	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae		Jiangsu sediment hypo-like virus 2
32382760	32382760	PRJNA356682_P_NODE_1079_length_1513_cov_4.670139_g697_i0	PRJNA356682	1079	1513	4.670139	70.65920307	Yunnan sediment hypo-like virus	2824570	Viruses	Viruses	455	2.2199999999999993e-152	NR	QYF49612.1	2824570	g697	i0	54.1	0.876404494382023	442	201	87.4	2	191	1513	86	526	QYF49612.1 MAG: polyprotein, partial [Yunnan sediment hypo-like virus]	diamond	1326	455	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae		Yunnan sediment hypo-like virus

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