metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA874604" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA874604" and tax_kingdom = "Orthornavirae"

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
27213065	27213065	PRJNA874604_P_NODE_19542_length_407_cov_1.089820_g19190_i0	PRJNA874604	19542	407	1.08982	4.4355674	Macluravirus YMCTCRI-	1551381	Viruses	Viruses	89.4	9.36e-19	NR	AIS22410.1	1551381	g19190	i0	48.2	1.59213759213759	110	42	75.9	2	312	4	9	110	AIS22410.1 polyprotein, partial [Macluravirus YMCTCRI-02]	diamond	648	89.4	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Macluravirus	Macluravirus YMCTCRI-02
27624087	27624087	PRJNA874604_P_NODE_32344_length_335_cov_1.175573_g31992_i0	PRJNA874604	32344	335	1.175573	3.93816955	Yam chlorotic necrosis virus	2175329	Viruses	Viruses	187	1.5399999999999996e-52	NR	YP_010086840.1	2175329	g31992	i0	85.6	0.994029850746269	111	16	99.4	0	335	3	915	1025	YP_010086840.1 polyprotein [Yam chlorotic necrosis virus]	diamond	333	187	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Macluravirus	Macluravirus dioscoreaflavinecrosis
30023819	30023819	PRJNA874604_P_NODE_91291_length_244_cov_0.900585_g90939_i0	PRJNA874604	91291	244	0.900585	2.1974274	Chinese yam necrotic mosaic virus	128818	Viruses	Viruses	87	1e-17	NR	AJD23391.1	128818	g90939	i0	78.5	0.971311475409836	79	17	97.1	0	1	237	1323	1401	AJD23391.1 polyprotein [Chinese yam necrotic mosaic virus]	diamond	237	87	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Macluravirus	Macluravirus dioscoreachinense
30181525	30181525	PRJNA874604_P_NODE_80352_length_247_cov_1.293103_g80000_i0	PRJNA874604	80352	247	1.293103	3.19396441	Yam chlorotic necrosis virus	2175329	Viruses	Viruses	123	2.07e-30	NR	YP_010086840.1	2175329	g80000	i0	85.1	0.813765182186235	67	10	81.4	0	2	202	2240	2306	YP_010086840.1 polyprotein [Yam chlorotic necrosis virus]	diamond	201	123	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Macluravirus	Macluravirus dioscoreaflavinecrosis
30403202	30403202	PRJNA874604_P_NODE_59293_length_267_cov_1.561856_g58941_i0	PRJNA874604	59293	267	1.561856	4.17015552	Skomarfal virus 47	3063349	Viruses	Viruses	43.9	0.0191	NR	WPR18547.1	3063349	g58941	i0	41.4	1.68539325842697	58	26	56.2	1	228	79	128	185	WPR18547.1 MAG: hypothetical protein [Skomarfal virus 47]	diamond	450	43.9	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Skomarfal virus 47
31920166	31920166	PRJNA874604_P_NODE_57837_length_270_cov_1.172589_g57485_i0	PRJNA874604	57837	270	1.172589	3.1659903	Orthomarburgvirus marburgense	3052505	Viruses	Viruses	183	2.53e-51	NR	AAR85459.1	3052505	g57485	i0	100	3.95555555555556	89	0	98.9	0	268	2	1186	1274	AAR85459.1 L protein [Orthomarburgvirus marburgense]	diamond	1068	183	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Filoviridae	Orthomarburgvirus	Orthomarburgvirus marburgense

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