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

5 rows where analysis = "diamond", bioproject = "PRJNA793147" and tax_phylum = "Negarnaviricota"

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
27685946	27685946	PRJNA793147_P_NODE_40044_length_266_cov_1.461929_g39778_i0	PRJNA793147	40044	266	1.461929	3.88873114	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	132	1.37e-34	NR	7XVR_A	RQ01	g39778	i0	70.5	1.98496240601504	88	26	99.2	0	266	3	300	387	7XVR_A Chain A, Neuraminidase [Wuhan spiny eel influenza virus]	diamond	528	132	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Zebrafish influenza B-like virus
31190877	31190877	PRJNA793147_P_NODE_13275_length_469_cov_2.980000_g13009_i0	PRJNA793147	13275	469	2.98	13.9762	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	127	1.3e-34	NR	ACB06477.1	RQ01	g13009	i0	50	2.05970149253731	106	53	67.8	0	407	90	4	109	ACB06477.1 BM2 protein [Influenza B virus (B/Taiwan/500/2005)]	diamond	966	127	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
31570952	31570952	PRJNA793147_P_NODE_14816_length_441_cov_1.932796_g14550_i0	PRJNA793147	14816	441	1.932796	8.52363036	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	169	1.7399999999999998e-46	NR	AVM87624.1	RQ01	g14550	i0	63.4	0.91156462585034	134	49	91.2	0	439	38	435	568	AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus]	diamond	402	169	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Zebrafish influenza B-like virus
31602560	31602560	PRJNA793147_P_NODE_53736_length_233_cov_0.878049_g53470_i0	PRJNA793147	53736	233	0.878049	2.04585417	Mink stool-associated rhabdovirus	3242821	Viruses	Viruses	150	4.379999999999999e-40	NR	XEQ84343.1	3242821	g53470	i0	93.5	0.991416309012876	77	5	99.1	0	2	232	1241	1317	XEQ84343.1 RNA-dependent RNA polymerase [Mink stool-associated rhabdovirus]	diamond	231	150	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Mink stool-associated rhabdovirus
32266968	32266968	PRJNA793147_P_NODE_25678_length_329_cov_1.107692_g25412_i0	PRJNA793147	25678	329	1.107692	3.64430668	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	50.1	2.59e-4	NR	AVM87625.1	RQ01	g25412	i0	47.4	0.884498480243161	97	46	83.9	3	277	2	1	97	AVM87625.1 NA [Wuhan spiny eel influenza virus]	diamond	291	50.1	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Zebrafish influenza B-like virus

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