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

5 rows where analysis = "diamond", bioproject = "PRJNA1067370" 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
27762388	27762388	PRJNA1067370_P_NODE_117344_length_228_cov_3.870968_g116795_i0	PRJNA1067370	117344	228	3.870968	8.82580704	Hangzhou cletus punctiger lispivirus 1	2905566	Viruses	Viruses	68.2	3.27e-11	NR	YP_010805220.1	2905566	g116795	i0	62.5	0.631578947368421	48	18	63.2	0	9	152	262	309	YP_010805220.1 MAG: hypothetical protein QKV05_gp3 [Hangzhou cletus punctiger lispivirus 1]	diamond	144	68.2	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Hemipvirus	Hemipvirus veri
28267166	28267166	PRJNA1067370_P_NODE_59986_length_280_cov_1.115942_g59437_i0	PRJNA1067370	59986	280	1.115942	3.1246376	Marine RNA virus JP-B	439016	Viruses	Viruses	65.1	8.18e-10	NR	YP_001429584.1	439016	g59437	i0	40	1.07142857142857	100	53	99.6	3	279	1	268	367	YP_001429584.1 hypothetical protein JP-B_gp2 [Marine RNA virus JP-B]	diamond	300	65.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Locarnavirus	Locarnavirus jerichoensis
29814375	29814375	PRJNA1067370_P_NODE_31_length_6458_cov_5.867659_g7_i0	PRJNA1067370	31	6458	5.867659	378.93341822	Hepelivirales sp.	2809460	Viruses	Viruses	997	0	NR	WAY16397.1	2809460	g7	i0	93.3	0.24852895633323	535	36	24.9	0	4445	2841	1	535	WAY16397.1 nonstructural polyprotein, partial [Hepelivirales sp.]	diamond	1605	997	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales			Hepelivirales sp.
31204145	31204145	PRJNA1067370_P_NODE_24275_length_387_cov_1.471338_g23727_i0	PRJNA1067370	24275	387	1.471338	5.69407806	Paecilomyces variotii partitivirus 1	3041005	Viruses	Viruses	118	4.9799999999999993e-29	NR	BEG63714.1	3041005	g23727	i0	54.8	0.806201550387597	104	47	80.6	0	75	386	265	368	BEG63714.1 coat protein [Paecilomyces variotii partitivirus 1]	diamond	312	118	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Paecilomyces variotii partitivirus 1
31742173	31742173	PRJNA1067370_P_NODE_117877_length_223_cov_10.586667_g117328_i0	PRJNA1067370	117877	223	10.586667	23.60826741	Halyomorpha halys orthomyxo-like virus 1	2950333	Viruses	Viruses	102	2.0899999999999994e-23	NR	URQ09140.1	2950333	g117328	i0	62.7	1.00896860986547	75	26	98.2	1	5	223	470	544	URQ09140.1 replicase PB2 [Halyomorpha halys orthomyxo-like virus 1]	diamond	225	102	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Halyomorpha halys orthomyxo-like virus 1

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