metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1068830" 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
27446796	27446796	PRJNA1068830_P_NODE_23_length_5215_cov_10.969078_g16_i0	PRJNA1068830	23	5215	10.969078	572.0374177	Conidiobolus chlamydosporus totivirus 2	2980976	Viruses	Viruses	73.2	1.11e-8	NR	UXL82819.1	2980976	g16	i0	26.6	0.522339405560882	331	194	17.9	10	3555	4487	239	540	UXL82819.1 RNA-dependent RNA polymerase [Conidiobolus chlamydosporus totivirus 2]	diamond	2724	73.2	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Conidiobolus chlamydosporus totivirus 2
27983267	27983267	PRJNA1068830_P_NODE_1305_length_1944_cov_2.760556_g1140_i0	PRJNA1068830	1305	1944	2.760556	53.66520864	Lentinula eaodes hypovirus 2	2992848	Viruses	Viruses	1196	0	NR	UZA97544.1	2992848	g1140	i0	95.4	0.945987654320988	613	28	94.6	0	104	1942	1	613	UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2]	diamond	1839	1196	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae	Hypovirus	Lentinula eaodes hypovirus 2
28330554	28330554	PRJNA1068830_P_NODE_64666_length_270_cov_1.187817_g63963_i0	PRJNA1068830	64666	270	1.187817	3.2071059	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	157	1.9999999999999998e-42	NR	WKU61618.1	3063761	g63963	i0	89.9	0.988888888888889	89	9	98.9	0	2	268	1664	1752	WKU61618.1 polyprotein [Zebrafish picornavirus 2]	diamond	267	157	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
28858862	28858862	PRJNA1068830_P_NODE_42328_length_341_cov_0.873134_g41625_i0	PRJNA1068830	42328	341	0.873134	2.97738694	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	107	1.84e-24	NR	WZI33513.1	3063761	g41625	i0	49.6	2.91202346041056	117	50	97.7	3	337	5	855	968	WZI33513.1 MAG: polyprotein, partial [Crohivirus A]	diamond	993	107	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Crohivirus	Danio blood picornavirus/Zebrafish picornavirus 2
30478180	30478180	PRJNA1068830_P_NODE_47813_length_317_cov_2.860656_g47110_i0	PRJNA1068830	47813	317	2.860656	9.06827952	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	105	8.66e-24	NR	AVM87439.1	3063761	g47110	i0	55.1	0.842271293375394	89	40	84.2	0	1	267	956	1044	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	267	105	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2

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