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

5 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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
2861671	2861671	PRJNA1160211_S_NODE_85483_length_486_cov_20.026634_g84263_i0	PRJNA1160211	85483	486	20.026634	97.32944124	Shenzhen dicistro-like virus	2789378	Viruses	Viruses	95.9	1.62e-19	NR	QPG92982.1	2789378	g84263	i0	41.8	1.55555555555556	134	70	77.8	3	48	425	747	880	QPG92982.1 polyprotein [Shenzhen dicistro-like virus]	diamond	756	95.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Shenzhen dicistro-like virus
6687753	6687753	PRJNA1160211_S_NODE_21706_length_698_cov_7.096000_g20684_i0	PRJNA1160211	21706	698	7.096	49.53008	Trichoderma gamsii alphapartitivirus 1	3032463	Viruses	Viruses	347	1e-113	NR	WGH72964.1	3032463	g20684	i0	84.5	0.829512893982808	193	30	83	0	581	3	1	193	WGH72964.1 MAG: putative RNA-dependent RNA polymerase [Trichoderma gamsii alphapartitivirus 1]	diamond	579	347	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Alphapartitivirus	Trichoderma gamsii alphapartitivirus 1
29377280	29377280	PRJNA1160211_S_NODE_80869_length_496_cov_12.548463_g79652_i0	PRJNA1160211	80869	496	12.548463	62.24037648	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	80.1	5.43e-14	NR	XCM68108.1	3003959	g79652	i0	38	0.653225806451613	108	65	65.3	2	492	169	882	987	XCM68108.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	324	80.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29440065	29440065	PRJNA1160211_S_NODE_128830_length_407_cov_1.832335_g127598_i0	PRJNA1160211	128830	407	1.832335	7.45760345	Drosophila biauraria male killing partitivirus 1	2933356	Viruses	Viruses	88.2	1.26e-17	NR	BDH75795.1	2933356	g127598	i0	39.7	0.855036855036855	116	70	85.5	0	6	353	175	290	BDH75795.1 uncharacterized protein [Drosophila biauraria male killing partitivirus 1]	diamond	348	88.2	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Drosophila biauraria male killing partitivirus 1
31494256	31494256	PRJNA1160211_S_NODE_204656_length_305_cov_7.663793_g203423_i0	PRJNA1160211	204656	305	7.663793	23.37456865	Cherry virus Trakiya	2074132	Viruses	Viruses	131	4.88e-33	NR	YP_009551963.1	2074132	g203423	i0	76	0.737704918032787	75	18	73.8	0	281	57	1769	1843	YP_009551963.1 replicase [Cherry virus Trakiya]	diamond	225	131	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Cherry virus Trakiya

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