metadata: contig_metadata: 5 rows where bioproject = "PRJNA492280" and tax

5 rows where bioproject = "PRJNA492280" and tax_phylum = "Pisuviricota"

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
452230	452230	PRJNA492280_P_NODE_8721_length_180_cov_5.538462_g8614_i0	PRJNA492280	8721	180	5.538462	9.9692316	Erysiphe necator associated partitivirus 2	2737084	Viruses	Viruses	99	1.93e-16	NTclustered	gi\|2273760843\|gb\|OL472009.1\|	2737084	g8614	i0	92.647	1.5	68	5	38	0	110	177	474	541	MAG: Erysiphe necator associated partitivirus 2 isolate KOP19SW segment RNA2, complete sequence	blastn	270	99	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Erysiphe necator associated partitivirus 2
1726635	1726635	PRJNA492280_P_NODE_1462_length_365_cov_5.649390_g1359_i0	PRJNA492280	1462	365	5.64939	20.6202735	Cladosporium cladosporioides partitivirus 1	3036362	Viruses	Viruses	353	8.48e-93	NTclustered	gi\|2465372832\|gb\|OP946875.1\|	3036362	g1359	i0	90.58	18.0602739726027	276	12	96	1	4	279	484	745	Cladosporium cladosporioides partitivirus 1 isolate AGS-CB3.2 segment RNA1, complete sequence	blastn	6592	353	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Cladosporium cladosporioides partitivirus 1
13205602	13205602	PRJNA492280_P_NODE_12471_length_164_cov_6.464567_g12364_i0	PRJNA492280	12471	164	6.464567	10.60188988	Sapovirus sp.	1906670	Viruses	Viruses	110	8.01e-20	NTclustered	gi\|2196304084\|gb\|MZ679047.1\|	1906670	g12364	i0	93.333	28.0792682926829	75	4	45	1	89	162	1461	1535	MAG: Sapovirus sp. isolate R16-k141_22382 polyprotein gene, partial cds	blastn	4605	110	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae	Sapovirus	Sapovirus sp.
16401440	16401440	PRJNA492280_P_NODE_1813_length_335_cov_2.580537_g1706_i0	PRJNA492280	1813	335	2.580537	8.64479895	Viruses	10239	Viruses	Viruses	60.2	1.89e-4	NTclustered	gi\|2167415105\|tpg\|BK059322.1\|	12271	g1706	i0	100	10.089552238806	32	0	10	0	185	216	3	34	TPA_asm: Arabis mosaic virus isolate SRR5788585_ArMV segment RNA1, complete sequence	blastn	3380	60.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus arabis
32447836	32447836	PRJNA492280_P_NODE_32679_length_150_cov_5.345133_g32572_i0	PRJNA492280	32679	150	5.345133	8.0176995	Plasmopara viticola lesion associated Partitivirus 3	2692001	Viruses	Viruses	43.9	0.0042	NR	QHD64799.1	2692001	g32572	i0	76	1.96	25	6	50	0	76	150	258	282	QHD64799.1 coat protein [Plasmopara viticola lesion associated Partitivirus 3]	diamond	294	43.9	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Plasmopara viticola lesion associated Partitivirus 3

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