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

6 rows where analysis = "diamond", bioproject = "PRJNA725806" 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
27241813	27241813	PRJNA725806_P_NODE_137123_length_175_cov_1.652174_g136821_i0	PRJNA725806	137123	175	1.652174	2.8913045	Dothistroma septosporum gammaflexivirus 1	3104549	Viruses	Viruses	106	6.46e-25	NR	WPV70693.1	3104549	g136821	i0	87.9	0.994285714285714	58	7	99.4	0	174	1	412	469	WPV70693.1 MAG: replicase [Dothistroma septosporum gammaflexivirus 1]	diamond	174	106	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Gammaflexiviridae	Gammaflexivirus	Dothistroma septosporum gammaflexivirus 1
27463236	27463236	PRJNA725806_P_NODE_183583_length_154_cov_5.538462_g183281_i0	PRJNA725806	183583	154	5.538462	8.52923148	Photinus pyralis orthomyxo-like virus 1	2137183	Viruses	Viruses	60.8	4.52e-9	NR	AVR52565.1	2137183	g183281	i0	64.9	0.720779220779221	37	13	72.1	0	1	111	156	192	AVR52565.1 NP [Photinus pyralis orthomyxo-like virus 1]	diamond	111	60.8	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Photinus pyralis orthomyxo-like virus 1
29389292	29389292	PRJNA725806_P_NODE_99689_length_197_cov_6.700000_g99387_i0	PRJNA725806	99689	197	6.7	13.199	Orthopteran chu-related virus OKIAV152	2792595	Viruses	Viruses	58.2	7.36e-8	NR	QPL15390.1	2792595	g99387	i0	48	0.761421319796954	50	26	76.1	0	2	151	413	462	QPL15390.1 glycoprotein [Orthopteran chu-related virus OKIAV152]	diamond	150	58.2	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae		Orthopteran chu-related virus OKIAV152
32043737	32043737	PRJNA725806_P_NODE_112338_length_189_cov_1.861842_g112036_i0	PRJNA725806	112338	189	1.861842	3.51888138	Plasmopara viticola lesion associated mitovirus 27	2719453	Viruses	Viruses	69.7	5.51e-12	NR	QIR30250.1	2719453	g112036	i0	60.7	0.888888888888889	56	22	88.9	0	182	15	34	89	QIR30250.1 RNA-dependent RNA polymerase [Plasmopara viticola lesion associated mitovirus 27]	diamond	168	69.7	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Plasmopara viticola lesion associated mitovirus 27
32075403	32075403	PRJNA725806_P_NODE_40018_length_265_cov_4.298246_g39721_i0	PRJNA725806	40018	265	4.298246	11.3903519	Partitiviridae sp.	1955170	Viruses	Viruses	53.1	3.58e-6	NR	WWV86449.1	1955170	g39721	i0	38.2	1.00754716981132	89	51	96.2	1	261	7	69	157	WWV86449.1 MAG: putative capsid protein, partial [Partitiviridae sp.]	diamond	267	53.1	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Partitiviridae sp.
32613057	32613057	PRJNA725806_P_NODE_52520_length_245_cov_1.639423_g52223_i0	PRJNA725806	52520	245	1.639423	4.01658635	Blattodean orthomyxo-related virus OKIAV181	2746285	Viruses	Viruses	85.5	3.29e-17	NR	QMP82185.1	2746285	g52223	i0	53.9	0.930612244897959	76	35	93.1	0	230	3	376	451	QMP82185.1 nucleocapsid protein [Blattodean orthomyxo-related virus OKIAV181]	diamond	228	85.5	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Blattodean orthomyxo-related virus OKIAV181

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