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

5 rows where analysis = "diamond", bioproject = "PRJNA870096" and tax_phylum = "Pisuviricota"

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
28926431	28926431	PRJNA870096_S_NODE_91748_length_184_cov_1.021277_g90084_i0	PRJNA870096	91748	184	1.021277	1.87914968	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	43.5	0.00391	NR	NP_859022.1	RQ13	g90084	i0	36.4	3.45652173913043	55	34	89.7	1	183	19	51	104	NP_859022.1 2A [Kobuvirus bejaponia]	diamond	636	43.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus
29360484	29360484	PRJNA870096_S_NODE_137529_length_153_cov_0.872727_g135865_i0	PRJNA870096	137529	153	0.872727	1.33527231	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	61.2	3.33e-9	NR	WAB24476.1	RQ13	g135865	i0	60	0.980392156862745	50	20	98	0	1	150	2561	2610	WAB24476.1 polyprotein [Avian megrivirus]	diamond	150	61.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Megrivirus	Zebrafish jaw picornavirus
29936976	29936976	PRJNA870096_S_NODE_35491_length_299_cov_3.023438_g33827_i0	PRJNA870096	35491	299	3.023438	9.04007962	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	74.3	6.01e-13	NR	QJX58422.1	RQ13	g33827	i0	44.3	4.69565217391304	97	52	95.3	2	299	15	2256	2352	QJX58422.1 polyprotein [Salivirus A]	diamond	1404	74.7	0.994645247657296	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Salivirus	Zebrafish jaw picornavirus
31414069	31414069	PRJNA870096_S_NODE_64036_length_219_cov_1.363636_g62372_i0	PRJNA870096	64036	219	1.363636	2.98636284	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	52	1.56e-5	NR	QMI57975.1	RQ13	g62372	i0	52.3	2.83561643835616	44	21	60.3	0	85	216	1029	1072	QMI57975.1 polyprotein, partial [Pacific black duck sicinivirus-like virus]	diamond	621	52	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Sicinivirus	Zebrafish jaw picornavirus
32300181	32300181	PRJNA870096_S_NODE_55079_length_237_cov_0.953608_g53415_i0	PRJNA870096	55079	237	0.953608	2.26005096	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	104	2.33e-24	NR	ADI48258.1	RQ13	g53415	i0	57.1	0.974683544303797	77	32	97.5	1	2	232	121	196	ADI48258.1 3D, partial [Bat kobuvirus TM003k]	diamond	231	104	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus

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