metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1011833" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1011833" and tax_superkingdom = "Viruses"

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
28234646	28234646	PRJNA1011833_S_NODE_28146_length_223_cov_1.600000_g27726_i0	PRJNA1011833	28146	223	1.6	3.568	Burke-Gilman virus	1916647	Viruses	Viruses	80.5	1.5e-15	NR	YP_009315888.1	1916647	g27726	i0	50.7	0.955156950672646	71	35	95.5	0	222	10	3120	3190	YP_009315888.1 polyprotein [Burke-Gilman virus]	diamond	213	80.5	1	Viruses							Burke-Gilman virus
29718604	29718604	PRJNA1011833_S_NODE_16710_length_296_cov_1.897233_g16290_i0	PRJNA1011833	16710	296	1.897233	5.61580968	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	45.4	0.0082	NR	WFP52505.1	3063761	g16290	i0	38.6	0.841216216216216	83	46	80.1	3	268	32	765	846	WFP52505.1 RNA-dependent RNA polymerase [Hippocampus erectus picornavirus 1]	diamond	249	45.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
30319598	30319598	PRJNA1011833_S_NODE_252_length_1856_cov_5.740210_g207_i0	PRJNA1011833	252	1856	5.74021	106.5382976	Moloney murine leukemia virus	11801	Viruses	Viruses	1218	0	NR	NP_057933.2	11801	g207	i0	97.7	3.99568965517241	618	14	99.9	0	1856	3	693	1310	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	7416	1218	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
32878858	32878858	PRJNA1011833_S_NODE_41060_length_181_cov_3.347826_g40640_i0	PRJNA1011833	41060	181	3.347826	6.05956506	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	63.9	5.54e-10	NR	AVM87439.1	3063761	g40640	i0	52.4	1.04419889502762	63	27	99.4	1	1	180	457	519	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	189	63.9	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);;