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

6 rows where analysis = "diamond", bioproject = "PRJNA897077" 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_species
13998077	13998077	PRJNA897077_P_NODE_291_length_1560_cov_54.746469_g256_i0	PRJNA897077	291	1560	54.746469	854.0449164	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	575	4.05e-200	NR	AVM87625.1	RQ01	g256	i0	64.2	0.907692307692308	472	164	89.8	3	1494	94	1	472	AVM87625.1 NA [Wuhan spiny eel influenza virus]	diamond	1416	575	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Zebrafish influenza B-like virus
20000230	20000230	PRJNA897077_P_NODE_18436_length_245_cov_1.226744_g18309_i0	PRJNA897077	18436	245	1.226744	3.0055228	Orthornavirae	2732396	Viruses	Viruses	73.6	5.38e-13	NR	XCO56027.1	3233859	g18309	i0	41.9	1.81224489795918	74	43	90.6	0	243	22	327	400	XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1]	diamond	444	73.6	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae	Fusarium culmorum yue-like virus 1
28476937	28476937	PRJNA897077_P_NODE_6506_length_381_cov_1.474026_g6379_i0	PRJNA897077	6506	381	1.474026	5.61603906	Qingdao RNA virus 4	2979708	Viruses	Viruses	125	1.9099999999999997e-30	NR	BDR95913.1	2979708	g6379	i0	48.8	0.984251968503937	125	64	98.4	0	3	377	1052	1176	BDR95913.1 RNA-dependent RNA polymerase [Qingdao RNA virus 4]	diamond	375	125	1	Viruses	Orthornavirae	Negarnaviricota	Chunqiuviricetes	Muvirales	Qinviridae	Qingdao RNA virus 4
29423916	29423916	PRJNA897077_P_NODE_309_length_1519_cov_17.403873_g273_i0	PRJNA897077	309	1519	17.403873	264.36483087	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	580	1.8099999999999999e-202	NR	AVM87625.1	RQ01	g273	i0	64.4	0.932192231731402	472	163	92.2	3	61	1461	1	472	AVM87625.1 NA [Wuhan spiny eel influenza virus]	diamond	1416	580	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Zebrafish influenza B-like virus
29707851	29707851	PRJNA897077_P_NODE_170_length_1847_cov_118.968433_g149_i0	PRJNA897077	170	1847	118.968433	2197.34695751	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	710	3.17e-250	NR	AVM87624.1	RQ01	g149	i0	62.2	0.924201407688143	569	211	92.3	3	1773	70	3	568	AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus]	diamond	1707	710	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Zebrafish influenza B-like virus
32110536	32110536	PRJNA897077_P_NODE_16298_length_250_cov_2.146893_g16171_i0	PRJNA897077	16298	250	2.146893	5.3672325	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	64.7	7.45e-10	NR	XBH23991.1	3063761	g16171	i0	41.9	1.812	74	39	85.2	2	248	36	811	883	XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus]	diamond	453	64.7	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);;