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

6 rows where analysis = "diamond", bioproject = "PRJNA1123436" 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
27828383	27828383	PRJNA1123436_P_NODE_65844_length_307_cov_1.645299_g64630_i0	PRJNA1123436	65844	307	1.645299	5.05106793	brine shrimp arlivirus 5	2900380	Viruses	Viruses	170	4.21e-49	NR	UNI74090.1	2900380	g64630	i0	84	0.977198697068404	100	16	97.7	0	306	7	251	350	UNI74090.1 MAG: hypothetical protein [brine shrimp arlivirus 5]	diamond	300	170	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
28491499	28491499	PRJNA1123436_P_NODE_77267_length_283_cov_1.290476_g76053_i0	PRJNA1123436	77267	283	1.290476	3.65204708	brine shrimp toti-like virus 1	2900477	Viruses	Viruses	132	1.39e-33	NR	UNI73990.1	2900477	g76053	i0	70.6	1.80212014134276	85	25	90.1	0	25	279	132	216	UNI73990.1 MAG: capsid protein [brine shrimp toti-like virus 1]	diamond	510	132	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		brine shrimp toti-like virus 1
30407305	30407305	PRJNA1123436_P_NODE_24913_length_522_cov_1.525612_g23706_i0	PRJNA1123436	24913	522	1.525612	7.96369464	Viruses	10239	Viruses	Viruses	107	3.11e-23	NR	AVM87441.1	2116205	g23706	i0	36.8	2.11494252873563	185	101	99.4	4	520	2	1020	1200	AVM87441.1 polyprotein [Wenling rattails picornavirus]	diamond	1104	108	0.990740740740741	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Wenling rattails picornavirus
30860131	30860131	PRJNA1123436_P_NODE_65174_length_309_cov_1.080508_g63960_i0	PRJNA1123436	65174	309	1.080508	3.33876972	brine shrimp arlivirus 8	2900383	Viruses	Viruses	49.3	3.88e-4	NR	UNI74120.1	2900383	g63960	i0	39.7	0.563106796116505	58	35	56.3	0	183	10	1	58	UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8]	diamond	174	49.3	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsaeighalis
31524088	31524088	PRJNA1123436_P_NODE_18536_length_621_cov_0.956204_g17342_i0	PRJNA1123436	18536	621	0.956204	5.93802684	brine shrimp arlivirus 5	2900380	Viruses	Viruses	187	9.47e-53	NR	UNI74091.1	2900380	g17342	i0	49.5	0.995169082125604	206	104	99.5	0	1	618	160	365	UNI74091.1 MAG: hypothetical protein [brine shrimp arlivirus 5]	diamond	618	187	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
32093327	32093327	PRJNA1123436_P_NODE_112938_length_245_cov_2.156977_g111724_i0	PRJNA1123436	112938	245	2.156977	5.28459365	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	70.5	6.64e-12	NR	AVM87418.1	3063761	g111724	i0	62	1.17551020408163	50	16	58.8	2	146	3	779	827	AVM87418.1 polyprotein [Yancheng osbecks grenadier anchovy picornavirus]	diamond	288	70.5	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);;